Contract Price Proposal Template.xlsx

XLSX spreadsheet 36 KB Posted

Attached to
Army Oil Analysis Program (AOAP) Worldwide Laboratory Management and Operations
Solicitation number
PANRSA-24-P-0000-015570
Issued by

About this file

This is a Contract Price Proposal Template in Excel format for the Army Oil Analysis Program (AOAP) Worldwide Laboratory Management and Operations contract. The template requires pricing for a base period, four option periods, and a six-month extension option across six locations: Fort Liberty (4 staff), Fort Cavazos (5 staff), Fort Lewis (4 staff), Redstone Arsenal (5 staff), Camp Doha Kuwait (1 staff), and Indonesia (1 staff).

The template includes tabs for Total Price by CLIN, Labor, Other Direct Costs (ODC), and Indirect Costs. Labor sections require detailed staffing information including labor categories, SCA codes, rates, and burden calculations with escalation factors. ODC sections cover travel expenses and overseas allowances. Indirect cost sections include overhead, G&A, profit, and subcontractor pass-through rates, all initially set at 1%. The template requires compliance with FAR 15.408 Table 15-2 and must be submitted in US dollars rounded to the nearest cent, with all calculations and formulas preserved.

View the file

Other files

Show all 18

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

Instructions

CONTRACT PRICE PROPOSAL TEMPLATE INSTRUCTIONS
- The purpose of this template is to provide a standard format by which the offeror submits cost/price information for the associated firm-fixed-price contract.
- This template serves in addition to, not in lieu of, requirements of FAR part 15.408 Table 15-2.
- It is critical that all cost/price data is provided in detail with comments as to how the data is calculated/derived.
- All cost/price amount shall be in United States Dollars, rounded to nearest one cent ($0.01).
- Leave all Excel formulas in place for data derived/calculated within template.
- Add comments to explain any other calculations or equations used to provide data in this template.
- Populate cells or link cells for "Total Price by CLIN" tab from "Labor", "ODC", and "Indirect Costs" tabs.
- This template may be modified, or another MS Excel workbook may be submitted, by the offeror to accommodate additional costs or differences in accounting methods, cost pool calculations, etc.

Total Price by CLIN

CONTRACT PRICE PROPOSAL
ARMY OIL ANALYSIS PROGRAM
CLINStaffing LevelTotal Direct Labor and BurdenOther Direct Costs (ODC)OverheadProfitG&ASubtotalSubcontractor Pass-ThroughTotal CLIN Price
0001Base Period CONUS Fort Liberty4.0
0002Base Period CONUS Fort Cavazos5.0
0003Base Period CONUS Fort Lewis4.0
0004Base Period CONUS Redstone Arsenal5.0
0005Base Period OCONUS FMS Camp Doha, Kuwait1.0
0006Base Period OCONUS FMS Indonesia1.0
Base Period Total:
1001Option Period 1 CONUS Fort Liberty4.0
1002Option Period 1 CONUS Fort Cavazos5.0
1003Option Period 1 CONUS Fort Lewis4.0
1004Option Period 1 CONUS Redstone Arsenal5.0
1005Option Period 1 OCONUS FMS Camp Doha, Kuwait1.0
1006Option Period 1 OCONUS FMS Indonesia1.0
Option Period 1 Total:
2001Option Period 2 CONUS Fort Liberty4.0
2002Option Period 2 CONUS Fort Cavazos5.0
2003Option Period 2 CONUS Fort Lewis4.0
2004Option Period 2 CONUS Redstone Arsenal5.0
2005Option Period 2 OCONUS FMS Camp Doha, Kuwait1.0
2006Option Period 2 OCONUS FMS Indonesia1.0
Option Period 2 Total:
3001Option Period 3 CONUS Fort Liberty4.0
3002Option Period 3 CONUS Fort Cavazos5.0
3003Option Period 3 CONUS Fort Lewis4.0
3004Option Period 3 CONUS Redstone Arsenal5.0
3005Option Period 3 OCONUS FMS Camp Doha, Kuwait1.0
3006Option Period 3 OCONUS FMS Indonesia1.0
Option Period 3 Total:
4001Option Period 4 CONUS Fort Liberty4.0
4002Option Period 4 CONUS Fort Cavazos5.0
4003Option Period 4 CONUS Fort Lewis4.0
4004Option Period 4 CONUS Redstone Arsenal5.0
4005Option Period 4 OCONUS FMS Camp Doha, Kuwait1.0
4006Option Period 4 OCONUS FMS Indonesia1.0
Option Period 4 Total:
5001Six Month Option CONUS Fort Liberty4.0
5002Six Month Option CONUS Fort Cavazos5.0
5003Six Month Option CONUS Fort Lewis4.0
5004Six Month Option CONUS Redstone Arsenal5.0
5005Six Month Option OCONUS FMS Camp Doha, Kuwait1.0
5006 Six Month Option OCONUS FMS Indonesia1.0
Six Month Option Total:
Grand Total:

