CE

profileLollll
W17303-XLS-ENG.xlsx
Home>Business & Finance homework help>Management homework help>CE

Project Info

Product Information
Bolt EV Bolt AV
Pre-production Volume (units) 1000 3500
Projected Annual Volume (units) 30,000 10,000
Project Life Cyce in Years (eff. 2019 MY) 5 5
Logistics Information
China Mexico California, US Germany
Taxes/ Duties - Paid on total manufacturing cost (material + labor) 3.60% 0.80% 0.00% 2.97%
Border Processing Fees (per shipment) $200.00 $200.00 $0.00 $200.00
Min Days of Inventory Required at Orion 8 5 3 8
Max Days of Inventory allowed at Orion 14 11 9 14
Shipping Plan (door to door - Ex Works) 40' Sea Container Consolidation 53' Truck Consolidation 53' Truck Consolidation 40' Sea Container Consolidation
Logistics Cost Calculation % of volume x full container cost + taxes and fees $/lb + taxes and fees $/lb % of volume x full container cost + taxes and fees
Full Container Cost $ 4,995.23 $ - 0 $ - 0 $ 3,813.98
Total Container Volume (cubic feet) 2376 - 0 - 0 2376
Transportaion Cost Rate ($/100lbs) $ - 0 $ 3.18 $ 3.18 $ - 0
Minimum Transportation Cost $ - 0 $ 75 $ 50 $ - 0
Transit Time (days) 26 7 4 25

Important facts: Use inventory carrying cost = 15% GM determines minimum inventory levels based on expedited transit time Maximum inventory allowed is equal to the min + one shipment + 1 box. Assume 235 working days/year

GM Bid List

Current Bidlist Report
As Of Date   22-Jul-2016
Brake e-Boost module Suppliers
RANK SUPPLIER QUALITY SERVICE
Quality Service Country Risk Rating Price MMOG/LE Name Location Mfg.Duns Lead Region PPM Major Disruptions Production PRR's Launch PRR's Supply Chain PRR's Controlled Shipping TS16949 Cert. NBH CCA Rating Financial Total PRR's ISO14001 Diversity Supplier
Risk Quality
Rating-FRR Excellence
Award
12 Mo. 6 Mo. 6 Mo. 6 Mo.
 Jun 15 Plant Recall Open Open
Sourceable
90 92.5 5 Y G Rosie Automotive International SHANGHAI, CN - CN 888999777 GMAP 7 0 0 0 1 1 0 Y N 1 3 2 N N Y
80 99.8 5 Y Y Elroy International SILAO, MX 444555888 GMNA 26 0 1 2 4 0 2 Y N 3 2 6 Y Y N
98 97.8 1 G G R.U.D.I. Braking Systems SAN DIEGO, US - CA 222555456 GMNA 3 0 0 2 1 0 0 Y N 1 1 0 Y N Y
2 Y R Orbitty International Manufacturing & Technology Co. MUNICH, DE 111222333 GMOV Y N 2 Y N
Non Sourceable
65 37.5 5 Y G H-B Automotive SHANGHAI, CN - CN 966812137 GMAP 1122 1 1 10 7 0 5 N Y 5 3 17 N N
Performance Criteria
<80 R 7-10 R R >7 >1 >2 >4 >2 >1 N Y 4,5 4,5,6,7 >4 N N
Y 4-6 Y Y 3.5-7 1  1-2  1-4  1-2 1 3 3  1-4 N
>=80 G 1-3 G G,NR <=3.4 0 0 0 0 0 Y N 1,2 1,2 0 Y Y Y
If Price Rank is RED for FRR you must have an Approval by GPSC Supply Risk Mgt
If MMOG/LE rank is RED, Buyer must alert the MMOG/LE team if supplier is to be included on an RFQ package.
If Service is RED with CCA PRRs, sourcing is prohibited. Submit Waiver to leadership for approval.
If Quality Ranking is Blank or RED, Sourcing requires SQ Leadership Approval

Rosie Auto - EV Quote

