Attachment_H_-_Staffing_Matrix_12-10-18.XLSB

XLSB spreadsheet 63 KB Posted

Attached to
Fort Sill - Full Food Services and Dining Facility Attendant Services
Solicitation number
W9124J-18-R-0024
Issued by

About this file

Written by GovTribe AI ·

This staffing matrix template and federal contract opportunity outline requirements for full food services and dining facility attendant services at multiple buildings on Fort Sill Army base in Oklahoma. The Department of the Army Materiel Command Mission and Installation Contracting Command Fort Sam Houston is soliciting proposals under solicitation number W9124J-18-R-0024 to provide all resources except Government Furnished Property as specified in the Performance Work Statement. Services include three meals per day for various headcounts at different buildings from Monday through Saturday as well as some Sunday and holiday meals. The staffing matrix template requires contractors to input planned labor hours and staffing levels by position for each meal period. This is a set-aside for small businesses under NAICS code 722310 with a size standard of $38.5M and is subject to the Randolph-Sheppard Act. Questions are due by September 7, 2018 and interested parties must register in the System for Award Management.

From the source

Attachment H - Staffing Matrix 12-10-18

Text of this file

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 AJ: 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 AK: 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 the RFP, the Staffing Matrix shall only be completed for CLINs/subCLINs within the Pricing Matrix that contain estimated quantities.
For example under CLIN 0005, subCLINs X0005AA - X005AD, would not require staffing projections in the Staffing Matrix.

Bldg 2755 CLIN 0003

1240 Capacity
3 meals/day3 MEALS H/C 1-2400
BREAKFASTLUNCHDINNER
Position3:304: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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF0.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.00.0- 0
3 meals/day3 MEALS PER DAY H/C 2401-4800
BREAKFASTLUNCHDINNER
Position3:304: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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF0.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.00.0- 0
3 meals/day3 MEALS PER DAY H/C 4801-7200
BREAKFASTLUNCHDINNER
Position3:304: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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF0.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.00.0- 0
Midnight Meal
1 meal1-800
Midnight Meal
Position19:3020:0020:3021:0021:3022:0022:3023:0023:300:000:301:001:302:00Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF0.00.00.00.00.00.00.00.00.00.00.00.00.00.0- 0

Bldg 3720 CLIN 0004

1300 Seating Capacity
3 meals/day3 MEALS PER DAY H/C 1-1300
BREAKFASTLUNCHDINNER
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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.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
3 meals/day3 MEALS PER DAY H/C 1301-2400
BREAKFASTLUNCHDINNER
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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00- 0
0.00
0.00
Supervisory0.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
3 meals/day3 MEALS PER DAY 2401 - 4000
BREAKFASTLUNCHDINNER
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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.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
3 meals/day3 MEALS PER DAY 4001 - 5200
BREAKFASTLUNCHDINNER
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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.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

Bldg 5965 CLIN 0005

2600 Design Capacity
3 meals/dayThree meals per day, 1 - 2400 Monday - Saturday
Most Likely # daysBREAKFASTLUNCHDINNER
Position3:304: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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0
3 meals/dayThree meals per day, 2401-4800 Monday-Saturday
Most likely # of daysBREAKFASTLUNCHDINNER
Position3:304: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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0

2600 Design Capacity

3 meals/dayThree meals per day, 4801 - 7200 Monday - Saturday
BREAKFASTLUNCHDINNER
Position3:304: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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0
3 meals/dayThree meals per day, 4801 - 7200 Sunday & Holidays
BREAKFASTLUNCHDINNER
Position3:304: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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0
3 meals/dayThree meals per day, 7201 - 10000 Monday - Saturday
BREAKFASTLUNCHDINNER
Position3:304: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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0
3 meals/dayThree meals per day, 7201 - 10000 Sunday & Holidays
BREAKFASTLUNCHDINNER
Position3:304: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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0
3 meals/dayThree Meals per day, 10001 - 12500 Sunday & Holidays
BREAKFASTLUNCHDINNER
Position3:304: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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0

Bldg 5966 CLIN 0006 2600 Design Capacity

3 meals/dayThree meals per day, 2401 - 4800 Monday - Saturday
BREAKFASTLUNCHDINNER
Position3:304: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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0
3 meals/dayThree meals per day, 4801 - 7200 Monday - Saturday
BREAKFASTLUNCHDINNER
Position3:304: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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0
3 meals/dayThree meals per day, 4801 - 7200 Sunday & Holidays
BREAKFASTLUNCHDINNER
Position3:304: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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0
3 meals/dayThree meals per day, 7201 - 10000 Monday - Saturday
BREAKFASTLUNCHDINNER
Position3:304: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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0
3 meals/dayThree meals per day, 7201 - 10000 Sunday & Holidays
BREAKFASTLUNCHDINNER
Position3:304: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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0
3 meals/dayThree Meals per day, 10001 - 12500 Sunday & Holidays
BREAKFASTLUNCHDINNER
Position3:304: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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0

Bldg 3443 DFA CLIN 0008

800 Design Capacity
3 meals/dayThree meals per day, 1 - 1500
BREAKFASTLUNCHDINNER
Position3:304: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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0
3 meals/dayThree meals per day, 1501 - 2500
BREAKFASTLUNCHDINNER
Position3:304: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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00- 0
0.00
Supervisory0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0

