Attachment_5_-_Revised_Pricing_Worksheet.xls

XLS spreadsheet 185 KB Posted

Attached to
Foreign Language Training and Training Support Services Federal contract opportunity
Solicitation number
W911S0-16-R-0001
Issued by
Department of the Army Materiel Command Mission and Installation Contracting Command Fort Eustis

View the file

Other files for this federal contract opportunity

Show all 17

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

Instructions

Instructions for Completing Price Workbook
Complete this workbook according to the instructions below or it may not roll up correctly
You MAY insert rows on tabls "Year 1" to "Year 5"; however, make sure the totals still make
sense.
Base Labor RatesEnter full offerror name in Cell 1B.
Base Labor RatesEnter the base direct labor rates for each labor category on the "Base Labor Rates" tab. The rates for the option years
can be entered manually or the base direct labor rates can be escalated by an escalation factor by formula. If the
rates are escalated by formula leave the formula intact so it can be evaluated.
Indirect RatesEnter all indirect rates for the base and all option years on the "Indirect Rates & Factors" tab.
If a rate is not applicable enter 0%.
Travel / ODCDo Not alter the amounts in the Travel & ODC tab, these are the Government specified not to exceed amounts.
Per the PWS G&A on travel is not an allowable cost for the anticipated contract.
The Instructional Materials and ODCs are inclusive of applicable allowable indirect rates.
DO NOT materially alter this workbook, password protect, lock cells or hide columns or sheets as it is set up to
automatically calculate the annual prices and roll up to a summary.

TEP

Total Evaluated Price
LaborTravel / ODCTotal
POPPricePricePrice
Year 1$0.00$ 1,915,000.00$1,915,000.00
Year 2$0.00$ 1,915,000.00$1,915,000.00
Year 3$0.00$ 1,915,000.00$1,915,000.00
Year 4$0.00$ 1,915,000.00$1,915,000.00
Year 5$0.00$ 1,915,000.00$1,915,000.00
Total Evaluated Price$0.00$9,575,000.00$9,575,000.00

Year 1

Labor Rate Build-up - Year 1
Government Provided Labor CategoriesDOL Wage Determination ID NumberLabor RateFringeSubtotalOverheadSubtotalG&ASub TotalProfitSubtotalCost of MoneyFully Burdened Labor RateEstimated Hours (Prime must account for at least 50%)Estimated Price
Applicable Indirect Rate0.00%0.00%0.00%0.00%- 0
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
Labor Total-$0.00$0.00
Travel & ODCTotal
Travel$ 1,700,000.00
Instructional Materials$ 200,000.00
ODC$ 15,000.00
Total Travel & ODC$ 1,915,000.00
Year 1 TEP$ 1,915,000.00

Year 2

Labor Rate Build-up - Year 2
Government Provided Labor CategoriesDOL Wage Determination ID NumberLabor RateFringeSubtotalOverheadSubtotalG&ASub TotalProfitSubtotalCost of MoneyFully Burdened Labor RateEstimated Hours (Prime must account for at least 50%)Estimated Price
Applicable Indirect Rate0.00%0.00%0.00%0.00%- 0
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
Labor Total-$0.00
Travel & ODCTotal
Travel$ 1,700,000.00
Instructional Materials$ 200,000.00
ODC$ 15,000.00
Total Travel & ODC$ 1,915,000.00
Year 2 TEP$ 1,915,000.00

Year 3

Labor Rate Build-up - Year 3
Government Provided Labor CategoriesDOL Wage Determination ID NumberLabor RateFringeSubtotalOverheadSubtotalG&ASub TotalProfitSubtotalCost of MoneyFully Burdened Labor RateEstimated Hours (Prime must account for at least 50%)Estimated Price
Applicable Indirect Rate0.00%0.00%0.00%0.00%- 0
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
Labor Total-$0.00
Travel & ODCTotal
Travel$ 1,700,000.00
Instructional Materials$ 200,000.00
ODC$ 15,000.00
Total Travel & ODC$ 1,915,000.00
Year 3 TEP$ 1,915,000.00

Year 4

Labor Rate Build-up - Year 4
Government Provided Labor CategoriesDOL Wage Determination ID NumberLabor RateFringeSubtotalOverheadSubtotalG&ASub TotalProfitSubtotalCost of MoneyFully Burdened Labor RateEstimated Hours (Prime must account for at least 50%)Estimated Price
Applicable Indirect Rate0.00%0.00%0.00%0.00%- 0
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
Labor Total-$0.00
Travel & ODCTotal
Travel$ 1,700,000.00
Instructional Materials$ 200,000.00
ODC$ 15,000.00
Total Travel & ODC$ 1,915,000.00
Year 4 TEP$ 1,915,000.00

Year 5

Labor Rate Build-up Year 5
Government Provided Labor CategoriesDOL Wage Determination ID NumberLabor RateFringeSubtotalOverheadSubtotalG&ASub TotalProfitSubtotalCost of MoneyFully Burdened Labor RateEstimated Hours (Prime must account for at least 50%)Estimated Price
Applicable Indirect Rate0.00%0.00%0.00%0.00%- 0
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0-$0.00
Labor Total-$0.00
Travel & ODCTotal
Travel$ 1,700,000.00
Instructional Materials$ 200,000.00
ODC$ 15,000.00
Total Travel & ODC$ 1,915,000.00
Year 5 TEP$ 1,915,000.00

Travel & ODC

Travel & ODC
YearTravelInstructional MaterialsODCTotal
1$ 1,700,000.00$ 200,000.00$ 15,000.00$ 1,915,000.00
2$ 1,700,000.00$ 200,000.00$ 15,000.00$ 1,915,000.00
3$ 1,700,000.00$ 200,000.00$ 15,000.00$ 1,915,000.00
4$ 1,700,000.00$ 200,000.00$ 15,000.00$ 1,915,000.00
5$ 1,700,000.00$ 200,000.00$ 15,000.00$ 1,915,000.00
Total$8,500,000.00$ 1,000,000.00$ 75,000.00$9,575,000.00

Base Labor Rates

Offeror's Name:
Composite Contract Rates
Base Labor Rates
Labor CategoryYear 1Year 2Year 3Year 4Year 5

Indirect Rates & Factors

Indirect Rates & Factors
Year 1Year 2Year 3Year 4Year 5
Fringe Rate
Overhead Rate
G&A Rate
Material Handling
FCCOM Factor
Profit Rate
Per FAR 31.205-10(b)(1) facilities capital cost of money (FCCOM) must be
calculated in accordance with 48 CFR 9904.414 to be considered
allowable. Therefore, the factor must be carried out to 5 decimal
places.

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