NOTE: You must select the material designation in order for all the formulas to work correctly
Supplier Cost Engineering
QUOTE Piece Cost Breakdown Worksheet Yearly Deliveries Lot Size
Breakdown Type: Program: BOLT EV Math /Dwg Level: 5
Date: 18-Sep-16 Vol Quoted: 30,000 104 288
Part #: 8675308 Supplier Daily Capacity (SDC): 128
Breakdown Level: Part Name: ELECTRIC BRAKE BOOSTER ASM @ hrs/day: 24
Supplier Name: Rosie Automotive International @ days/week: 5
AP/EWO# Mgf. Location: SHANGHAI, CHINA Quoted Currency: USD
(If applicable) Mfg Duns #: 888999777 Avg Year of Project 2022 Labor
Contact Name: Jean Vander Pyl PPAP Date:
Contact Email: [email protected]
Raw Material & Purchased Components: (labor Included)
(1) (2) (3) (4) (5) (6) (7a) (8) (9) (7b)
Item Description M/D/P
Prestes, Gustavo: M = Raw Material to Manufacturing D = Direct Sourced Purchased part P = Purchased Component 		QUANTITY OF PCS Unit of measure Mass Unit Cost Material Total Supplier Country of Mfg Handling Cost
COVER M 1 Kilograms 0.105 2.8660 2.8660
HOUSING M 1 Kilograms 0.274 2.8660 2.8660
EV HARDWARE COMPONENT M 1 Kilograms 0.187 8.6000 8.6000
CONNECTION LINES P 2 Kilograms 0.321 2.2500 4.5000
FASTENER CLIPS P 2 Kilograms 0.11 0.1500 0.3000
SCREW (COVER/HOUSING) P 2 Kilograms 0.15 0.0800 0.1600
Seconds Cavities
40 1
45 2
48 3
(10) MFG TOTALS 14.3320
Marilyn Woolery: If =M (mfg) then sum here 		50 4
(11) PURCHASED TOTALS 4.9600
Marilyn Woolery: If =P (mfg) then sum here 		52 8
19.291960
Marilyn Woolery: Year 1
Prestes, Gustavo: M = Raw Material to Manufacturing D = Direct Sourced Purchased part P = Purchased Component
Marilyn Woolery: Year 2 		55
60
(39) Remarks:
VZNKRP: Include Lump Sum ED&D 		Total Manufacturing Cost (Material + Labor): (26) 19.29196
Scrap 0.7% 0.13504
Fixed Handling Material 4.9% 0.94531
Variable Plant Overhead 10.0% 1.94270
Standard Cost 22.31501
Variable SGA 10.00% (27) 2.23150
Non-amoritized Costs (Items not included in Piece Price) Profit: 6.0% (28) 1.47279
Tooling $ 150,000 Non Manufactured Costs (29)
Software Development $ - 0 Software License Fee (31) 20.00000
Sub Total - Selling Price (Mfg. Parts) (33) 46.01930
Supplier's Supply Chain Costs
Marilyn Woolery: Includes freight, insurance,warehousing, import/export and custom duties and taxes covered by GM)
Marilyn Woolery: Year 3
Marilyn Woolery: Year 4 		(34)
Expendable Dunnage (35) 1.24086
Sequencing Sub-Assembly (36) 0.00000
Other (EDD)
Prestes, Gustavo: Each project has a specific cost
Marilyn Woolery: Year 5
VZNKRP: Include Lump Sum ED&D 		(37) 10.19000
Other (Identify Here) (37)
FINAL SALES PRICE (38) $ 57.450
(40) PRODUCTIVITY %: best price up front
(41) PRODUCTIVITY EFF. DATE

Elroy - EV Quote