Field Svc (Reimb) CLIN 0011

Reimbursable Customer1-300
BREAKFASTLUNCHDINNER
Position3:304: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:30Daily Hours
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00- 0

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 C8
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 2755 BLDG 3720 BLDG 5965 BLDG 5966 BLDG 3443

Other files

File Type Posted
W9124J-18-R-0024_Amendment_00011.pdf PDF
Attachment_F_-_Estimated_Workload_12-03-18.docx DOCX document
Attachment_G_-_Pricing_Matrix_12-03-18.XLSX XLSX spreadsheet
Attachment_H_-_Staffing_Matrix_12-3-18.XLSB XLSB spreadsheet
W9124J-18-R-0024_Amendment_00010_12-03-18.pdf PDF
Attachment_O_-_Invoicing_Instructions.pdf PDF
Attachment_P_-_Ordering_Instructions.pdf PDF
W9124J-18-R-0024_Conformed_Copy_11-09-18.pdf PDF
W9124J-18-R-0024_Amendment_0009_11-09-18.pdf PDF
W9124J-18-R-0024_Amendment_0008.pdf PDF
W9124J-18-R-0024_Amendment_0007_10-22-18.pdf PDF
W9124J-18-R-0024_Amendment_0006_10-16-18.pdf PDF
W9124J-18-R-0024_Conformed_Copy_10-16-18.pdf PDF
W9124J18R00240005.pdf PDF
Attachment_F_-_Estimated_Workload,_09_Oct_2018.docx DOCX document
W9124J-18-R-0024_Amendment_0004.pdf PDF
W9124J-18-R-0024_Conformed_Copy_10-02-18.pdf PDF
Attachment_N_-_Site_Visit_Attendees_06-27-18.pdf PDF
W9124J-18-R-0024_Amendment_0003.pdf PDF
Attachment_I_-_Ft_Sill_CBA_10-1-18.pdf PDF
IA01_Attachment_H_-_Staffing_Matrix_SILL_09-20-18.XLSB XLSB spreadsheet
IA01_Attachment_F-3_-_Head_Count_Summary_FY18_Fort_Sill_09-20-18.xlsx XLSX spreadsheet
IA01_Attachment_F-4_-_Head_Count_Daily_Summary_FY18_09-20-18.xlsx XLSX spreadsheet
W9124J-18-R-0024_Conformed_Copy_09-20-18.pdf PDF
Fort_Sill_RFP_Technical_Questions_09-20-18.pdf PDF
IA01_Attachment_F_-_Estimated_Workload_09-20-18.docx DOCX document
IA01_Attachment_F-2_-_Head_Count_Daily_Summary_FY17_09-20-18.xlsx XLSX spreadsheet
IA01_Attachment_E_-_(1)_Durable_Supplies_List_FS_09-20-18.xlsx XLSX spreadsheet
W9124J-18-R-0024_Amendment_0002_09-20-18.pdf PDF
IA01_Attachment_F-1_-_Head_Count_Summary_FY17_Fort_Sill_09-20-18.xlsx XLSX spreadsheet
W9124J-18-R-0024_Conformed_Copy_09-14-18.pdf PDF
W9124J-18-R-0024_Amendment_0001.pdf PDF
IA01_Attachment_E_-_(1)_Durable_Supplies_List_FS_(29_Mar_2018).xlsx XLSX spreadsheet
IA0_Attachment_C_-_Dining_Facility_Drawings_Fort_Sill_FS_(29_Mar_2018).pdf PDF
IA01_Attachment_H_-_Staffing_Matrix_SILL06JUN.XLSB XLSB spreadsheet
IA01_Attachment_F_-_Estimated_Workload.docx DOCX document
IA01_Attachment_J_-_Ft_Sill_Facility_Photos.pdf PDF
IA01_Attachment_B_-_DFAC_Capacities_(29_Mar_2018).xlsx XLSX spreadsheet
Fort_Sill_Solicitation_W9124J18R0024.pdf PDF
IA01_Attachment_G_-_Pricing_Matrix.xlsx XLSX spreadsheet
IA01_Attachment_D_-_Dining_Facility_Equipment_List_FS_(29_Mar_2018).xlsx XLSX spreadsheet
IA01_Attachment_L_-_Specific_Relevant_Contracts_Reference_Sheet.pdf PDF
IA01_Attachment_F-2_-_Head_Count_Daily_Summary_FY_17.xlsx XLSX spreadsheet
IA01_Attachment_F-1_-_Head_Count_Summary_FY17_Fort_Sill.xlsx XLSX spreadsheet
IA01_Attachment_K_-_SubContractor_Consent_Form_for_Release_of_Past_Performance_Info.pdf PDF
IA01_Attachment_M_-_Past_Performance_Questionnaire.pdf PDF
IA04_Attachment_I_-_CBA_&_Addendum.pdf PDF
IA01_Attachment_E_-_(2)_Expendable_Supplies_List_(29_Mar_2018).xlsx XLSX spreadsheet
IA01_Attachment_A_-_Dining_Facility_Location_Map_Fort_Sill_FS_(29_Mar_2018).pdf PDF
Show all 49

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

File details come from the government source that posted it. Updated .