Attachment O - FRAL Government Estimated Staffing Matrix 7 Oct 26.xlsx

XLSX spreadsheet 571 KB Posted

Attached to
Fort Rucker, AL Full Food Service
Solicitation number
W5168W27RA014
Issued by

About this file

This is a government-provided staffing matrix template for dining facility (DFAC) operations at Fort Rucker, AL. The spreadsheet serves as an estimating tool for contractors to input labor requirements across multiple dining facilities (Buildings 5914, 6204, and placeholder tabs for Buildings C, D, E, and F) and calculate total annual staffing hours by position and service category.

The matrix is structured to accommodate multiple staffing scenarios based on estimated patron capacity ranges and meal service times. For Building 5914 (702-person capacity), the template includes three primary scenarios: Weekday 3-Meals Per Day for 1-1,091 patrons, Weekday 3-Meals Per Day for 1,091-2,000 patrons, and Weekend 3-Meals Per Day. Building 6204 (400-person capacity) contains similar scenarios for lower capacity ranges. Each scenario requires input of staffing quantities by labor category (First Cook, Second Cook, Third Cook, Ration Clerk, Headcount Clerk, Secretary/Typist, Shift Leader, and various Mess Attendant positions) across 30-minute time increments throughout operating hours. The template automatically calculates total daily hours and annual hours by multiplying daily hours by estimated operating days. Additional service categories include extended hours meal service (priced in 0.5-hour increments), periodic in-depth cleaning, and dining facility opening/closing procedures. A CAP SUMMARY tab consolidates annual hour estimates by position across all facilities, with Building 5914 totaling 98,407 non-management hours and Building 6204 totaling 63,125 non-management hours. Management positions (Dining Facility Manager) are tracked separately as FTE counts rather than hourly rates.

View the file

Other files

File Type Posted
Attachment R - Past Performance Questionnaire.docx DOCX document
Attachment H - FRAL Staffing Matrix Offeror Input Template 7 Oct 26.xlsx XLSX spreadsheet
Solicitation Amendment - W5168W27RA0140001.pdf PDF
Attachment C - FRAL AFMIS Headcount.xlsx XLSX spreadsheet
Attachment I - FRAL Invoice Tracker.xlsx XLSX spreadsheet
Attachment D3 - FRAL Durable Property.xlsx XLSX spreadsheet
Attachment L - FRAL Collective Bargaining Agreement_Language Modification.docx DOCX document
Attachment D2 - FRAL Real Property.xlsx XLSX spreadsheet
Attachment_L___FRAL_Collective_Bargaining_Agreement.pdf PDF
Attachment F2 - FRAL Building Plans.pdf PDF
Attachment F1 - FRAL Dining Facility Location Map.pdf PDF
Attachment A - FRAL FFS PWS 20 Oct 26.pdf PDF
Attachment F3 - FRAL Pictures of Facilities.pdf PDF
Attachment K - FRAL Contractor Accident Reporting Format.xlsx XLSX spreadsheet
Attachment Q - Past Performance Consent Letter.docx DOCX document
Attachment E - FRAL Sample Materials List.xlsx XLSX spreadsheet
Attachment B - FRAL Workload Data Capabilities.xlsx XLSX spreadsheet
Attachment P - Past Performance Reference Sheet.docx DOCX document
Attachment D1 - FRAL GFP Listing.xlsx XLSX spreadsheet
Attachment D4 - FRAL Incidental Property.xlsx XLSX spreadsheet
Attachment G - FRAL Pricing Matrix 19 Oct 2026.xlsx XLSX spreadsheet
Attachment M -FRAL Wage Determination 2015-4631.pdf PDF
Show all 22

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

Instructions These instructions apply to the tabs for each bldg. The CAP SUMMARY tab will automatically calculate, input is not needed. The PMO tab contains separate instructions.