NOTE: You must select the material designation in order for all the formulas to work correctly
Supplier Cost Engineering
QUOTE Piece Cost Breakdown Worksheet Yearly Deliveries Lot Size
Breakdown Type: Program: BOLT EV Math /Dwg Level: 5
Date: 18-Sep-16 Vol Quoted: 30,000 104 288
Part #: 8675308 Supplier Daily Capacity (SDC): 128
Breakdown Level: Part Name: ELECTRIC BRAKE BOOSTER ASM @ hrs/day: 24
Supplier Name: Elroy International @ days/week: 5
AP/EWO# Mgf. Location: Silao, Mexico Quoted Currency: USD
(If applicable) Mfg Duns #: 444555888 Avg Year of Project 2022 Labor
Contact Name: Daws Butler PPAP Date:
Contact Email: [email protected]
Raw Material & Purchased Components: (labor Included)
(1) (2) (3) (4) (5) (6) (7a) (8) (9) (7b)
Item Description M/D/P
Prestes, Gustavo: M = Raw Material to Manufacturing D = Direct Sourced Purchased part P = Purchased Component 		QUANTITY OF PCS Unit of measure Mass Unit Cost Material Total Supplier Country of Mfg Handling Cost
COVER M 1 Kilograms 0.105 3.1020 3.1020
HOUSING M 1 Kilograms 0.274 3.2480 3.2480
EV HARDWARE COMPONENT 1 P 1 Kilograms 0.187 7.8000 7.8000
EV HARDWARE COMPONENT 2 P 1 Kilograms 0.155 5.6000 5.6000
CONNECTION LINES P 2 Kilograms 0.321 1.9500 3.9000
FASTENER CLIPS P 2 Kilograms 0.11 0.1600 0.3200
SCREW (COVER/HOUSING) P 2 Kilograms 0.15 0.0800 0.1600
Seconds Cavities
40 1
45 2
48 3
(10) MFG TOTALS 6.3500
Marilyn Woolery: If =M (mfg) then sum here 		50 4
(11) PURCHASED TOTALS 17.7800
Marilyn Woolery: If =P (mfg) then sum here 		52 8
24.130000
Marilyn Woolery: Year 1
Prestes, Gustavo: M = Raw Material to Manufacturing D = Direct Sourced Purchased part P = Purchased Component
Marilyn Woolery: Year 2 		55
60
(39) Remarks:
VZNKRP: Include Lump Sum ED&D 		Total Manufacturing Cost (Material + Labor): (26) 24.13000
Scrap 0.7% 0.16891
Fixed Handling Material 4.9% 1.18237
Variable Plant Overhead 10.0% 2.42989
Standard Cost 27.91117
Variable SGA 10.00% (27) 2.79112
Non-amoritized Costs (Items not included in Piece Price) Profit: 6.0% (28) 1.84214
Tooling $ 50,000 Non Manufactured Costs (29)
Software Development $ 1,500,000 Software License Fee (31) 0.00000
Sub Total - Selling Price (Mfg. Parts) (33) 32.54443
Supplier's Supply Chain Costs
Marilyn Woolery: Includes freight, insurance,warehousing, import/export and custom duties and taxes covered by GM)
Marilyn Woolery: Year 3
Marilyn Woolery: Year 4 		(34)
Expendable Dunnage (35) 1.51798
Sequencing Sub-Assembly (36) 0.00000
Other (EDD)
Prestes, Gustavo: Each project has a specific cost
VZNKRP: Include Lump Sum ED&D
Marilyn Woolery: Year 5 		(37) 10.19000
Other (Identify Here) (37)
FINAL SALES PRICE (38) $ 44.252
(40) PRODUCTIVITY %: best price up front
(41) PRODUCTIVITY EFF. DATE

R.U.D.I. - EV Quote

NOTE: You must select the material designation in order for all the formulas to work correctly
Supplier Cost Engineering
QUOTE Piece Cost Breakdown Worksheet Yearly Deliveries Lot Size
Breakdown Type: Program: BOLT EV Math /Dwg Level: 5
Date: 18-Sep-16 Vol Quoted: 30,000 104 288
Part #: 8675308 Supplier Daily Capacity (SDC): 128
Breakdown Level: Part Name: ELECTRIC BRAKE BOOSTER ASM @ hrs/day: 24
Supplier Name: R.U.D.I. Braking Systems @ days/week: 5
AP/EWO# Mgf. Location: San Jose, CA Quoted Currency: USD
(If applicable) Mfg Duns #: 222555456 Avg Year of Project 2022 Labor
Contact Name: Don Messick PPAP Date:
Contact Email: [email protected]
Raw Material & Purchased Components: (labor Included)
(1) (2) (3) (4) (5) (6) (7a) (8) (9) (7b)
Item Description M/D/P
Prestes, Gustavo: M = Raw Material to Manufacturing D = Direct Sourced Purchased part P = Purchased Component 		QUANTITY OF PCS Unit of measure Mass Unit Cost Material Total Supplier Country of Mfg Handling Cost
COVER M 1 Kilograms 0.129 3.5000 3.5000
HOUSING M 1 Kilograms 0.299 3.7500 3.7500
EV HARDWARE COMPONENT 1 M 1 Kilograms 0.187 8.0000 8.0000
EV HARDWARE COMPONENT 2 M 1 Kilograms 0.155 5.7500 5.7500
CONNECTION LINES P 2 Kilograms 0.321 4.2000 8.4000
FASTENER CLIPS P 2 Kilograms 0.11 0.3200 0.6400
SCREW (COVER/HOUSING) P 2 Kilograms 0.15 0.2000 0.4000
Seconds Cavities
40 1
45 2
48 3
(10) MFG TOTALS 21.0000
Marilyn Woolery: If =M (mfg) then sum here 		50 4
(11) PURCHASED TOTALS 9.4400
Marilyn Woolery: If =P (mfg) then sum here 		52 8
30.440000
Marilyn Woolery: Year 1
Prestes, Gustavo: M = Raw Material to Manufacturing D = Direct Sourced Purchased part P = Purchased Component
Marilyn Woolery: Year 2 		55
60
(39) Remarks:
VZNKRP: Include Lump Sum ED&D 		Total Manufacturing Cost (Material + Labor): (26) 30.44000
Scrap 0.7% 0.21308
Fixed Handling Material 4.9% 1.49156
Variable Plant Overhead 10.0% 3.06531
Standard Cost 35.20995
Variable SGA 10.00% (27) 3.52099
Non-amoritized Costs (Items not included in Piece Price) Profit: 6.0% (28) 2.32386
Tooling $ - 0 Non Manufactured Costs (29)
Software Development $ - 0 Software License Fee (31) 30.00000
Sub Total - Selling Price (Mfg. Parts) (33) 71.05480
Supplier's Supply Chain Costs
Marilyn Woolery: Includes freight, insurance,warehousing, import/export and custom duties and taxes covered by GM)
Marilyn Woolery: Year 3
Marilyn Woolery: Year 4 		(34)
Expendable Dunnage (35) 1.51798
Sequencing Sub-Assembly (36) 0.00000
Other (EDD)
Prestes, Gustavo: Each project has a specific cost
VZNKRP: Include Lump Sum ED&D
Marilyn Woolery: Year 5 		(37) 10.19000
Other (Identify Here) (37)
FINAL SALES PRICE (38) $ 82.763
(40) PRODUCTIVITY %: best price up front
(41) PRODUCTIVITY EFF. DATE

