Attachment H - FKKY CST Food Service Staffing Matrix_17Jan23.xlsx

XLSX spreadsheet 92 KB Posted

Attached to
Ft Knox, KY Non-Traditional Full Food Service Cadet Summer Training
Solicitation number
W5168W23R0009
Issued by

About this file

Written by GovTribe AI ·

This document includes a staffing matrix template and instructions for a food service contract opportunity at Fort Knox, Kentucky. The staffing matrix requires contractors to provide estimated full-time equivalents for food service labor categories such as dining facility attendants and shift leaders for various meal periods across multiple dining facilities. Contractors must also provide staffing estimates for additional services including extended meal hours, periodic deep cleanings, and dining facility opening and closing functions. The related federal contract opportunity is a solicitation for non-traditional full food services to provide dining facility management and remote site feeding for Cadet Summer Training at designated dining facilities. The fixed-price task order contract will have a base year and four option years, with an anticipated period of performance from March 2023 to September 2028. A virtual site visit will be held on January 18, 2023 and questions are due by January 20, 2023. The awarded contractor must register in the System for Award Management and check the federal business opportunities website for solicitation amendments.

View the file

Other files

File Type Posted
W5168W-23-R-0009 CST FFS Amendment (1)conformed copy.pdf PDF
Ft Knox CST W5168W-23-R-0009 QA Amendment(1).pdf PDF
Attachment J DFAC Est Opening Closing Schedule 20 Jan 2023.xlsx XLSX spreadsheet
W5168W-23-R-0009 CST FFS Amendment (1) JMD.pdf PDF
Ft Knox CST Site visit vendors roster 18 Jan 2023.pdf PDF
Attachement O CST (FKKY) FFS PWS CLEAN 23 JAN 23.pdf PDF
Attachment J DFAC Est Opening Closing Schedule 17Nov22.xlsx XLSX spreadsheet
Attachment O - CST (FKKY) FFS PWS 9 JAN 22.docx DOCX document
Attachment D3 - Durables.xlsx XLSX spreadsheet
Ft Knox CST RFP W5168W-23-R-0009 Final.pdf PDF
Attachment K SubContractor Consent Form for Release of Past Performance Info.pdf PDF
Attachment G - FKKY CST Pricing Matrix 7NOV22.xlsx XLSX spreadsheet
Attachment M Past Performance Questionnaire (1).pdf PDF
Attachment D2 Real Property.xlsx XLSX spreadsheet
Attachment D1 - GFP 16DEC22.xlsx XLSX spreadsheet
Attachment P - Wage Determination - 20230111.pdf PDF
Attachment A - DFAC Location Map.pdf PDF
Attachment F - FKKY CST Building Capabilities 7NOV22.docx DOCX document
Attachment L Specific Relevant Contracts Reference Sheet.pdf PDF
Attachment I - FKKY CBA for Southern Food June.pdf PDF
Attachment B - FKKY CST Projected Headcount and Ration Cycle.xlsx XLSX spreadsheet
Attachment E - Sample Materials List.xlsx XLSX spreadsheet
Attachment C - Building Plans.pdf PDF
Attachment H - FKKY CST Food Service Staffing Matrix.xlsx XLSX spreadsheet
Show all 24

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 Headcount band listed in building worksheet
1. Column A: Enter the labor categories included in the proposal in the area starting under "Position" column A; (i.e., Dining Facility Attendant (DFA), Shift Leader, etc.) in each band.
NOTE: Enter all supervisory positions (i.e. Dining Facility Manager) 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 "DFA" 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
DFA3.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. For subCLINs in which Pricing is not included at this time, but may be negotiated at a later day, staffing is not requested at this time but may be requested at a later date.

Bldg 5940

Building5940
Seating Capacity800
Two Meals (Breakfast & Dinner)
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
0.00
0.00
0.00
0.00
Supervisory- 0
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.00.0- 0
One Meal (Breakfast)
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
0.00
0.00
0.00
0.00
Supervisory- 0
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.00.0- 0
One Meal (Dinner)
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
0.00
0.00
0.00
0.00
Supervisory- 0
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.00.0- 0

