Atch A-Pricing Spreadsheet.xlsx

XLSX spreadsheet 30 KB Posted

Attached to
Operations and Maintenance of Pavement Facilities
Solicitation number
692M15-21-R-00022
Issued by

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

CLINTypeDescriptionOrdering Period 1Ordering Period 2Ordering Period 3Ordering Period 4Ordering Period 5Total
X001FFPO&M$ - 0
X002CostMaterials$ 100,504.94$ 611,171.19$ 239,147.88$ 675,959.96$ 257,907.92$ 1,884,691.89
X003T&MSpecial Projects$ 238,182.37$ 257,696.21$ 272,549.22$ 293,565.23$ 321,978.89$ 1,383,971.92
X004CostTravel$ 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

TotalOrdering Period 1Ordering Period 2Ordering Period 3Ordering Period 4Ordering Period 5
Labor CategorySOWHoursAmountHoursRateAmountHoursRateAmountHoursRateAmountHoursRateAmountHoursRateAmount
Pavement Technician Type 14.4.14,928.00$ - 0985.60$ - 0$ - 0985.60$ - 0$ - 0985.60$ - 0$ - 0985.60$ - 0$ - 0985.60$ - 0$ - 0
Pavement Technician Type 24.4.13,542.00$ - 0708.40$ - 0$ - 0708.40$ - 0$ - 0708.40$ - 0$ - 0708.40$ - 0$ - 0708.40$ - 0$ - 0
System/Network Administrator4.4.11,540.00$ - 0308.00$ - 0$ - 0308.00$ - 0$ - 0308.00$ - 0$ - 0308.00$ - 0$ - 0308.00$ - 0$ - 0
Pavement Technician Type 14.4.21,500.00$ - 0300.00$ - 0$ - 0300.00$ - 0$ - 0300.00$ - 0$ - 0300.00$ - 0$ - 0300.00$ - 0$ - 0
Pavement Technician Type 24.4.21,300.00$ - 0260.00$ - 0$ - 0260.00$ - 0$ - 0260.00$ - 0$ - 0260.00$ - 0$ - 0260.00$ - 0$ - 0
Pavement Technician Type 44.4.2600.00$ - 0120.00$ - 0$ - 0120.00$ - 0$ - 0120.00$ - 0$ - 0120.00$ - 0$ - 0120.00$ - 0$ - 0
System/Network Administrator4.4.2525.00$ - 0105.00$ - 0$ - 0105.00$ - 0$ - 0105.00$ - 0$ - 0105.00$ - 0$ - 0105.00$ - 0$ - 0
Pavement Technician Type 14.4.31,078.00$ - 0215.60$ - 0$ - 0215.60$ - 0$ - 0215.60$ - 0$ - 0215.60$ - 0$ - 0215.60$ - 0$ - 0
Pavement Technician Type 24.4.3616.00$ - 0123.20$ - 0$ - 0123.20$ - 0$ - 0123.20$ - 0$ - 0123.20$ - 0$ - 0123.20$ - 0$ - 0
Pavement Technician Type 44.4.3462.00$ - 092.40$ - 0$ - 092.40$ - 0$ - 092.40$ - 0$ - 092.40$ - 0$ - 092.40$ - 0$ - 0
System/Network Administrator4.4.3539.00$ - 0107.80$ - 0$ - 0107.80$ - 0$ - 0107.80$ - 0$ - 0107.80$ - 0$ - 0107.80$ - 0$ - 0
Pavement Technician Type 14.4.42,310.00$ - 0462.00$ - 0$ - 0462.00$ - 0$ - 0462.00$ - 0$ - 0462.00$ - 0$ - 0462.00$ - 0$ - 0
Pavement Technician Type 24.4.41,480.00$ - 0296.00$ - 0$ - 0296.00$ - 0$ - 0296.00$ - 0$ - 0296.00$ - 0$ - 0296.00$ - 0$ - 0
Pavement Technician Type 44.4.41,078.00$ - 0215.60$ - 0$ - 0215.60$ - 0$ - 0215.60$ - 0$ - 0215.60$ - 0$ - 0215.60$ - 0$ - 0
System/Network Administrator4.4.41,078.00$ - 0215.60$ - 0$ - 0215.60$ - 0$ - 0215.60$ - 0$ - 0215.60$ - 0$ - 0215.60$ - 0$ - 0
Pavement Technician Type 14.4.52,002.00$ - 0400.40$ - 0$ - 0400.40$ - 0$ - 0400.40$ - 0$ - 0400.40$ - 0$ - 0400.40$ - 0$ - 0
Pavement Technician Type 34.4.53,480.00$ - 0696.00$ - 0$ - 0696.00$ - 0$ - 0696.00$ - 0$ - 0696.00$ - 0$ - 0696.00$ - 0$ - 0
Pavement Technician Type 44.4.580.00$ - 016.00$ - 0$ - 016.00$ - 0$ - 016.00$ - 0$ - 016.00$ - 0$ - 016.00$ - 0$ - 0
System/Network Administrator4.4.51,078.00$ - 0215.60$ - 0$ - 0215.60$ - 0$ - 0215.60$ - 0$ - 0215.60$ - 0$ - 0215.60$ - 0$ - 0
Pavement Technician Type 1OT200.00$ - 040.00$ - 0$ - 040.00$ - 0$ - 040.00$ - 0$ - 040.00$ - 0$ - 040.00$ - 0$ - 0
Pavement Technician Type 2OT200.00$ - 040.00$ - 0$ - 040.00$ - 0$ - 040.00$ - 0$ - 040.00$ - 0$ - 040.00$ - 0$ - 0
Pavement Technician Type 3OT200.00$ - 040.00$ - 0$ - 040.00$ - 0$ - 040.00$ - 0$ - 040.00$ - 0$ - 040.00$ - 0$ - 0
Pavement Technician Type 4OT200.00$ - 040.00$ - 0$ - 040.00$ - 0$ - 040.00$ - 0$ - 040.00$ - 0$ - 040.00$ - 0$ - 0
Heavy Vehicle Simulator OperatorOT200.00$ - 040.00$ - 0$ - 040.00$ - 0$ - 040.00$ - 0$ - 040.00$ - 0$ - 040.00$ - 0$ - 0
Subtotal Labor30,216.00$ - 06,043.20$ - 06,043.20$ - 06,043.20$ - 06,043.20$ - 06,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 RateFringeOverheadG&AProfitOrd. Period 1Ord. Period 2Ord. Period 3Ord. Period 4Ord. 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 CategoryOrd. Period 1Ord. Period 2Ord. Period 3Ord. Period 4Ord. 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 .