Orbitty - EV Quote

NOTE: You must select the material designation in order for all the formulas to work correctly
Supplier Cost Engineering
QUOTE Piece Cost Breakdown Worksheet Yearly Deliveries Lot Size
Breakdown Type: Program: BOLT EV Math /Dwg Level: 5
Date: 18-Sep-16 Vol Quoted: 30,000 104 288
Part #: 8675308 Supplier Daily Capacity (SDC): 128
Breakdown Level: Part Name: ELECTRIC BRAKE BOOSTER ASM @ hrs/day: 24
Supplier Name: Orbitty International Manufacturing & Technology Co. @ days/week: 5
AP/EWO# Mgf. Location: Germany Quoted Currency: USD
(If applicable) Mfg Duns #: 111222333 Avg Year of Project 2022 Labor
Contact Name: Frank Welker PPAP Date:
Contact Email: [email protected]
Raw Material & Purchased Components: (labor Included)
(1) (2) (3) (4) (5) (6) (7a) (8) (9) (7b)
Item Description M/D/P
Prestes, Gustavo: M = Raw Material to Manufacturing D = Direct Sourced Purchased part P = Purchased Component 		QUANTITY OF PCS Unit of measure Mass Unit Cost Material Total Supplier Country of Mfg Handling Cost
COVER M 1 Kilograms 0.105 3.1020 3.1020
HOUSING M 1 Kilograms 0.274 3.2480 3.2480
EV HARDWARE COMPONENT 1 M 1 Kilograms 0.187 7.6000 7.6000
EV HARDWARE COMPONENT 2 M 1 Kilograms 0.155 4.9900 4.9900
CONNECTION LINES P 2 Kilograms 0.321 2.3500 4.7000
FASTENER CLIPS P 2 Kilograms 0.11 0.1600 0.3200
SCREW (COVER/HOUSING) P 2 Kilograms 0.15 0.0800 0.1600
Seconds Cavities
40 1
45 2
48 3
(10) MFG TOTALS 18.9400
Marilyn Woolery: If =M (mfg) then sum here 		50 4
(11) PURCHASED TOTALS 5.1800
Marilyn Woolery: If =P (mfg) then sum here 		52 8
24.120000
Marilyn Woolery: Year 1
Prestes, Gustavo: M = Raw Material to Manufacturing D = Direct Sourced Purchased part P = Purchased Component
Marilyn Woolery: Year 2 		55
60
(39) Remarks:
VZNKRP: Include Lump Sum ED&D 		Total Manufacturing Cost (Material + Labor): (26) 24.12000
Scrap 0.7% 0.16884
Fixed Handling Material 4.9% 1.18188
Variable Plant Overhead 10.0% 2.42888
Standard Cost 27.89960
Variable SGA 10.00% (27) 2.78996
Non-amoritized Costs (Items not included in Piece Price) Profit: 6.0% (28) 1.84137
Tooling $ - 0 Non Manufactured Costs (29)
Software Development $ 4,000,000 Software License Fee (31) 0.00000
Sub Total - Selling Price (Mfg. Parts) (33) 32.53094
Supplier's Supply Chain Costs
Marilyn Woolery: Includes freight, insurance,warehousing, import/export and custom duties and taxes covered by GM)
Marilyn Woolery: Year 3
Marilyn Woolery: Year 4 		(34)
Expendable Dunnage (35) 1.51798
Sequencing Sub-Assembly (36) 0.00000
Other (EDD)
Prestes, Gustavo: Each project has a specific cost
VZNKRP: Include Lump Sum ED&D
Marilyn Woolery: Year 5 		(37) 10.19000
Other (Identify Here) (37)
FINAL SALES PRICE (38) $ 44.239
(40) PRODUCTIVITY %: best price up front
(41) PRODUCTIVITY EFF. DATE

