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
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!
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%
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%
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
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
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!
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)
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
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
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
aa_Comp Brkdwn Mstr_ CHINA_Stamp'g & Asm's_Rel #38_Mdl Yr 2013 to 2019.xls
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
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
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
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