Attachment H - FSGA Staffing Matrix.xlsx

This is a staffing matrix template for the Full Food Services (FFS) contract at Fort Stewart, GA that provides instructions and data entry fields for calculating labor requirements across multiple dining facilities. The spreadsheet is designed to automatically calculate full-time equivalents (FTEs), total annual hours, and staffing levels based on user inputs for different labor categories and meal service scenarios.

The template covers five dining facilities (Buildings 19225, 12902, 13102, 13302, and 110) plus a Project Management Office (PMO), with each facility tab containing meal service windows (breakfast, lunch, and dinner) spanning from 3:30 AM to 8:30 PM in 30-minute increments. Users input the quantity of personnel in each labor category for specified time periods, and the spreadsheet automatically calculates total hours per position. The matrix also includes sections for other services such as extended meal service (priced in 0.5-hour increments), periodic in-depth cleaning, and dining facility opening or closing activities, with annual hour calculations based on estimated frequency. Staffing scenarios can be modeled with different labor categories including First Cook, Second Cook/Baker, Third Cook, Ration Clerk, Headcount, Secretary/Typist, Shift Leader, and Mess Attendant, along with management positions (Dining Facility Manager and Assistant Dining Facility Manager). The CAP SUMMARY tab automatically consolidates non-management and management FTE data across all buildings, using a standard of 1,864 non-exempt annual productive hours for most facilities and 1,840 hours for one location, enabling the contractor to develop comprehensive staffing proposals aligned with the facility capacities and operational requirements.