Question

Problem 11-23 (Static) Gentle Ben's Bar and Restaurant uses 5,000 quart bottles of an imported wine each year. The effervescent wine costs $3 per bottle and Is served only in whole bottles because it loses its bubbles quickly. Ben figures that it costs $10 each time an order is placed, and holding costs are 20 percent of the purchase price. It takes three weeks for an order to arrive. Weekly demand is 100 bottles (closed two weeks per year) with a standard deviation of 30 bottles. Ben would like to use an inventory system that minimizes inventory cost and will provide a 95 percent service probability. a. What is the economic quantity for Ben to order? (Round your answer to the nearest whole number.) Economic order quantity bottles b. At what inventory level should he place an order? (Use Excel's NORM.S.INV) function to find the z value. Round z value to 2 decimal places and final answer to the nearest whole number.) Inventory level bottles

Answer 1

(a): Economic order quantity = 408 bottles

Calculations: EOQ = [2*D*S/H]^0.5

= [(2*5000*10/(0.2*3)]^0.5

= 408.25. This will be rounded to nearest whole number i.e. 408

(b): Inventory level = 385 bottles

Calculations:

Using the NORM.S.INV function in excel we get z = 1.64

Thus R = 100*3 + 1.64*(3^0.5)*30

= 300 + 85.22

= 385 bottles