SBHI Attachment H - Staffing Matrix blank -12MAY22.xlsx

XLSX spreadsheet 130 KB Posted

Attached to
Dining Facility Attendant Schofield Barracks, Hawaii
Solicitation number
W5168W-23-R-0005
Issued by

View the file

Other files

Show all 17

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

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

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 below the grey line in each
2. Columns C through AK: 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 "DFA" positions to work from 0700 to 0930 for Bldg.6065, enter 3 in columns K - N.
Breakfast
Position6:006:307:007:308:008:309:009:3010:00
DFA3.003.003.003.003.00
3. Column AL: 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. NOTE: Per the RFP, the Staffing Matrix shall only be completed for CLINs/SubCLINs within the Pricing Matrix that contain estimated quantities.

CLIN 0002 DFAC 6065

Weekdays/Weekends - Three Meals per day (1 - 474 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
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
Weekdays/Weekends - Three Meals per day (475 - 948 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
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
Fed. Holidays - Three Meals per day (1 - 527 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
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
100% Take-Out Weekdays/Weekends - Three Meals per day (1 - 948 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
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

CLIN 0003 DFAC 357

Weekdays - Three Meals per day (1 - 1,200 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
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
Weekdays - Three Meals per day (1,201 - 2,400 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
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
Weekends/Fed. Holidays - Two Meals per day (1 - 1,200 meals)
BrunchSupper
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
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
Thanksgiving - Three Meals per day (1 - 1,333 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
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
100% Take-Out Weekdays - Three Meals per day (1 - 1,200 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
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
Holiday Meal Prep and Night Baking Clean Up
BreakfastDinner
Position3:304:004:305:005:306:006:307:007:308:008:3014:0014:3015:0015:3016:0016:3017:0017:3018:0018:3019:0019:3020:0020:3021:0021:3022:0022: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
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

CLIN 0004 DFAC 102

Weekdays - Three Meals per day (1 - 750 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
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
Weekdays - Three Meals per day (751 - 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
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
Weekends/Fed. Holidays - Two Meals per day (1 - 750 meals)
BrunchSupper
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
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
Thanksgiving - Three Meals per day (1 - 833 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
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
100% Take-Out Weekdays - Three Meals per day (1 - 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
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
Holiday Meal Prep and Night Baking Clean Up
BreakfastDinner
Position3:304:004:305:005:306:006:307:007:308:008:3014:0014:3015:0015:3016:0016:3017:0017:3018:0018:3019:0019:3020:0020:3021:0021:3022:0022: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
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

CLIN 0005 DFAC 780

Weekdays - Three Meals per day (1 - 1,950 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
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
Weekends/Fed. Holidays - Two Meals per day (1 - 1,950 meals)
BrunchSupper
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
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
Thanksgiving - Three Meals per day (1 - 2,167 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
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
100% Take-Out Weekdays - Three Meals per day (1 - 1,950 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
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
Holiday Meal Prep and Night Baking Clean Up
BreakfastDinner
Position3:304:004:305:005:306:006:307:007:308:008:3014:0014:3015:0015:3016:0016:3017:0017:3018:0018:3019:0019:3020:0020:3021:0021:3022:0022: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
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 1.6.1.1
Complete the yellow boxes below for each service area:
1. Input the Labor Category beginning in A11.
2. Input the number of FTEs required for each position under Bldg 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 "DFA" is proposed for an additional 15 mins of DFAC serving time).

Extended Service Hours PWS 1.6.1.1Staffing for Bldg 6065Staffing for Bldg 357Staffing for Bldg 102Staffing for Bldg 780
(EXAMPLE) DFA1111

TOTAL FTEs per Quarter Hour 0 0 0 0

IAW PWS 4.2
Complete the yellow boxes below for each service area:
1. Input the Labor Category beginning in A31.
2. Input the number of FTEs required for each position under Bldg Column C.
Periodic In-depth Cleaning PWS 4.2Staffing for Bldg 6065Staffing for Bldg 357Staffing for Bldg 102Staffing for Bldg 780
(EXAMPLE) DFA1111

TOTAL FTEs 0 0 0 0

IAW PWS 4.3
1. Input the Labor Category beginning in A50.
2. Input the number of FTEs required for each position under Bldg Column C.
Dining Facility Opening and Closure PWS 4.3Staffing for Bldg 6065Staffing for Bldg 357Staffing for Bldg 102Staffing for Bldg 780
(EXAMPLE) DFA1111

TOTAL FTEs 0 0 0 0

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