Question: do it in excel , because i have the work but i dont know how to input on excel Use this information to answer the

do it in excel , because i have the work but i dont know how to input on excel do it in excel , because i have the work but i
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 5000s) 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.72 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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!