A major automobile manufacturer located in Georgetown, Kentucky, has two certified vendors that produce brake pads with the information shown below. New Albany Manufacturing is located in Columbus, Ohio, and LaPlaya Manufacturing is located in Monterrey, Mexico. The automobile assembly factory is assumed to operate 250 days per year. Certified Supplier New Albany Mfg. Transport Cost per Unit (Ct) $1.45 LaPlaya Mfg. $1.71 a. Use the Total Supply Chain Cost Excel template to compute the supply chain costs associated with each supplier if the annual demand is 340,000 brake pads. Do not round intermediate calculations. Round your answer to the nearest dollar. 34,000 units Order quantity: Total procurement cost: Total management oversight cost: Total annual transportation cost: $ $ $ Annual order cost: Annual holding cost: Average annual pipeline inventory cost: Total supply chain costs: b. What supplier and order quantity do you recommend based on total costs? Based on total cost, the company should choose -Select- $ $ $ $ $ $ $ $ $ $ $ Order Size (Q) 34,000 68,000 Price per Unit (P) $9.02 $8.26 68,000 units Oversight Cost per Unit (0) $0.00 $0.40 ✓with corresponding order quantity of brake pads.. Order Cost (Co) $145 $210 Cost to Store One Unit One Year (Ch) $1.85 $1.65 Order Lead Time in Days (L) 50 72
A major automobile manufacturer located in Georgetown, Kentucky, has two certified vendors that produce brake pads with the information shown below. New Albany Manufacturing is located in Columbus, Ohio, and LaPlaya Manufacturing is located in Monterrey, Mexico. The automobile assembly factory is assumed to operate 250 days per year. Certified Supplier New Albany Mfg. Transport Cost per Unit (Ct) $1.45 LaPlaya Mfg. $1.71 a. Use the Total Supply Chain Cost Excel template to compute the supply chain costs associated with each supplier if the annual demand is 340,000 brake pads. Do not round intermediate calculations. Round your answer to the nearest dollar. 34,000 units Order quantity: Total procurement cost: Total management oversight cost: Total annual transportation cost: $ $ $ Annual order cost: Annual holding cost: Average annual pipeline inventory cost: Total supply chain costs: b. What supplier and order quantity do you recommend based on total costs? Based on total cost, the company should choose -Select- $ $ $ $ $ $ $ $ $ $ $ Order Size (Q) 34,000 68,000 Price per Unit (P) $9.02 $8.26 68,000 units Oversight Cost per Unit (0) $0.00 $0.40 ✓with corresponding order quantity of brake pads.. Order Cost (Co) $145 $210 Cost to Store One Unit One Year (Ch) $1.85 $1.65 Order Lead Time in Days (L) 50 72
Elementary Geometry For College Students, 7e
7th Edition
ISBN:9781337614085
Author:Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:Alexander, Daniel C.; Koeberlein, Geralyn M.
Chapter1: Line And Angle Relationships
Section1.CR: Review Exercises
Problem 3CR: Name the four characteristics of a good definition.
Related questions
Question
Transcribed Image Text:A major automobile manufacturer located in Georgetown, Kentucky, has two certified vendors that produce brake pads with the information shown below. New Albany Manufacturing is located in Columbus, Ohio, and LaPlaya Manufacturing is located in
Monterrey, Mexico. The automobile assembly factory is assumed to operate 250 days per year.
Certified
Supplier
New Albany Mfg.
Transport
Cost per
Unit (Ct)
$1.45
LaPlaya Mfg.
$1.71
a. Use the Total Supply Chain Cost Excel template to compute the supply chain costs associated with each supplier if the annual demand is 340,000 brake pads. Do not round intermediate calculations. Round your answer to the nearest dollar.
34,000 units
Order quantity:
Total procurement cost:
Total management oversight cost:
Total annual transportation cost:
$
$
$
Annual order cost:
Annual holding cost:
Average annual pipeline inventory cost:
Total supply chain costs:
b. What supplier and order quantity do you recommend based on total costs?
Based on total cost, the company should choose -Select-
$
$
$
$
$
$
$
$
$
$
$
Order
Size (Q)
34,000
68,000
Price per
Unit (P)
$9.02
$8.26
68,000 units
Oversight
Cost
per Unit (0)
$0.00
$0.40
✓with corresponding order quantity of
brake pads.
Order Cost
(Co)
$145
$210
Cost to Store
One Unit
One Year (Ch)
$1.85
$1.65
Order Lead
Time in
Days (L)
50
72
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
Recommended textbooks for you
Elementary Geometry For College Students, 7e
Geometry
ISBN:
9781337614085
Author:
Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:
Cengage,
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell
Elementary Geometry For College Students, 7e
Geometry
ISBN:
9781337614085
Author:
Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:
Cengage,
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL
Algebra: Structure And Method, Book 1
Algebra
ISBN:
9780395977224
Author:
Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:
McDougal Littell