1. Positions: For each building tab, input positions at the bottom in rows 267-282. The positions will be automatically populated throughout the tab for each staffing scenario.
a.After all positions and staffing scenarios have been input, the number of hours for each service will automatically populate at the bottom of each tab in rows 267-278.
b.For management positions, input the number of FTEs in column G rows 280-282. Total management hours are for informational purposes only and will not be priced hourly.
2. For Staffing Scenarios (e.g. Weekdays Three meals per day; Weekends Two meals per day meals per day)
Columns B through AJ: Enter the quantity of people in each labor category listed 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 E - I.
Breakfast
Position6:006:307:007:308:008:309:009:3010:00
DFA3.003.003.003.003.00
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.
3. For "Other Services" Starting on Row 265:
a.Extended Hours
Column L: Enter the quantity of people in each labor category listed to support this function.
Column M: Automatic calculation to show the number of people input in Column L into a half hour.
Column N: Automatic calculation to total hours per position based on the estimated quantity provided by the USG.
In the example below, 1 Cook I, would be .5 hours for a half hour, using the quantity of 6 instances per year, the total annual hours for Cook I is 3 hours.
In the example below, 3 Cook II, would be 1.5 hours for a half hour, using the quantity of 6 instances per year, the total annual hours for Cook II is 9 hours.
Labor CategoryFTEs.5 hour totalAnnual Hours
Cook I10.53
Cook II31.59
# of times per year6
b.Periodic In-Depth Cleaning
Column T: Enter the quantity of hours for each labor category listed to support this function.
Column U: Automatic calculation to show the annual hours by multiplying the input hours per instance by the estimated occurrences per year provide by the USG.
In the example below, 8 hours for Cook I for 2 occurrences per year, calculates a total of 16 hours annually for Cook I.
In the example below, 24 hours for Cook II for 2 occurrences per year, calculates a total of 48 hours annually for Cook II.
Labor CategoryHours per InstanceAnnual Hours
Cook I816
Cook II2448
# of times per year2
c.Dining Facility Opening or Closing
Column AA: Enter the quantity of hours for each labor category listed to support this function.
Column AB: Automatic calculation to show the annual hours by multiplying the input hours per instance by the estimated occurrences per year provided by the USG.
In the example below, 8 hours for Cook I for 3 occurrences per year, calculates a total of 24 hours annually for Cook I.
In the example below, 16 hours for Cook II for 3 occurrences per year, calculates a total of 48 hours annually for Cook II.
Labor CategoryHours per InstanceAnnual Hours
Cook I824
Cook II1648

# of times per year 3

CAP SUMMARY

Bldg 5914Bldg 6204
PositionAnnual CAP by PositionPositionAnnual CAP by Position
First Cook5,067.00First Cook3,508.00
Second Cook13,159.00Second Cook9,154.00
Third Cook18,162.00Third Cook9,154.00
Ration Clerk5,259.00Ration Clerk4,183.00
Headcount Clerk5,632.00Headcount Clerk3,840.00
Secretary/Typist4,347.00Secretary/Typist2,968.00
0- 00- 0
Shift Leader4,895.00Shift Leader3,381.00
Mess Attendant (Pots &Pans)12,709.00Mess Attendant (Pots &Pans)8,819.00
Mess Attendant (Clipper Room)16,918.00Mess Attendant (Clipper Room)9,634.00
Mess Attendant (Dining Room)12,259.00Mess Attendant (Dining Room)8,484.00
0- 00- 0
Total Non-Management98,407.00Total Non-Management63,125.00

PMO

Project Management Office (incl Q/C, HR, etc.)

Labor Category Number FTEs

TOTAL - 0

Bldg 5914

