Question

In: Operations Management

The So's Hobby Shop carries a line of radio-controlled model racing cars. Average daily demand for...

The So's Hobby Shop carries a line of radio-controlled model racing cars. Average daily demand for the model cars is 100 with a standard deviation of 30. Unit inventory holding cost is estimated at $0.90/year. The shop purchases the model cars from one supplier. It is estimated that the ordering cost is $100 per order. The delivery lead time is 10 working days. Mr. So decides to use a Reorder Point System to control the inventory of the model cars and wants to achieve a service level of 90%. Assume 300 working days per year.

  1. (3 points) Determine the optimal reorder point R and order quantity EOQ. (Hint: R = average demand during lead time + safety stock)
  1. (3 points) Using the R and Q determined in part a), what is the average inventory in the shop? (Hint: average inventory = EOQ/2 + safety stock)
  1. (4 points) Mr. So is considering a new supplier who can deliver the same line of model cars with a perfectly reliable lead time of only 3 working days. Estimate the potential annual savings in inventory holding cost by switching to this new supplier. (Hint: the saving = holding cost * reduction of average inventory)

Solutions

Expert Solution

a)

Daily Demand µD = 100
Standard Deviation of Daily Demand σD = 30
Working days per year n = 300
Annual Demand D = n*µD 30,000
Lead Time (Days) L = 10
Desired Service level α = 90%
Z-value corresponding to Service Level Zα = NORMSINV(α) 1.28
Safety stock ss = ZασD √L 121
Reorder Point R = µD*L + ss 1,121
Annual Holding Cost per Unit H = $0.90
Ordering Cost per Order S = $100
Optimal Order Qty Q* = √(2SD/H) 2,582

Optimal reorder point, R = 1121

EOQ = 2582

-------------------------------------------------------------------------------------------------------

b)

Average inventory = EOQ/2 + Safety stock

= 2582/2 + 121

= 1412

-------------------------------------------------------------------------------------------------------

c)

New lead time, L = 3 days

Revised safety stock = 1.28*30*sqrt(3)

= 67

EOQ remains unchanged.

New average inventory = 2582/2+67

= 1358

Reduction in average inventory = 1412 - 1358

= 54

Savings = 54*0.9

= $ 48.6

keosha answered 1 year ago
Next > < Previous

Related Solutions

The A&M Hobby Shop carries a line of radio-controlled model racing cars. Demand for the cars...
The A&M Hobby Shop carries a line of radio-controlled model racing cars. Demand for the cars is assumed to be constant at a rate of 40 cars per month. The cars cost $60 each, and ordering costs are approximately $15 per order, regardless of the order size. The annual holding cost rate is 20%. Determine the economic order quantity and total annual cost under the assumption that no backorders are permitted. If required, round your answers to two decimal places....
The A&M Hobby Shop carries a line of radio-controlled model racing cars. Demand for the cars...
The A&M Hobby Shop carries a line of radio-controlled model racing cars. Demand for the cars is assumed to be constant at a rate of 27 cars per month. The cars cost $69 each, and ordering costs are approximately $11 per order, regardless of the order size. The annual holding cost rate is 21%. (a) Determine the economic order quantity and total annual cost under the assumption that no backorders are permitted. If required, round your answers to two decimal...
The A&M Hobby Shop carries a line of radio-controlled model racing cars. Demand for the cars...
The A&M Hobby Shop carries a line of radio-controlled model racing cars. Demand for the cars is assumed to be constant at a rate of 25 cars per month. The cars cost $70 each, and ordering costs are approximately $10 per order, regardless of the order size. The annual holding cost rate is 23%. ROUND ANSWERS TO TWO DECIMAL PLACES Determine the economic order quantity and total annual cost under the assumption that no backorders are permitted. If required, round...
The A&M Hobby Shop carries a line of radio-controlled model racing cars. Demand for the cars...
The A&M Hobby Shop carries a line of radio-controlled model racing cars. Demand for the cars is assumed to be constant at a rate of 40 cars per month. The cars cost $60 each, and ordering costs are approximately $15 per order, regardless of the order size. The annual holding cost rate is 20%. Determine the economic order quantity and total annual cost under the assumption that no backorders are permitted. If required, round your answers to two decimal places....
The A&M Hobby Shop carries a line of radio-controlled model racing cars. Demand for the cars...
The A&M Hobby Shop carries a line of radio-controlled model racing cars. Demand for the cars is assumed to be constant at a rate of 50 cars per month. The cars cost $80 each, and ordering costs are approximately $15 per order, regardless of the order size. The annual holding cost rate is 20%. (a) Determine the economic order quantity and total annual cost (in $) under the assumption that no backorders are permitted. (Round your answers to two decimal...
The A&M Hobby Shop carries a line of radio-controlled model racing cars. Demand for the cars...
The A&M Hobby Shop carries a line of radio-controlled model racing cars. Demand for the cars is assumed to be constant at a rate of 30 cars per month. The cars cost $51 each, and ordering costs are approximately $12 per order, regardless of the order size. The annual holding cost rate is 19%. Determine the economic order quantity and total annual cost under the assumption that no backorders are permitted. If required, round your answers to two decimal places....
A radio controlled model boat is placed in a lake at the point O with initial...
A radio controlled model boat is placed in a lake at the point O with initial velocity 0.6j ms^-1 and its velocity after 15 seconds was measured as (10.5i -0.9j) ms^-1. The acceleration of the boat is modelled as being constant. Find an expression for the position of the boat at time t. For what value of t was the boat north-East of O. For what value of t was the boat travelling in the direction north-east? The boat lost...
Munoz, Inc., produces a special line of plastic toy racing cars.​ Munoz, Inc., produces the cars...
Munoz, Inc., produces a special line of plastic toy racing cars.​ Munoz, Inc., produces the cars in batches. To manufacture a batch of the​ cars, Munoz,​ Inc., must set up the machines and molds. Setup costs are​ batch-level costs because they are associated with batches rather than individual units of products. A separate Setup Department is responsible for setting up machines and molds for different styles of car. Setup overhead costs consist of some costs that are variable and some...
i.Demand Range Model The average daily demand for a particular item is 438 with a standard...
i.Demand Range Model The average daily demand for a particular item is 438 with a standard deviation of 24. The current policy is to order enough items for 25 days. What is the likely range for that 25-day demand? Determine the range with a calculation (mean +/- 3 stdev) Determine the range with a simulation.
17. An appliance store carries a specialty model of microwave ovens. The demand for the microwave...
17. An appliance store carries a specialty model of microwave ovens. The demand for the microwave oven is relatively constant at 2500 units per year. Placing an order costs the store $500 regardless the quantity ordered. Carrying one unit over a one year period costs the store $50. The store opens 300 days per year and the lead time for this item is 12 working days. Because of the special features of the microwave oven, customers may buy it whether...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT