Question: can you show how to do this work Question 13 Using a computerized Inventory Management System, a Paint Supply Store franchise continuously monitors the inventory

can you show how to do this work Question 13 can you show how to do this work
Question 13 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 X 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.0M? Reorder Point, ROP = L +SS Service Level Value 99.99% 3.719 dAverage Demand Rate per Time Period 99.90% 3.090 D = Demand Rate per Year 99.00% 2.326 95.00% L-Average Lead time time periods) 1.645 90.00% 1.282 SS = Safety Stock = z dal 85.00% 1.036 80.00% 0.842 dal (Assuming Lead Time is constant as in Periodic review) 0 Standard Deviation of the demand z Number of Standard deviations corresponding to a service level Q = Order Quantity Average Inventory Level=0/2 + SS H = Holding Cost Per Year Per Unit s - Ordering/Setup Cost Per Order Total Annual Inventory Cost = H+ s +H(SS) Time Between 2DS Economic Order Quantity, EOQ = VH EOQ Orders = TBO = Selected Answer: C. 395 gallons of paint Correct Answer: D. 29 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!