Attachment H - Staffing Matrix - 20220826.xlsx

XLSX spreadsheet 99 KB Posted

Attached to
Full Food Services - Fort Knox, KY
Solicitation number
W5168W23R0006
Issued by

View the file

Other files

File Type Posted
Questions from Vendors_ Ft. Knox Non-CST with KO answers updated 23 March 2023.pdf PDF
Attachment F - Estimated Workload Data (BLDG 2835 Update)- Capabilities - 20230323.pdf PDF
Ft. Knox Full Food Services W5168W23R0006 Amendment 0003.pdf PDF
Ft. Knox, KY Non-CST Full Food Service Site Visit (Virtual) - Attendance report 2-9-23.pdf PDF
W5168W-23-R-0006 Solicitation Modification 2.pdf PDF
Attachment B - FKKY AFMIS Headcount Data FY19-22.xlsx XLSX spreadsheet
Attachment O - Performance Work Statement - 20230309.docx DOCX document
Attachment G - FKKY FFS Pricing Matrix - 17FEb23.xlsx XLSX spreadsheet
Attachment H - FKKY FFS Staffing Matrix 17Feb23.xlsx XLSX spreadsheet
Attachment J - Facilities Photos.pdf PDF
Amended Request for Proposal - W5168W23R0006-0001 FFS Ft Knox.pdf PDF
Attachment O - Performance Work Statement - 20220522.docx DOCX document
Attachment A - Dining Facility Location Map.pdf PDF
Attachment B - Headcount AFMIS Data FY19-21.xlsx XLSX spreadsheet
Attachment F - Estimated Workload Data - Capabilities - 202206522.docx DOCX document
Request for Proposal - W5168W23R0006 FFS Ft Knox.pdf PDF
Attachment K - Consent Forms for Release of Past Performance Info.docx DOCX document
Attachment C - Dining Facility Drawing.pdf PDF
Attachment D3 - Durable Property.xlsx XLSX spreadsheet
Attachment I - CBA Negotiated Agreement CBA Addendum - 20220615.pdf PDF
Attachment M - Past Performance Questionnaire - 20210920.docx DOCX document
Attachment D1 - Government Furnished Property.xlsx XLSX spreadsheet
Attachment G - Pricing Matrix - 20220922.xlsx XLSX spreadsheet
Attachment D2 - Real Property.xlsx XLSX spreadsheet
Attachment L - Specific Relevant Contracts Reference Sheet 08-2019.docx DOCX document
Attachment J - Facilities Photos.pdf PDF
Attachment E - Sample Materials List.xlsx XLSX spreadsheet
Show all 27

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 2835

Building2835
Seating Capacity1300
Three meals per day 1 – 820 meals
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 821-1625 meals
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 1626-2438 meals
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 2439-3250 meals
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 3251-4875 meals
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 1491

Building1491
Seating Capacity1000
Three meals per day 1 – 500 meals
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 501-1000 meals
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 1001-1500 meals
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 1501-2000 meals
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 2001-3000 meals
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 2380

Building2380
Seating Capacity400
Three meals per day 1 – 300 meals
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 301-600 meals
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 601-900 meals
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 901-1200 meals
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.

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

Bldg 502

Building502
Seating Capacity732
Three meals per day 1 – 550 meals
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 551-1100 meals
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 1101-1650 meals
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 1651-2200 meals
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 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 2.1.4Staffing for Bldg 2835Staffing for Bldg 1491Staffing for Bldg 2380Staffing for Bldg 502
(EXAMPLE) Cook I1111

TOTAL FTEs per Quarter Hour 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 2835Staffing for Bldg 1491Staffing for Bldg 2380Staffing for Bldg 502
(EXAMPLE) Cook I1111

TOTAL FTEs 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 2835Staffing for Bldg 1491Staffing for Bldg 2380Staffing for Bldg 502
(EXAMPLE) Cook I1111

TOTAL FTEs 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 Category Number FTEs Productive Hours per FTE Total Prod Hrs

TOTAL - 0 - 0

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