Question: plz attach excel spreadsheets used, thanks Problem 3 [30 points] A bank is trying to determine which ofthe two machines should be rented to process

plz attach excel spreadsheets used, thanks

plz attach excel spreadsheets used, thanks
Problem 3 [30 points] A bank is trying to determine which ofthe two machines should be rented to process checks. Machine 1 rents for $10,000 per year and processes 1.000 checks per hour. Machine 2 rents for $15,000 per year and processes 1,600 checks per hour. Assume that the machines work 3 hours a day. 5 days a week, 50 weeks a year. The bank must process an average of 800 checks per hour, and the average check processed is for $100. Assume an annual interest rate of 20% over the income of the checks. Then determine the cost of the bank [in lost interest] for each hour that check spends waiting for and undergoing processing (waiting in the system]. Assume the interarrival times and service times are exponential. a] Calculate the performance metrics {Lug}, L, Lc], Ls. W, Wq, W5} for each queue system: using machine 1 or using machine 2. [10 points} b] Calculate the delay costs [in loss interest] and service operation costs per hour, and determine what is the best choice: machine 1 or machine 2. [10 points] c] Suppose that the bank undergoes a sudden increase in sales and now the arrival rate increase in 2000 checks per hour. Thus. the bank is considering two machines to work in parallel at a rate of 1300 checks per hour. What would be the probability that the servers are idle? {Pg} (Hint: use the excel spreadsheet]. [10 points}

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!