Rosie Auto - AV Quote

NOTE: You must select the material designation in order for all the formulas to work correctly
Supplier Cost Engineering
QUOTE Piece Cost Breakdown Worksheet Yearly Deliveries Lot Size
Breakdown Type: Program: BOLT AV Math /Dwg Level: 5
Date: 18-Sep-16 Vol Quoted: 10,000 104 96
Part #: 9675309 Supplier Daily Capacity (SDC): 43
Breakdown Level: Part Name: ELECTRIC BRAKE BOOSTER ASM @ hrs/day: 24
Supplier Name: Rosie Automotive International @ days/week: 5
AP/EWO# Mgf. Location: SHANGHAI, CHINA Quoted Currency: USD
(If applicable) Mfg Duns #: 888999777 Avg Year of Project 2022 Labor
Contact Name: Jean Vander Pyl PPAP Date:
Contact Email: [email protected]
Raw Material & Purchased Components: (labor Included)
(1) (2) (3) (4) (5) (6) (7a) (8) (9) (7b)
Item Description M/D/P
Prestes, Gustavo: M = Raw Material to Manufacturing D = Direct Sourced Purchased part P = Purchased Component 		QUANTITY OF PCS Unit of measure Mass Unit Cost Material Total Supplier Country of Mfg Handling Cost
COVER M 1 Kilograms 0.105 2.8660 2.8660
HOUSING M 1 Kilograms 0.274 2.8660 2.8660
AV HARDWARE COMPONENT 1 M 1 Kilograms 0.187 8.6000 8.6000
AV HARDWARE COMPONENT 2 M 1 Kilograms 0.155 5.2000 5.2000
CONNECTION LINES P 2 Kilograms 0.321 2.2500 4.5000
FASTENER CLIPS P 2 Kilograms 0.11 0.1500 0.3000
SCREW (COVER/HOUSING) P 2 Kilograms 0.15 0.0800 0.1600
Seconds Cavities
40 1
45 2
48 3
(10) MFG TOTALS 19.5320
Marilyn Woolery: If =M (mfg) then sum here 		50 4
(11) PURCHASED TOTALS 4.9600
Marilyn Woolery: If =P (mfg) then sum here 		52 8
24.491960
Marilyn Woolery: PER ASSEMBLY
Prestes, Gustavo: M = Raw Material to Manufacturing D = Direct Sourced Purchased part P = Purchased Component
Marilyn Woolery: Year 2 		55
60
(39) Remarks:
VZNKRP: Include Lump Sum ED&D 		Total Manufacturing Cost (Material + Labor): (26) 24.49196
Scrap 0.7% 0.17144
Fixed Handling Material 4.9% 1.20011
Variable Plant Overhead 10.0% 2.46634
Standard Cost 28.32985
Variable SGA 10.00% (27) 2.83299
Non-amoritized Costs (Items not included in Piece Price) Profit: 6.0% (28) 1.86977
Tooling $ 500,000 Non Manufactured Costs (29)
Software Development $ - 0 Software License Fee (31) 40.00000
Sub Total - Selling Price (Mfg. Parts) (33) 73.03261
Supplier's Supply Chain Costs
Marilyn Woolery: Includes freight, insurance,warehousing, import/export and custom duties and taxes covered by GM)
Marilyn Woolery: Year 3
Marilyn Woolery: Year 4 		(34)
Expendable Dunnage (35) 1.55393
Sequencing Sub-Assembly (36) 0.00000
Other (EDD)
Prestes, Gustavo: Each project has a specific cost
Marilyn Woolery: Year 5
VZNKRP: Include Lump Sum ED&D 		(37) 10.19000
Other (Identify Here) (37)
FINAL SALES PRICE (38) $ 84.777
(40) PRODUCTIVITY %: best price up front
(41) PRODUCTIVITY EFF. DATE

Elroy - AV Quote

