Please solve this in Microsoft Excel and show what equations were used in each cell.

Everyday a truck delivers gasoline to a Shell gas station. The supplier uses three size truck foe delivery of gasoline to stations. The gas is stores in an underground storage tank. Two sizes of trucks are used in the delivery operation. The station operates 7 days a week. The following data is given about the station. Type of Truck Capacity (gallons) Probability N 1 2 3 50000 40000 24000 0.40 0.50 0.10 Daily gasoline sale is variable which is normally distributed with mean = 42000 and standard deviation=1000 gallons. Historical data shows that on a daily basis, depending on the temperature and other factors, the gas storage losses Z gallons of gasoline because of leaks, evaporations, and other factors. Assumptions: a)-The variable Z varies between 300 and 500 (distributed uniformly) gallons, b)-The station wishes to maintain a safety stock of 500 gallons) Simulate the inventory level in the storage for 3 months (90 days) and answer the following questions 1). Determine average inventory in the storage and average delivery volume/day 2). What is the probability that the gas station will run of gas 3). If the station desire to be sure (99% of time) that they will meet daily customer Demand and still maintain the 500 gallons safety stock, what size storage do you recommend for the station. Everyday a truck delivers gasoline to a Shell gas station. The supplier uses three size truck foe delivery of gasoline to stations. The gas is stores in an underground storage tank. Two sizes of trucks are used in the delivery operation. The station operates 7 days a week. The following data is given about the station. Type of Truck Capacity (gallons) Probability N 1 2 3 50000 40000 24000 0.40 0.50 0.10 Daily gasoline sale is variable which is normally distributed with mean = 42000 and standard deviation=1000 gallons. Historical data shows that on a daily basis, depending on the temperature and other factors, the gas storage losses Z gallons of gasoline because of leaks, evaporations, and other factors. Assumptions: a)-The variable Z varies between 300 and 500 (distributed uniformly) gallons, b)-The station wishes to maintain a safety stock of 500 gallons) Simulate the inventory level in the storage for 3 months (90 days) and answer the following questions 1). Determine average inventory in the storage and average delivery volume/day 2). What is the probability that the gas station will run of gas 3). If the station desire to be sure (99% of time) that they will meet daily customer Demand and still maintain the 500 gallons safety stock, what size storage do you recommend for the station