Attachment N - Example Staffing Matrix FWAK.xlsx

XLSX spreadsheet 86 KB Posted

Attached to
W5168W-24-R-0014 Dining Facility Attendant - Fort Wainwright
Solicitation number
W5168W-24-R-0014
Issued by

About this file

Written by GovTribe AI ·

This staffing matrix template provides an example of required labor categories, staffing levels, and hours to support dining facility services at two buildings under a Department of the Army food services contract. The template outlines positions including food sanitation shift leader, pots and pans, food sanitation specialist, and dining facility attendant. It includes instructions for completing the matrix based on variables such as facility capacity, number of meals served, and service models ranging from full dining to takeout. Staffing is shown as varying by meal periods and building in half hour increments. The template also includes instructions and examples for estimating labor needs for special services such as extended hours, deep cleaning, dining facility openings and closings. A separate tab is provided to estimate project management office labor. This template appears intended to help contractors estimate pricing for providing dining facility attendant and remote site feeding services at Fort Wainwright, Alaska under solicitation number W5168W-24-R-0014.

View the file

Other files

File Type Posted
Attachment Q - Technical Questions and Answers (W5168W24R0014).xlsx XLSX spreadsheet
Fort Wainwright W5168W24R0014 Solicitation Amendment 1.pdf PDF
Attachment R - Sample Materials Quantity List.xlsx XLSX spreadsheet
Attachment P - Fairbanks North Wage Determination 15-5683.pdf PDF
Attachment F - FWAK DFA 5 July 2023.docx DOCX document
Attachment B - FWAK AFMIS Headcount FY23_FY22_FY21.xlsx XLSX spreadsheet
Attachment K - Consent Forms for Release of Past Performance Info.pdf PDF
Attachment G - FWAK Pricing Matrix - 14Nov23.xlsx XLSX spreadsheet
Attachment E - FWAK Sample Materials List.xlsx XLSX spreadsheet
Attachment J - FWAK Pictures of Facilities.pptx PPTX presentation
Attachment I - Fort WainWright ISC CBA 2022-2025.docx.pdf PDF
Attachment L - Specific Relevant Contracts Reference Sheet.pdf PDF
Fort Wainwright W5168W24R0014 Solicitation.pdf PDF
Attachment D4 - FWAK Incidental Property.xlsx XLSX spreadsheet
Attachment O - FWAK DFA PWS 6 Nov 23.pdf PDF
Attachment M - Past Performance Questionnaire.docx DOCX document
Attachment C - FWAK DFA Building Plans.pdf PDF
Attachment A - FWAK DFAC Local Map.pdf PDF
Attachment H - FWAK DFA Staffing Matrix 3OCT23.xlsx XLSX spreadsheet
Show all 19

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 building worksheet. The Other Services and PMO tabs contain their own Instructions.
Note: This document is for example purposes only.
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 0930, 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 3416

BLDG:3416Note: This document is for example purposes only.Note: this document is for Example purposes only.
Capacity:800
Three meals per day 1 – 1200 meals
BREAKFASTLUNCHDINNER
0745-09151130-13001700 - 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:0016:0016:3017:0017:3018:0018:3019:0019:3020:0020:30Daily Hours
Food Sanitation Shift Leader1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0011.00
Pots and Pans2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.0022.00
Food Sanitation Specialist Clipper1.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0032.00
Food Sanitation Specialist Dining1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0010.50
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total per 1/2 Hour increment0.00.00.00.00.00.00.04.07.07.07.07.07.07.00.07.07.07.07.07.07.07.00.00.00.07.07.07.07.07.07.07.07.00.00.0
Total Daily Hours75.50
Three meals per day 1201 – 2400 meals
BREAKFASTLUNCHDINNER
0745-09151130-13001700 - 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:0016:0016:3017:0017:3018:0018:3019:0019:3020:0020:30Daily Hours
Food Sanitation Shift Leader1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0011.00
Pots and Pans3.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0033.00
Food Sanitation Specialist Clipper1.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.0042.50
Food Sanitation Specialist Dining2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.0021.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total per 1/2 Hour increment0.00.00.00.00.00.00.05.010.010.010.010.010.010.00.010.010.010.010.010.010.010.00.00.00.010.010.010.010.010.010.010.010.00.00.0
Total Daily Hours107.50
Two meals per day 1 – 1200 meals
BrunchSupper
0930-13001600-1730
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
Food Sanitation Shift Leader1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.008.50
Pots and Pans2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.0017.00
Food Sanitation Specialist Clipper1.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0024.50
Food Sanitation Specialist Dining1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.008.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total per 1/2 Hour increment0.00.00.00.00.00.00.00.00.00.00.04.07.07.07.07.07.07.07.07.07.07.00.00.07.07.07.07.07.07.00.00.00.00.00.0
Total Daily Hours58.00
Two meals per day 1201 – 2400 meals
BrunchSupper
0930-13001600-1730
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
Food Sanitation Shift Leader1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.008.50
Pots and Pans4.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0026.00
Food Sanitation Specialist Clipper1.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.0032.50
Food Sanitation Specialist Dining2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.0016.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total per 1/2 Hour increment0.00.00.00.00.00.00.00.00.00.00.06.010.010.010.010.010.010.010.010.010.010.00.00.010.010.010.010.010.010.00.00.00.00.00.0
Total Daily Hours83.00
100% Take-Out, three meals per day 1 – 1200 meals
BREAKFASTLUNCHDINNER
0745-09151130-13001700 - 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:0016: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
Total per 1/2 Hour increment0.00.00.00.00.00.00.00.00.00.00.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
Total Daily Hours- 0
100% Take-Out, three meals per day 1201 – 2400 meals
BREAKFASTLUNCHDINNER
0745-09151130-13001700 - 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:0016: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
Total per 1/2 Hour increment0.00.00.00.00.00.00.00.00.00.00.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
Total Daily Hours- 0
100% Take-Out, two meals per day 1 – 1200 meals
BrunchSupper
0930-13001600-1730
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
Total per 1/2 Hour increment0.00.00.00.00.00.00.00.00.00.00.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
Total Daily Hours- 0
100% Take-Out, two meals per day 1200 – 2400 meals
BrunchSupper
0930-13001600-1730
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
Total per 1/2 Hour increment0.00.00.00.00.00.00.00.00.00.00.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
Total Daily Hours- 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.

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