NOTE: You must select the material designation in order for all the formulas to work correctly
Supplier Cost Engineering
QUOTE Piece Cost Breakdown Worksheet Yearly Deliveries Lot Size
Breakdown Type: Program: BOLT AV Math /Dwg Level: 5
Date: 18-Sep-16 Vol Quoted: 10,000 104 96
Part #: 9675309 Supplier Daily Capacity (SDC): 43
Breakdown Level: Part Name: ELECTRIC BRAKE BOOSTER ASM @ hrs/day: 24
Supplier Name: Elroy International @ days/week: 5
AP/EWO# Mgf. Location: Silao, Mexico Quoted Currency: USD
(If applicable) Mfg Duns #: 444555888 Avg Year of Project 2022 Labor
Contact Name: Daws Butler PPAP Date:
Contact Email: [email protected]
Raw Material & Purchased Components: (labor Included)
(1) (2) (3) (4) (5) (6) (7a) (8) (9) (7b)
Item Description M/D/P
Prestes, Gustavo: M = Raw Material to Manufacturing D = Direct Sourced Purchased part P = Purchased Component 		QUANTITY OF PCS Unit of measure Mass Unit Cost Material Total Supplier Country of Mfg Handling Cost
COVER M 1 Kilograms 0.105 3.1020 3.1020
HOUSING M 1 Kilograms 0.274 3.2480 3.2480
AV HARDWARE COMPONENT 1 P 1 Kilograms 0.187 7.8000 7.8000
AV HARDWARE COMPONENT 2 P 1 Kilograms 0.155 5.6000 5.6000
AV HARDWARE COMPONENT 3 P 1 Kilograms 1.842 6.8000 6.8000
CONNECTION LINES P 2 Kilograms 0.321 2.3500 4.7000
FASTENER CLIPS P 2 Kilograms 0.11 0.1600 0.3200
SCREW (COVER/HOUSING) P 2 Kilograms 0.15 0.0800 0.1600
Seconds Cavities
40 1
45 2
48 3
(10) MFG TOTALS 6.3500
Marilyn Woolery: If =M (mfg) then sum here 		50 4
(11) PURCHASED TOTALS 25.3800
Marilyn Woolery: If =P (mfg) then sum here 		52 8
31.730000
Marilyn Woolery: Year 1
Prestes, Gustavo: M = Raw Material to Manufacturing D = Direct Sourced Purchased part P = Purchased Component
Marilyn Woolery: Year 2 		55
60
(39) Remarks:
VZNKRP: Include Lump Sum ED&D 		Total Manufacturing Cost (Material + Labor): (26) 31.73000
Scrap 0.7% 0.22211
Fixed Handling Material 4.9% 1.55477
Variable Plant Overhead 10.0% 3.19521
Standard Cost 36.70209
Variable SGA 10.00% (27) 3.67021
Non-amoritized Costs (Items not included in Piece Price) Profit: 6.0% (28) 2.42234
Tooling $ 350,000 Non Manufactured Costs (29)
Software Development $ 2,600,000 Software License Fee (31) 0.00000
Sub Total - Selling Price (Mfg. Parts) (33) 42.79464
Supplier's Supply Chain Costs
Marilyn Woolery: Includes freight, insurance,warehousing, import/export and custom duties and taxes covered by GM)
Marilyn Woolery: Year 3
Marilyn Woolery: Year 4 		(34)
Expendable Dunnage (35) 2.80593
Sequencing Sub-Assembly (36) 0.00000
Other (EDD)
Prestes, Gustavo: Each project has a specific cost
VZNKRP: Include Lump Sum ED&D
Marilyn Woolery: Year 5 		(37) 10.19000
Other (Identify Here) (37)
FINAL SALES PRICE (38) $ 55.791
(40) PRODUCTIVITY %: best price up front
(41) PRODUCTIVITY EFF. DATE

R.U.D.I. - AV Quote

