Please give formulas for excel input.

QUESTION 2 15 points Save An Worac Company is a drug manufacture Wozac has recently accepted an order from its best customer for 8000 ounces of a new muracie drug and worse wants to plan its production schedule to meet the customer's promised delivery date of December 1 There are three sources of uncertainty that make planning difficult First, the drug must be produced in batches, and there is uncertainty in the time required to produce a batch, which could be anywhere from 5 to 11 days. The uncertainty is described by the discrete distribution as in the following table Days 5 7 8 9 10 11 Probability 005 010 0.30 020 010 0.05 020 Second, they (usati quantity) from any batch is uncertain Based on historical data, Worac boleves the yold can be modeled by a Normal distribution with the mean of 1000, and the standard deviation of 100 Third, all batches must go through a rigorous inspection once they are completed the probability that a typical batch passes inspection is only 0 7 W probability 03 the batch tail inspection and none of it can be used to help the order Woza wants to use simulation to help decide how many days prior to the due dinte should begin production Download the template file to help Wozac to sit up the simulation model and run the simulation for 1000 repetition Based on the simulated data, please provide the information on the following questions (1) The average the minimum, and the maximum number of batches produced to satisfy the order (2) The average the minimum and the maximum number of days used to satisfy the order (3) What is the delivery day quote to give so that the firm will miss the quote only by 5% of chance? (4) What is the probability of satisfying the order no less than 125 days? Excam 25 92 23 24 5 24 27 20 24 2 20 29 30 21 32 32 34 35 10 11 12 12 14 15 15 17 33 34 35 30 27 31 16 41 1 44 45 10 20 21 22 23 24 25 2 27 21 29 30 44 45 6 UT 4 50 31 42 43 49 50 51 53 59 HO-Data thered + DIP 1 NH 14 57 5 Szery Date 5 Add Min butcher 41 Mehr 53 54 55 ST 59 Arred Mindre Hexdate w BE ST ** 25 92 23 24 5 24 27 20 24 2 20 29 30 21 32 32 34 35 10 11 12 12 14 15 15 17 33 34 35 30 27 31 16 41 1 44 45 10 20 21 22 23 24 25 2 27 21 29 30 44 45 6 UT 4 50 31 42 43 49 50 51 53 59 HO-Data thered + DIP 1 NH 14 57 5 Szery Date 5 Add Min butcher 41 Mehr 53 54 55 ST 59 Arred Mindre Hexdate w BE ST **