Attachment 5 (Compensation Plan).xlsx

This is a Compensation Plan template in spreadsheet format for offeror pricing submission on solicitation W81K00-26-R-A032. The document provides instructions and structured tabs for offerors to complete labor category pricing for a non-personal services contract supporting augmented laboratory personnel at Public Health Command-Europe (PHC-E) in Landstuhl, Germany.

The compensation plan contains six contract line item (CLIN) groups: base period (0001), four option periods (1001, 2001, 3001, 4001), and a six-month extension (5001). For each period, offerors must populate yellow-highlighted cells with hourly Base Salary rates, Overhead amounts, and Profit figures for five labor categories: Microbiological Analysts (3,824 hours), Chemist (1,910 hours), LIMS Administrator (1,910 hours), Physical Science Technician (1,910 hours), and Medical Analyst (1,910 hours). The spreadsheet automatically calculates Total Billable Hourly Rates from the entered base salary, overhead, and profit values, which then auto-populate corresponding cells on the solicitation price sheet. All rates must be submitted as hourly figures rather than annual amounts, and completion of tabs 0001, 1001, 2001, 3001, 4001, and 5001 is mandatory prior to submission.