NOTE: You must select the material designation in order for all the formulas to work correctly
Supplier Cost Engineering
QUOTE Piece Cost Breakdown Worksheet Yearly Deliveries Lot Size
Breakdown Type: Program: BOLT AV Math /Dwg Level: 5
Date: 18-Sep-16 Vol Quoted: 10,000 104 96
Part #: 9675309 Supplier Daily Capacity (SDC): 43
Breakdown Level: Part Name: ELECTRIC BRAKE BOOSTER ASM @ hrs/day: 24
Supplier Name: R.U.D.I. Braking Systems @ days/week: 5
AP/EWO# Mgf. Location: San Jose, CA Quoted Currency: USD
(If applicable) Mfg Duns #: 222555456 Avg Year of Project 2022 Labor
Contact Name: Don Messick PPAP Date:
Contact Email: [email protected]
Raw Material & Purchased Components: (labor Included)
(1) (2) (3) (4) (5) (6) (7a) (8) (9) (7b)
Item Description M/D/P
Prestes, Gustavo: M = Raw Material to Manufacturing D = Direct Sourced Purchased part P = Purchased Component 		QUANTITY OF PCS Unit of measure Mass Unit Cost Material Total Supplier Country of Mfg Handling Cost
COVER M 1 Kilograms 0.129 3.5000 3.5000
HOUSING M 1 Kilograms 0.299 3.7500 3.7500
AV HARDWARE COMPONENT 1 M 1 Kilograms 0.187 8.0000 8.0000
AV HARDWARE COMPONENT 2 M 1 Kilograms 0.155 5.7500 5.7500
AV HARDWARE COMPONENT 3 P 1 Kilograms 1.842 5.3000 5.3000
CONNECTION LINES P 2 Kilograms 0.321 4.2000 8.4000
FASTENER CLIPS P 2 Kilograms 0.11 0.3200 0.6400
SCREW (COVER/HOUSING) P 2 Kilograms 0.15 0.2000 0.4000
Seconds Cavities
40 1
45 2
48 3
(10) MFG TOTALS 21.0000
Marilyn Woolery: If =M (mfg) then sum here 		50 4
(11) PURCHASED TOTALS 14.7400
Marilyn Woolery: If =P (mfg) then sum here 		52 8
35.740000
Marilyn Woolery: Year 1
Prestes, Gustavo: M = Raw Material to Manufacturing D = Direct Sourced Purchased part P = Purchased Component
Marilyn Woolery: Year 2 		55
60
(39) Remarks:
VZNKRP: Include Lump Sum ED&D 		Total Manufacturing Cost (Material + Labor): (26) 35.74000
Scrap 0.7% 0.25018
Fixed Handling Material 4.9% 1.75126
Variable Plant Overhead 10.0% 3.59902
Standard Cost 41.34046
Variable SGA 10.00% (27) 4.13405
Non-amoritized Costs (Items not included in Piece Price) Profit: 6.0% (28) 2.72847
Tooling $ 800,000 Non Manufactured Costs (29)
Software Development $ - 0 Software License Fee (31) 50.00000
Sub Total - Selling Price (Mfg. Parts) (33) 98.20297
Supplier's Supply Chain Costs
Marilyn Woolery: Includes freight, insurance,warehousing, import/export and custom duties and taxes covered by GM)
Marilyn Woolery: Year 3
Marilyn Woolery: Year 4 		(34)
Expendable Dunnage (35) 2.80593
Sequencing Sub-Assembly (36) 0.00000
Other (EDD)
Prestes, Gustavo: Each project has a specific cost
VZNKRP: Include Lump Sum ED&D
Marilyn Woolery: Year 5 		(37) 10.19000
Other (Identify Here) (37)
FINAL SALES PRICE (38) $ 111.199
(40) PRODUCTIVITY %: best price up front
(41) PRODUCTIVITY EFF. DATE

Orbitty - AV Quote