BLDG:5914
Capacity:702
Weekday 3-Meals Per Day (1-1,091)
BREAKFASTLUNCHDINNER
0630-08001130-13001730-1900Estimated Days
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 Hours132
First Cook1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0014.50
Second Cook2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.0029.00
Third Cook3.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0043.50
Ration Clerk1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0012.50
Headcount Clerk2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.0016.00
Secretary/Typist1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0012.50
00.00
Shift Leader1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0014.00
Mess Attendant (Pots &Pans)2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.0028.00
Mess Attendant (Clipper Room)3.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0040.50
Mess Attendant (Dining Room)2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.0027.00
00.00
Total Non-Management237.50
Management
Dining Facility Manager1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0015.50
00.00
00.00
Total Management15.50
Total per 1/2 Hour increment0.00.00.07.010.019.019.019.019.019.017.017.017.01.017.019.019.019.019.019.019.017.01.017.017.017.017.019.019.019.019.019.015.015.00.0
Total Daily Hours253.00
Weekday 3-Meals Per Day (1,091-2,000)
BREAKFASTLUNCHDINNEREstimated Days
0630-08001130-13001730-1900114
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
First Cook1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0014.50
Second Cook3.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0043.50
Third Cook4.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.0058.00
Ration Clerk2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.001.001.001.001.001.001.001.001.001.0020.50
Headcount Clerk2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.0016.00
Secretary/Typist1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0012.50
00.00
Shift Leader1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0014.00
Mess Attendant (Pots &Pans)3.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0042.00
Mess Attendant (Clipper Room)4.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.0054.00
Mess Attendant (Dining Room)3.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0040.50
00.00
Total Non-Management315.50
Management
Dining Facility Manager1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0015.50
00.00
00.00
Total Management15.50
Total per 1/2 Hour increment0.00.00.09.013.025.025.025.025.025.023.023.023.01.023.025.025.025.025.025.025.023.01.022.022.022.022.024.024.024.024.024.020.020.00.0
Total Daily Hours331.00
Weekend 3-Meals Per Day
BREAKFASTLUNCHDINNEREstimated Days
0630-08301115-13151700-190098
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
First Cook1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0014.50
Second Cook3.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0043.50
Third Cook4.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.0058.00
Ration Clerk1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0012.50
Headcount Clerk2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.0017.00
Secretary/Typist1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0012.50
00.00
Shift Leader1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0014.00
Mess Attendant (Pots &Pans)3.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0042.00
Mess Attendant (Clipper Room)4.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.004.0054.00
Mess Attendant (Dining Room)3.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0040.50
00.00
Total Non-Management308.50
Management
Dining Facility Manager1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0015.50
00.00
00.00
Total Management15.50
Total per 1/2 Hour increment0.00.00.09.013.024.024.024.024.024.022.022.022.01.022.024.024.024.024.024.024.022.01.022.022.022.024.024.024.024.024.024.020.020.00.0
Total Daily Hours324.00
Staffing Scenario
BREAKFASTLUNCHDINNEREstimated Days
0700-09301200 - 13301600 - 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
First Cook0.00
Second Cook0.00
Third Cook0.00
Ration Clerk0.00
Headcount Clerk0.00
Secretary/Typist0.00
00.00
Shift Leader0.00
Mess Attendant (Pots &Pans)0.00
Mess Attendant (Clipper Room)0.00
Mess Attendant (Dining Room)0.00
00.00
Total Non-Management- 0
Management
Dining Facility Manager0.00
00.00
00.00
Total Management- 0
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 Scenario
BREAKFASTLUNCHDINNEREstimated Days
0700-09301200 - 13301600 - 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
First Cook0.00
Second Cook0.00
Third Cook0.00
Ration Clerk0.00
Headcount Clerk0.00
Secretary/Typist0.00
00.00
Shift Leader0.00
Mess Attendant (Pots &Pans)0.00
Mess Attendant (Clipper Room)0.00
Mess Attendant (Dining Room)0.00
00.00
Total Non-Management- 0
Management
Dining Facility Manager0.00
00.00
00.00
Total Management- 0
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 Scenario
BREAKFASTLUNCHDINNEREstimated Days
0700-09301200 - 13301600 - 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
First Cook0.00
Second Cook0.00
Third Cook0.00
Ration Clerk0.00
Headcount Clerk0.00
Secretary/Typist0.00
00.00
Shift Leader0.00
Mess Attendant (Pots &Pans)0.00
Mess Attendant (Clipper Room)0.00
Mess Attendant (Dining Room)0.00
00.00
Total Non-Management- 0
Management
Dining Facility Manager0.00
00.00
00.00
Total Management- 0
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 Scenario
BREAKFASTLUNCHDINNEREstimated Days
0700-09301200 - 13301600 - 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
First Cook0.00
Second Cook0.00
Third Cook0.00
Ration Clerk0.00
Headcount Clerk0.00
Secretary/Typist0.00
00.00
Shift Leader0.00
Mess Attendant (Pots &Pans)0.00
Mess Attendant (Clipper Room)0.00
Mess Attendant (Dining Room)0.00
00.00
Total Non-Management- 0
Management
Dining Facility Manager0.00
00.00
00.00
Total Management- 0
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 Scenario
BREAKFASTLUNCHDINNEREstimated Days
0700-09301200 - 13301600 - 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
First Cook0.00
Second Cook0.00
Third Cook0.00
Ration Clerk0.00
Headcount Clerk0.00
Secretary/Typist0.00
00.00
Shift Leader0.00
Mess Attendant (Pots &Pans)0.00
Mess Attendant (Clipper Room)0.00
Mess Attendant (Dining Room)0.00
00.00
Total Non-Management- 0
Management
Dining Facility Manager0.00
00.00
00.00
Total Management- 0
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 Scenario
BREAKFASTLUNCHDINNEREstimated Days
0700-09301200 - 13301600 - 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
First Cook0.00
Second Cook0.00
Third Cook0.00
Ration Clerk0.00
Headcount Clerk0.00
Secretary/Typist0.00
00.00
Shift Leader0.00
Mess Attendant (Pots &Pans)0.00
Mess Attendant (Clipper Room)0.00
Mess Attendant (Dining Room)0.00
00.00
Total Non-Management- 0
Management
Dining Facility Manager0.00
00.00
00.00
Total Management- 0
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 Scenario
BREAKFASTLUNCHDINNEREstimated Days
0700-09301200 - 13301600 - 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
First Cook0.00
Second Cook0.00
Third Cook0.00
Ration Clerk0.00
Headcount Clerk0.00
Secretary/Typist0.00
00.00
Shift Leader0.00
Mess Attendant (Pots &Pans)0.00
Mess Attendant (Clipper Room)0.00
Mess Attendant (Dining Room)0.00
00.00
Total Non-Management- 0
Management
Dining Facility Manager0.00
00.00
00.00
Total Management- 0
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
Total Days344.00
PositionDFAC ServiceExtendedDeep CleaningOpen/CloseTotal HoursExtended Hour Meal Svc PWS 1.6.1.1, priced in .5 hoursPeriodic In-Depth Cleaning PWS 4.2Dining Facility Opening or Closing PWS 4.3
Labor CategoryFTEs per 1/2 hour increment.5 hr TotalAnnual HoursLabor CategoryHours per InstanceAnnual HoursLabor CategoryHours per InstanceAnnual Hours
First Cook4,988.001532.00325,067.00First Cook10.515First Cook832First Cook832
Second Cook13,050.004532.003213,159.00Second Cook31.545Second Cook832Second Cook832
Third Cook18,038.006032.003218,162.00Third Cook4260Third Cook832Third Cook832
Ration Clerk5,212.0015- 0325,259.00Ration Clerk10.515Ration Clerk0Ration Clerk832
Headcount Clerk5,602.0030- 005,632.00Headcount Clerk2130Headcount Clerk0Headcount Clerk0
Secretary/Typist4,300.0015- 0324,347.00Secretary/Typist10.515Secretary/Typist0Secretary/Typist832
- 00- 00- 00000000
Shift Leader4,816.001532.00324,895.00Shift Leader10.515Shift Leader832Shift Leader832
Mess Attendant (Pots &Pans)12,600.004532.003212,709.00Mess Attendant (Pots &Pans)31.545Mess Attendant (Pots &Pans)832Mess Attendant (Pots &Pans)832
Mess Attendant (Clipper Room)16,794.006032.003216,918.00Mess Attendant (Clipper Room)4260Mess Attendant (Clipper Room)832Mess Attendant (Clipper Room)832
Mess Attendant (Dining Room)12,150.004532.003212,259.00Mess Attendant (Dining Room)31.545Mess Attendant (Dining Room)832Mess Attendant (Dining Room)832
- 00- 00- 00000000
Management PositionManagement PositionManagement PositionManagement Position
Dining Facility ManagerDining Facility Manager00Dining Facility Manager0Dining Facility Manager0
0000000
0000000
97,550.00345.00224.00288.0098,407.00- 0
Extended Meal Svc .5 hour30# of times per year4# of times per year4

