show all the calculations and formulas on excell please

QUESTION 1 [21] Tiger Tyres' average daily sales of a certain tyre brand is 8 units. The actual number of sales each day is 7, 8, or 9 with probabilities 0.3, 0.4, and 0.3, respectively. The lead time for delivery averages 3 days, although the time may be 3, 4, or 5 days with probabilities 0.2, 0.6, and 0.2. The company plans to place an order when the inventory level for this tyre drops to 32 units (based on the average demand and average lead time). The following random numbers have been generated: 52, 78, 13, 06, 99, 98, 80, 09, 67, 89, 45 (set 1) 10, 47, 99, 37 (set 2) Use set 1 of these random numbers to simulate daily demand and use set 2 to generate lead times. Simulate the ordering period and determine whether the company runs out of stock before the first order shipment arrives. Assume inventory on hand is at 32 and an order should be placed on the first day (21)