Attachment_9_Staffing_Matrix.xlsx

XLSX spreadsheet 79 KB Posted

Attached to
Full Food Services Federal contract opportunity
Solicitation number
FA301018R0001
Issued by
Department of the Air Force Air Education and Training Command

About this file

Attachment 9 - Staffing Matrix

View the file

Other files for this federal contract opportunity

Other files attached to Full Food Services, newest first.
File Type Posted
Amendment_0003_to_FA301018R0001.pdf PDF
Additional_info_for_52.208-9.docx DOCX document
Amend_2_FA301018R0001.pdf PDF
Food_Service__PWS__Revised_18_Dec_17.pdf PDF
FA301018R00010001.pdf PDF
Food_Service__PWS__Revised_11_Dec_17.pdf PDF
2017_Preface_to_WW_Menu.pdf PDF
Q_&_A_13_Dec_17.pdf PDF
Q_&_A_posted_8_Dec_17.pdf PDF
Q_&_A_5_Dec_17.pdf PDF
PWS_Atch_1-5_Initial_Supplies_All_DFACs.pdf PDF
Q_&_A_5_Dec_17.pdf PDF
Site_Visit_Sign-In_29_Nov_17.pdf PDF
Q__A_28_Nov_17.pdf PDF
PWS_Atch_1-4_GFE__warehouse_office.xlsx XLSX spreadsheet
Attachment_7_Client_Authorization_Letter.doc DOC document
PWS_Atch_1-2_GFE_BLDG_7904_Magnolia.xlsx XLSX spreadsheet
PWS_Atch_1-3__GFE_BLDG_6960_Azalea.xlsx XLSX spreadsheet
Attachment_5_PP_Questionnaire.doc DOC document
PWS_Atch_1-1_GFE_BLDG_2001_Live_Oak.xlsx XLSX spreadsheet
FA301018R0001.pdf PDF
Attachment_2_Wage_Determination_20_15-5147_Rev_3.pdf PDF
Attachment_6_Subcontractor_Teaming_Consent.doc DOC document
Attachment_3_CBA-with_Addendum.pdf PDF
Attachment_1__Food_Service__PWS__29_Aug__17.pdf PDF
ppi_tool.accdb MDB file
Attachment_8__KAFB_Incentive_Option_Periods_v2.0.pdf PDF
Attachment_4__Instructions_for_PPI_Tool_v4.0_4_Oct_17.docx DOCX document
Show all 28

On GovTribe

Work with this file on GovTribe

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

Text version

Matrix- Azalea Weekdays

A (Gray)BC (Blue)
00000000000000111111111111111111112TOTAL
33445566778899001122334455667788990HOURS
03030303030303030303030303030303030
00000000000000000000000000000000000
COOK I0.00
COOK II0.00
IN-FLIGHT COOK0.00
SALAD MAKER0.00
CASHIER0.00
FSS (SERVE)0.00
FSS (SERVE/CLEAN)0.00
FSS (SETUP/SERVE/CLEAN)0.00
FSS (PASTRY/FRUIT BAR))0.00
FSS (POT & PANS)0.00
FSS (POTS/PANS/KITCHEN CLEANUP)0.00
FSS (CLIPPER)0.00
FSS (BUSSERS)0.00
FSS (BUSSER/CLIPPER)0.00
FSS (MILK LINE)0.00
FSS (ICE CREAM)0.00
FSS (UTILITY/OTHER)0.00
FSS (PREP/CLIPPER)0.00
FSS (PREP/POTS & PANS)0.00
STOREKEEPER I0.00
STOREKEEPER II0.00
TRUCK DRIVER0.00
TRUCK DRIVER (PREP/TRUCK DRIVER)0.00
MANAGER0.00
SUPERVISOR0.00
0.00
0.00
0.00
FSS = FOOD SANITATION SPECIALISTDirect Labor0.00
Number of days
0
A (Gray)BC (Blue)
2222222200000TOTAL
0112233401122HOURS
3030303030303
0000000000000
COOK I0.00
COOK II0.00
IN-FLIGHT COOK0.00
SALAD MAKER0.00
CASHIER0.00
FSS (SERVE)0.00
FSS (SERVE/CLEAN)0.00
FSS (SETUP/SERVE/CLEAN)0.00
FSS (PASTRY/FRUIT BAR)0.00
FSS (POT & PANS)0.00
FSS (POTS/PANS/KITCHEN CLEANUP)0.00
FSS (CLIPPER)0.00
FSS (BUSSERS)0.00
FSS (BUSSER/CLIPPER)0.00
FSS (MILK LINE)0.00
FSS (ICE CREAM)0.00
FSS (UTILITY/OTHER)0.00
FSS (PREP/CLIPPER)0.00
FSS (PREP/POTS & PANS)0.00
STOREKEEPER I0.00
STOREKEEPER II0.00
TRUCK DRIVER0.00
TRUCK DRIVER (PREP/TRUCK DRIVER)0.00
MANAGER0.00
SUPERVISOR0.00
0.00
0.00
0.00
FSS = FOOD SANITATION SPECIALISTDirect Labor0.00
Number of days
0

