i need help solving this analytics question

Ch 8 Excel Problems Use this information to answer the following questions. Use Excel ABC Inc. must make a decision on its current capacity for next year. Estimated profits (in $000s) based on next year's demand are shown in the table below. Next Year's Demand Alternative Low High Expand $100 $200 Subcontract $50 $120 Do Nothing $40 $50 1) Refer to the information above. a. Which alternative should be chosen based on the maximax criterion? b. Which alternative should be chosen based on the maximin criterion? c. Which alternative should be chosen based on the Lapalce criterion? d. Which alternative should be chosen based on criterion of realism with alpha=0.7? e. Which alternative should be chosen based on the minimax regret criterion? Ch 9 Excel Problems use Excelmodules 1) A local bank has a single drive-in teller window. Customers arrive at the drive-in window following a Poisson distribution at an average rate of 20 per hour. Assume that service is provided at the drive-in window at a rate of 30 customers per hour and that service time follows an exponential distribution. Moreover, assume that the population size is infinite and the queue length is unrestricted. To determine the efficiency of operations, the bank wishes to examine several queue operating characteristics. a. What is the utilization rate of this service system? b. What is the average number of customers in line? c. What is the average time that each customer spends in the queue? d. What is the average time that each customer spends in the system? e. What is the probability that the drive-in window will be idle? Guering Model MM (ponential Service Times AN Cocorro There we Vermutter than ng Arte ( Average server 10 Service Average of our in the 1900 11 Mbwa Amber of customers in the eye) 20000 12 Average willing then the gove (W) 0.0667 13 Argenthe system 0.1000 14 Probly of time) 0.3390 15 17 10 W Hunter of Unte Proy Pro 0.3333 0.3333 0.2222 05 0.1441 2000 0-3000 4 2005 0.2685 5 0.04 00123 6 0.0290 OS 7 001 0610 0 0 0.00 9 0.0087 DOT 30 SO 0.00 11 0.000 0903 92 0.0006 33 13 0.0017 09 14 00011 15 0.000 O. 36 0005 0.9990 12 0.000 0.83 0.0002 9 0.000 99 ERRRRRRRRRRRRRRRRRRRRS