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.