Attachment 0013 - Cost Model.xlsx

XLSX spreadsheet 626 KB Posted

Attached to
Cossi Clutch Assembly for AH-64 Apache
Solicitation number
W58RGZ-22-R-0066
Issued by

View the file

Other files

Show all 21

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

TABLES

Cost Elements by CLINB245678
ALL CLINSTotal Dollars by CLINIndirect Cost by CategoryLabor Hours by Category by CFYIndirect Rates by Category by CFYDirect Labor Rates by Category by CFY
ContractorContractorIndirectContractorContractor Proposed Labor Hours by Labor CategoryDescriptionContractor Proposed Indirect RatesContractor Proposed Direct Labor Rates
Cost ElementProposedCLINProposedCategoryProposedLabor Category20212022202320242025TOTALCode20212022202320242025Code20212022202320242025
Direct Labor Hours- 00001$0Fringe$0Labor Cat1- 0- 0- 0- 0- 0- 0Fringe0.00%0.00%0.00%0.00%0.00%Labor Cat1$0.00$0.00$0.00$0.00$0.00
Direct Labor Cost$00002$0Labor Overhead$0Labor Cat2- 0- 0- 0- 0- 0- 0Labor Overhead0.00%0.00%0.00%0.00%0.00%Labor Cat2$0.00$0.00$0.00$0.00$0.00
Subtotal (Direct Labor)$0TOTAL$0Material Overhead$0Labor Cat3- 0- 0- 0- 0- 0- 0Material Overhead0.00%0.00%0.00%0.00%0.00%Labor Cat3$0.00$0.00$0.00$0.00$0.00
Fringe$0General & Admin$0Total- 0- 0- 0- 0- 0- 0General & Admin0.00%0.00%0.00%0.00%0.00%
Labor OH$0Direct Labor Hours by CLINLabor FCCOM$0Labor FCCOM0.000%0.000%0.000%0.000%0.000%
Material OH$0ContractorG&A FCCOM$0G&A FCCOM0.000%0.000%0.000%0.000%0.000%
G&A$0CLINProposedTOTAL$0
Subtotal (Indirect)$00001- 0
IWTA$00002- 0ODCs by Category
Subcontracts$0TOTAL- 0Contractor
Material$0CategoryProposed
Travel$0Direct Labor Dollars by CLINTravel$0
ODC$0ContractorMisc ODC$0
Total excl. FCCOM$0CLINProposedTOTAL ODC$0
FCCOM$00001$0
Total Cost$00002$0
Fee/Profit$0TOTAL$0
Total Price$0
Fringe, O/H, G&A, COM by CLIN
0001Contractor
ContractorCLINProposed
Cost ElementProposed0001$0
Direct Labor Hours- 00002$0
Direct Labor Cost$0TOTAL$0
Subtotal (Direct Labor)$0
Fringe$0IWTA by CLIN
Labor OH$0Contractor
Material OH$0CLINProposed
G&A$00001$0
Subtotal (Indirect)$00002$0
IWTA$0TOTAL$0
Subcontracts$0
Material$0Subcontracts by CLIN
Travel$0Contractor
ODC$0CLINProposed
Total excl. FCCOM$00001$0
FCCOM$00002$0
Total Cost$0TOTAL$0
Fee/Profit$0
Total Price$0Material Costs by CLIN
Contractor
0002CLINProposed
Contractor0001$0
Cost ElementProposed0002$0
Direct Labor Hours- 0TOTAL$0
Direct Labor Cost$0
Subtotal (Direct Labor)$0ODC by CLIN (Includes Travel)
Fringe$0Contractor
Labor OH$0CLINProposed
Material OH$00001$0
G&A$00002$0
Subtotal (Indirect)$0TOTAL$0
IWTA$0
Subcontracts$0Fee/Profit by CLIN
Material$0Contractor
Travel$0CLINProposed
ODC$00001$0
Total excl. FCCOM$00002$0
FCCOM$0TOTAL$0
Total Cost$0
Fee/Profit$0Fee/Profit Percentage by CLIN
Total Price$0Contractor
CLINProposed
000110.00%
000210.00%

Fee Calc Fee Rate Fee Dollars

