Question
COULD YOU BE ABLE HELP ME THIS ASSIGMENT ON EXCELL? A bank is building a new branch. One of the major decisions is how many
COULD YOU BE ABLE HELP ME THIS ASSIGMENT ON EXCELL?
A bank is building a new branch. One of the major decisions is how many teller stations to put in the bank. Historical data will be used for planning the bank design. The following data has been provided:
Customers per day (normally distributed):
= 448.6
= 59.7
Customers served per day by one teller (normally distributed):
= 76.5
= 12.4
However, on 29.6% of the days a teller has a computer malfunction which decreases the number of customers served. On those days:
Customers served per day by one teller (normally distributed):
= 38.6
= 8.4
Design a simulation to determine how many teller stations are needed such that during at least 95% of the days all customers are served. Provide data analysis to support your decision.
Provide data analysis to verify that you have tested the model's validity.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started