Attachment_H_-_FMWI_Staffing_Matrix_rev_26Oct2018.XLSX

XLSX spreadsheet 78 KB Posted

Attached to
Full Food Service - Fort McCoy
Solicitation number
W9124J18R0029
Issued by

View the file

Other files

File Type Posted
Attachment_N_-_31-Day_Master_Menu_Oct_18_DFACs_50_&_1362.pdf PDF
W9124J18R0029_Amendment_0001.docx DOCX document
Attachment_F1_-_Estimated_Workload_rev_26Oct2018.docx DOCX document
Attachment_O_-_Site_Visit_Industry_Sign_in_sheet.pdf PDF
Attachment_P_-_Fort_McCoy_FFS_Q&A_26Oct2018.xlsx XLSX spreadsheet
Attachment_J_-_Consent_Forms_for_Release_of_Past_Performance_Info_rev_26Oct2018.pdf PDF
Attachment_M_-_10-Day_Master_Exercise_Menu_DFACs_1672_&_2674.pdf PDF
Attachment_F2_-_FY16_-_FY17_HCDailySummary_FM.XLSX XLSX spreadsheet
Attachment_G_Pricing_Matrix_FMWI_20SEP18.XLSX XLSX spreadsheet
Attachment_E2_-_Expendable_Supplies_List_FM.PDF PDF
Attachment_K_-_Specific_Relevant_Contracts_Reference_Sheet.pdf PDF
Attachment_F1_-_Estimated_Workload_19SEP18_Final.docx DOCX document
Attachment_J_-_SubContractor_Consent_Form_for_Release_of_Past_Performance_Info.pdf PDF
Attachment_H_-_FMWI_Staffing_Matrix.xlsx XLSX spreadsheet
Attachment_L_-_Past_Performance_Questionnaire.pdf PDF
Attachment_E1_-_Durable_Supplies_List_FM.PDF PDF
W9124J18R0029_Fort_McCoy_FFS_Solicitation.docx DOCX document
Attachment_B_-_DFAC_Capacities_FM.PDF PDF
Attachment_D_-_Dining_Facility_Equipment_List_FM.PDF PDF
Attachment_I_-_Ft._McCoy_CBA_2018.PDF PDF
Attachment_A_-_Dining_Facility_Location_Map_FM.PDF PDF
Attachment_C_-_Dining_Facility_Drawings_FM.PDF PDF
Show all 22

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

PMO Staff

Project Management Office (incl Q/C, HR, etc.)
Instructions:
List each labor category only once.
PMO labor categories and FTEs should only be listed on this tab.

Labor Category FTEs Prod Hrs per FTE Total Prod Hrs

TOTAL 0.000 0.00

Instructions

These instructions apply to each Headcount band listed in each building tab within the Staffing Matrix.
1. Column A: Enter the labor categories included in the proposal in the area highlighted in green starting under "Position" (i.e., Cook I, Cook II, etc.)
NOTE: Enter all supervisory positions below the grey line in each
2. Columns B through AI: Enter the quantity of people in each labor category listed scheduled to support the contract during the hours listed.
For example, if staffing plan is for 3 "Cook I" position's to work from 0530 to 0830, enter 3 in columns F - L.
3. Column AJ: Do not enter any information as this column contains formulas and will calculate the total number of hours for each position (labor category listed).
Using example above, column AK would calculate a total of 10.5 hours.
NOTE: Per Addendum to 52.212-1 of the RFP, the Staffing Matrix shall only be completed for CLINs/subCLINs within the Pricing Matrix that contain estimated quantities.
As an example, CLIN 0005 contains subCLINs with no estimated quantities. Therefore, subCLINs X0005AC, X005AD, X005BA, X005BC, X005BD and X005EA
not require staffing projections in the Staffing Matrix.

BLDG 50 CLIN 0003

Design Capacity: 650FY17 HCBLDG 50
1-600
3 meals per day70
Position4:004:305:005:306:006:307:007:308:008:309:009:3010:0010:3011:0011:3012:0012:3013:0013:3014:0014:3015:0015:3016:0016:3017:0017:3018:0018:3019:0019:3020:0020:30Per Day Hrs
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0- 0
H/C 601-1800
3 meals per day98
Position4:004:305:005:306:006:307:007:308:008:309:009:3010:0010:3011:0011:3012:0012:3013:0013:3014:0014:3015:0015:3016:0016:3017:0017:3018:0018:3019:0019:3020:0020:30Per Day Hrs
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0- 0

BLDG 1362 CLIN 0004

Design Capacity: 390FY17BLDG 1362
1-300
3 meals per day37
Position4:004:305:005:306:006:307:007:308:008:309:009:3010:0010:3011:0011:3012:0012:3013:0013:3014:0014:3015:0015:3016:0016:3017:0017:3018:0018:3019:0019:3020:0020:30Per Day Hrs
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0- 0
301-900
3 meals per day81
Position4:004:305:005:306:006:307:007:308:008:309:009:3010:0010:3011:0011:3012:0012:3013:0013:3014:0014:3015:0015:3016:0016:3017:0017:3018:0018:3019:0019:3020:0020:30Per Day Hrs
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0- 0
H/C 901-2100
3 meals per day33
Position4:004:305:005:306:006:307:007:308:008:309:009:3010:0010:3011:0011:3012:0012:3013:0013:3014:0014:3015:0015:3016:0016:3017:0017:3018:0018:3019:0019:3020:0020:30Per Day Hrs
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0- 0

BLDG 1672 CLIN 0005

Design Capacity: 1,428FY17BLDG 1672
3 meals a day1-600 3 Meals
Position2
4:004:305:005:306:006:307:007:308:008:309:009:3010:0010:3011:0011:3012:0012:3013:0013:3014:0014:3015:0015:3016:0016:3017:0017:3018:0018:3019:0019:3020:0020:30Per Day Hrs
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0- 0
601-1800 3 Meals
3 meals a day10
Position4:004:305:005:306:006:307:007:308:008:309:009:3010:0010:3011:0011:3012:0012:3013:0013:3014:0014:3015:0015:3016:0016:3017:0017:3018:0018:3019:0019:3020:0020:30Per Day Hrs
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0- 0
401-1200 2 Meals
2 meals a day2
Position4:004:305:005:306:006:307:007:308:008:309:009:3010:0010:3011:0011:3012:0012:3013:0013:3014:0014:3015:0015:3016:0016:3017:0017:3018:0018:3019:0019:3020:0020:30Per Day Hrs
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0- 0

BLDG 2674 CLIN 0006

Design Capacity: 1,400 BLDG 2674

1-400 2 Meals
2 meals a day9
Position4:004:305:005:306:006:307:007:308:008:309:009:3010:0010:3011:0011:3012:0012:3013:0013:3014:0014:3015:0015:3016:0016:3017:0017:3018:0018:3019:0019:3020:0020:30Per Day Hrs
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0- 0
401-1200 2 Meals
2 meals a day94
Position4:004:305:005:306:006:307:007:308:008:309:009:3010:0010:3011:0011:3012:0012:3013:0013:3014:0014:3015:0015:3016:0016:3017:0017:3018:0018:3019:0019:3020:0020:30Per Day Hrs
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0- 0
1201-2000 2 Meals
2 meals a day75
Position4:004:305:005:306:006:307:007:308:008:309:009:3010:0010:3011:0011:3012:0012:3013:0013:3014:0014:3015:0015:3016:0016:3017:0017:3018:0018:3019:0019:3020:0020:30Per Day Hrs
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0- 0
2001-3000 2 Meals
2 meals a day3
Position4:004:305:005:306:006:307:007:308:008:309:009:3010:0010:3011:0011:3012:0012:3013:0013:3014:0014:3015:0015:3016:0016:3017:0017:3018:0018:3019:0019:3020:0020:30Per Day Hrs
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0- 0
Total average # of meals
1-199
200-600
601-1000
101-1500
pre/post

Extended Svc

IAW PWS 2.1.4
Input the Labor Category beginnined in A8
Input the number of labor hours required for a full hour of extended meal service for each building; starting on line 8
These Estimates are for .25 hours. (E.g.: a 1 in the Cook I column means you need 1 cook for 0.25 hrs)

Extended Hour Meal Svc BLDG 50 BLDG 1362 BLDG 1672 BLDG 2674 Double CLIN

PWS 3.1.2.6 - BLDG 50
Open/Close
Labor CategoryHours Rqrd
PWS 3.1.2.6 - BLDG 1362
Open/Close
Labor CategoryHours Rqrd
PWS 3.1.2.6 - BLDG 1672
Open/Close
Labor CategoryHours Rqrd
PWS 3.1.2.6 - BLDG 2674
Open/Close
Labor CategoryHours Rqrd
PWS 3.1.2.6 - Company Size Double
Open/Close
Labor CategoryHours Rqrd

File details come from the government source that posted it.