Question

In: Operations Management

A discount appliance store sells iPhones. The store purchases iPhones at a price of $95 per...

A discount appliance store sells iPhones. The store purchases iPhones at a price of $95 per unit. The following information applies to this product.

  • Demand = 20 units/day
  • Order cost = $56/order
  • Annual holding cost = 25% of purchase price
  • Desired cycle-service level = 90%
  • Lead time = 10 days
  • Standard deviation of daily demand = 4 units
  • Current on-hand inventory 220 units, with no open orders or back orders

The store operates 52 weeks per year, 6 days per week. It has a continuous inventory review system.

  1. What is the annual cost saved by shifting from the 500-unit lot size to the EOQ?

Suppose that the discount appliance store uses a P system instead of a Q system. They order inventory every 12 days.

  1. What should T be?
  2. How much more safety stock (than with a Q system) is needed?
  3. It is time for the periodic review. How much should be ordered?

Solutions

Expert Solution

a.

Unit Cost P = 95

Daily Demand d = 20 units

Annual Demand D = 20*52*6 = 6240

Ordering cost S = 56

Holding cost H = 25%*95 = 23.75

SD of daily demand = 4 units

Service Level = 90%

Z = 1.28

Lead Time L = 10 days

On hand Inventroy = 220 units

EOQ = (2DS/H)^(1/2)

EOQ = (2*6240*56/23.75)^(1/2)

EOQ = 171.54

EOQ = 172 units

Total Cost at Q = (D/Q)*S + (Q/2)*H + P*D

Total Cost (Q=172) = (6240/172)*56 + (172/2)*23.75 + 6240*95 = 596874.13

Total Cost (Q=500) = (6240/500)*56 + (500/2)*23.75 + 6240*95 = 599436.38

Saving in Cost = 599436.38 - 596874.13 = 2562.25

_____________________________________________________________________________

Review Period = 12 days

T = d*(L + Review Period) + Z*SD of daily demand*(L+Review Period)^(1/2)

T = 20* (10+12) + 1.28*4*(10+12)^(1/2)

T = 464.01 units

T = 464 units

b.

Safety Stock with Q System = Z*SD of daily demand*(L+Review Period)^(1/2)

SSq = 1.28*4*10^(1/2)

SSq = 16.19 = 16 units

Safety Stock with P System = Z*SD of daily demand*(L+Review Period)^(1/2)

SSp = 1.28*4*(10+12)^(1/2)

SSp = 24.01

SSp = 24 units

Increase in Safety Stock = 24 - 16 = 8 units

c.

Order Quantity Q = T - On Hand Inventory

Q = 464 - 220

Q = 244 units


Related Solutions

A discount appliance store sells iPhones. The store purchases iPhones at a price of $95 per...
A discount appliance store sells iPhones. The store purchases iPhones at a price of $95 per unit. The following information applies to this product. Demand = 20 units/day Order cost = $56/order Annual holding cost = 25% of purchase price Desired cycle-service level = 90% (z=1.28) Lead time = 10 days Standard deviation of daily demand = 4 units Current on-hand inventory 220 units, with no open orders or back orders The store operates 52 weeks per year, 6 days...
Appliance for Less is a local appliance store. It costs this store $23.44 per unit annually...
Appliance for Less is a local appliance store. It costs this store $23.44 per unit annually for storage, insurance, etc., to hold microwave in their inventory. Sales this year are anticipated to be 266 units. Each order costs $68. The company is using Economic Order Quantity model in placing the orders. It takes approximately 2 day(s) to receive an order after it has been placed. If the store insists on a 6 day(s) safety stock (assume 365-days a year), what...
​The Discount Appliance Store uses a continuous review system (Q system).
The Discount Appliance Store uses a continuous review system (Q system).One of the company's items has the following characteristics:- Demand =10 units/week (assume 52 weeks per year)- Ordering or Setup Cost (S)=$ 45) order- Holding cost (H)=$12 unit/year- Lead Time (L)=3 weeks (constant)- Standard Deviation in Weekly Demand = 8 units- Cycle-Service Level =70%What is the EOQ for this item?What is the desired safety stock?What is the desired reorder point R?What is the total annual cost?Suppose that the current policy...
In the market for Iphones the equilibrium price for Iphones is $400, and the quantity of...
In the market for Iphones the equilibrium price for Iphones is $400, and the quantity of Iphones sold is 20,000. (f) The Processor used to make Iphones becomes considerably cheaper and innovation raises the incomes of the population. Show the relevant shifts in your diagram (g) Suppose the government implements a price ceiling of $300. What happens to the market? (h) Suppose the government implements a price ceiling of $500. What happens to the market? (i) Suppose the government implements...
Assume the demand for Apple iphones is very elastic. If Appleraises the price on iPhones...
Assume the demand for Apple iphones is very elastic. If Apple raises the price on iPhones from $900 to $1,100, will the total revenue increase or decrease for Apple? Explain why.
Which of the following would increase supply for iPhones? Technology for producing iPhones improves Price of...
Which of the following would increase supply for iPhones? Technology for producing iPhones improves Price of data plans decreases Income of possible customers increases Price of Android phones increases
A chain of appliance stores, APP Corporation, purchases inventory with a net price of $600,000 each...
A chain of appliance stores, APP Corporation, purchases inventory with a net price of $600,000 each day. The company purchases the inventory under the credit terms of 1/15, net 30. APP always takes the discount, but takes the full 15 days to pay its bills. What is the average accounts payable for APP? Round your answer to the nearest dollar.
A chain of appliance stores, APP Corporation, purchases inventory with a net price of $450,000 each...
A chain of appliance stores, APP Corporation, purchases inventory with a net price of $450,000 each day. The company purchases the inventory under the credit terms of 2/15, net 30. APP always takes the discount, but takes the full 15 days to pay its bills. What is the average accounts payable for APP?
Accounts Payable A chain of appliance stores, APP Corporation, purchases inventory with a net price of...
Accounts Payable A chain of appliance stores, APP Corporation, purchases inventory with a net price of $250,000 each day. The company purchases the inventory under the credit terms of 1/15, net 30. APP always takes the discount, but takes the full 15 days to pay its bills. What is the average accounts payable for APP? Round your answer to the nearest dollar.
1.) A chain of appliance stores, APP Corporation, purchases inventory with a net price of $450,000...
1.) A chain of appliance stores, APP Corporation, purchases inventory with a net price of $450,000 each day. The company purchases the inventory under the credit terms of 1/15, net 40. APP always takes the discount but takes the full 15 days to pay its bills. What is the average accounts payable for APP? Round your answer to the nearest dollar. 2.) Snider Industries sells on terms of 2/10, net 35. Total sales for the year are $600,000. Thirty percent...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT