Attachment_J-1_-_Price_Model.xlsx

XLSX spreadsheet 39 KB Posted

Attached to
PATRIOT Exercise Program for the Air National Guard A-2/3/6
Solicitation number
W9133L17R0004
Issued by

About this file

Attachment J-1 - Price Model

View the file

Other files

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

I.a.1 - Final Pricing

National Guard Bureau A2/3/6 PATRIOT Exercise Program W9133L-17-R-0004

CLIN TypeDescriptionTO CLINQTYUnit of MeasurePriceExtended Price
FFPPATRIOT Exercise Program Services00011JOB$ - 0$ - 0
COSTTravel00021JOB$ 100,000.00$ 100,000.00
FFPContractor Manapower Reporting (CMRA)00031EANSPNSP
FFPPATRIOT Exercise Program Services10011JOB$ - 0$ - 0
COSTTravel10021JOB$ 100,000.00$ 100,000.00
FFPContractor Manapower Reporting (CMRA)10031EANSPNSP
FFPPATRIOT Exercise Program Services20011JOB$ - 0$ - 0
COSTTravel20021JOB$ 100,000.00$ 100,000.00
FFPContractor Manapower Reporting (CMRA)20031EANSPNSP
FFPPATRIOT Exercise Program Services30011JOB$ - 0$ - 0
COSTTravel30021JOB$ 100,000.00$ 100,000.00
FFPContractor Manapower Reporting (CMRA)30031EA$ - 0NSP
Note 1: This woksheet will be populated based on rates and quantities entered into the Pricing Detail Worksheets

Note 2: The estimated travel cost for all periods will be based on the Government estimate.

Note 3: Contractor may, on a monthly basis, invoice the lesser of 1/12 the CLIN price or that amount minus any equitable reduction in contract price due in accordance FAR 52.246-4 -- Inspection of Services -- Fixed-Price for CLINs 0001, 1001, 2001 and 3001.

Note 4: Contractor Manpower Reporting is normally proposed as "Not Seperately Priced" as labor costs associated with the preparation of this report are included in G&A. These CLINs are included per Army policy and the contractor may propose a price if desired or propose this CLIN as NSP.

Base Period$ 100,000.00
Option Year 1$ 100,000.00
Option Year 2$ 100,000.00
Option Year 3$ 100,000.00
Total Evaluated Price$ 400,000.00

I.a.2 - Pricing Detail - Base W9133L-17-R-0004 Base Year Pricing Worksheet

CLIN
Labor CategoryProposed Personnel00010003
Strategic Plans Analysis ServicesCMRA
RateHoursPriceRateHoursPrice
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
Other Direct CostsDescriptionPriceQuantityExt PriceRateQuantityTotal Price
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
Total Price:$ - 0Total Price:$ - 0
Unit Price:$ - 0Unit Price:NSP

I.a.3 - Pricing Detail - OY1 W9133L-17-R-0004 Option Year 1 Pricing Worksheet

CLIN
Labor CategoryProposed Personnel10011003
Strategic Plans Analysis ServicesCMRA
RateHoursPriceRateHoursPrice
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
Other Direct CostsDescriptionPriceQuantityExt PriceRateQuantityTotal Price
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
Total Price:$ - 0Total Price:$ - 0
Unit Price:$ - 0Unit Price:NSP

I.a.4 - Pricing Detail - OY2 W9133L-17-R-0004 Option Year 2 Pricing Worksheet

Labor CategoryProposed Personnel20012003
Strategic Plans Analysis ServicesCMRA
RateHoursPriceRateHoursPrice
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
Other Direct CostsDescriptionPriceQuantityExt PriceRateQuantityTotal Price
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
Total Price:$ - 0Total Price:$ - 0
Unit Price:$ - 0Unit Price:NSP

I.a.5 - Pricing Detail - OY3 W9133L-17-R-0004 Option Year 3 Pricing Worksheet

Labor CategoryProposed Personnel20012003
Strategic Plans Analysis ServicesCMRA
RateHoursPriceRateHoursPrice
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
Other Direct CostsDescriptionPriceQuantityExt PriceRateQuantityTotal Price
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
$ - 0$ - 0
Total Price:$ - 0Total Price:$ - 0
Unit Price:$ - 0Unit Price:NSP

I.a.6 - Rate Buildup

NG-J3 CE2T2

Rate Buildup Worksheet

Year
BaseOption Period 1Option Period 2Option Period 3
Rates:EscalationEscalationEscalation
FringeFringeFringeFringe
Labor O/HLabor O/HLabor O/HLabor O/H
G&AG&AG&AG&A
ProfitProfitProfitProfit
Base Year Labor Rates
Labor CategoryProposed PersonBase SalaryBase Hourly RateFringeLabor O/HG&ASubtotalProfitFully Burdened Rate
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Option Period 1 Labor Rates
Labor CategoryProposed PersonBase SalaryBase Hourly RateFringeLabor O/HG&ASubtotalProfitFully Burdened Rate
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Option Period 2 Labor Rates
Labor CategoryProposed PersonBase SalaryBase Hourly RateFringeLabor O/HG&ASubtotalProfitFully Burdened Rate
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
Option Period 3 Labor Rates
Labor CategoryProposed PersonBase SalaryBase Hourly RateFringeLabor O/HG&ASubtotalProfitFully Burdened Rate
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0
$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0

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