Bldg 3728

BLDG:3728Note: This document is for example purposes only.
Capacity:800
Three meals per day 1 – 1200 meals
BREAKFASTLUNCHDINNER
0745-09151130-13001700 - 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:0016:0016:3017:0017:3018:0018:3019:0019:3020:0020:30Daily Hours
Food Sanitation Shift Leader1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0011.00
Pots and Pans2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.0022.00
Food Sanitation Specialist Clipper1.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0032.00
Food Sanitation Specialist Dining1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0010.50
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total per 1/2 Hour increment0.00.00.00.00.00.00.04.07.07.07.07.07.07.00.07.07.07.07.07.07.07.00.00.00.07.07.07.07.07.07.07.07.00.00.0
Total Daily Hours75.50
Three meals per day 1201 – 2400 meals
BREAKFASTLUNCHDINNER
0745-09151130-13001700 - 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:0016:0016:3017:0017:3018:0018:3019:0019:3020:0020:30Daily Hours
Food Sanitation Shift Leader1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0011.00
Pots and Pans3.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0033.00
Food Sanitation Specialist Clipper1.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.0042.50
Food Sanitation Specialist Dining2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.0021.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total per 1/2 Hour increment0.00.00.00.00.00.00.05.010.010.010.010.010.010.00.010.010.010.010.010.010.010.00.00.00.010.010.010.010.010.010.010.010.00.00.0
Total Daily Hours107.50
Two meals per day 1 – 1200 meals
BrunchSupper
0930-13001600-1730
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
Food Sanitation Shift Leader1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.008.50
Pots and Pans2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.0017.00
Food Sanitation Specialist Clipper1.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0024.50
Food Sanitation Specialist Dining1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.008.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total per 1/2 Hour increment0.00.00.00.00.00.00.00.00.00.00.04.07.07.07.07.07.07.07.07.07.07.00.00.07.07.07.07.07.07.00.00.00.00.00.0
Total Daily Hours58.00
Two meals per day 1201 – 2400 meals
BrunchSupper
0930-13001600-1730
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
Food Sanitation Shift Leader1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.008.50
Pots and Pans4.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0026.00
Food Sanitation Specialist Clipper1.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.0032.50
Food Sanitation Specialist Dining2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.0016.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Total per 1/2 Hour increment0.00.00.00.00.00.00.00.00.00.00.06.010.010.010.010.010.010.010.010.010.010.00.00.010.010.010.010.010.010.00.00.00.00.00.0
Total Daily Hours83.00
100% Take-Out, three meals per day 1 – 1200 meals
BREAKFASTLUNCHDINNER
0745-09151130-13001700 - 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:0016: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
Total per 1/2 Hour increment0.00.00.00.00.00.00.00.00.00.00.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
Total Daily Hours- 0
100% Take-Out, three meals per day 1201 – 2400 meals
BREAKFASTLUNCHDINNER
0745-09151130-13001700 - 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:0016: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
Total per 1/2 Hour increment0.00.00.00.00.00.00.00.00.00.00.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
Total Daily Hours- 0
100% Take-Out, two meals per day 1 – 1200 meals
BrunchSupper
0930-13001600-1730
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
Total per 1/2 Hour increment0.00.00.00.00.00.00.00.00.00.00.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
Total Daily Hours- 0
100% Take-Out, two meals per day 1200 – 2400 meals
BrunchSupper
0930-13001600-1730
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
Total per 1/2 Hour increment0.00.00.00.00.00.00.00.00.00.00.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
Total Daily Hours- 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.

Other Services

Note: Other Services will be ordered under the applicable Building CLIN
Note: This document is for example purposes only.
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, in Columns C & E.

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 "DFA" is proposed for an additional 15 mins of DFAC serving time).

Extended Hours PWS 2.1.4Staffing for Bldg 3416Staffing for Bldg 3728
(EXAMPLE) DFA11

TOTAL FTEs 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, in Columns C & E.
Periodic In-Depth Cleaning PWS 4.2Staffing for Bldg 3416Staffing for Bldg 3728
(EXAMPLE) DFA11

TOTAL FTEs 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, in Columns C & E.
Dining Facility Opening PWS 4.3Staffing for Bldg 3416Staffing for Bldg 3728
(EXAMPLE) DFA11

TOTAL FTEs 0 0

IAW PWS 4.3
Complete the yellow boxes below for each service area:
Extended Hours:
1. Input the Labor Category beginning in A79.
2. Input the number of FTEs required for each position under each Bldg Column, in Columns C & E.
Dining Facility Closing PWS 4.3Staffing for Bldg 3416Staffing for Bldg 3728
(EXAMPLE) DFA11

TOTAL FTEs 0 0

PMO

Project Management Office (incl Q/C, HR, etc.)
Note: This document is for example purposes only.
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 .