WR-ALC Production Overhead Contractor Pricing Worksheet Proposal.pdf
PDF 158 KB Posted
- Attached to
- Warner Robins Air Logistics Complex Production Overhead Support Federal contract opportunity
- Solicitation number
- FA857125R0006
About this file
This is a pricing worksheet template for a follow-on contract covering production overhead support at Warner Robins Air Logistics Complex from January 20, 2025 through January 19, 2030. The worksheet outlines labor categories, hours, and staffing levels across five ordering periods, with all CLINs being Firm Fixed Price. The required staffing includes 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 worksheet defines productive hours as 1,872 per year per person based on a 2,080-hour work year minus 88 hours for federal holidays, 80 hours vacation, and 40 hours sick leave, as specified in the DoD Independent Government Cost Estimate Handbook. The template includes columns for hourly rates and total costs, though these are currently unpopulated ($0.00). Each ordering period maintains consistent staffing levels and hours across the five-year performance period.
View the file
Other files for this federal contract opportunity
Show all 24
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
DIRECT DOCAT FOLLOW-ON (POP: 20 Jan 2025 thru 19 Jan 2030)
Basic Year POP CLIN Nomenclature
WG/GS
Equivalent Grade
Series Number
FTEs Hours* Total Hours
Basic Yr-Ordering Period I 20 Jan 2025 thru 19 Jan 2026
Production Control Clerks GS 09 1150 17 1,872 31,824
Basic Yr-Ordering Period I 21 Jan 2025 thru 19 Jan 2026
Planners GS 11 1152 5 1,872 9,360
Basic Yr-Ordering Period I 22 Jan 2025 thru 19 Jan 2026
Material Subject Matter Expert GS-13 0343 1 1,700 1,700
Basic Yr-Ordering Period I 23 Jan 2025 thru 19 Jan 2026
Schedulers GS-11 0895 11 1,872 20,592
Basic Yr-Ordering Period I 24 Jan 2025 thru 19 Jan 2026
Supervisors GS 13 1150 2 1,872 3,744 Grand Total (Direct) Total Ordering Period I (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 = 40 hrs.
• Productive hours available per year per person = 1,872*
* 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
Fully Burden Hourly Rate
Total Ordering Period POP CLIN Nomenclature
WG/GS
Equivalent Grade
FTEs Hours
$0.00 Ordering Period II
20 Jan 2026 thru 19 Jan 2027 Production Control Clerks GS 09 17 1,872
$0.00 Ordering Period II
21 Jan 2026 thru 19 Jan 2027 Planners GS 11 5 1,872
$0.00 Ordering Period II
22 Jan 2026 thru 19 Jan 2027 Material Subject Matter Expert GS-13 1 1,700
$0.00 Ordering Period II
23 Jan 2026 thru 19 Jan 2027 Schedulers GS-11 11 1,872
$0.00 Ordering Period II
24 Jan 2026 thru 19 Jan 2027 Supervisors GS 13 2 1,872
$0.00 Total Ordering Period II (Direct)
Total Hours Hourly Rate Total Ordering Period POP
CLIN Nomenclature
WG/GS
Equivalent Grade
FTEs
31,824 $0.00 Ordering Period III 20 Jan 2027 thru 19 Jan 2028 Production Control Clerks GS 09 17
9,360 $0.00 Ordering Period III 21 Jan 2027 thru 19 Jan 2028 Planners GS 11 5
1,700 $0.00 Ordering Period III 22 Jan 2027 thru 19 Jan 2028 Material Subject Matter Expert GS-13 1
20,592 $0.00 Ordering Period III 23 Jan 2027 thru 19 Jan 2028 Schedulers GS-11 11
3,744 $0.00 Ordering Period III 24 Jan 2027 thru 19 Jan 2028 Supervisors GS 13 2
$0.00 Total Ordering Period III (Direct)
Hours Total Hours
Rate Total Ordering Period POP
CLIN Nomenclature
WG
Equivalen t Grade
1,872 31,824 $0.00 Ordering Period IV 20 Jan 2028 thru 19 Jan 2029 Production Control Clerks GS 09
1,872 9,360 $0.00 Ordering Period IV 21 Jan 2028 thru 19 Jan 2029 Planners GS 11
1,700 1,700 $0.00 Ordering Period IV 22 Jan 2028 thru 19 Jan 2029 Material Subject Matter Expert GS-13
1,872 20,592 $0.00 Ordering Period IV 23 Jan 2028 thru 19 Jan 2029 Schedulers GS-11
1,872 3,744 $0.00 Ordering Period IV 24 Jan 2028 thru 19 Jan 2029 Supervisors GS 13
$0.00 Total Ordering Period IV (Direct)
FTEs Hours Total Hours
Rate Total Ordering Period POP
CLIN Nomenclature
17 1,872 31,824 $0.00 Ordering Period V
20 Jan 2029 thru 19 Jan 2030 Production Control Clerks
5 1,872 9,360 $0.00 Ordering Period V
05 Dec 2028 thru 04 Dec 2029 Planners
1 1,700 1,700 $0.00 Ordering Period V
05 Dec 2028 thru 04 Dec 2029 Material Subject Matter Expert
11 1,872 20,592 $0.00 Ordering Period V
05 Dec 2028 thru 04 Dec 2029 Schedulers
2 1,872 3,744 $0.00 Ordering Period V
05 Dec 2028 thru 04 Dec 2029 Supervisors
$0.00 Total Ordering Period V (Direct)
WG/GS
Equivalent
Grade FTEs Hours Total Hours
Hourly Rate Total Grand Total
GS 09 17 1,872 31,824 $0.00 $0.00
GS 11 5 1,872 9,360 $0.00 $0.00
GS-13 1 1,700 1,700 $0.00 $0.00
GS-11 11 1,872 20,592 $0.00 $0.00
GS 13 2 1,872 3,744 $0.00 $0.00
$0.00 $0.00 Grand Total (Direct)
Sheet1
File details come from the government source that posted it. Updated .