Attachment_0004_TAP_Pricing_Workbook.xlsx

XLSX spreadsheet 49 KB Posted

Attached to
Team Armor Partnership (TAP)
Solicitation number
W56HZV-19-R-0043
Issued by

About this file

This attachment to a solicitation provides pricing templates for a Team Armor Partnership (TAP) contract for receipt, storage, issue and repair of Abrams, Bradley and Wolverine line and shop replacement units. The contractor shall perform this work at Building 88037 at Fort Hood, Texas. The cost plus fixed fee contract has a one year base period and two one-year options. Pricing templates are provided for the base year and each option year requiring labor categories, hours and rates by department and skill level as well as material, other direct costs and fee. The Department of the Army Materiel Command TACOM Life Cycle Management Command is the agency and repairs shall be done to technical manual or original equipment manufacturer standards.

The templates require completion of yellow highlighted cells with labor categories, hours and rates as well as material, other direct costs and fee. Formulas will auto-populate totals for cost and price. Cells are locked to prevent manipulation beyond yellow highlighted inputs. All inputs must reconcile to provided labor hours. Once filled in, the templates will provide pricing for the base year and two option years of the TAP contract for receipt, storage, issue and repair of Abrams, Bradley and Wolverine units at Fort Hood, Texas.

Attachment 0004 TAP Pricing Workbook

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

Instructions

Solicitation: W56HZV-19-R-0043
Attachment 0004 TAP 2.0 - Pricing Workbook
Instructions
1. Cells that require inputs are highlighted in yellow
2. All cells highlighted in yellow must be completed
3. Do not adjust formulas or otherwise manipulate any of the non-yellow highlighted cells
4. Do not alter or make changes to this attachment except for inputting values in those cells highlighted in yellow
5. Inputs in the Summary, CLIN 1001, CLIN 2001 and CLIN 3001 tabs are necessary for the attachment to be complete
6. Labor categories and labor hours are provided in rows 5, 16, 27, 38, 49, 60 and 71
7. Offeror must input hours by department and skill band for each category that total the labor hours found in the rows mentioned above
8. Rows 5, 16, 27, 38, 49, 60, 71 will turn green once the labor hour inputs reconcile to the hours provided for each category (i.e. an input of 43 in cells E6 and E7 will result in row 5 turning green. This indicates that the total hours for this section reconcile to the hours provided)
9. Row 82 will turn green once all hours are accounted for
9. Note cells F3 and G3 for each CLIN. Once one section is filled in, the other section will be greyed out. (i.e. an input of $1.00 in cell F6 will result in I6 and I7 being greyed out as an input is not necessary)

Tasks- Examples Examples of Tasks by Labor Grouping

ContractsEngineeringProduction & Delivery
Contract administrationQuality assuranceIdentifying material for repairs
Proposal developmentTest engineeringMaterial handling
Data & change management
Laboratory operations
Facilities engineering
Supply Chain ManagementSustainment ServicesProgram Office
Product managementFacility operations (TAP Warehouse)Planning
Product planningSite coordinationOversight of daily operations
Unique ID (UID)- receipting/issuing through LMPAnalysis
Maintaining database information
Human Resource activities
Issuing GFM requirements
Finance
Finance Support

Summary

Solicitation: W56HZV-19-R-0043
Attachment 0004 TAP 2.0 - Pricing Workbook
Summary

Offeror

Detail
CLINItemContract TypeProposed Estimated CostProposed
Fixed FeeProposed Price
1001TAP Contract - CPFF - Year 1, Base AwardCost Plus Fixed Fee$ 6,783,587.77$ - 0$ 6,783,587.77
2001TAP Contract - CPFF - Year 2, Option 1Cost Plus Fixed Fee6,814,373.34- 06,814,373.34
3001TAP Contract - CPFF - Year 3, Option 2Cost Plus Fixed Fee6,845,158.90- 06,845,158.90
Total$ 20,443,120.01$ - 0$ 20,443,120.01

CLIN 1001

TAP Contract - CPFF - Year 1, Base Award

Labor:Complete for each row where Subcontractor FBLR is input in Column IComplete either Columns F, G, and H or I and J. DO NOT enter inputs in both
Direct Labor Category DescriptionService Contract Act (SCA) Wage Determination (WD) Number (if applicable)Occupational Code or Position Description (Including any Group/Zone if applicable)Subcontractor Name
(if applicable)67,360
Estimated HoursDirect Labor
($ per hour)Fringe
($ per hour)Labor Overhead
($ per hour)Subcontractor

FBLR

($ per hour) Prime Overhead on Subcontractor

FBLR

