Eagle Electric Repair is a repair facility for several major electric appliance manufacturers. Eagle wants to find a low-cost supplier for an electric relay switch used in many appliances. The annual requirements for the relay switch (D) are 100,000 units. Eagle operates 250 days a year. The following data are available for two suppliers, Kramer and Sunrise, for the part: Supplier Freight CostsShipping Quantity (Q ) Price/Unit (p) Carrying Cost/Unit (H ) Lead Time (L) (days) Administrative Costs 2,000 10,000 Kramer $30,000 $20,000 $5.00 $1.00 5 $10,000 Sunrise $28,000 $18,000 $4.90 $0.98 9 $11,000 Which supplier will provide the lowest annual total costs?
Eagle Electric Repair is a repair facility for several major electric appliance manufacturers. Eagle wants to find a low-cost supplier for an electric relay switch used in many appliances. The annual requirements for the relay switch (D) are 100,000 units. Eagle operates 250 days a year. The following data are available for two suppliers, Kramer and Sunrise, for the part: Supplier Freight CostsShipping Quantity (Q ) Price/Unit (p) Carrying Cost/Unit (H ) Lead Time (L) (days) Administrative Costs 2,000 10,000 Kramer $30,000 $20,000 $5.00 $1.00 5 $10,000 Sunrise $28,000 $18,000 $4.90 $0.98 9 $11,000 Which supplier will provide the lowest annual total costs?
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
Eagle Electric Repair is a repair facility for several major electric appliance manufacturers. Eagle wants to find a low-cost supplier for an electric relay switch used in many appliances. The annual requirements for the relay switch (D) are 100,000 units. Eagle operates 250 days a year. The following data are available for two suppliers, Kramer and Sunrise, for the part:
Supplier | Freight Costs Shipping Quantity (Q ) |
Price/Unit (p) | Carrying Cost/Unit (H ) | Lead Time (L) (days) | Administrative Costs | |
2,000 | 10,000 | |||||
Kramer | $30,000 | $20,000 | $5.00 | $1.00 | 5 | $10,000 |
Sunrise | $28,000 | $18,000 | $4.90 | $0.98 | 9 | $11,000 |
Which supplier will provide the lowest annual total costs?
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 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.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.