Staffing Matrix 7 Feb 22.xlsx

38 KB Posted

Attached to
Full Food Service - Fort Leavenworth, KS Corrections Command
Solicitation number
W5168W-22-D-0004
Issued by

View the file

Other files

File Type Posted
Attachment A - Location Map.docx DOCX document
Attachment B - Historical Headcount.docx DOCX document
Performance Work Statement PWS Fort Leavenworth Corrections Cmd_FFS 11 Feb 22.pdf PDF
Pricing Matrix 7 Feb 22.xlsx XLSX spreadsheet
Wage Determination 2015-5105_Leavenworth.pdf PDF
Attachment E - Sample Material List.docx DOCX document
Photos_USDB.pdf PDF
Attachment F - Estimated Workload.docx DOCX document
Attachment C - Bldg Plans.docx DOCX document

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 Total Prod Hrs

TOTAL 0.00 0.00

Instructions

1. Column A: Enter the labor categories included in the proposal in the area highlighted in green starting under "Position" (i.e., Food Sanitation Specialist, Food Sanitation Speciliast Lead, 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 II" position's to work from 0630 to 0930, enter 3 in columns H-M.
Example:
3:304:004:305:005:306:006:307:007:308:008:309:009:30
Cook II3.003.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 9 hours.
4. NOTE: Per the RFP, the Staffing Matrix shall only be completed for CLINs/SubCLINs within the Pricing Matrix that contain estimated quantities.

MCC

Seating Capacity216
Bldg:USDBUSDB Facility Meals up to 450 meals (M-S)
BREAKFASTLUNCHDINNER
365Breakfast Hours 0500 - 0800Lunch Hours 1030-1330Dinner Hours 1530-1830
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 HoursAnnual Hours
0.000.000
0.000.000
0.000.000
0.000.000
0.000.000
0.000.000
0.000.000
0.000.000
0.000.000
0.000.000
0.000.000
Supervisory- 0- 0
0.000.000
0.000.000
0.000.000
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- 0
Seating Capacity173
Bldg:MWJRCFMWJRCF Facility Meals up to 300 meals (M-S)
BREAKFASTLUNCHDINNER
365Breakfast Hours 0500 - 0800Lunch Hours 1030-1330Dinner Hours 1530-1830
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 HoursAnnual Hours
0.000.000
0.000.000
0.000.000
0.000.000
0.000.000
0.000.000
0.000.000
0.000.000
0.000.000
0.000.000
0.000.000
Supervisory- 0- 0
0.000.000
0.000.000
0.000.000
TOTAL STAFF During meals- 0- 0

Other Services

IAW PWS 1.6.4 Extended Services
Complete the yellow boxes below:
1. Input the Labor Category beginning in A10.
2. Input the number of FTEs required for each position under each Bldg Column, starting in Column C.

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 Hour Meal SvcStaffing for USDBStaffing for MWJRCF
(EXAMPLE) Cook I11

TOTALS: 0 0

IAW PWS 5.1.1.3 Periodic In-Depth Cleaning
Complete the yellow boxes below:
1. Input the Labor Category beginning in A27.
2. Input the number of FTEs required for each position under each Bldg Column, starting in Column C.
Periodic In-Depth CleaningStaffing for USDBStaffing for MWJRCF
(EXAMPLE) Food Service Worker11

TOTALS: 0 0

IAW PWS 5.1.1.4
1. Input the Labor Category beginning in A43.
2. Input the number of FTEs required for each position under Bldg Column C.
Short and Long Range Closure and Opening of Dining FacilitiesStaffing for Bldg USDBStaffing for MWJRCF
(EXAMPLE) DFA11

TOTAL FTEs 0 0

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