NOTE: You must select the material designation in order for all the formulas to work correctly
Supplier Cost Engineering
QUOTE Piece Cost Breakdown Worksheet Yearly Deliveries Lot Size
Breakdown Type: Program: BOLT AV Math /Dwg Level: 5
Date: 18-Sep-16 Vol Quoted: 10,000 104 96
Part #: 9675309 Supplier Daily Capacity (SDC): 43
Breakdown Level: Part Name: ELECTRIC BRAKE BOOSTER ASM @ hrs/day: 24
Supplier Name: Orbitty International Manufacturing & Technology Co. @ days/week: 5
AP/EWO# Mgf. Location: Germany Quoted Currency: USD
(If applicable) Mfg Duns #: 111222333 Avg Year of Project 2022 Labor
Contact Name: Frank Welker PPAP Date:
Contact Email: [email protected]
Raw Material & Purchased Components: (labor Included)
(1) (2) (3) (4) (5) (6) (7a) (8) (9) (7b)
Item Description M/D/P
Prestes, Gustavo: M = Raw Material to Manufacturing D = Direct Sourced Purchased part P = Purchased Component 		QUANTITY OF PCS Unit of measure Mass Unit Cost Material Total Supplier Country of Mfg Handling Cost
COVER M 1 Kilograms 0.105 3.1020 3.1020
HOUSING M 1 Kilograms 0.274 3.2480 3.2480
AV HARDWARE COMPONENT 1 M 1 Kilograms 0.187 7.6000 7.6000
AV HARDWARE COMPONENT 2 M 1 Kilograms 0.155 4.9900 4.9900
AV HARDWARE COMPONENT 3 M 1 Kilograms 1.842 5.8000 5.8000
CONNECTION LINES P 2 Kilograms 0.321 2.3500 4.7000
FASTENER CLIPS P 2 Kilograms 0.11 0.1600 0.3200
SCREW (COVER/HOUSING) P 2 Kilograms 0.15 0.0800 0.1600
Seconds Cavities
40 1
45 2
48 3
(10) MFG TOTALS 24.7400
Marilyn Woolery: If =M (mfg) then sum here 		50 4
(11) PURCHASED TOTALS 5.1800
Marilyn Woolery: If =P (mfg) then sum here 		52 8
29.920000
Marilyn Woolery: Year 1
Prestes, Gustavo: M = Raw Material to Manufacturing D = Direct Sourced Purchased part P = Purchased Component
Marilyn Woolery: Year 2 		55
60
(39) Remarks:
VZNKRP: Include Lump Sum ED&D 		Total Manufacturing Cost (Material + Labor): (26) 29.92000
Scrap 0.7% 0.20944
Fixed Handling Material 4.9% 1.46608
Variable Plant Overhead 10.0% 3.01294
Standard Cost 34.60846
Variable SGA 10.00% (27) 3.46085
Non-amoritized Costs (Items not included in Piece Price) Profit: 6.0% (28) 2.28416
Tooling $ 150,000 Non Manufactured Costs (29)
Software Development $ 6,000,000 Software License Fee (31) 0.00000
Sub Total - Selling Price (Mfg. Parts) (33) 40.35347
Supplier's Supply Chain Costs
Marilyn Woolery: Includes freight, insurance,warehousing, import/export and custom duties and taxes covered by GM)
Marilyn Woolery: Year 3
Marilyn Woolery: Year 4 		(34)
Expendable Dunnage (35) 2.80593
Sequencing Sub-Assembly (36) 0.00000
Other (EDD)
Prestes, Gustavo: Each project has a specific cost
VZNKRP: Include Lump Sum ED&D
Marilyn Woolery: Year 5 		(37) 10.19000
Other (Identify Here) (37)
FINAL SALES PRICE (38) $ 53.349
(40) PRODUCTIVITY %: best price up front
(41) PRODUCTIVITY EFF. DATE

Packaging EV

Part Info RAI-China Elroy-MX R.U.D.I.-US OIMT-DE Empty Pallet Info
Total Asm Mass (kg) 1.7 1.9 1.9 1.9 Length (inches) 54
Length (inches) 5 10 10 10 Width (inches) 48
Width (inches) 4 4 4 4 height (inches) 4
height (inches) 1.75 1.75 1.75 1.75 Weight (kg) 5
Std Pk 9 8 8 8 Cost $10.00
Pack Weight (lbs) 36.5 35.4 36.3 35.4
Packaging supplies Weight/Pallet (kg) Cost/Pallet
Empty Container Info banding/pallet (est.) 0.1 $ 2.00
Length (inches) 18 22 22 22 Clips/pallet 0.1 $ 0.08
Width (inches) 16 18 18 18
height (inches) 3 3 3 3 Padded anti-static box with removable lid
Weight (kg) 1 1 1 1
Cost $ 11.00 $ 12.00 $ 12.00 $ 12.00
Load Configuration
Boxes/Layer 9 6 6 6
Standard Shipment (layers) 8 14 14 14
Packaging cost per piece $ 1.24 $ 1.52 $ 1.52 $ 1.52

Packaging AV

Part Info RAI-China Elroy-MX R.U.D.I.-US OIMT-DE Empty Pallet Info
Total Asm Mass (kg) 1.9 3.7 3.8 3.7 Length (inches) 54
Length (inches) 10 15 15 15 Width (inches) 48
Width (inches) 4 4 4 4 height (inches) 4
height (inches) 1.75 1.75 1.75 1.75 Weight (kg) 5
Std Pk 8 4 4 4 Cost $10.00
Pack Weight (lbs) 35.4 35.1 35.5 35.1
Packaging supplies Weight/Pallet (kg) Cost/Pallet
Empty Container Info banding/pallet (est.) 0.1 $ 2.00
Length (inches) 22 18 18 18 Clips/pallet 0.1 $ 0.08
Width (inches) 18 16 16 16
height (inches) 3 3 3 3 Padded anti-static box with removable lid
Weight (kg) 1 1 1 1
Cost $ 12.00 $ 11.00 $ 11.00 $ 11.00
Load Configuration
Boxes/Layer 7 9 9 9
Standard Shipment (layers) 4 6 6 6
Packaging cost per piece $ 1.55 $ 2.81 $ 2.81 $ 2.81

image1.png