Attachment 2_Staffing_Schedule_V2.xlsx

XLSX spreadsheet 57 KB Posted

Attached to
Nutrition Care Services; Military Treatment Facilities - Forts Irwin, Leonard Wood, Riley, Stewart, and West Point
Solicitation number
HT940827RE003
Issued by

About this file

Written by GovTribe AI ·

This is a Staffing Schedule template for a nutrition care food service contract supporting five military medical treatment facilities (MTFs): Weed Army Community Hospital (Fort Irwin, California), General Leonard Wood Community Hospital (Fort Leonard Wood, Missouri), Irwin Army Community Hospital (Fort Riley, Kansas), Winn Army Community Hospital (Fort Stewart, Georgia), and Keller Army Community Hospital (West Point, New York). The template provides a blank staffing matrix organized by facility and day type (Monday-Friday and Weekends/Holidays), with hourly time slots spanning from 3:30 AM to 8:30 PM in 30-minute increments. Contractors are instructed to enter labor categories aligned with Collective Bargaining Agreement (CBA) designations in the position column, specify the quantity of personnel assigned to each labor category for designated hours, and include all supervisory positions below a designated grey line. The template includes fields for calculating total production hours per full-time equivalent (FTE) and contains a separate Project Management Office (PMO) tab for listing administrative, quality control, and human resources personnel. Column AK contains automated formulas that calculate total daily hours for each position, eliminating the need for manual calculation.

This document is a template and instructional worksheet with no completed data entries. It does not specify staffing levels, labor categories, or pricing information, and serves only to establish the format and structure for contractors responding to solicitation HT940827RE003 to submit their proposed staffing plans for the Defense Health Agency's nutrition care food service requirement.

View the file

Other files

File Type Posted
West Point- Keller Army Community Hospital_Apr 2025.pptx PPTX presentation
Technical Exhibit K_Mission Essential.pdf PDF
Fort Riley- Irwin Army Community Hospital (part 2) Apr 2025.pptx PPTX presentation
PWS_ Nutrition Care Food Services.pdf PDF
HT940827RE003_Instructions_52.212-1.pdf PDF
Technical Exhibit D_Key Employees.pdf PDF
Attachment 1_Contractor_Teaming_Organization.docx DOCX document
Technical Exhibit J3_Fort Riley CBA.pdf PDF
Technical Exhibit A_Performance Requirement Summary.xlsx XLSX spreadsheet
Attachment 5_Consent_Letter.pdf PDF
Technical Exhibit B_Hours of Operation.pdf PDF
Technical Exhibit J4_Fort Stewart CBA.pdf PDF
Technical Exhibit E_Property Book Inventory.pdf PDF
Fort Irwin- Weed Army Community Hospital Apr 2025.pptx PPTX presentation
Technical Exhibit M_Deliverables for Contract.pdf PDF
Attachment 3_White_Paper_Performance_Summary.pdf PDF
Technical Exhibit H_Contract Sites Annual Historical Work Data.xlsx XLSX spreadsheet
HT940827RE003_Evaluation_52.212-2.pdf PDF
Attachment 6_Client Authorization Letter.pdf PDF
Technical Exhibit G_MR40-46_Cash Control.pdf PDF
Technical Exhibit J5_West Point CBA.pdf PDF
Solicitation SF 1449 - HT940827RE003.pdf PDF
Technical Exhibit L_Tri-Service-Food-Code_TB MED 530.pdf PDF
Fort Leonard Wood- General Leonard Wood Army Community_New Hospital Under Construction.pptx PPTX presentation
Attachment 4_Past_Performance_Questionnaire.docx DOCX document
Technical Exhibit J2_Fort Leonard Wood CBA.pdf PDF
Technical Exhibit F_MEMO Satisfaction Survey.pdf PDF
Technical Exhibit J1_Fort Irwin CBA.pdf PDF
Fort Stewart- Winn Army Community Hospital_Apr 2025.pptx PPTX presentation
Technical Exhibit C_Sample Menu.pdf PDF
Attachment 7_Pricing Worksheet_October 2026.xlsx XLSX spreadsheet
Fort Riley- Irwin Army Community Hospital (part 1) Apr 2025.pptx PPTX presentation
Show all 32

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 each building tab within the Staffing Matrix.
1. Column A: Enter the labor categories included in the proposal in the area highlighted in green starting under "Position" (i.e., Cook I, Cook II, 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 I" position's to work from 0530 to 0830, enter 3 in columns F - L.
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 10.5 hours.

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

TOTAL 0.000 0.00

Staffing Schedule

Fort Irwin, CA
Monday-Friday
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
Labor Category by CBA - Letter to designate position
Food Service Worker I - A0400 - 12000.00
Food Service Worker I - B0400 - 12000.00
Food Service Worker II - A0500 - 13000.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
Supervisory- 0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF0.00.00.00.00.00.00.00.00.00.00.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
Fort Irwin, CA
Weekends/Holidays
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
Supervisory- 0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF0.00.00.00.00.00.00.00.00.00.00.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
Fort Leonard Wood, GA
Monday-Friday
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
Supervisory- 0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
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
Fort Leonard Wood, GA
Weekends/Holidays
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
Supervisory- 0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF0.00.00.00.00.00.00.00.00.00.00.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
Fort Riley, KS
Monday-Friday
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
Supervisory- 0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF0.00.00.00.00.00.00.00.00.00.00.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
Fort Riley, KS
Weekends/Holidays
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
Supervisory- 0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF0.00.00.00.00.00.00.00.00.00.00.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
Fort Stewart, GA
Monday-Friday
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
Supervisory- 0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF0.00.00.00.00.00.00.00.00.00.00.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
Fort Stewart, GA
Weekends/Holidays
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
Supervisory- 0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF0.00.00.00.00.00.00.00.00.00.00.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
West Point, NY
Monday-Friday
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
Supervisory- 0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF0.00.00.00.00.00.00.00.00.00.00.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
West Point, NY
Weekends/Holidays
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
Supervisory- 0
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL STAFF0.00.00.00.00.00.00.00.00.00.00.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

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