Matrix- Azalea Weekends

A (Gray)BC (Blue)
00000000000000111111111111111111112TOTAL
33445566778899001122334455667788990HOURS
03030303030303030303030303030303030
00000000000000000000000000000000000
COOK I0.00
COOK II0.00
IN-FLIGHT COOK0.00
SALAD MAKER0.00
CASHIER0.00
FSS (SERVE)0.00
FSS (SERVE/CLEAN)0.00
FSS (SETUP/SERVE/CLEAN)0.00
FSS (PASTRY/FRUIT BAR))0.00
FSS (POT & PANS)0.00
FSS (POTS/PANS/KITCHEN CLEANUP)0.00
FSS (CLIPPER)0.00
FSS (BUSSERS)0.00
FSS (BUSSER/CLIPPER)0.00
FSS (MILK LINE)0.00
FSS (ICE CREAM)0.00
FSS (UTILITY/OTHER)0.00
FSS (PREP/CLIPPER)0.00
FSS (PREP/POTS & PANS)0.00
STOREKEEPER I0.00
STOREKEEPER II0.00
TRUCK DRIVER0.00
TRUCK DRIVER (PREP/TRUCK DRIVER)0.00
MANAGER0.00
SUPERVISOR0.00
0.00
0.00
0.00
FSS = FOOD SANITATION SPECIALISTDirect Labor0.00
Number of days
0
A (Gray)BC (Blue)
2222222200000TOTAL
0112233401122HOURS
3030303030303
0000000000000
COOK I0.00
COOK II0.00
IN-FLIGHT COOK0.00
SALAD MAKER0.00
CASHIER0.00
FSS (SERVE)0.00
FSS (SERVE/CLEAN)0.00
FSS (SETUP/SERVE/CLEAN)0.00
FSS (PASTRY/FRUIT BAR)0.00
FSS (POT & PANS)0.00
FSS (POTS/PANS/KITCHEN CLEANUP)0.00
FSS (CLIPPER)0.00
FSS (BUSSERS)0.00
FSS (BUSSER/CLIPPER)0.00
FSS (MILK LINE)0.00
FSS (ICE CREAM)0.00
FSS (UTILITY/OTHER)0.00
FSS (PREP/CLIPPER)0.00
FSS (PREP/POTS & PANS)0.00
STOREKEEPER I0.00
STOREKEEPER II0.00
TRUCK DRIVER0.00
TRUCK DRIVER (PREP/TRUCK DRIVER)0.00
MANAGER0.00
SUPERVISOR0.00
0.00
0.00
0.00
FSS = FOOD SANITATION SPECIALISTDirect Labor0.00
Number of days
0

Matrix- Central Prep

