Simulate the following inventory replenishment problem for 20 weeks. You will have to use the Excel program to simulate. Demand is uniformly distributed between 20 and 30 units. Inventory Cost per week $1.50 Shortage Cost per week $2.50 Week 1 2 3 4 5 6 7 8 9 Demand Week Demand Lead Time 21 22 30 21 27 28 23 29 21 11 12 13 14 15 16 17 18 19 22 28 28 29 27 26 24 27 23 2222 10 25 20 2 It is given that Beginning Stock on Hand (SOH)| Supply in Week 1 "-" Supply in Week 2 "=" 0 Demand in Week 1 Demand in Week 2 Q1. What is the total inventory cost at the end of 20 weeks if the order size in every week is 28 units? Q2. What is the total shortage cost at the end of 20 weeks if the order size in every week is 28 units? Q3. What is the total cost (inventory + shortage) at the end of 20 weeks if the order size is equal to the demand in every week. Q4. If the order size is equal to the demand in every week, how many units are delivered in week 15?|| Beginning Week Supply Net SOH Demand End SOH SOH Order Quantity Delivery Week 1 0 21 21 21 0 21 3 2 0 22 22 22 0 28 4 3 0 21 21 30 -9 28 5 4 -9 28 19 21 -2 28 6 5 -2 28 26 27 -1 28 7 6 -1 28 27 28 -1 28 8 7 -1 28 27 23 4 28 9 8 4 28 32 29 28 10 9 3 28 31 21 10 28 11 10 10 28 38 25 13 28 12 11 13 28 41 22 19 28 13 12 19 28 47 28 19 28 14 13 19 28 47 28 19 28 15 14 19 28 47 29 18 28 16 15 18 28 46 27 19 28 17 16 19 28 47 26 21 28 17 21 28 49 24 25 28 18 25 28 53 27 26 28 19 26 28 54 23 31 28 20 31 28 59 21 38 28 12222 18 19 20 Total Inventory 265 Total Shortage -13 Total Inv Cost $397.50 Total Sh. Cost $32.50 Total Cost $430.00 Answers $570.00 $5.00 $362.50 28 |Simulate the customer service system in a bank for 20 customers for the data given below. Customer # 1 2 3 4 5 6 7 8 9 10 Customer Arrival Time 7 12 17 21 28 30 37 41 47 52 Customer Service Time 5 5 4 5 5 5 5 5 6 5 Customer # 11 12 13 14 15 16 17 18 19 20 Customer Arrival Time 56 58 65 70 71 78 82 85 92 94 Customer Service Time 7 5 4 4 5 5 5 5 7 5 Q1. Maximum waiting time 12 Q2. Average waiting time per customer 4 Q3. Total idle time of the server 9 Server Arrival Service Start End Customer Time Time Time Time Time Waiting Idle Time 0 1 7 5 7 12 0 7 2 12 5 12 17 0 0 3 17 4 17 21 0 0 4 21 5 21 26 0 0 5 28 5 28 33 0 2 6 30 5 33 38 3 0 7 37 5 38 43 1 0 8 41 5 43 48 2 0 9 47 6 48 54 1 0 10 52 5 54 59 11 56 7 59 66 12 58 5 66 71 13 65 4 71 75 2386 0 0 0 0 14 70 75 79 5 0 15 71 5 79 84 8 0 16 78 17 82 18 85 19 92 5557 5 84 89 6 0 89 94 7 0 5 94 99 9 0 7 99 106 7 0 20 94 5 106 111 12 0