($ per hour)Prime G&A
($ per hour)Prime Misc
($ per hour)Prime FCCM
($ per hour)Estimated Cost
($ per hour)Prime Fixed Fee
($ per hour)Price
($ per hour)Estimated

Cost

(Extended)Fixed Fee
(Extended)Price

(Extended)

Contracts86
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Engineering3,026
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Production & Delivery2,499
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Program Office580
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Supply Chain Management217
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Sustainment Services60,306
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Finance646
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Total0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Total Material Costs:
DescriptionPrice
Material$6,482,598.89
Material Overhead (If Applicable)
General & Administrative
Facilities Capital Cost of Money
Total Estimated Material Cost$6,482,598.89
Fixed Fee
Other Direct Costs (ODC):
DescriptionPrice
ODC's$300,988.88
ODC Overhead (If Applicable)
General & Administrative
Facilities Capital Cost of Money
Total Estimated ODC's$300,988.88
Fixed Fee
Total:
DescriptionPrice
Estimated Cost$6,783,587.77
Fixed Fee$0.00
Price$6,783,587.77

CLIN 2001

TAP Contract - CPFF - Year 2, Option 1

Labor:Complete for each row where Subcontractor FBLR is input in Column IComplete either Columns F, G, and H or I and J. DO NOT enter inputs in both
Direct Labor Category DescriptionService Contract Act (SCA) Wage Determination (WD) Number (if applicable)Occupational Code or Position Description (Including any Group/Zone if applicable)Subcontractor Name
(if applicable)71,367
Estimated HoursDirect Labor
($ per hour)Fringe
($ per hour)Labor Overhead
($ per hour)Subcontractor

FBLR

($ per hour) Prime Overhead on Subcontractor

FBLR

($ per hour)Prime G&A
($ per hour)Prime Misc
($ per hour)Prime FCCM
($ per hour)Estimated Cost
($ per hour)Prime Fixed Fee
($ per hour)Price
($ per hour)Estimated

Cost

(Extended)Fixed Fee
(Extended)Price

(Extended)

Contracts91
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Engineering3,206
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Production & Delivery2,648
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Program Office615
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Supply Chain Management229
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Sustainment Services63,893
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Finance685
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Total0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Total Material Costs:
DescriptionPrice
Material$6,493,964.32
Material Overhead (If Applicable)
General & Administrative
Facilities Capital Cost of Money
Total Estimated Material Cost$6,493,964.32
Fixed Fee$0.00
Other Direct Costs (ODC):
DescriptionPrice
ODC's$320,409.02
ODC Overhead (If Applicable)
General & Administrative
Facilities Capital Cost of Money
Total Estimated ODC's$320,409.02
Fixed Fee
Total:
DescriptionPrice
Estimated Cost$6,814,373.34
Fixed Fee$0.00
Price$6,814,373.34

CLIN 3001

TAP Contract - CPFF - Year 3, Option 2

Labor:Complete for each row where Subcontractor FBLR is input in Column IComplete either Columns F, G, and H or I and J. DO NOT enter inputs in both
Direct Labor Category DescriptionService Contract Act (SCA) Wage Determination (WD) Number (if applicable)Occupational Code or Position Description (Including any Group/Zone if applicable)Subcontractor Name
(if applicable)75,374
Estimated HoursDirect Labor
($ per hour)Fringe
($ per hour)Labor Overhead
($ per hour)Subcontractor

FBLR

($ per hour) Prime Overhead on Subcontractor

FBLR

($ per hour)Prime G&A
($ per hour)Prime Misc
($ per hour)Prime FCCM
($ per hour)Estimated Cost
($ per hour)Prime Fixed Fee
($ per hour)Price
($ per hour)Estimated

Cost

(Extended)Fixed Fee
(Extended)Price

(Extended)

Contracts96
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Engineering3,386
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Production & Delivery2,797
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Program Office649
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Supply Chain Management242
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Sustainment Services67,481
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Finance723
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
$0.00$0.00$0.00$0.00$0.00
Total0$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
Total Material Costs:
DescriptionPrice
Material$6,505,329.74
Material Overhead (If Applicable)
General & Administrative
Facilities Capital Cost of Money
Total Estimated Material Cost$6,505,329.74
Fixed Fee
Other Direct Costs (ODC):
DescriptionPrice
ODC's$339,829.16
ODC Overhead (If Applicable)
General & Administrative
Facilities Capital Cost of Money
Total Estimated ODC's$339,829.16
Fixed Fee
Total:
DescriptionPrice
Estimated Cost$6,845,158.90
Fixed Fee$0.00
Price$6,845,158.90

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