Bldg 6012

Building6012
Seating Capacity800
Two Meals (Breakfast & Dinner)
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
0.00
0.00
0.00
0.00
Supervisory- 0
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.00.0- 0
One Meal (Breakfast)
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
0.00
0.00
0.00
0.00
Supervisory- 0
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.00.0- 0
One Meal (Dinner)
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
0.00
0.00
0.00
0.00
Supervisory- 0
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.00.0- 0

Bldg 6018

Building6018
Seating Capacity800
Two Meals (Breakfast & Dinner)
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
0.00
0.00
0.00
0.00
Supervisory- 0
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.00.0- 0
One Meal (Breakfast)
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
0.00
0.00
0.00
0.00
Supervisory- 0
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.00.0- 0
One Meal (Dinner)
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
0.00
0.00
0.00
0.00
Supervisory- 0
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.00.0- 0

Bldg 5915

Building5915
Seating Capacity800
Two Meals (Breakfast & Dinner)
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
0.00
0.00
0.00
0.00
Supervisory- 0
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.00.0- 0
One Meal (Breakfast)
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
0.00
0.00
0.00
0.00
Supervisory- 0
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.00.0- 0
One Meal (Dinner)
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
0.00
0.00
0.00
0.00
Supervisory- 0
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.00.0- 0

Bldg 5917

Building5917
Seating Capacity800
Two Meals (Breakfast & Dinner)
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
0.00
0.00
0.00
0.00
Supervisory- 0
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.00.0- 0
One Meal (Breakfast)
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
0.00
0.00
0.00
0.00
Supervisory- 0
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.00.0- 0
One Meal (Dinner)
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
0.00
0.00
0.00
0.00
Supervisory- 0
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.00.0- 0

Staffing for this subCLIN will be requested at a later date, if needed.

Staffing for this subCLIN will be requested at a later date, if needed.

Bldg 6542

Building6542
Seating Capacity1000
Three Meals per Day Side A
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
0.00
0.00
0.00
0.00
Supervisory- 0
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.00.0- 0
Three Meals per Day Sides A & B
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
0.00
0.00
0.00
0.00
Supervisory- 0
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.00.0- 0

Bldg 6555

Building6555
Seating Capacity1000
Three Meals per Day Side A
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
0.00
0.00
0.00
0.00
Supervisory- 0
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.00.0- 0
Three Meals per Day Sides A & B
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
0.00
0.00
0.00
0.00
Supervisory- 0
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.00.0- 0

Other Services Note: Other Services will be ordered under the applicable Building CLIN

IAW PWS 2.1.4
Complete the yellow boxes below for each service area:
Extended Hours:
1. Input the Labor Category beginning in A13.
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 C12 reflects 1 "Cook I" is proposed for an additional 15 mins of DFAC serving time).

Extended Hours PWS 2.1.4Staffing for Bldg 5940Staffing for Bldg 6012Staffing for Bldg 6018Staffing for Bldg 5915Staffing for Bldg 5917Staffing for Bldg 6542Staffing for Bldg 6555
(EXAMPLE) Cook I1111111

TOTAL FTEs per Quarter Hour 0 0 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 5940Staffing for Bldg 6012Staffing for Bldg 6018Staffing for Bldg 5915Staffing for Bldg 5917Staffing for Bldg 6542Staffing for Bldg 6555
(EXAMPLE) Cook I1111111

TOTAL FTEs 0 0 0 0 0 0 0

IAW PWS 4.3
Complete the yellow boxes below for each service area:
Extended Hours:
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 5940Staffing for Bldg 6012Staffing for Bldg 6018Staffing for Bldg 5915Staffing for Bldg 5917Staffing for Bldg 6542Staffing for Bldg 6555
(EXAMPLE) Cook I1111111

TOTAL FTEs 0 0 0 0 0 0 0

PMO

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 CategoryNumber FTEsProductive Hours per FTETotal Prod Hrs
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
TOTAL- 0- 0

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