ATTACHMENT 5 - EMPLOYEE TOTAL COMPENSATION PLAN SAMPLE.xlsx

This is a labor cost template for employee total compensation planning in response to a federal contract solicitation. The template is designed for offerors to submit an Employee Total Compensation Plan for each labor category designated as a "professional employee" under the solicitation. The spreadsheet calculates billable hourly rates based on direct labor costs, fringe benefits, general and administrative (G&A) costs, and profit margins across a five-year ordering period (base year plus four option years).

The template itemizes fringe benefit categories including sick leave, health insurance, Social Security tax, Medicare, FUTA, SUTA, workers' compensation, holidays, and vacation hours. Offerors are instructed that these fringe benefit line items are examples only and not mandatory or all-inclusive; they may adjust the template to accommodate their specific compensation package needs and should add additional items such as recruitment bonuses, retention incentives, matching contributions, or pension plan funding as separate line items. The template uses a standard formula multiplying 2,087 hours (annual full-time equivalent) by the base hourly rate to calculate annual total base labor cost, with all costs rolled up to determine the total billable hourly rate for each labor category.