CLINTotal Cost Less FCCOMODCTravelMaterial - Very HighMaterial - HighMaterial - MediumMaterial - LowIWTA Fee-BearingIWTA Non-Fee BearingSub Fee-BearingSub Non-Fee BearingFCCOMOther (Labor, Burdens)ODCTravelMaterial VHMaterial HMaterial MMaterial LIWTA Fee-BearingIWTA Non-Fee BearingSub Fee-BearingSub Non-Fee BearingFCCOMOther (Labor, Burdens)ODCTravelMaterial VHMaterial HMaterial MMaterial LIWTA Fee-BearingIWTA Non-Fee BearingSub Fee-BearingSub Non-Fee BearingFCCOMOther (Labor, Burdens)Total Fee
0001$0$0$0$0$0$0$0$0$0$0$0$0$00.00%0.00%10.00%8.00%6.00%4.00%10.00%0.00%10.00%0.00%0.00%10.00%$0$0$0$0$0$0$0$0$0$0$0$0$0
0002$0$0$0$0$0$0$0$0$0$0$0$0$00.00%0.00%10.00%8.00%6.00%4.00%10.00%0.00%10.00%0.00%0.00%10.00%$0$0$0$0$0$0$0$0$0$0$0$0$0
Total$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
Material Fee by Risk Category
Material RiskFee RateTotal Material BaseTotal Material Fee
Very High10.00%$0$0
High8.00%$0$0
Medium6.00%$0$0
Low4.00%$0$0
Total$0$0
TRUE

All CLINs

CLIN:ALL
TOTAL20212022202320242025
(Row for Rates Array)2ERROR:#REF!ERROR:#REF!3ERROR:#REF!ERROR:#REF!4ERROR:#REF!ERROR:#REF!5ERROR:#REF!ERROR:#REF!6ERROR:#REF!
DescriptionHrs/BaseDollarsHrs/BaseRateDollarsHrs/BaseRateDollarsHrs/BaseRateDollarsHrs/BaseRateDollarsHrs/BaseRateDollarsIndividual CLIN CHECKDIFFERENCE
DIRECT LABOR:
Labor Cat10$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$00$0
Labor Cat20$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$00$0
Labor Cat30$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$00$00$0
SUBTOTALDIRECT LABOR COST0$00$00$00$00$00$00$00$0
INDIRECT COST:
Fringe$0$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0$0$0$0$0
Labor Overhead$0$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0$0$0$0$0
SUBTOTALIndirects$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0$0
ODCs:
TRAVEL$0$0$0$0$0$0$0$0$0$0
Misc ODC$0$0$0$0$0$0$0$0$0$0
SUBTOTALODCs$0$0$0$0$0$0$0$0$0$0
MATERIAL:
Purchased Parts$0$0$0$0$0$0$0$0$0$0
Value added end items$0$0$0$0$0$0$0$0$0$0
SUBTOTALMATERIAL$0$0$0$0$0$0$0$0$0$0
MATERIAL OVERHEAD:
Material Overhead$0$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0$0$0$0$0
SUBTOTALMATERIAL OH$0$0$0$0$0$0$0$0$0$0
IWTAs:
IWTA Fee-Bearing$0$0$0$0$0$0$0$0$0$0
IWTA Non-Fee Bearing$0$0$0$0$0$0$0$0$0$0
SUBTOTALIWTA$0$0$0$0$0$0$0$0$0$0
SUBCONTRACTs:
Subcontract Fee-Bearing$0$0$0$0$0$0$0$0$0$0
Subcontract Non-Fee Bearing$0$0$0$0$0$0$0$0$0$0
SUBTOTALSUBCONTRACTS$0$0$0$0$0$0$0$0$0$0
G & A EXPENSE:
General & Admin$0$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0$0$0$0$0
SUBTOTALG&A$0$0$0$0$0$0$0$0$0$0

SUBTOTAL COST EXCL. FCCOM $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

FCCOM:
Labor FCCOM$0$0$00.000%$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0$0$0$0$0
G&A FCCOM$0$0$00.000%$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0$0$0$0$0
SUBTOTALFCCOM$0$0$0$0$0$0$0$0$0$0

SUBTOTAL COST $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

CLIN 0001

CLIN:0001
TOTAL20212022202320242025
(Row for Rates Array)2ERROR:#REF!ERROR:#REF!3ERROR:#REF!ERROR:#REF!4ERROR:#REF!ERROR:#REF!5ERROR:#REF!ERROR:#REF!6ERROR:#REF!
DescriptionHrs/BaseDollarsHrs/BaseRateDollarsHrs/BaseRateDollarsHrs/BaseRateDollarsHrs/BaseRateDollarsHrs/BaseRateDollars
DIRECT LABOR:
Labor Cat10$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
Labor Cat20$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
Labor Cat30$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
SUBTOTALDIRECT LABOR COST0$00$00$00$00$00$0
INDIRECT COST:
Fringe$0$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0
Labor Overhead$0$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0
SUBTOTALIndirects$0$0$0$0$0$0$0$0$0$0$0$0
ODCs:
TRAVEL$0$0$0$0$0$0
Misc ODC$0$0$0$0$0$0
SUBTOTALODCs$0$0$0$0$0$0
MATERIAL:
Purchased Parts$0$0$0$0$0$0
Value added end items$0$0$0$0$0$0
SUBTOTALMATERIAL$0$0$0$0$0$0
MATERIAL OVERHEAD:
Material Overhead$0$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0
SUBTOTALMATERIAL OH$0$0$0$0$0$0
IWTAs:
IWTA Fee-Bearing$0$0$0$0$0$0
IWTA Non-Fee Bearing$0$0$0$0$0$0
SUBTOTALIWTA$0$0$0$0$0$0
SUBCONTRACTs:
Subcontract Fee-Bearing$0$0$0$0$0$0
Subcontract Non-Fee Bearing$0$0$0$0$0$0
SUBTOTALSUBCONTRACTS$0$0$0$0$0$0
G & A EXPENSE:
General & Admin$0$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0
SUBTOTALG&A$0$0$0$0$0$0

SUBTOTAL COST EXCL. FCCOM $0 $0 $0 $0 $0 $0

FCCOM:
Labor FCCOM$0$0$00.000%$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0
G&A FCCOM$0$0$00.000%$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0
SUBTOTALFCCOM$0$0$0$0$0$0

SUBTOTAL COST $0 $0 $0 $0 $0 $0

CLIN 0002

CLIN:0002
TOTAL20212022202320242025
(Row for Rates Array)2ERROR:#REF!ERROR:#REF!3ERROR:#REF!ERROR:#REF!4ERROR:#REF!ERROR:#REF!5ERROR:#REF!ERROR:#REF!6ERROR:#REF!
DescriptionHrs/BaseDollarsHrs/BaseRateDollarsHrs/BaseRateDollarsHrs/BaseRateDollarsHrs/BaseRateDollarsHrs/BaseRateDollars
DIRECT LABOR:
Labor Cat10$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
Labor Cat20$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
Labor Cat30$00$0.00$00$0.00$00$0.00$00$0.00$00$0.00$0
SUBTOTALDIRECT LABOR COST0$00$00$00$00$00$0
INDIRECT COST:
Fringe$0$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0
Labor Overhead$0$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0
SUBTOTALIndirects$0$0$0$0$0$0$0$0$0$0$0$0
ODCs:
TRAVEL$0$0$0$0$0$0
Misc ODC$0$0$0$0$0$0
SUBTOTALODCs$0$0$0$0$0$0
MATERIAL:
Purchased Parts$0$0$0$0$0$0
Value added end items$0$0$0$0$0$0
SUBTOTALMATERIAL$0$0$0$0$0$0
MATERIAL OVERHEAD:
Material Overhead$0$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0
SUBTOTALMATERIAL OH$0$0$0$0$0$0
IWTAs:
IWTA Fee-Bearing$0$0$0$0$0$0
IWTA Non-Fee Bearing$0$0$0$0$0$0
SUBTOTALIWTA$0$0$0$0$0$0
SUBCONTRACTs:
Subcontract Fee-Bearing$0$0$0$0$0$0
Subcontract Non-Fee Bearing$0$0$0$0$0$0
SUBTOTALSUBCONTRACTS$0$0$0$0$0$0
G & A EXPENSE:
General & Admin$0$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0
SUBTOTALG&A$0$0$0$0$0$0