Bldg 6204

BLDG:6204
Capacity:400
Weekday 3-Meals Per Day (1-880)
BREAKFASTLUNCHDINNER
0700-08301100-12301700-1830Estimated Days
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 Hours92
First Cook1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0013.50
Second Cook2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.0027.00
Third Cook2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.0027.00
Ration Clerk1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0011.50
Headcount Clerk2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.0015.00
Secretary/Typist1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0011.50
00.00
Shift Leader1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0013.00
Mess Attendant (Pots &Pans)2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.0026.00
Mess Attendant (Clipper Room)3.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0037.50
Mess Attendant (Dining Room)2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.002.0025.00
00.00
Total Non-Management207.00
Management
Dining Facility Manager1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0014.50
00.00
00.00
Total Management14.50
Total per 1/2 Hour increment0.00.00.00.06.09.018.018.018.018.018.016.016.01.018.018.018.018.018.016.016.016.01.016.016.016.018.018.018.018.018.014.014.00.00.0
Total Daily Hours221.50
Weekday 3-Meals Per Day (881-1300)
BREAKFASTLUNCHDINNEREstimated Days
0700-08301100-12301700-1830162
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
First Cook1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0013.50
Second Cook3.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0040.50
Third Cook3.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0040.50
Ration Clerk2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.001.001.001.001.001.001.001.001.0019.00
Headcount Clerk2.002.002.002.002.002.002.002.002.002.002.002.002.002.002.0015.00
Secretary/Typist1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0011.50
00.00
Shift Leader1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0013.00
Mess Attendant (Pots &Pans)3.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0039.00
Mess Attendant (Clipper Room)3.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0037.50
Mess Attendant (Dining Room)3.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.003.0037.50
00.00
Total Non-Management267.00
Management
Dining Facility Manager1.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.001.0014.50
00.00
00.00
Total Management14.50
Total per 1/2 Hour increment0.00.00.00.08.012.023.023.023.023.023.021.021.01.023.023.023.023.023.021.021.021.01.020.020.020.022.022.022.022.022.018.018.00.00.0
Total Daily Hours281.50
Staffing Scenario
BREAKFASTLUNCHDINNEREstimated Days
0700-09301200 - 13301600 - 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
First Cook0.00
Second Cook0.00
Third Cook0.00
Ration Clerk0.00
Headcount Clerk0.00
Secretary/Typist0.00
00.00
Shift Leader0.00
Mess Attendant (Pots &Pans)0.00
Mess Attendant (Clipper Room)0.00
Mess Attendant (Dining Room)0.00
00.00
Total Non-Management- 0
Management
Dining Facility Manager0.00
00.00
00.00
Total Management- 0
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 Scenario
BREAKFASTLUNCHDINNEREstimated Days
0700-09301200 - 13301600 - 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
First Cook0.00
Second Cook0.00
Third Cook0.00
Ration Clerk0.00
Headcount Clerk0.00
Secretary/Typist0.00
00.00
Shift Leader0.00
Mess Attendant (Pots &Pans)0.00
Mess Attendant (Clipper Room)0.00
Mess Attendant (Dining Room)0.00
00.00
Total Non-Management- 0
Management
Dining Facility Manager0.00
00.00
00.00
Total Management- 0
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 Scenario
BREAKFASTLUNCHDINNEREstimated Days
0700-09301200 - 13301600 - 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
First Cook0.00
Second Cook0.00
Third Cook0.00
Ration Clerk0.00
Headcount Clerk0.00
Secretary/Typist0.00
00.00
Shift Leader0.00
Mess Attendant (Pots &Pans)0.00
Mess Attendant (Clipper Room)0.00
Mess Attendant (Dining Room)0.00
00.00
Total Non-Management- 0
Management
Dining Facility Manager0.00
00.00
00.00
Total Management- 0
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 Scenario
BREAKFASTLUNCHDINNEREstimated Days
0700-09301200 - 13301600 - 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
First Cook0.00
Second Cook0.00
Third Cook0.00
Ration Clerk0.00
Headcount Clerk0.00
Secretary/Typist0.00
00.00
Shift Leader0.00
Mess Attendant (Pots &Pans)0.00
Mess Attendant (Clipper Room)0.00
Mess Attendant (Dining Room)0.00
00.00
Total Non-Management- 0
Management
Dining Facility Manager0.00
00.00
00.00
Total Management- 0
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 Scenario
BREAKFASTLUNCHDINNEREstimated Days
0700-09301200 - 13301600 - 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
First Cook0.00
Second Cook0.00
Third Cook0.00
Ration Clerk0.00
Headcount Clerk0.00
Secretary/Typist0.00
00.00
Shift Leader0.00
Mess Attendant (Pots &Pans)0.00
Mess Attendant (Clipper Room)0.00
Mess Attendant (Dining Room)0.00
00.00
Total Non-Management- 0
Management
Dining Facility Manager0.00
00.00
00.00
Total Management- 0
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 Scenario
BREAKFASTLUNCHDINNEREstimated Days
0700-09301200 - 13301600 - 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
First Cook0.00
Second Cook0.00
Third Cook0.00
Ration Clerk0.00
Headcount Clerk0.00
Secretary/Typist0.00
00.00
Shift Leader0.00
Mess Attendant (Pots &Pans)0.00
Mess Attendant (Clipper Room)0.00
Mess Attendant (Dining Room)0.00
00.00
Total Non-Management- 0
Management
Dining Facility Manager0.00
00.00
00.00
Total Management- 0
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 Scenario
BREAKFASTLUNCHDINNEREstimated Days
0700-09301200 - 13301600 - 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
First Cook0.00
Second Cook0.00
Third Cook0.00
Ration Clerk0.00
Headcount Clerk0.00
Secretary/Typist0.00
00.00
Shift Leader0.00
Mess Attendant (Pots &Pans)0.00
Mess Attendant (Clipper Room)0.00
Mess Attendant (Dining Room)0.00
00.00
Total Non-Management- 0
Management
Dining Facility Manager0.00
00.00
00.00
Total Management- 0
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 Scenario
BREAKFASTLUNCHDINNEREstimated Days
0700-09301200 - 13301600 - 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
First Cook0.00
Second Cook0.00
Third Cook0.00
Ration Clerk0.00
Headcount Clerk0.00
Secretary/Typist0.00
00.00
Shift Leader0.00
Mess Attendant (Pots &Pans)0.00
Mess Attendant (Clipper Room)0.00
Mess Attendant (Dining Room)0.00
00.00
Total Non-Management- 0
Management
Dining Facility Manager0.00
00.00
00.00
Total Management- 0
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
Total Days254.00
PositionDFAC ServiceExtendedDeep CleaningOpen/CloseTotal HoursExtended Hour Meal Svc PWS 1.6.1.1, priced in .5 hoursPeriodic In-Depth Cleaning PWS 4.2Dining Facility Opening or Closing PWS 4.3
Labor CategoryFTEs per 1/2 hour increment.5 hr TotalAnnual HoursLabor CategoryHours per InstanceAnnual HoursLabor CategoryHours per InstanceAnnual Hours
First Cook3,429.001532.00323,508.00First Cook10.515First Cook832First Cook832
Second Cook9,045.004532.00329,154.00Second Cook31.545Second Cook832Second Cook832
Third Cook9,045.004532.00329,154.00Third Cook31.545Third Cook832Third Cook832
Ration Clerk4,136.0015- 0324,183.00Ration Clerk10.515Ration Clerk0Ration Clerk832
Headcount Clerk3,810.0030- 003,840.00Headcount Clerk2130Headcount Clerk0Headcount Clerk0
Secretary/Typist2,921.0015- 0322,968.00Secretary/Typist10.515Secretary/Typist0Secretary/Typist832
- 00- 00- 00000000
Shift Leader3,302.001532.00323,381.00Shift Leader10.515Shift Leader832Shift Leader832
Mess Attendant (Pots &Pans)8,710.004532.00328,819.00Mess Attendant (Pots &Pans)31.545Mess Attendant (Pots &Pans)832Mess Attendant (Pots &Pans)832
Mess Attendant (Clipper Room)9,525.004532.00329,634.00Mess Attendant (Clipper Room)31.545Mess Attendant (Clipper Room)832Mess Attendant (Clipper Room)832
Mess Attendant (Dining Room)8,375.004532.00328,484.00Mess Attendant (Dining Room)31.545Mess Attendant (Dining Room)832Mess Attendant (Dining Room)832
- 00- 00- 00000000
Management PositionManagement PositionManagement PositionManagement Position
Dining Facility ManagerDining Facility Manager00Dining Facility Manager0Dining Facility Manager0
0000000
0000000
62,298.00315.00224.00288.0063,125.00- 0
Extended Meal Svc .5 hour30# of times per year4# of times per year4

Bldg C

BLDG:C
Capacity:XXXX
Staffing Scenario
BREAKFASTLUNCHDINNER
0730-09001130-13001630-1800Estimated Days
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
00.00
00.00
00.00
00.00
00.00
00.00
00.00
00.00
00.00
00.00
00.00
00.00
Total Non-Management- 0
Management
00.00
00.00
00.00
Total Management- 0
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 Scenario
BREAKFASTLUNCHDINNEREstimated Days
0700-09301200 - 13301600 - 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
00.00
00.00
00.00
00.00
00.00
00.00
00.00
00.00
00.00
00.00
00.00
00.00
Total Non-Management- 0
Management
00.00
00.00
00.00
Total Management- 0

This is the start of the file's text. The full file is on GovTribe.

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