THE FILE IS ATTACHED TO THE QUESTIONS:

PLEASE MAKE SURE TO ATTACH AN EXCEL DOCUMENT WITH THE ANSWER

SHOWING ALL FORMULAS WITHIN THE EXCEL DOCUMENT

QUESTIONS:

a) Conduct a one day simulation using Excel (100 customers (periods) per day). HINT: set up a simulation to repeat what happens during each of the 100 six-minute periods. For each period, keep track of the number of customers currently waiting, the number of customers arriving, number of customers being served (0 if there is no one waiting or arriving and 1 otherwise), the order size (profit) for that customer (if there is a customer), and number of customers balking.

b) For each day, determine the total revenue per day and the number of lost customers per day.

c) Simulate 30 days to find out the average total profit per day and the average number of lost customers per day. You can repeat the simulation twenty times (eg. using F9) and keep track of the total profit and number of lost customers per day.

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.