Attachment H - Ft. Sill Staffing Matrix 1Feb23.xlsx

91 KB Posted

Attached to
Ft. Sill, OK Full Food Services
Solicitation number
W5168W23R0007
Issued by

About this file

Written by GovTribe AI ·

This document is a staffing matrix template for a full food services contract opportunity at Fort Sill, Oklahoma. The staffing matrix includes instructions for contractors to populate labor categories, hours, and staffing levels across multiple dining facilities and optional services. Labor categories will include positions like cooks, supervisors, and managers. The facilities cover full food services across six buildings, including three large dining halls seating 1,240, 1,300, and 2,600 personnel respectively. Optional services include field services for up to 9,000 additional meals, extended hours, periodic deep cleaning, and dining facility opening and closing support. The related federal contract opportunity is solicitation number W5168W23R0007 for full food services at Fort Sill, with the procuring agency being the Department of the Army. Contractors must use this staffing matrix template to propose staffing plans that demonstrate the ability to fully support the requirements across the various facilities and optional services.

View the file

Other files

File Type Posted
Attachment Q - Ft. Sill FFS RFP Q and A -W5168W23R0007 15AUG23_Final.xlsx XLSX spreadsheet
Attachment H - Staffing Matrix - 14Aug23.xlsx XLSX spreadsheet
Attachment I - Ft. Sill-Collective Bargaining Agreement 01.01.23-12.31.23.pdf PDF
Attachment Q - Ft. Sill FFS RFP Q and A -W5168W23R0007 15AUG23_Final.xlsx XLSX spreadsheet
Modified - Ft. Sill Solicitation Amendment W5168W23R0007 0001_17AUG23.pdf PDF
Attachment F - Estimated Workload Data - Capabilities - 14AUG23.docx DOCX document
Fort Sill Site Visit Slides .pptx PPTX presentation
Site Visit Roster - Fort Sill.pdf PDF
Attachment D2 - Real Property.xlsx XLSX spreadsheet
Attachment B - Ft. Sill - AFMIS FY22_FY21_FY20.xlsx XLSX spreadsheet
Attachment D3 - Durable Property.xlsx XLSX spreadsheet
Attachment O - Performance Work Statement 16 June 2023_Final.docx DOCX document
Attachment F - Estimated Workload 8Dec22.docx DOCX document
Attachment E - Sample Materials List.xlsx XLSX spreadsheet
Attachment I - Ft. Sill-Collective Bargaining Agreement eff 15 May 2022.pdf PDF
Schedule B-1 Pricing Matrix.xlsx XLSX spreadsheet
Attachment J - Ft. Sill Pictures of Facilities.pdf PDF
Attachment L - Specific Relevant Contracts Reference Sheet 08-2019.docx DOCX document
Attachment D1 - GFP.xlsx XLSX spreadsheet
Attachment K - Consent Forms for Release of Past Performance Info.docx DOCX document
Attachment N- Ft. Sill, OK FFS DOL Wage Determination.pdf PDF
Attachment P - PIEE Solicitation Vendor Posting Offer Training.pdf PDF
Attachment A- Ft. Sill DFAC Location Map.pdf PDF
Attachment C - Ft. Sill Building Plans.pdf PDF
Attachment M - Past Performance Questionnaire - 20210920.docx DOCX document
Ft. Sill Solicitation W5168W-23-R-0007_21 July 23.pdf PDF
Show all 26

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.

Instructions

These instructions apply to each subCLIN 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.
In the example below, the Breakfast serving period highlighted is from 0730 to 0900; assuming staffing is for 3 "Cook I" positions to work from 0700 to 0900, 3 would be input in columns D - H.
Breakfast
Position6:006:307:007:308:008:309:009:3010:00
Cook I3.003.003.003.003.00
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 7.5 hours.
4. Bldg 5965 CLIN 0005 and Bldg 5966 CLIN 0006): The serving hours for Bldgs 5965 & 5966 vary, per Attachment F, but the serving periods are all 90 minutes. The Staffing Matrix uses serving hours for each meal for Monday - Saturday hours.
5. Field Svc (Reimb) CLIN 0008: This requirement can be for Breakfast, Lunch, or Dinner, the serving times for each meal vary but the serving periods are all 90 minutes. The Staffing Matrix only uses serving hours for Breakfast.
Please note that although Dining Facility Managers (and Assistant Dining Facility Managers) would be priced as part of PMO, for the Staffing Matrix, those positions should be included in the Bldg subCLINs.

