Atch A-Pricing Spreadsheet.xlsx
XLSX spreadsheet 30 KB Posted
- Solicitation number
- 692M15-21-R-00022
View the file
Other files
Show all 13
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
A.1 CLIN Summary
| CLIN | Type | Description | Ordering Period 1 | Ordering Period 2 | Ordering Period 3 | Ordering Period 4 | Ordering Period 5 | Total |
| X001 | FFP | O&M | $ - 0 | |||||
| X002 | Cost | Materials | $ 100,504.94 | $ 611,171.19 | $ 239,147.88 | $ 675,959.96 | $ 257,907.92 | $ 1,884,691.89 |
| X003 | T&M | Special Projects | $ 238,182.37 | $ 257,696.21 | $ 272,549.22 | $ 293,565.23 | $ 321,978.89 | $ 1,383,971.92 |
| X004 | Cost | Travel | $ 6,640.00 | $ 6,640.00 | $ 6,640.00 | $ 6,640.00 | $ 6,640.00 | $ 33,200.00 |
| Total Evaluated Price | $ 345,327.31 | $ 875,507.40 | $ 518,337.10 | $ 976,165.19 | $ 586,526.81 | $ 3,301,863.81 |
Instructions:
CLIN X001 - Operations & Maintenance (FFP) - Offerors are to submit a firm-fixed-price for O&M for each year of the contract in the grey shaded cells in the table above.
CLIN X002 - Materials (Cost Reimbursement) - The Government has provided an estimated materials amount for each year of the contract. The estimated amounts already include indirect expenses to be applied to the actual expenses incurred. Materials are non-fee bearing costs.
CLIN X003 - Special Projects (T&M) - The Government has provided estimated materials costs and estimated labor hours in Tab A.2 Special Projects. The Offeror must provide fully burdened labor rates by filling in the grey shaded cells with proposed direct labor rates, indirect rates, profit, escalation rates, and overtime rates for each of the requested labor categories.
CLIN X004 - Travel (Cost Reimbursement) - The Government has provided an estimated travel amount for each year of the contract. The estimated amounts already include indirect expenses to be applied to the actual expenses incurred. Travel costs are non-fee bearing costs.
The Total Evaluated Price (TEP) will be calculated by summing CLINs X001 through X004.
A.2 Special Projects
| Total | Ordering Period 1 | Ordering Period 2 | Ordering Period 3 | Ordering Period 4 | Ordering Period 5 | |||||||||||||
| Labor Category | SOW | Hours | Amount | Hours | Rate | Amount | Hours | Rate | Amount | Hours | Rate | Amount | Hours | Rate | Amount | Hours | Rate | Amount |
| Pavement Technician Type 1 | 4.4.1 | 4,928.00 | $ - 0 | 985.60 | $ - 0 | $ - 0 | 985.60 | $ - 0 | $ - 0 | 985.60 | $ - 0 | $ - 0 | 985.60 | $ - 0 | $ - 0 | 985.60 | $ - 0 | $ - 0 |
| Pavement Technician Type 2 | 4.4.1 | 3,542.00 | $ - 0 | 708.40 | $ - 0 | $ - 0 | 708.40 | $ - 0 | $ - 0 | 708.40 | $ - 0 | $ - 0 | 708.40 | $ - 0 | $ - 0 | 708.40 | $ - 0 | $ - 0 |
| System/Network Administrator | 4.4.1 | 1,540.00 | $ - 0 | 308.00 | $ - 0 | $ - 0 | 308.00 | $ - 0 | $ - 0 | 308.00 | $ - 0 | $ - 0 | 308.00 | $ - 0 | $ - 0 | 308.00 | $ - 0 | $ - 0 |
| Pavement Technician Type 1 | 4.4.2 | 1,500.00 | $ - 0 | 300.00 | $ - 0 | $ - 0 | 300.00 | $ - 0 | $ - 0 | 300.00 | $ - 0 | $ - 0 | 300.00 | $ - 0 | $ - 0 | 300.00 | $ - 0 | $ - 0 |
| Pavement Technician Type 2 | 4.4.2 | 1,300.00 | $ - 0 | 260.00 | $ - 0 | $ - 0 | 260.00 | $ - 0 | $ - 0 | 260.00 | $ - 0 | $ - 0 | 260.00 | $ - 0 | $ - 0 | 260.00 | $ - 0 | $ - 0 |
| Pavement Technician Type 4 | 4.4.2 | 600.00 | $ - 0 | 120.00 | $ - 0 | $ - 0 | 120.00 | $ - 0 | $ - 0 | 120.00 | $ - 0 | $ - 0 | 120.00 | $ - 0 | $ - 0 | 120.00 | $ - 0 | $ - 0 |
| System/Network Administrator | 4.4.2 | 525.00 | $ - 0 | 105.00 | $ - 0 | $ - 0 | 105.00 | $ - 0 | $ - 0 | 105.00 | $ - 0 | $ - 0 | 105.00 | $ - 0 | $ - 0 | 105.00 | $ - 0 | $ - 0 |
| Pavement Technician Type 1 | 4.4.3 | 1,078.00 | $ - 0 | 215.60 | $ - 0 | $ - 0 | 215.60 | $ - 0 | $ - 0 | 215.60 | $ - 0 | $ - 0 | 215.60 | $ - 0 | $ - 0 | 215.60 | $ - 0 | $ - 0 |
| Pavement Technician Type 2 | 4.4.3 | 616.00 | $ - 0 | 123.20 | $ - 0 | $ - 0 | 123.20 | $ - 0 | $ - 0 | 123.20 | $ - 0 | $ - 0 | 123.20 | $ - 0 | $ - 0 | 123.20 | $ - 0 | $ - 0 |
| Pavement Technician Type 4 | 4.4.3 | 462.00 | $ - 0 | 92.40 | $ - 0 | $ - 0 | 92.40 | $ - 0 | $ - 0 | 92.40 | $ - 0 | $ - 0 | 92.40 | $ - 0 | $ - 0 | 92.40 | $ - 0 | $ - 0 |
| System/Network Administrator | 4.4.3 | 539.00 | $ - 0 | 107.80 | $ - 0 | $ - 0 | 107.80 | $ - 0 | $ - 0 | 107.80 | $ - 0 | $ - 0 | 107.80 | $ - 0 | $ - 0 | 107.80 | $ - 0 | $ - 0 |
| Pavement Technician Type 1 | 4.4.4 | 2,310.00 | $ - 0 | 462.00 | $ - 0 | $ - 0 | 462.00 | $ - 0 | $ - 0 | 462.00 | $ - 0 | $ - 0 | 462.00 | $ - 0 | $ - 0 | 462.00 | $ - 0 | $ - 0 |
| Pavement Technician Type 2 | 4.4.4 | 1,480.00 | $ - 0 | 296.00 | $ - 0 | $ - 0 | 296.00 | $ - 0 | $ - 0 | 296.00 | $ - 0 | $ - 0 | 296.00 | $ - 0 | $ - 0 | 296.00 | $ - 0 | $ - 0 |
| Pavement Technician Type 4 | 4.4.4 | 1,078.00 | $ - 0 | 215.60 | $ - 0 | $ - 0 | 215.60 | $ - 0 | $ - 0 | 215.60 | $ - 0 | $ - 0 | 215.60 | $ - 0 | $ - 0 | 215.60 | $ - 0 | $ - 0 |
| System/Network Administrator | 4.4.4 | 1,078.00 | $ - 0 | 215.60 | $ - 0 | $ - 0 | 215.60 | $ - 0 | $ - 0 | 215.60 | $ - 0 | $ - 0 | 215.60 | $ - 0 | $ - 0 | 215.60 | $ - 0 | $ - 0 |
| Pavement Technician Type 1 | 4.4.5 | 2,002.00 | $ - 0 | 400.40 | $ - 0 | $ - 0 | 400.40 | $ - 0 | $ - 0 | 400.40 | $ - 0 | $ - 0 | 400.40 | $ - 0 | $ - 0 | 400.40 | $ - 0 | $ - 0 |
| Pavement Technician Type 3 | 4.4.5 | 3,480.00 | $ - 0 | 696.00 | $ - 0 | $ - 0 | 696.00 | $ - 0 | $ - 0 | 696.00 | $ - 0 | $ - 0 | 696.00 | $ - 0 | $ - 0 | 696.00 | $ - 0 | $ - 0 |
| Pavement Technician Type 4 | 4.4.5 | 80.00 | $ - 0 | 16.00 | $ - 0 | $ - 0 | 16.00 | $ - 0 | $ - 0 | 16.00 | $ - 0 | $ - 0 | 16.00 | $ - 0 | $ - 0 | 16.00 | $ - 0 | $ - 0 |
| System/Network Administrator | 4.4.5 | 1,078.00 | $ - 0 | 215.60 | $ - 0 | $ - 0 | 215.60 | $ - 0 | $ - 0 | 215.60 | $ - 0 | $ - 0 | 215.60 | $ - 0 | $ - 0 | 215.60 | $ - 0 | $ - 0 |
| Pavement Technician Type 1 | OT | 200.00 | $ - 0 | 40.00 | $ - 0 | $ - 0 | 40.00 | $ - 0 | $ - 0 | 40.00 | $ - 0 | $ - 0 | 40.00 | $ - 0 | $ - 0 | 40.00 | $ - 0 | $ - 0 |
| Pavement Technician Type 2 | OT | 200.00 | $ - 0 | 40.00 | $ - 0 | $ - 0 | 40.00 | $ - 0 | $ - 0 | 40.00 | $ - 0 | $ - 0 | 40.00 | $ - 0 | $ - 0 | 40.00 | $ - 0 | $ - 0 |
| Pavement Technician Type 3 | OT | 200.00 | $ - 0 | 40.00 | $ - 0 | $ - 0 | 40.00 | $ - 0 | $ - 0 | 40.00 | $ - 0 | $ - 0 | 40.00 | $ - 0 | $ - 0 | 40.00 | $ - 0 | $ - 0 |
| Pavement Technician Type 4 | OT | 200.00 | $ - 0 | 40.00 | $ - 0 | $ - 0 | 40.00 | $ - 0 | $ - 0 | 40.00 | $ - 0 | $ - 0 | 40.00 | $ - 0 | $ - 0 | 40.00 | $ - 0 | $ - 0 |
| Heavy Vehicle Simulator Operator | OT | 200.00 | $ - 0 | 40.00 | $ - 0 | $ - 0 | 40.00 | $ - 0 | $ - 0 | 40.00 | $ - 0 | $ - 0 | 40.00 | $ - 0 | $ - 0 | 40.00 | $ - 0 | $ - 0 |
| Subtotal Labor | 30,216.00 | $ - 0 | 6,043.20 | $ - 0 | 6,043.20 | $ - 0 | 6,043.20 | $ - 0 | 6,043.20 | $ - 0 | 6,043.20 | $ - 0 | ||||||
| Material | $ 1,383,971.92 | $ 238,182.37 | $ 257,696.21 | $ 272,549.22 | $ 293,565.23 | $ 321,978.89 | ||||||||||||
| Total | $ 1,383,971.92 | $ 238,182.37 | $ 257,696.21 | $ 272,549.22 | $ 293,565.23 | $ 321,978.89 |
A.3 Rates
| Fully Burdened Labor Rate Build-up | ||||||||||
| Base Rate | Fringe | Overhead | G&A | Profit | Ord. Period 1 | Ord. Period 2 | Ord. Period 3 | Ord. Period 4 | Ord. Period 5 | |
| Labor Category | ||||||||||
| Pavement Technician Type 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Pavement Technician Type 2 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Pavement Technician Type 3 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Pavement Technician Type 4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Heavy Vehicle Simulator Operator | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| System/Network Administrator | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | $ - 0 |
| Overtime Fully Burdened Labor Rates | |||||
| Labor Category | Ord. Period 1 | Ord. Period 2 | Ord. Period 3 | Ord. Period 4 | Ord. Period 5 |
| Pavement Technician Type 1 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Pavement Technician Type 2 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Pavement Technician Type 3 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Pavement Technician Type 4 | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Heavy Vehicle Simulator Operator | $ - 0 | $ - 0 | $ - 0 | $ - 0 | |
| Instructions: | |||||
| The Offeror must fill in grey shaded cells. The Offeror may modify formulas, and/or add or remove columns to align with the Offeror's government approved practices. |
File details come from the government source that posted it. Updated .