Attachment H - FWAK DFA Staffing Matrix 3OCT23.xlsx

XLSX spreadsheet 84 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 document contains a staffing matrix template for a federal dining facility attendant contract opportunity. The template outlines staffing requirements for multiple buildings and meal service scenarios. Labor categories include dining facility attendants and shift leaders. Staffing levels are specified in half-hour increments for breakfast, lunch, dinner, brunch, and supper meal periods. Templates are also included for optional contract line items for extended hours services, periodic deep cleaning, and dining facility opening and closing support. The staffing matrix requests contractors populate the templates to indicate their proposed labor categories and staffing levels to meet the requirements. A separate section is included for project management office labor categories and full-time equivalents. The associated federal opportunity is for dining facility attendant services at Fort Wainwright under solicitation number W5168W-24-R-0014 from the Department of the Army. Response is requested using the staffing matrix template to outline the offeror's proposed staffing approach.

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 N - Example Staffing Matrix FWAK.xlsx XLSX spreadsheet
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
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.
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:3416
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
0.00
0.00
0.00
0.00
0.00
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
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
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
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
0.00
0.00
0.00
0.00
0.00
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 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:3728
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
0.00
0.00
0.00
0.00
0.00
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
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
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
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
0.00
0.00
0.00
0.00
0.00
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 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

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.)
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 .