QUESTION FIVE The weekly demand for hand sanitizer at a local pharmacy is assumed to follow a probability distribution as given below. Demand (units) 0 1 2 3 4 5 Probability 0.14 0.16 0.20 0.15 0.25 0.10 I The cost of ordering the sanitizer from a supplier is RM40 per order. The holding cost RM2 per unit per week. Whenever stock-out occurs, the pharmacy will incur a loss of RM10 per unit. This pharmacy policy is to order 9 units whenever its inventory reached 5 units or less at the end of the week. Current Inventory is 7 units. The lead time for an order is given in the following table: Lead time (weeks) Probability 0.4 2 0.5 0.1 1 3 Using the following random numbers and the incomplete) simulation table, simulate the Inventory system for 12 weeks. Demand : 37.97, 09, 42, 50, 81, 33, 00, 16, 77, 61, 10 Lead time: 39, 66, 22, 97 ti th Week Simulation Table for Inventory System Beginning Demand Ending Order Costs (RM) Inventory RN Units Inventory (Y/N) RN Ordering Holding Stock-out Total 37 2 6 Y 1 40 10 O 50 ac q4 - 1 2 Complete the simulation table, and hence determine the following for the 12-weeks period This pharmacy policy is to order 9 units whenever its inventory reached 5 units or less at the end of the week. Current inventory is 7 units. The lead time for an order is given in the following table: Lead time (weeks) Probability 0.4 2 3 0.1 1 0.5 Using the following random numbers and the incomplete) simulation table, simulate the inventory system for 12 weeks. Demand : 37, 97, 09, 42, 50, 81, 33, 00, 16, 77, 61, 10 Lead time: 39, 66, 22, 97 Week Simulation Table for Inventory System Beginning Demand Ending Order Costs (RM) Inventory RN Units Inventory (Y/N) RN LOrdering Holding Stock-out Total 7 37 2 5 Y 39 1 40 10 0 50 1 2 Complete the simulation table, and hence determine the following for the 12-weeks period. (a) Total demand. (3 marks) (b) Total ordering cost. (3 marks) (c) Total holding cost. (3 marks) (d) Average number of orders, (3 marks) (e) Weekly average of total cost. (3 marks) ti