PMO Staff CLIN 0002

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

Bldg 2755 CLIN 0003

1240 Capacity
Three meals per day, 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
Supervisory
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
Three meals per day, 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
Supervisory
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

Bldg 3720 CLIN 0004

1300 Seating Capacity
Three meals per day, 1 - 1950
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
Supervisory
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
Three meals per day, 1951 - 3900
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
Supervisory
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
Kitchen + One Quad (2400 meals maximum)
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
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0
Kitchen + Two Quads (4800 meals maximum)
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
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0
Kitchen + Three Quads (7200 meals maximum)
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
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0
Kitchen + Four Quads
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
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0
Kitchen Mermites Only (Breakfast & Dinner 9 Battery maximum)
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
Supervisory
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
Kitchen + One Quad (2400 meals maximum)
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
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0
Kitchen + Two Quads (4800 meals maximum)
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
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0
Kitchen + Three Quads (7200 meals maximum)
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
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0
Kitchen + Four Quads
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
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0
Kitchen Mermites Only (Breakfast & Dinner 9 Battery maximum)
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
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0

Bldg 3443 DFA CLIN 0007

800 Design Capacity
Three 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
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0
Three 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.00
Supervisory
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF During meals- 0

Field Svc CLIN 0008

Reimbursable CustomerField Service Meal Period (Breakfast, Lunch or Dinner) PWS 4.5.5
BREAKFAST
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

Note: Other Services will be ordered under the applicable Building CLIN
IAW PWS 1.6.1.1
Complete the yellow boxes below for each service area:
Extended Hours:
1. Input the Labor Category beginning in A11.
2. Input the number of FTEs required for each position under each Bldg Column, starting with Column C, E, G, etc.

3. Please note these are based on quarter hour (15 mins) increments (see below example - entering a quantity of 1 in cell C11 reflects 1 "Cook I" is proposed for an additional 15 mins of DFAC serving time).

Extended Hours PWS 1.6.1.1Staffing for Bldg 2755 (FFS)Staffing for Bldg 3720 (FFS)Staffing for Bldg 5965 (FFS)Staffing for Bldg 5966 (FFS)Staffing for Bldg 3433 (DFA)
(EXAMPLE) Cook I11111

TOTAL FTEs per Quarter Hour 0 0 0 0 0

IAW PWS 4.2
Complete the yellow boxes below for each service area:
Periodic In-Depth Cleaning
1. Input the Labor Category beginning in A35.
2. Input the number of FTEs required for each position under each Bldg Column, starting with Column C, E, G, etc.
Periodic In-Depth Cleaning PWS 4.2Staffing for Bldg 2755 (FFS)Staffing for Bldg 3720 (FFS)Staffing for Bldg 5965 (FFS)Staffing for Bldg 5966 (FFS)Staffing for Bldg 3433 (DFA)
(EXAMPLE) Cook I11111

TOTAL FTEs 0 0 0 0 0

IAW PWS 4.3
Complete the yellow boxes below for each service area:
Dining Facility Opening and Closing
1. Input the Labor Category beginning in A57.
2. Input the number of FTEs required for each position under each Bldg Column, starting with Column C, E, G, etc.
Dining Facility Opening and Closing PWS 4.3Staffing for Bldg 2755 (FFS)Staffing for Bldg 3720 (FFS)Staffing for Bldg 5965 (FFS)Staffing for Bldg 5966 (FFS)Staffing for Bldg 3433 (DFA)
(EXAMPLE) Cook I11111

TOTAL FTEs 0 0 0 0 0

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