Group case project question # 4&5 needed

peaflower9661
Q3SimulationWorksheetforSimulation.xlsx
Home>Business & Finance homework help>Group case project question # 4&5 needed

Q3-Simulation

Q3 Simulation Worksheet Open 8:00 am 8.0 hrs 480 min Rain days idle (no biz) 6%
NOTE: FOR PERSONAL AND TEAM USE ONLY Close 6:00 pm 18.0 hrs 1080 min
DO NOT REPRODUCE OR DISTRIBUTE EXCEPT AS PART OF YOUR TEAM SUBMISSION Profit Margin 65%
Customer Count Car Inter-arrival times (IAT) Clock Arrival Time After Hours = 0 Start Wash Service Service time (ST) End Wash Service Wait time Wash idle time No Rain Revenue No Rain Profit RESULTS OUTPUT RISK Mean (Daily) RISK Mean (Annual)
0 0 480 0 0 480 0 0 $ - 0 $ - 0 Car Count 80 79.0 27,106
1 1.0304855282 481.030 1 481.0305 7 488.0305 0.0000 1.0305 $ 10.00 $ 6.50 Revenue $ 717.00 $ 711.04 $ 243,959
2 3.7557219119 484.786 1 488.0305 6 494.0305 3.2443 0.0000 $ 9.00 $ 5.85 Profit $ 466.05 $ 462.18 $ 158,574
3 8.5900695883 493.376 1 494.0305 6 500.0305 0.6542 0.0000 $ 9.00 $ 5.85
4 17.9694685984 511.346 1 511.3457 5 516.3457 0.0000 11.3153 $ 8.00 $ 5.20
5 1.4135991916 512.759 1 516.3457 5 521.3457 3.5864 0.0000 $ 8.00 $ 5.20 Average wait time 6.4 7.42
6 8.6821321924 521.441 1 521.4415 6 527.4415 0.0000 0.0957 $ 9.00 $ 5.85 Max wait time 23.6 26.22
7 5.8316481822 527.273 1 527.4415 5 532.4415 0.1684 0.0000 $ 8.00 $ 5.20
8 1.0851852084 528.358 1 532.4415 5 537.4415 4.0832 0.0000 $ 8.00 $ 5.20
9 6.1703555505 534.529 1 537.4415 7 544.4415 2.9128 0.0000 $ 10.00 $ 6.50 Average Idle Time 1.5 1.72
10 1.0578665669 535.587 1 544.4415 6 550.4415 8.8549 0.0000 $ 9.00 $ 5.85 Max idle time 24.8 23.32
11 15.9426916002 551.529 1 551.5292 5 556.5292 0.0000 1.0877 $ 8.00 $ 5.20
12 7.1269754731 558.656 1 558.6562 6 564.6562 0.0000 2.1270 $ 9.00 $ 5.85
13 5.913570779 564.570 1 564.6562 7 571.6562 0.0864 0.0000 $ 10.00 $ 6.50 WASH MINUTES PRICE PROBABILITY
14 4.2370351433 568.807 1 571.6562 7 578.6562 2.8494 0.0000 $ 10.00 $ 6.50 economy 5 $8.00 33.33333%
15 4.715091267 573.522 1 578.6562 5 583.6562 5.1343 0.0000 $ 8.00 $ 5.20 custom 6 $9.00 33.33333%
16 10.5475488353 584.069 1 584.0694 6 590.0694 0.0000 0.4132 $ 9.00 $ 5.85 deluxe 7 $10.00 33.33333%
17 8.465556106 592.535 1 592.5350 5 597.5350 0.0000 2.4656 $ 8.00 $ 5.20
18 8.2765714573 600.812 1 600.8116 5 605.8116 0.0000 3.2766 $ 8.00 $ 5.20
19 2.2298321192 603.041 1 605.8116 6 611.8116 2.7702 0.0000 $ 9.00 $ 5.85
20 1.9888606083 605.030 1 611.8116 6 617.8116 6.7813 0.0000 $ 9.00 $ 5.85
21 4.5077927663 609.538 1 617.8116 5 622.8116 8.2735 0.0000 $ 8.00 $ 5.20
22 2.5596415885 612.098 1 622.8116 7 629.8116 10.7139 0.0000 $ 10.00 $ 6.50
23 7.751050857 619.849 1 629.8116 5 634.8116 9.9628 0.0000 $ 8.00 $ 5.20
24 7.5691088867 627.418 1 634.8116 7 641.8116 7.3937 0.0000 $ 10.00 $ 6.50
25 4.1887305946 631.607 1 641.8116 7 648.8116 10.2050 0.0000 $ 10.00 $ 6.50
26 1.4266641366 633.033 1 648.8116 5 653.8116 15.7783 0.0000 $ 8.00 $ 5.20
27 9.4754412659 642.509 1 653.8116 5 658.8116 11.3029 0.0000 $ 8.00 $ 5.20
28 9.853156526 652.362 1 658.8116 5 663.8116 6.4497 0.0000 $ 8.00 $ 5.20
29 2.8238881746 655.186 1 663.8116 7 670.8116 8.6258 0.0000 $ 10.00 $ 6.50
30 9.5482234687 664.734 1 670.8116 7 677.8116 6.0776 0.0000 $ 10.00 $ 6.50
31 2.0645626747 666.799 1 677.8116 6 683.8116 11.0130 0.0000 $ 9.00 $ 5.85
32 10.4269560918 677.225 1 683.8116 6 689.8116 6.5861 0.0000 $ 9.00 $ 5.85
33 10.128501831 687.354 1 689.8116 7 696.8116 2.4576 0.0000 $ 10.00 $ 6.50
34 3.062596238 690.417 1 696.8116 5 701.8116 6.3950 0.0000 $ 8.00 $ 5.20
35 2.7350361975 693.152 1 701.8116 7 708.8116 8.6600 0.0000 $ 10.00 $ 6.50
36 1.5567533067 694.708 1 708.8116 6 714.8116 14.1032 0.0000 $ 9.00 $ 5.85
37 3.6125423819 698.321 1 714.8116 7 721.8116 16.4907 0.0000 $ 10.00 $ 6.50
38 3.0702885568 701.391 1 721.8116 5 726.8116 20.4204 0.0000 $ 8.00 $ 5.20
39 7.2231253802 708.614 1 726.8116 5 731.8116 18.1972 0.0000 $ 8.00 $ 5.20
40 11.9823867559 720.597 1 731.8116 6 737.8116 11.2149 0.0000 $ 9.00 $ 5.85
41 7.5040392171 728.101 1 737.8116 6 743.8116 9.7108 0.0000 $ 9.00 $ 5.85
42 7.2964505632 735.397 1 743.8116 7 750.8116 8.4144 0.0000 $ 10.00 $ 6.50
43 3.242773982 738.640 1 750.8116 5 755.8116 12.1716 0.0000 $ 8.00 $ 5.20
44 9.7151169761 748.355 1 755.8116 7 762.8116 7.4565 0.0000 $ 10.00 $ 6.50
45 5.722489367 754.078 1 762.8116 5 767.8116 8.7340 0.0000 $ 8.00 $ 5.20
46 4.9056105406 758.983 1 767.8116 5 772.8116 8.8284 0.0000 $ 8.00 $ 5.20
47 1.5790057492 760.562 1 772.8116 5 777.8116 12.2494 0.0000 $ 8.00 $ 5.20
48 2.8492840183 763.411 1 777.8116 6 783.8116 14.4001 0.0000 $ 9.00 $ 5.85
49 13.374760934 776.786 1 783.8116 6 789.8116 7.0253 0.0000 $ 9.00 $ 5.85
50 24.6778048195 801.464 1 801.4640 7 808.4640 0.0000 11.6525 $ 10.00 $ 6.50
51 10.1783310508 811.642 1 811.6424 6 817.6424 0.0000 3.1783 $ 9.00 $ 5.85
52 7.0660767712 818.708 1 818.7085 7 825.7085 0.0000 1.0661 $ 10.00 $ 6.50
53 1.0659141444 819.774 1 825.7085 5 830.7085 5.9341 0.0000 $ 8.00 $ 5.20
54 2.0330968463 821.807 1 830.7085 7 837.7085 8.9010 0.0000 $ 10.00 $ 6.50
55 13.3345406408 835.142 1 837.7085 5 842.7085 2.5664 0.0000 $ 8.00 $ 5.20
56 3.5382592658 838.680 1 842.7085 6 848.7085 4.0282 0.0000 $ 9.00 $ 5.85
57 1.1924785343 839.873 1 848.7085 6 854.7085 8.8357 0.0000 $ 9.00 $ 5.85
58 4.2693229215 844.142 1 854.7085 5 859.7085 10.5664 0.0000 $ 8.00 $ 5.20
59 4.4384945144 848.581 1 859.7085 5 864.7085 11.1279 0.0000 $ 8.00 $ 5.20
60 5.9117757724 854.492 1 864.7085 7 871.7085 10.2161 0.0000 $ 10.00 $ 6.50
61 1.223762204 855.716 1 871.7085 6 877.7085 15.9924 0.0000 $ 9.00 $ 5.85
62 5.0491169606 860.765 1 877.7085 7 884.7085 16.9432 0.0000 $ 10.00 $ 6.50
63 8.6576228433 869.423 1 884.7085 6 890.7085 15.2856 0.0000 $ 9.00 $ 5.85
64 1.1499999778 870.573 1 890.7085 6 896.7085 20.1356 0.0000 $ 9.00 $ 5.85
65 2.5016277251 873.074 1 896.7085 7 903.7085 23.6340 0.0000 $ 10.00 $ 6.50
66 29.2473650543 902.322 1 903.7085 5 908.7085 1.3866 0.0000 $ 8.00 $ 5.20
67 4.4903606943 906.812 1 908.7085 5 913.7085 1.8963 0.0000 $ 8.00 $ 5.20
68 8.5164393045 915.329 1 915.3286 5 920.3286 0.0000 1.6202 $ 8.00 $ 5.20
69 2.85209317 918.181 1 920.3286 6 926.3286 2.1479 0.0000 $ 9.00 $ 5.85
70 10.3568749321 928.538 1 928.5376 7 935.5376 0.0000 2.2090 $ 10.00 $ 6.50
71 1.7735430283 930.311 1 935.5376 7 942.5376 5.2265 0.0000 $ 10.00 $ 6.50
72 20.2250782369 950.536 1 950.5362 6 956.5362 0.0000 7.9986 $ 9.00 $ 5.85
73 5.4654062221 956.002 1 956.5362 7 963.5362 0.5346 0.0000 $ 10.00 $ 6.50
74 19.8504166903 975.852 1 975.8520 6 981.8520 0.0000 12.3158 $ 9.00 $ 5.85
75 30.834534527 1006.687 1 1006.6866 7 1013.6866 0.0000 24.8345 $ 10.00 $ 6.50
76 5.1059268299 1011.793 1 1013.6866 6 1019.6866 1.8941 0.0000 $ 9.00 $ 5.85
77 12.9153721029 1024.708 1 1024.7079 5 1029.7079 0.0000 5.0213 $ 8.00 $ 5.20
78 3.9424064686 1028.650 1 1029.7079 7 1036.7079 1.0576 0.0000 $ 10.00 $ 6.50
79 27.7917550086 1056.442 1 1056.4420 5 1061.4420 0.0000 19.7342 $ 8.00 $ 5.20
80 17.2416222519 1073.684 1 1073.6837 7 1080.6837 0.0000 12.2416 $ 10.00 $ 6.50
81 1.3117950525 1074.995 0 0.0000 7 0.0000 $ - 0 $ - 0
82 7.8552920998 1082.851 0 0.0000 5 0.0000 $ - 0 $ - 0
83 2.0899037676 1084.941 0 0.0000 5 0.0000 $ - 0 $ - 0
84 9.0245769093 1093.965 0 0.0000 5 0.0000 $ - 0 $ - 0
85 1.237544774 1095.203 0 0.0000 6 0.0000 $ - 0 $ - 0
86 2.3812889016 1097.584 0 0.0000 6 0.0000 $ - 0 $ - 0
87 2.5929550786 1100.177 0 0.0000 5 0.0000 $ - 0 $ - 0
88 13.2153609605 1113.392 0 0.0000 6 0.0000 $ - 0 $ - 0 2
89 4.2601946656 1117.653 0 0.0000 6 0.0000 $ - 0 $ - 0
90 1.5890088407 1119.242 0 0.0000 5 0.0000 $ - 0 $ - 0
91 25.0560033894 1144.298 0 0.0000 5 0.0000 $ - 0 $ - 0
92 14.8690261301 1159.167 0 0.0000 6 0.0000 $ - 0 $ - 0
93 10.5087790113 1169.675 0 0.0000 5 0.0000 $ - 0 $ - 0
94 2.8337258863 1172.509 0 0.0000 7 0.0000 $ - 0 $ - 0
95 7.2082456172 1179.717 0 0.0000 7 0.0000 $ - 0 $ - 0
96 12.0551427632 1191.773 0 0.0000 6 0.0000 $ - 0 $ - 0
97 10.7163062997 1202.489 0 0.0000 6 0.0000 $ - 0 $ - 0
98 6.4900880022 1208.979 0 0.0000 6 0.0000 $ - 0 $ - 0
99 16.0214515189 1225.000 0 0.0000 5 0.0000 $ - 0 $ - 0
100 5.745339284 1230.746 0 0.0000 7 0.0000 $ - 0 $ - 0