A (Gray)BC (Blue)
00000000000000111111111111111111112TOTAL
33445566778899001122334455667788990HOURS
03030303030303030303030303030303030
00000000000000000000000000000000000
COOK I0.00
COOK II0.00
IN-FLIGHT COOK0.00
SALAD MAKER0.00
CASHIER0.00
FSS (SERVE)0.00
FSS (SERVE/CLEAN)0.00
FSS (SETUP/SERVE/CLEAN)0.00
FSS (PASTRY/FRUIT BAR))0.00
FSS (POT & PANS)0.00
FSS (POTS/PANS/KITCHEN CLEANUP)0.00
FSS (CLIPPER)0.00
FSS (BUSSERS)0.00
FSS (BUSSER/CLIPPER)0.00
FSS (MILK LINE)0.00
FSS (ICE CREAM)0.00
FSS (UTILITY/OTHER)0.00
FSS (PREP/CLIPPER)0.00
FSS (PREP/POTS & PANS)0.00
STOREKEEPER I0.00
STOREKEEPER II0.00
TRUCK DRIVER0.00
TRUCK DRIVER (PREP/TRUCK DRIVER)0.00
MANAGER0.00
SUPERVISOR0.00
0.00
0.00
0.00
FSS = FOOD SANITATION SPECIALISTDirect Labor0.00
Number of days
0
A (Gray)BC (Blue)
2222222200000TOTAL
0112233401122HOURS
3030303030303
0000000000000
COOK I0.00
COOK II0.00
IN-FLIGHT COOK0.00
SALAD MAKER0.00
CASHIER0.00
FSS (SERVE)0.00
FSS (SERVE/CLEAN)0.00
FSS (SETUP/SERVE/CLEAN)0.00
FSS (PASTRY/FRUIT BAR)0.00
FSS (POT & PANS)0.00
FSS (POTS/PANS/KITCHEN CLEANUP)0.00
FSS (CLIPPER)0.00
FSS (BUSSERS)0.00
FSS (BUSSER/CLIPPER)0.00
FSS (MILK LINE)0.00
FSS (ICE CREAM)0.00
FSS (UTILITY/OTHER)0.00
FSS (PREP/CLIPPER)0.00
FSS (PREP/POTS & PANS)0.00
STOREKEEPER I0.00
STOREKEEPER II0.00
TRUCK DRIVER0.00
TRUCK DRIVER (PREP/TRUCK DRIVER)0.00
MANAGER0.00
SUPERVISOR0.00
0.00
0.00
0.00
FSS = FOOD SANITATION SPECIALISTDirect Labor0.00
Number of days
0

Matrix- Flight Kitchen

A (Gray)BC (Blue)
00000000000000111111111111111111112TOTAL
33445566778899001122334455667788990HOURS
03030303030303030303030303030303030
00000000000000000000000000000000000
COOK I0.00
COOK II0.00
IN-FLIGHT COOK0.00
SALAD MAKER0.00
CASHIER0.00
FSS (SERVE)0.00
FSS (SERVE/CLEAN)0.00
FSS (SETUP/SERVE/CLEAN)0.00
FSS (PASTRY/FRUIT BAR))0.00
FSS (POT & PANS)0.00
FSS (POTS/PANS/KITCHEN CLEANUP)0.00
FSS (CLIPPER)0.00
FSS (BUSSERS)0.00
FSS (BUSSER/CLIPPER)0.00
FSS (MILK LINE)0.00
FSS (ICE CREAM)0.00
FSS (UTILITY/OTHER)0.00
FSS (PREP/CLIPPER)0.00
FSS (PREP/POTS & PANS)0.00
STOREKEEPER I0.00
STOREKEEPER II0.00
TRUCK DRIVER0.00
TRUCK DRIVER (PREP/TRUCK DRIVER)0.00
MANAGER0.00
SUPERVISOR0.00
0.00
0.00
0.00
FSS = FOOD SANITATION SPECIALISTDirect Labor0.00
Number of days
0
A (Gray)BC (Blue)
2222222200000TOTAL
0112233401122HOURS
3030303030303
0000000000000
COOK I0.00
COOK II0.00
IN-FLIGHT COOK0.00
SALAD MAKER0.00
CASHIER0.00
FSS (SERVE)0.00
FSS (SERVE/CLEAN)0.00
FSS (SETUP/SERVE/CLEAN)0.00
FSS (PASTRY/FRUIT BAR)0.00
FSS (POT & PANS)0.00
FSS (POTS/PANS/KITCHEN CLEANUP)0.00
FSS (CLIPPER)0.00
FSS (BUSSERS)0.00
FSS (BUSSER/CLIPPER)0.00
FSS (MILK LINE)0.00
FSS (ICE CREAM)0.00
FSS (UTILITY/OTHER)0.00
FSS (PREP/CLIPPER)0.00
FSS (PREP/POTS & PANS)0.00
STOREKEEPER I0.00
STOREKEEPER II0.00
TRUCK DRIVER0.00
TRUCK DRIVER (PREP/TRUCK DRIVER)0.00
MANAGER0.00
SUPERVISOR0.00
0.00
0.00
0.00
FSS = FOOD SANITATION SPECIALISTDirect Labor0.00
Number of days
0

