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 42 gallons of Orange Paint every week (for 52 weeks per year, Standard Deviation of the Demand 5 gallons) They purchase Orange Paint from their supplier at a price of $2 50 per gallon It takes 1 50 weeks to receive an order from the supplier Administrative costs for Ordering paint have been estimated to be $20 per order Holding Costs 25 of the purchase price per gallon per year How much Safety Stock should the company hold to have Service Level of a 85 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 90 00 1 282 SS Safety Stock Z OL 85 00 1 036 80 00 0 842 Odl Loa (Assuming Lead Time is constant as in Periodic review) 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 ( ) s H(SS) Time Between Economic Order Quantity, EOQ Orders TBO 60 A 218 gallons of paint B 6 gallons of paint C 66 gallons of paint D 10 gallons of paint E 34 gallons of paint

The Answer is in the image, click to view ...

Question: 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

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 42 gallons of Orange Paint every week (for 52 weeks per year, Standard Deviation of the Demand = 5 gallons). They purchase Orange Paint from their supplier at a price of $2.50 per gallon. It takes 1.50 weeks to receive an order from the supplier. Administrative costs for Ordering paint have been estimated to be $20 per order. Holding Costs = 25% of the purchase price per gallon per year.

How much Safety Stock should the company hold to have Service Level of a 85.0%? Using a computerized Inventory Management System,

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 90.00% 1.282 SS = Safety Stock = Z OL 85.00% 1.036 80.00% 0.842 Odl= Loa (Assuming Lead Time is constant as in Periodic review) 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 = (%) + s + H(SS) Time Between Economic Order Quantity, EOQ - Orders = TBO = 60 A. 218 gallons of paint B.6 gallons of paint C.66 gallons of paint D. 10 gallons of paint E. 34 gallons of paint