Please clearly show all Excel Formulas used to solve this problem.

15. The Paymore Rental Car Agency rents cars in a small town. It wants to determine how many rental cars it should maintain. Based on market projections and historical data, the manager has determined probability distributions for the number of rentals per day and rental duration (in days only) as shown in the following tables: Number of Customers/Day Probability 0 1 2 3 .20 .20 .50 .10 1.00 Rental Duration (days) Probability 1 2 3 4 5 .10 .30 .40 .10 .10 1.00 Design a simulation experiment for the car agency and simulate using a fleet of four rental cars for 10 days. Compute the probability that the agency will not have a car available upon demand. Should the agency expand its fleet? Explain how a simulation experiment could be designed to determine the optimal fleet size for the Paymore Agency