Northcutt manufactures high-end racing bikes and is looking for a source of gear sprocket sets. Northcutt would need 1,550 sets a month. Supplier A is a domestic firm, and Suppliers B and C are located overseas. Cost information for the suppliers is as follows: Supplier A-Price of $100 per set, plus packing cost of $2 per set. Total inland freight costs for all 1,550 units would be $800 per month. Supplier B-Price of $96 per set, plus packing cost of $3.50 per set. International transportation costs would total $3,500 per month, while total inland freight costs would be $800 per month. Supplier C-Price of $93 per set, plus packing cost of $3.00 per set. International transportation costs would total $5,000 per month, while total inland freight costs would be $1,000 per month. a. (**) Calculate total landed costs per unit and per month for the three potential suppliers. Who is the cheapest? Who is the most expensive? b. (***) Suppose that international and inland freight costs are fixed for volumes up to 4,000 units a month. Under this assumption, which supplier would have the lowest landed cost if demand were cut in half? If demand doubled? Whose landed cost is most sensitive to volume changes? c. (**) What factors other than landed costs might Northcutt consider when selecting the supplier? (Hint: Incorporate what you learned in Chapters 50 and 70.
Northcutt manufactures high-end racing bikes and is looking for a source of gear sprocket sets. Northcutt would need 1,550 sets a month. Supplier A is a domestic firm, and Suppliers B and C are located overseas. Cost information for the suppliers is as follows: Supplier A-Price of $100 per set, plus packing cost of $2 per set. Total inland freight costs for all 1,550 units would be $800 per month. Supplier B-Price of $96 per set, plus packing cost of $3.50 per set. International transportation costs would total $3,500 per month, while total inland freight costs would be $800 per month. Supplier C-Price of $93 per set, plus packing cost of $3.00 per set. International transportation costs would total $5,000 per month, while total inland freight costs would be $1,000 per month. a. (**) Calculate total landed costs per unit and per month for the three potential suppliers. Who is the cheapest? Who is the most expensive? b. (***) Suppose that international and inland freight costs are fixed for volumes up to 4,000 units a month. Under this assumption, which supplier would have the lowest landed cost if demand were cut in half? If demand doubled? Whose landed cost is most sensitive to volume changes? c. (**) What factors other than landed costs might Northcutt consider when selecting the supplier? (Hint: Incorporate what you learned in Chapters 50 and 70.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
Related questions
Question
Transcribed Image Text:6. Northcutt manufactures high-end racing bikes and is looking for a source of gear
sprocket sets. Northcutt would need 1,550 sets a month. Supplier A is a domestic firm,
and Suppliers B and C are located overseas. Cost information for the suppliers is as
follows:
Supplier A-Price of $100 per set, plus packing cost of $2 per set. Total inland
freight costs for all 1,550 units would be $800 per month.
▪ Supplier B-Price of $96 per set, plus packing cost of $3.50 per set. International
transportation costs would total $3,500 per month, while total inland freight costs
would be $800 per month.
Supplier C-Price of $93 per set, plus packing cost of $3.00 per set. International
transportation costs would total $5,000 per month, while total inland freight costs
would be $1,000 per month.
a. (**) Calculate total landed costs per unit and per month for the three potential
suppliers. Who is the cheapest? Who is the most expensive?
b. (***) Suppose that international and inland freight costs are fixed for volumes
up to 4,000 units a month. Under this assumption, which supplier would have
the lowest landed cost if demand were cut in half? If demand doubled? Whose
landed cost is most sensitive to volume changes?
c. (**) What factors other than landed costs might Northcutt consider when
selecting the supplier? (Hint: Incorporate what you learned in Chapters 50
and 70.
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 4 steps with 1 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.