Please solve without using Excel Solver

Question 1 (30 points) 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 per Probability day 10 .20 .20 2 .50 .10 3 Rental duration in days Probability 3 10 .30 40 .10 .10 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. Use the following random numbers in order (from left to right) for the simulation of number of customers per day: 0.62 0.48 0.96 0.86 0.86 0.29 0.79 0.22 0.08 0.62 Use the following random numbers in order (from left to right, first row first - as you need them) for the simulation of car rental duration in days. 0.19 0.66 0.27 0.43 10.20 0.92 0.22 0.91 0.46 0.49 0.66 0.09 0.81 0.05 0.91 10.97 0.24 0.01 0.27 0.69 0.18 0.06 0.53 0.97 10.13 0.21 0.97 0.09 0.26 0.47 0.62 0.89 10.76 0.24 0.10 0.90 Please conduct the simulation day by day using Word, Excel or pen and paper and then take a picture of your work. Upload your file for grading! Advice: Remember you are conducting the simulation manually and you are not supposed to use Excel formulas but rather show the process (however you can Excel to display your work!). Also, a car rented in day 1 with a duration of 2 days becomes available for rent in day 3 (assuming no repair, no delay in return, for simplicity). Please do not add your own assumptions, ideas into the question! Question 2 (20 points) One of the large photocopiers used by a printing company has a number of special functions unique to that particular model. This photocopier generally performs well but, because of the complexity of its design and the frequency of usage, it occasionally breaks down. The department has kept records of the number of breakdowns per month over the last fifty months. The data is summarized in the table below: Zorinou Number of Breakdowns Probability 0.12 0.32 0.24 0.20 0.08 0.04 The cost of a repair depends mainly on the time taken, the level of expertise required and the cost of any spare parts. There are four levels of repair. The cost per repair for each level and probabilities for different levels of repair are show in table below: 0.50 Repair Category Repair Cost Probability $35 $75 0.30 $150 0.16 $350 0.04 Based on the probabilities given in the two tables and using the random number streams given below, simulate for each of 12 consecutive months the number of breakdowns and the repair cost of each breakdown. Note that for each month you must show both the number of breakdowns, the repair cost for each breakdown (if any) and the total monthly repair cost as well as the total annual repair cost. Use the following random numbers in order (from left to right) for the simulation of number of breakdowns per month: 0.13 0.21 0.08 0.09 0.89 0.26 0.65 0.28 0.97 0.24 0.10 0.90 LA Use the following random numbers in order (from left to right, first row first - as you need them) for the simulation of repair cost for each breakdown. 0.19 0.39 0.07 0.42 0.65 0.61 0.85 0.40 0.75 0.73 0.16 0.64 + 0.38 0.05 0.91 0.97 0.24 0.01 0.27 0.69 0.18 0.06 0.53 0.97 Please conduct the simulation month by month (first month first, second month, third month so on) You can either do this question using Word, Excel or pen and paper and then take a picture of your work! Upload your file for grading