Question: Question CumpleLiuiislatus. QUESTION 16 Using a computerized Inventory Management System, a Paint Supply Store franchise continuously monitors the inventory of all the paint located at

Question CumpleLiuiislatus. QUESTION 16 Using a
Question CumpleLiuiislatus. QUESTION 16 Using a
Question CumpleLiuiislatus. QUESTION 16 Using a computerized Inventory Management System, a Paint Supply Store franchise continuously monitors the inventory of all the paint located at each of their 15 stores and their distribution warehouse. The Paint Supply Store franchise sells an average of 74 gallons of Purple Paint every week (for 52 weeks per year, Standard Deviation of the Demand = 8 gallons). They purchase Purple Paint from their supplier at a price of $4.00 per gallon. It takes 2.50 weeks to receive an order from the supplier. Administrative costs for Ordering paint have been estimated to be $35 per order. Holding Costs = 40% of the purchase price per gallon per year. How much Safety Stock should the company hold to have a Service Level of 99.0%? Reorder Point, ROP = dL + SS Service Level z Value 99.99% 3.719 d = Average Demand Rate per Time Period 99.90% 3.090 D = Demand Rate per Year 99.00% 2.326 L = Average Lead time (time periods) 95.00% 1.645 SS = Safety Stock = 2 O AL 90.00% 1.282 85.00% 1.036 Oal = lo 80.00% 0.842 (Assuming Lead Time is constant as in Periodic review) a = Standard Deviation of the demand z = Number of Standard deviations corresponding to a service level Q = Order Quantity Average Inventory Level = Q/2 + SS H = Holding Cost Per Year Per Unit S = Ordering/Setup Cost Per Order Total Annual Inventory Cost: H+ ( s+H(SS) Show Timer Question Completion Status: SS = Safety Stock = z od 85.00% 1.036 80.00% Oal = 10 (Assuming Lead Time is constant as in Periodic review) 0d = Standard Deviation of the demand 2 = Number of Standard deviations corresponding to a service level Q = Order Quantity Average Inventory Level = Q/2 + SS H = Holding Cost Per Year Per Unit S = Ordering/Setup Cost Per Order Total Annual Inventory Cost = (%) h + s + H(SS) Economic Order Quantity, EOQ = 1205 Time Between Orders = TBO = ? A. 395 gallons of paint B. 160 gallons of paint C. 13 gallons of paint D. 29 gallons of paint E. 1377 gallons of paint

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!