Matrix- Magnolia

A (Gray)BC (Blue)
00000000000000111111111111111111112TOTAL
33445566778899001122334455667788990HOURS
03030303030303030303030303030303030
00000000000000000000000000000000000
COOK I0.00
COOK II0.00
IN-FLIGHT COOK0.00
SALAD MAKER0.00
CASHIER0.00
FSS (SERVE)0.00
FSS (SERVE/CLEAN)0.00
FSS (SETUP/SERVE/CLEAN)0.00
FSS (PASTRY/FRUIT BAR))0.00
FSS (POT & PANS)0.00
FSS (POTS/PANS/KITCHEN CLEANUP)0.00
FSS (CLIPPER)0.00
FSS (BUSSERS)0.00
FSS (BUSSER/CLIPPER)0.00
FSS (MILK LINE)0.00
FSS (ICE CREAM)0.00
FSS (UTILITY/OTHER)0.00
FSS (PREP/CLIPPER)0.00
FSS (PREP/POTS & PANS)0.00
STOREKEEPER I0.00
STOREKEEPER II0.00
TRUCK DRIVER0.00
TRUCK DRIVER (PREP/TRUCK DRIVER)0.00
MANAGER0.00
SUPERVISOR0.00
0.00
0.00
0.00
FSS = FOOD SANITATION SPECIALISTDirect Labor0.00
Number of days
0
A (Gray)BC (Blue)
2222222200000TOTAL
0112233401122HOURS
3030303030303
0000000000000
COOK I0.00
COOK II0.00
IN-FLIGHT COOK0.00
SALAD MAKER0.00
CASHIER0.00
FSS (SERVE)0.00
FSS (SERVE/CLEAN)0.00
FSS (SETUP/SERVE/CLEAN)0.00
FSS (PASTRY/FRUIT BAR)0.00
FSS (POT & PANS)0.00
FSS (POTS/PANS/KITCHEN CLEANUP)0.00
FSS (CLIPPER)0.00
FSS (BUSSERS)0.00
FSS (BUSSER/CLIPPER)0.00
FSS (MILK LINE)0.00
FSS (ICE CREAM)0.00
FSS (UTILITY/OTHER)0.00
FSS (PREP/CLIPPER)0.00
FSS (PREP/POTS & PANS)0.00
STOREKEEPER I0.00
STOREKEEPER II0.00
TRUCK DRIVER0.00
TRUCK DRIVER (PREP/TRUCK DRIVER)0.00
MANAGER0.00
SUPERVISOR0.00
0.00
0.00
0.00
FSS = FOOD SANITATION SPECIALISTDirect Labor0.00
Number of days
0

Matrix- Live Oak

A (Gray)BC (Blue)
00000000000000111111111111111111112TOTAL
33445566778899001122334455667788990HOURS
03030303030303030303030303030303030
00000000000000000000000000000000000
COOK I0.00
COOK II0.00
IN-FLIGHT COOK0.00
SALAD MAKER0.00
CASHIER0.00
FSS (SERVE)0.00
FSS (SERVE/CLEAN)0.00
FSS (SETUP/SERVE/CLEAN)0.00
FSS (PASTRY/FRUIT BAR))0.00
FSS (POT & PANS)0.00
FSS (POTS/PANS/KITCHEN CLEANUP)0.00
FSS (CLIPPER)0.00
FSS (BUSSERS)0.00
FSS (BUSSER/CLIPPER)0.00
FSS (MILK LINE)0.00
FSS (ICE CREAM)0.00
FSS (UTILITY/OTHER)0.00
FSS (PREP/CLIPPER)0.00
FSS (PREP/POTS & PANS)0.00
STOREKEEPER I0.00
STOREKEEPER II0.00
TRUCK DRIVER0.00
TRUCK DRIVER (PREP/TRUCK DRIVER)0.00
MANAGER0.00
SUPERVISOR0.00
0.00
0.00
0.00
FSS = FOOD SANITATION SPECIALISTDirect Labor0.00
Number of days
0
A (Gray)BC (Blue)
2222222200000TOTAL
0112233401122HOURS
3030303030303
0000000000000
COOK I0.00
COOK II0.00
IN-FLIGHT COOK0.00
SALAD MAKER0.00
CASHIER0.00
FSS (SERVE)0.00
FSS (SERVE/CLEAN)0.00
FSS (SETUP/SERVE/CLEAN)0.00
FSS (PASTRY/FRUIT BAR)0.00
FSS (POT & PANS)0.00
FSS (POTS/PANS/KITCHEN CLEANUP)0.00
FSS (CLIPPER)0.00
FSS (BUSSERS)0.00
FSS (BUSSER/CLIPPER)0.00
FSS (MILK LINE)0.00
FSS (ICE CREAM)0.00
FSS (UTILITY/OTHER)0.00
FSS (PREP/CLIPPER)0.00
FSS (PREP/POTS & PANS)0.00
STOREKEEPER I0.00
STOREKEEPER II0.00
TRUCK DRIVER0.00
TRUCK DRIVER (PREP/TRUCK DRIVER)0.00
MANAGER0.00
SUPERVISOR0.00
0.00
0.00
0.00
FSS = FOOD SANITATION SPECIALISTDirect Labor0.00
Number of days
0

Completion Instructions Section A (Shaded in Gray)(Column A)

These are the skill sets from the collective bargaining agreement that will be used to perform this contract. The manager and supervisor are not included in the CBA. An offeror may propose additional skill sets by adding them to the spreadsheet in the row under the supervisor row.
Section B (Non-shaded Area)(Columns B - AJ)
Enter the proposed number of personnel for the specified time. Time is shaded in orange and runs down the column using the 24-hour military time (e.g. 0730 hrs). The two shades of orange are used only to visually separate the columns. The table allows for 30-minute increments. If proposing more than one person for a skill set and 30-minute increment, enter the number of people in the block corresponding to the time and skill set (e.g. "1" or "2", etc.). If proposing only 15 minutes, enter ".5" in the block corresponding to the time and skill set. If entering only 15 minutes for multiple people in one skill set during a specific time, multiply ".5" by the number of people. An example of when you may want to enter only 15 minutes is for a cashier; you may want the cashier to come in 15 minutes prior to the scheduled operating shift to set up the cash register and get ready for customers.
Section C (Shaded in Blue)(Column AK)
Shows the totals the number of hours needed for one day
Section C represents the total proposed hours for each skill set from 0300 - 0230. Section C is automatically calculated and adjusted as data is entered.
EXAMPLE 1: The offeror proposes one Cashier from 0400-0500 for Dining Facility X. Enter "1" in the Cashier row under the 0400 and the 0430 time frame. The total hours (Section C) will automatically adjust to "1"
EXAMPLE 2: The offeror proposes two Cashiers from 0400-0500 for Dining Facility X. Enter "2" in the Cashier row under the 0400 and the 0430 time frame. The total hours (Section C) will automatically adjust to "2"
EXAMPLE 3: The offeror proposes a Cashier from 0345-0815 for Dining Facility X. Enter ".5" in the Cashier row under the 0330, enter "1" in the rows under 0400, 0430, 0500, 0530, 0600, 0630, 0700, 0730 and enter ".5" in the row under the 0830 time frame. The total hours (Section C) will automatically adjust to "5". In this same example, if you have 2 cashiers, you will enter "1" under the 0330 and 0830 rows and you will enter "2" for the other time periods. The total hours (Section C) will automatically adjust to "10"
NOTE: The color coded shading is for visual simplicity only. It has no other significance.

File details come from the government source that posted it.