SUBTOTAL COST EXCL. FCCOM $0 $0 $0 $0 $0 $0

FCCOM:
Labor FCCOM$0$0$00.000%$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0
G&A FCCOM$0$0$00.000%$0$00.00%$0$00.00%$0$00.00%$0$00.00%$0
SUBTOTALFCCOM$0$0$0$0$0$0

SUBTOTAL COST $0 $0 $0 $0 $0 $0

INPUT-Labor Hrs

LABOR HOURS
Cost ElementBOE #CWBSLabor CategoryLocationRate CodeCLINSOWBOE Description20212022202320242025Total
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0
- 0

INPUT-TRAVEL

TRAVEL
Cost ElementCWBSCLINFrom LocationTo LocationPurposeYearTripsPeopleDaysCarsAirfareLodgingMIERental CarMiscEscalationTotal
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0

INPUT-ODCs

OTHER DIRECT COSTS
QuantityQuantityQuantityQuantityQuantityExtended CostExtended CostExtended CostExtended CostExtended CostTotal
Cost ElementBOE #CWBSCategoryCLINVendorDescriptionUnitUnit PriceBasis of Estimate2021202220232024202520212022202320242025
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0

INPUT-Material

MATERIAL
QuantityQuantityQuantityQuantityQuantityExtended CostExtended CostExtended CostExtended CostExtended CostTotal
Cost ElementBOE #CWBSCategoryCLINRisk CategoryVendorDescriptionUnitUnit PriceBasis of Estimate2021202220232024202520212022202320242025
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
$0$0$0$0$0$0
TOTALTOTAL$0$0$0$0$0$0

INPUT-Subs

SUBCONTRACTS
Cost ElementCost Element1BOE #CWBSSubcontractorCLINDescription20212022202320242025Total
$0
$0
$0
$0
$0
$0
Total Subcontract CostTotal Subcontract Cost$0$0$0$0$0$0
$0
$0
$0
$0
$0
$0
Total Subcontract Commercial ItemsTotal Subcontract Commercial Items$0$0$0$0$0$0
$0
$0
$0
$0
$0
$0
Total Subcontract FeeTotal Subcontract Fee$0$0$0$0$0$0

INPUT-IWTAs

IWTA
Cost ElementCost Element1BOE #WBSSubcontractorCLINDescription20212022202320242025Total
$0
$0
$0
$0
Total IWTA Fee-BearingTotal IWTA Fee-Bearing$0$0$0$0$0$0
$0
$0
$0
$0
Total IWTA MaterialTotal IWTA Material$0$0$0$0$0$0
$0
$0
$0
$0
Total IWTA Commercial ItemsTotal IWTA Commercial Items$0$0$0$0$0$0
$0
$0
$0
$0
Total IWTA ODC/TravelTotal IWTA ODC/Travel$0$0$0$0$0$0
$0
$0
$0
$0
Total IWTA FCCOMTotal IWTA FCCOM$0$0$0$0$0$0

INPUT-Rates & Factors

DIRECT RATESERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!
Labor Category20212022202320242025
23456
Labor Cat1$0.00$0.00$0.00$0.00$0.00
Labor Cat2$0.00$0.00$0.00$0.00$0.00
Labor Cat3$0.00$0.00$0.00$0.00$0.00
INDIRECT RATES
Description20212022202320242025
Fringe0.00%0.00%0.00%0.00%0.00%
Labor Overhead0.00%0.00%0.00%0.00%0.00%
Material Overhead0.00%0.00%0.00%0.00%0.00%
General & Admin0.00%0.00%0.00%0.00%0.00%
Labor FCCOM0.000%0.000%0.000%0.000%0.000%
G&A FCCOM0.000%0.000%0.000%0.000%0.000%
FEE/PROFIT RATES
TYPE OF RATE20212022202320242025
Fixed Fee0.00%0.00%0.00%0.00%0.00%
Target Fee0.00%0.00%0.00%0.00%0.00%
Award Fee0.00%0.00%0.00%0.00%0.00%
Profit0.00%0.00%0.00%0.00%0.00%

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