Description
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.
Unformatted Attachment Preview
Purchase answer to see full attachment

Explanation & Answer

The solution is attached.Please, give me feedback.
Simulation:
Customer waiting limit:
Period
1
2
3
4
5
6
7
8
Random #
0.2850
0.5756
0.3070
0.5866
0.2217
0.5183
0.3383
0.4094
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
0.2396
0.3500
0.8050
0.6916
0.6874
0.0654
0.6509
0.7802
0.4005
0.2238
0.8436
0.4599
0.7651
0.0483
0.0737
0.9289
0.1503
0.7571
0.5808
0.9962
0.4785
0.3679
0.8481
0.9298
0.5786
0.5262
0.9295
0.1143
0.5366
0.7051
0.6223
0.2101
0.7611
0.5537
4
# of customers # of customers
customers
# of customers
waiting
arriving
being served
balking
0
0
0
0
0
1
1
0
0
0
0
0
0
1
1
0
0
0
0
0
0
1
1
0
0
1
1
0
0
1
1
0
0
0
0
1
1
1
0
0
1
1
0
1
1
2
1
0
2
1
2
2
3
3...
