Question

In: Operations Management

Special Purpose EOQ Model: Price-break model Problem information: Annual Forecast: 12,000 units Order processing cost: $125/order...

Special Purpose EOQ Model: Price-break model

Problem information:

Annual Forecast: 12,000 units

Order processing cost: $125/order

Inventory Carrying rate: 20% per year

Unit Price

Price levels

1 to 999 units/order

$510

1000 to 2999 units/order

$500

3000+ units/order

$490

1. Calculate EOQ at each price-break

2. Determine Q at each price-break

3. Plug the Q value into the total cost annual cost function to determine the total cost for each order quantity

a. TAIC = RC + (R/Q)S + (Q/2)kC

4. What is the optimal order quantity?

5. What is the total annual inventory cost at the optimal order quantity?

Solutions

Expert Solution

Annual inventory cost has 2 components :

  1. Annual ordering cost
  2. Annual inventory holding cost

Let optimal order quantity = Q

Annual demand = D

Cost of placing an order = Co

Annual unit inventory holding cost = Ch

Therefore ,

Annual ordering cost

= Cost of placing an order x Number of orders in a year

= Cost of placing an order x Annual demand / Optimal order quantity

= Co x D/Q

Annual inventory holding cost

= Annual unit inventory holding cost x Average inventory

= Annual unit inventory holding cost x

= Cost of placing an order x Optimal order quantity / 2

= Ch x Q/2

Total annual inventory cost at optimal order quantity

= Annual ordering cost + Annual inventory holding cost

= Co x D/Q + Ch x Q/2

TOTAL ANNUAL INVENTORY COST AT OPTIMAL ORDER QUANTITY = Co x D/Q + Ch x Q/2


Related Solutions

Using the EOQ​ model, if a​ firm's order quantity is 500 units and its annual holding...
Using the EOQ​ model, if a​ firm's order quantity is 500 units and its annual holding cost is greater than its annual setup​ cost, then what can we say about the optimal order​ quantity? A. Optimal order quantity​ = 500 units B. Optimal order quantity​ < 500 units C. Optimal order quantity​ > 500 units D. Not enough information is given to answer the question
the primary purpose of the Economic Order Quantity (EOQ) model is to: A. Maximize the customer...
the primary purpose of the Economic Order Quantity (EOQ) model is to: A. Maximize the customer service level B. Calculate the reorder point, so that replenishment take place at the proper time C. Calculate the optimum safety stock level D. None of these answers
For an EOQ ordering quantity of 750 units, an ordering cost of $5 per order, a...
For an EOQ ordering quantity of 750 units, an ordering cost of $5 per order, a holding cost of $10 per unit per year, and an annual demand of 900 units, what is the annual total cost for this value of Q?
1. Consider the basic EOQ model (no uncertainty). Optimal order quantity (Q ∗) is 1,800 units....
1. Consider the basic EOQ model (no uncertainty). Optimal order quantity (Q ∗) is 1,800 units. What is the average inventory level (I ∗)? a. 900 units b. 1,800 units c. 600 units d. 1,000 units e. 3,600 units 2. Consider the basic EOQ model (no uncertainty). Annual holding cost (AHC) is $2,400. Find annual ordering cost (AOC). a. Cannot be answered because there is missing information b. AOC=$0, since there is no uncertainty c. $1,200, since AOC=AHC/2 at economic...
Set up the Economic Order Quantity model given the information below. Annual Demand 50,000 units Order...
Set up the Economic Order Quantity model given the information below. Annual Demand 50,000 units Order Cost $150 per order Unit Cost $100 per unit Inventory Holding      15% of unit cost What is the Economic Order Quantity of the product? What is the total annual cost when EOQ is ordered each time?
Find the EOQ, the total annual cost associated with the economic order quantity, the reorder point,...
Find the EOQ, the total annual cost associated with the economic order quantity, the reorder point, number of orders per year and the time between orders. Annual Demand 15,600 units Weeks Operating 52 weeks/year Set up Cost $60/order Holding rate 20% Unit cost $80 /unit Lead-Time 5 weeks
"A special-purpose machine is to be purchased at a cost of $18,000. The expected annual operating...
"A special-purpose machine is to be purchased at a cost of $18,000. The expected annual operating and maintenance cost and the salvage (or market) values for each year of the machine's service are as follows. Year of service 1; O&M costs $2200; Market value $14,400 Years of service 2; O&M costs $3300; Market value $11,100 Years of service 3; O&M costs $4000; Market value $5,700 Years of service 4; O&M costs $5500; Market value $3,000 Years of service 5; O&M...
Suppose we have an Economic Order Quantity (EOQ) problem with discounts. A (annual demand)= 10000, k...
Suppose we have an Economic Order Quantity (EOQ) problem with discounts. A (annual demand)= 10000, k (order cost)= 10, c1 (item cost)= 8, h (holding cost)= 0.1 For orders of 2000 or more, the cost is discounted from 8 to 7.3728. What is the optimal TAC (total annual cost, including order and holding, and also including the purchase costs)?
One company operates 300 days per year. The economic order quantity (EOQ) is 250 units. Annual demand is 5000 units.
One company operates 300 days per year. The economic order quantity (EOQ) is 250 units. Annual demand is 5000 units. The expected time between orders will be: 15 days20 days1.2 days16.6 daysNone of the above
1. Create a new Problem 1 worksheet and build up the Economic Order Quantity (EOQ) model...
1. Create a new Problem 1 worksheet and build up the Economic Order Quantity (EOQ) model as discussed in the slides. Use the following values for the model variables: Annual Demand: 105,000 Cost Per Unit: $27.38 Holding Costs: 7.5% Ordering Costs: $273.00 Make sure that your model calculates the Unit Holding Costs, EOQ and Orders to Place per Year. 2. Create a new Problem 2 worksheet and build up the Earned Value Management (EVM) model as discussed in the slides....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT