The Soon Company is a multinational company that purchases one of its crucial components from a supplier who offers quantity discounts to encourage larger order quantities. The supply chain manager of the company wants to determine the optimal order quantity to minimize the total annual inventory cost. The company’s annual demand forecast for the item is 850 units, the order cost is $10 per order, and the annual holding rate is 41 percent. The price schedule for the item is: Order Quantity Price per Unit ($) 1–150 6.00 151–350 5.50 351 and above 5.00 The first break point is 151 units and the second is 351 units. The spreadsheet is below and perform the required analysis Optimal Order Quantity with Quantity Discounts Annual Demand Forecast 850 Order cost per order $10.00 Annual holding rate 41% Order Quantity Price per unit 1 150 $6.00 151 350 $5.50 351 1.00E+99 $5.00 Feasible? EOQ at the highest price point EOQ at the middle price point EOQ at the lowest price point Total Annual TAIC(EOQ) Inventory TAIC(break point 1) Costs TAIC(break point 2) Optimal Order Quantity TAIC, corresponding to OOQ

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter10: Introduction To Simulation Modeling
Section10.4: Simulation With Built-in Excel Tools
Problem 14P
icon
Related questions
icon
Concept explainers
Topic Video
Question

The Soon Company is a multinational company that purchases one of its crucial components from a supplier who offers quantity discounts to encourage larger order quantities. The supply chain manager of the company wants to determine the optimal order quantity to minimize the total annual inventory cost. The company’s annual demand forecast for the item is 850 units, the order cost is $10 per order, and the annual holding rate is 41 percent. The price schedule for the item is:

Order Quantity Price per Unit ($)
1–150 6.00
151–350 5.50
351 and above 5.00

The first break point is 151 units and the second is 351 units. The spreadsheet is below and perform the required analysis 

Optimal Order Quantity with Quantity Discounts      
       
Annual Demand Forecast 850  
Order cost per order $10.00  
Annual holding rate 41%  
       
Order Quantity Price per unit  
1 150 $6.00  
151 350 $5.50  
351 1.00E+99 $5.00  
       
      Feasible?
EOQ at the highest price point    
EOQ at the middle price point    
EOQ at the lowest price point    
       
Total Annual    TAIC(EOQ)
Inventory   TAIC(break point 1)
Costs   TAIC(break point 2)
       
Optimal Order Quantity    
TAIC, corresponding to OOQ      
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Inventory management
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,