汽车行业金属冲压件成本核算估算模型Automotive Ford GM Chrysler PSA VW Metal Cost Model

MY
Price Breakdown - Cap Equip Amortization Worksheet New Price Level
Part Number /
Description Tool Description Number of Tools T C Design Cost Construction Cost Currency Total Cost ($US)
Item # Part Num / Descript Tool Description Number of Cavities or Stations Number of Tools T C Design Cost Build Cost Currency Total Cost ($US) Tooling Adjustment 100% Standard Tool Descriptions
Totals from page 2 Total raw material & purchased components
Operation Costs (labor & burden)
Operation Item # Action Process Descript Machine Type and Size Output / Hour (pieces) Cost / Hour ($US) Req'd / Part Markup on Outside Services 13.0%
Total Cost Less: Amount Amortized in Piece Price Net Cost Memo: Piece Price Amortization @ pieces annually for years with 9.00% interest Page 4
aa_Comp Brkdwn Mstr_ CHINA_Stamp'g & Asm's_Rel #38_Mdl Yr 2013 to 2019.xls
Price Breakdown - Piece Price Worksheet (Process Costs continued) New Price Level
Operation Costs (labor & burden)
Operation Item # Action Process Descript Machine Type and Size Output / Hour (pieces) Cost / Hour ($US) Req'd / Part Cost per Part ($US) Markup on Outside Services 13.0% 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Total Process Costs (carried to Page 1) Page 3 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
CN Model Year/Program Annual Volume RFC Number Part Number Description Design Level Orig Quote Date Current Quote Date Memo: Previous design level
MY
Price Breakdown - Tool Cost Worksheet New Price Level
aa_Comp Brkdwn Mstr_ CHINA_Stamp'g & Asm's_Rel #38_Mdl Yr 2013 to 2019.xls
E09P Components Rev 01
001
Page 1 of 5
o
CN Model Year/Program Annual Volume RFC Number Part Number Description Design Level Orig Quote Date Current Quote Date Memo: Previous design level
Total Material Costs (carried to Page 1) Page 2
aa_Comp Brkdwn Mstr_ CHINA_Stamp'g & Asm's_Rel #38_Mdl Yr 2013 to 2019.xls
E09P Components Rev 01
001
Page 2 of 5
o
CN Model Year/Program Annual Volume RFC Number Part Number Description Design Level Orig Quote Date Current Quote Date Memo: Previous design level
MY
Price Breakdown - Piece Price Worksheet New Price Level
aa_Comp Brkdwn Mstr_ CHINA_Stamp'g & Asm's_Rel #38_Mdl Yr 2013 to 2019.xls
Component Number
Description
Material
Raw Material Size thk width pitch total raw parts parts mat'l wt out req'd 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 pc wt each
Total Hourly-Rate Costs
Part Number /
Description Tool Description
Number of Tools
T C
Design Cost
Construction Cost
Currency
Total Cost ($US)
Total Other Out-Of-Pocket Costs Total Program Costs Memo: Piece Price Amortization @ pieces annually for years with 9.00% interest Page 5
Totals from page 3 Total process (labor & burden) Raw Mat'l Scrap Rebate @ .00% Total Mfg. Cost (Material + Labor & Burden + Scrap) S G & A @ 5.00% Profit @ 8.00% Cap Equip Amortization Packaging Selling Price @ supplier plant Shipping Selling Price @ Magna plant Production Tool Cost Page 1
Blank Die Draw Die Form Die Trim Die Prc Die Prog Die Transfer Die Tool'g Transfer Die Auto Bend Fixt CNC Bend Tool'g Dieco Bend Tool'g Manual Weld Fixt Robot Weld Fixt Spot Weld Fixt Staking Fixt Riveting Fixt Heat Staking Fixt Foam Mold Tool'g Plastic Inj Mold Final Insp Gage
MY
Price Breakdown - Piece Price Worksheet (Material Costs continued) New Price Level
Material Costs (raw mat'l and purchased components)
Item # Unit of Meas Cost / Unit ($US) Units Req'd Cost/Part Mat'l ($US) Markup on Outside Services 13.0%
Material Costs (raw mat'l and purchased components)
Item # Component Number Description Material Unit of Meas Cost / Unit ($US) Units Req'd Cost/Part Mat'l ($US) Markup on Outside Services 13.0% Raw Material Size thk width pitch total raw parts parts mat'l wt out req'd 1 1 1 1 1 1 1 1 1 pc wt each
No. of Oper's 1 1 1 1 1 1 1 1 1
Labor Hrs/Pt pcs/min #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
sec/pc #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0!
o
CN Model Year/Program Annual Volume RFC Number Part Number Description Design Level Orig Quote Date Current Quote Date Memo: Previous design level
MY
No. of Oper's
Labor Hrs/Pt
pcs/min
sec/pc
aa_Comp Brkdwn Mstr_ CHINA_Stamp'g & Asm's_Rel #38_Mdl Yr 2013 to 2019.xls
E09P Components Rev 01
001
Page 3 of 5
o
E09P Components Rev 01
0源自文库1
Page 4 of 5
o
CN Model Year/Program Annual Volume RFC Number Part Number Description Design Level Orig Quote Date Current Quote Date Memo: Previous design level