Attachment_5_-_Pricing_Worksheet.xls

XLS spreadsheet 178 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

About this file

Attachment 5 - Pricing Worksheet

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 the applicable indirect rates for the base and all option years on the "Indirect Rates & Factors" tab
Travel / ODCDO enter proposed amounts for ODCs (Other Direct Costs)
Do Not alter the amounts for travel in the Travel & ODC tab, these are the Government specified not to exceed amounts.
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.

&LAttachment (7a)&C&A&R&P of &N

W900KK-15-R-0006

TEP

LaborTravel / ODCTotal
POPPricePricePrice
Year 1$0.00$ 1,700,000.00$1,700,000.00
Year 2$0.00$ 1,700,000.00$1,700,000.00
Year 3$0.00$ 1,700,000.00$1,700,000.00
Year 4$0.00$ 1,700,000.00$1,700,000.00
Year 5$0.00$ 1,700,000.00$1,700,000.00
Total Evaluated Price$0.00$8,500,000.00$8,500,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 TotalODCRateTotal-$0.00
Material$ - 0
Material Handling0.00%$ - 0
Material G&A Base$ - 0
G&A0.00%$ - 0
Material Total
Travel$ 1,700,000.00
G&A0.00%$ - 0
Travel Total
Year 1 TEP$ 1,700,000.00

&LAttachment (7a)&C&A&R&P of &N

W900KK-15-R-0006

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
ODCRateTotal
Material$ - 0
Material Handling0.00%$ - 0
Material G&A Base$ - 0
G&A0.00%$ - 0
Material Total
Travel$ 1,700,000.00
G&A0.00%$ - 0
Travel Total
Year 2 TEP$ 1,700,000.00

&LAttachment (7a)&C&A&R&P of &N

W900KK-15-R-0006

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
ODCRateTotal
Material$ - 0
Material Handling0.00%$ - 0
Material G&A Base$ - 0
G&A0.00%$ - 0
Material Total
Travel$ 1,700,000.00
G&A0.00%$ - 0
Travel Total
Year 3 TEP$ 1,700,000.00

&LAttachment (7a)&C&A&R&P of &N

W900KK-15-R-0006

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
ODCRateTotal
Material$ - 0
Material Handling0.00%$ - 0
Material G&A Base$ - 0
G&A0.00%$ - 0
Material Total
Travel$ 1,700,000.00
G&A0.00%$ - 0
Travel Total
Year 4 TEP$ 1,700,000.00

&LAttachment (7a)&C&A&R&P of &N

W900KK-15-R-0006

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
ODCRateTotal
Material$ - 0
Material Handling0.00%$ - 0
Material G&A Base$ - 0
G&A0.00%$ - 0
Material Total
Travel$ 1,700,000.00
G&A0.00%$ - 0
Travel Total
Year 5 TEP$ 1,700,000.00

&LAttachment (7a)&C&A&R&P of &N

W900KK-15-R-0006

Travel & ODC

YearTravelMaterial/ODCsTotal
1$ 1,700,000.00$ - 0$1,700,000.00
2$ 1,700,000.00$ - 0$1,700,000.00
3$ 1,700,000.00$ - 0$1,700,000.00
4$ 1,700,000.00$ - 0$1,700,000.00
5$ 1,700,000.00$ - 0$1,700,000.00
Total$8,500,000.00$ - 0$8,500,000.00

&LAttachment (7a)&C&A&R&P of &N

W900KK-15-R-0006

Base Labor Rates

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

&LAttachment (7a)&C&A&R&P of &N

W900KK-15-R-0006

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 .