Labor

LABORBase PeriodOption Period 1Option Period 2Option Period 3Option Period 4Opt 6-Month Extension
LocationLabor TitleOccupation Code (SCA-WD)SCA Exempt? (yes/no)Sub-contracted? (yes/no)Employees RequiredDirect Labor Rate (Hourly)Productive HoursTotal Direct LaborLabor Burden (%)Total Direct Labor & BurdenAdjustment for Escalation (%)Total Direct Labor & BurdenAdjustment for Escalation (%)Total Direct Labor & BurdenAdjustment for Escalation (%)Total Direct Labor & BurdenAdjustment for Escalation (%)Total Direct Labor & BurdenTotal Direct Labor & Burden
Sample EntryLifeguard28310NONO415.001,50090,000.0015.0%103,500.001.5%105,052.501.5%106,628.291.5%108,227.711.5%109,851.1354,925.56
Fort Liberty, NCLaboratory Manager- 0- 0- 0- 0- 0- 0- 0
Fort Liberty, NCAssistant Laboratory Manager- 0- 0- 0- 0- 0- 0- 0
Fort Liberty, NCLaboratory Technician- 0- 0- 0- 0- 0- 0- 0
Fort Cavazos, TXLaboratory Manager- 0- 0- 0- 0- 0- 0- 0
Fort Cavazos, TXAssistant Laboratory Manager- 0- 0- 0- 0- 0- 0- 0
Fort Cavazos, TXLaboratory Technician- 0- 0- 0- 0- 0- 0- 0
Fort Lewis, WALaboratory Manager- 0- 0- 0- 0- 0- 0- 0
Fort Lewis, WAAssistant Laboratory Manager- 0- 0- 0- 0- 0- 0- 0
Fort Lewis, WALaboratory Technician- 0- 0- 0- 0- 0- 0- 0
Redstone Arsenal, ALProject Lead- 0- 0- 0- 0- 0- 0- 0
Redstone Arsenal, ALJAVA Developer- 0- 0- 0- 0- 0- 0- 0
Redstone Arsenal, ALPL/SQL Developer- 0- 0- 0- 0- 0- 0- 0
Redstone Arsenal, ALSr. Condition Monitoring Analyst- 0- 0- 0- 0- 0- 0- 0
Redstone Arsenal, ALCondition Monitoring Analyst- 0- 0- 0- 0- 0- 0- 0
Camp Doha, KUField Service Representative- 0- 0- 0- 0- 0- 0- 0
Semarang, IDField Service Representative- 0- 0- 0- 0- 0- 0- 0
Notes:
- Insert detailed comments for calculating productive hours [i.e., (8 hr day * 5 days/wk) - (10 federal holidays + 12.5 days leave) = 1,900 productive hours]
- Insert detailed comments, amounts, rates for labor burden
- Insert detailed comments, amounts, rates for escalation (inflation, H & W, etc.)

ODC

OTHER DIRECT COSTS (ODC)
Fort Liberty ExpensesUnit PriceQtyExtended Cost
Travel (Lab Mgr to RSA)1,000.00

Gordon Gipner: Example:

Airfare: 500.00 Hotel: 200.00 Car Rental: 200.00 Per diem: 100.00 1 1,000.00

Fort Cavazos ExpensesUnit PriceQtyExtended Cost
Travel (Lab Mgr to RSA)
Fort Lewis ExpensesUnit PriceQtyExtended Cost
Travel (Lab Mgr to RSA)
Redstone ExpensesUnit PriceQtyExtended Cost
Travel (Project Lead to Bragg)
Travel (Project Lead to Hood)
Travel (Project Lead to Lewis)
Travel (Project Lead to Arifjan)
Kuwait FMSUnit PriceQtyExtended Cost
Living Allowance (Monthly/per person)
Travel (Deployment & Re-deployment, 1 Each)
Vehicle (Monthly/per person)
Indonesia/TBD FMSUnit PriceQtyExtended Cost
Living Allowance (Monthly/per person)
Travel (Deployment & Re-deployment, 1 Each)
Vehicle (Monthly/per person)
Notes:
- Insert detailed amounts in comments for each aggregated expense (sample comment under Fort Liberty Travel)
- RSA = Redstone Arsenal, AL

Indirect Costs

INDIRECT COSTS/RATES
(%)
Overhead1.00%
G&A1.00%
Profit1.00%
Subcontractor Pass-Through1.00%
Notes:
- Insert details in comments for each indirect cost pool and other rates.

File details come from the government source that posted it. Updated .