WR-ALC Production Overhead Contractor Pricing Worksheet Proposal 19 Feb 25.xlsx
XLSX spreadsheet 16 KB Posted
- Solicitation number
- FA857125R0006
About this file
This is a pricing worksheet template for a follow-on production overhead support contract at Warner Robins Air Logistics Complex, covering a period from April 19, 2025 through April 18, 2030. The worksheet specifies five labor categories with associated staffing levels: 17 Production Control Clerks (GS-09), 5 Planners (GS-11), 1 Material Subject Matter Expert (GS-13, part-time), 11 Schedulers (GS-11), and 2 Supervisors (GS-13).
The template is structured across five ordering periods of one year each, with calculations based on 1,856 productive hours per year per person (accounting for federal holidays, vacation, and sick leave). All Contract Line Item Numbers (CLINs) will be Firm Fixed Price (FFP). The worksheet requires contractors to input fully burdened hourly rates to calculate total costs for each labor category and ordering period. This template is associated with solicitation FA857125R0006 for the Warner Robins Air Logistics Complex Production Overhead Support contract.
View the file
Other files
Show all 24
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
Sheet1
| Overhead Production FOLLOW-ON (POP: 19 April 2025 thru 18 Jan 2030) | |||||||||||||||||||||||||||||||||||||||||||||||
| Basic Year | POP | CLIN Nomenclature | WG/GS Equivalent Grade | Series Number | FTEs | Hours* | Total Hours | Fully Burden Hourly Rate | Total | Ordering Period | POP | CLIN Nomenclature | WG/GS Equivalent Grade | FTEs | Hours | Total Hours | Hourly Rate | Total | Ordering Period | POP | CLIN Nomenclature | WG/GS Equivalent Grade | FTEs | Hours | Total Hours | Hourly Rate | Total | Ordering Period | POP | CLIN Nomenclature | WG Equivalent Grade | FTEs | Hours | Total Hours | Hourly Rate | Total | Ordering Period | POP | CLIN Nomenclature | WG/GS Equivalent Grade | FTEs | Hours | Total Hours | Hourly Rate | Total | Grand Total | |
| Basic Yr-Ordering Period I | 19 April 2025 thru 18 April 2026 | Production Control Clerks | GS 09 | 1150 | 17 | 1,856 | 31,552 | $0.00 | Ordering Period II | 19 April 2026 thru 18 April 2027 | Production Control Clerks | GS 09 | 17 | 1,856 | 31,552 | $0.00 | Ordering Period III | 19 April 2027 thru 18 April 2028 | Production Control Clerks | GS 09 | 17 | 1,856 | 31,552 | $0.00 | Ordering Period IV | 19 April 2028 thru 18 April 2029 | Production Control Clerks | GS 09 | 17 | 1,856 | 31,552 | $0.00 | Ordering Period V | 19 April 2029 thru 18 April 2030 | Production Control Clerks | GS 09 | 17 | 1,856 | 31,552 | $0.00 | $0.00 | ||||||
| Basic Yr-Ordering Period I | 19 April 2025 thru 18 April 2026 | Planners | GS 11 | 1152 | 5 | 1,856 | 9,280 | $0.00 | Ordering Period II | 19 April 2026 thru 18 April 2027 | Planners | GS 11 | 5 | 1,856 | 9,280 | $0.00 | Ordering Period III | 19 April 2027 thru 18 April 2028 | Planners | GS 11 | 5 | 1,856 | 9,280 | $0.00 | Ordering Period IV | 20 April 2028 thru 18 April 2029 | Planners | GS 11 | 5 | 1,856 | 9,280 | $0.00 | Ordering Period V | 19 April 2029 thru 18 April 2030 | Planners | GS 11 | 5 | 1,856 | 9,280 | $0.00 | $0.00 | ||||||
| Basic Yr-Ordering Period I | 19 April 2025 thru 18 April 2026 | Material Subject Matter Expert | GS-13 | 0343 | 1 | 1,700 | 1,700 | $0.00 | Ordering Period II | 19 April 2026 thru 18 April 2027 | Material Subject Matter Expert | GS-13 | 1 | 1,700 | 1,700 | $0.00 | Ordering Period III | 19 April 2027 thru 18 April 2028 | Material Subject Matter Expert | GS-13 | 1 | 1,700 | 1,700 | $0.00 | Ordering Period IV | 21 April 2028 thru 18 April 2029 | Material Subject Matter Expert | GS-13 | 1 | 1,700 | 1,700 | $0.00 | Ordering Period V | 19 April 2029 thru 18 April 2030 | Material Subject Matter Expert | GS-13 | 1 | 1,700 | 1,700 | $0.00 | $0.00 | ||||||
| Basic Yr-Ordering Period I | 19 April 2025 thru 18 April 2026 | Schedulers | GS-11 | 0895 | 11 | 1,856 | 20,416 | $0.00 | Ordering Period II | 19 April 2026 thru 18 April 2027 | Schedulers | GS-11 | 11 | 1,856 | 20,416 | $0.00 | Ordering Period III | 19 April 2027 thru 18 April 2028 | Schedulers | GS-11 | 11 | 1,856 | 20,416 | $0.00 | Ordering Period IV | 22 April 2028 thru 18 April 2029 | Schedulers | GS-11 | 11 | 1,856 | 20,416 | $0.00 | Ordering Period V | 19 April 2029 thru 18 April 2030 | Schedulers | GS-11 | 11 | 1,856 | 20,416 | $0.00 | $0.00 | ||||||
| Basic Yr-Ordering Period I | 19 April 2025 thru 18 April 2026 | Supervisors | GS 13 | 1150 | 2 | 1,856 | 3,712 | $0.00 | Ordering Period II | 19 April 2026 thru 18 April 2027 | Supervisors | GS 13 | 2 | 1,856 | 3,712 | $0.00 | Ordering Period III | 19 April 2027 thru 18 April 2028 | Supervisors | GS 13 | 2 | 1,856 | 3,712 | $0.00 | Ordering Period IV | 23 April 2028 thru 18 April 2029 | Supervisors | GS 13 | 2 | 1,856 | 3,712 | $0.00 | Ordering Period V | 19 April 2029 thru 18 April 2030 | Supervisors | GS 13 | 2 | 1,856 | 3,712 | $0.00 | $0.00 | ||||||
| Grand Total (Direct) | Total Ordering Period I (Direct) | $0.00 | Total Ordering Period II (Direct) | $0.00 | Total Ordering Period III (Direct) | $0.00 | Total Ordering Period IV (Direct) | $0.00 | Total Ordering Period V (Direct) | $0.00 | $0.00 | Grand Total (Direct) | |||||||||||||||||||||||||||||||||||
| · Available work hours per year (40 hrs. per week x 52 weeks) = 2080 hrs. | |||||||||||||||||||||||||||||||||||||||||||||||
| · Holidays = 88 hrs. (We now have 11 federal holidays instead of 10) | |||||||||||||||||||||||||||||||||||||||||||||||
| · Vacation = 80 hrs. | |||||||||||||||||||||||||||||||||||||||||||||||
| · Sick Leave = 56 hrs. | |||||||||||||||||||||||||||||||||||||||||||||||
| · Productive hours available per year per person = 1,856* | |||||||||||||||||||||||||||||||||||||||||||||||
| * Taken from DoD Independent Government Cost Estimate, Handbook for Services Acquisition, Feb 2018 | |||||||||||||||||||||||||||||||||||||||||||||||
| * SME position is an Part Time Equivelant (PTE) | |||||||||||||||||||||||||||||||||||||||||||||||
| * All CLINS will be FFP |
File details come from the government source that posted it. Updated .