Group case project question # 4&5 needed

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

Q4-Simulation

Q4 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 78.1 26,794
1 1.0304855282 481.030 1 481.0305 8 489.0305 0.0000 1.0305 $ 11.00 $ 7.15 Revenue $ 759.00 $ 741.87 $ 254,537
2 3.7557219119 484.786 1 489.0305 6 495.0305 4.2443 0.0000 $ 9.00 $ 5.85 Profit $ 493.35 $ 482.22 $ 165,449
3 8.5900695883 493.376 1 495.0305 7 502.0305 1.6542 0.0000 $ 10.00 $ 6.50
4 17.9694685984 511.346 1 511.3457 5 516.3457 0.0000 9.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 11.4 11.72
6 8.6821321924 521.441 1 521.4415 7 528.4415 0.0000 0.0957 $ 10.00 $ 6.50 Max wait time 31.7 35.19
7 5.8316481822 527.273 1 528.4415 5 533.4415 1.1684 0.0000 $ 8.00 $ 5.20
8 1.0851852084 528.358 1 533.4415 5 538.4415 5.0832 0.0000 $ 8.00 $ 5.20
9 6.1703555505 534.529 1 538.4415 7 545.4415 3.9128 0.0000 $ 10.00 $ 6.50 Average Idle Time 1.0 1.30
10 1.0578665669 535.587 1 545.4415 7 552.4415 9.8549 0.0000 $ 10.00 $ 6.50 Max idle time 24.8 21.06
11 15.9426916002 551.529 1 552.4415 6 558.4415 0.9123 0.0000 $ 9.00 $ 5.85
12 7.1269754731 558.656 1 558.6562 7 565.6562 0.0000 0.2147 $ 10.00 $ 6.50
13 5.913570779 564.570 1 565.6562 8 573.6562 1.0864 0.0000 $ 11.00 $ 7.15 WASH MINUTES PRICE PROBABILITY
14 4.2370351433 568.807 1 573.6562 8 581.6562 4.8494 0.0000 $ 11.00 $ 7.15 economy 5 $8.00 35.00000%
15 4.715091267 573.522 1 581.6562 5 586.6562 8.1343 0.0000 $ 8.00 $ 5.20 custom 6 $9.00 25.00000%
16 10.5475488353 584.069 1 586.6562 6 592.6562 2.5868 0.0000 $ 9.00 $ 5.85 deluxe 7 $10.00 20.00000%
17 8.465556106 592.535 1 592.6562 5 597.6562 0.1212 0.0000 $ 8.00 $ 5.20 elite 8 $11.00 20.00000%
18 8.2765714573 600.812 1 600.8116 6 606.8116 0.0000 3.1554 $ 9.00 $ 5.85
19 2.2298321192 603.041 1 606.8116 7 613.8116 3.7702 0.0000 $ 10.00 $ 6.50
20 1.9888606083 605.030 1 613.8116 6 619.8116 8.7813 0.0000 $ 9.00 $ 5.85
21 4.5077927663 609.538 1 619.8116 5 624.8116 10.2735 0.0000 $ 8.00 $ 5.20
22 2.5596415885 612.098 1 624.8116 8 632.8116 12.7139 0.0000 $ 11.00 $ 7.15
23 7.751050857 619.849 1 632.8116 6 638.8116 12.9628 0.0000 $ 9.00 $ 5.85
24 7.5691088867 627.418 1 638.8116 8 646.8116 11.3937 0.0000 $ 11.00 $ 7.15
25 4.1887305946 631.607 1 646.8116 8 654.8116 15.2050 0.0000 $ 11.00 $ 7.15
26 1.4266641366 633.033 1 654.8116 5 659.8116 21.7783 0.0000 $ 8.00 $ 5.20
27 9.4754412659 642.509 1 659.8116 5 664.8116 17.3029 0.0000 $ 8.00 $ 5.20
28 9.853156526 652.362 1 664.8116 5 669.8116 12.4497 0.0000 $ 8.00 $ 5.20
29 2.8238881746 655.186 1 669.8116 8 677.8116 14.6258 0.0000 $ 11.00 $ 7.15
30 9.5482234687 664.734 1 677.8116 8 685.8116 13.0776 0.0000 $ 11.00 $ 7.15
31 2.0645626747 666.799 1 685.8116 7 692.8116 19.0130 0.0000 $ 10.00 $ 6.50
32 10.4269560918 677.225 1 692.8116 6 698.8116 15.5861 0.0000 $ 9.00 $ 5.85
33 10.128501831 687.354 1 698.8116 8 706.8116 11.4576 0.0000 $ 11.00 $ 7.15
34 3.062596238 690.417 1 706.8116 5 711.8116 16.3950 0.0000 $ 8.00 $ 5.20
35 2.7350361975 693.152 1 711.8116 7 718.8116 18.6600 0.0000 $ 10.00 $ 6.50
36 1.5567533067 694.708 1 718.8116 6 724.8116 24.1032 0.0000 $ 9.00 $ 5.85
37 3.6125423819 698.321 1 724.8116 7 731.8116 26.4907 0.0000 $ 10.00 $ 6.50
38 3.0702885568 701.391 1 731.8116 5 736.8116 30.4204 0.0000 $ 8.00 $ 5.20
39 7.2231253802 708.614 1 736.8116 5 741.8116 28.1972 0.0000 $ 8.00 $ 5.20
40 11.9823867559 720.597 1 741.8116 7 748.8116 21.2149 0.0000 $ 10.00 $ 6.50
41 7.5040392171 728.101 1 748.8116 7 755.8116 20.7108 0.0000 $ 10.00 $ 6.50
42 7.2964505632 735.397 1 755.8116 8 763.8116 20.4144 0.0000 $ 11.00 $ 7.15
43 3.242773982 738.640 1 763.8116 5 768.8116 25.1716 0.0000 $ 8.00 $ 5.20
44 9.7151169761 748.355 1 768.8116 8 776.8116 20.4565 0.0000 $ 11.00 $ 7.15
45 5.722489367 754.078 1 776.8116 5 781.8116 22.7340 0.0000 $ 8.00 $ 5.20
46 4.9056105406 758.983 1 781.8116 6 787.8116 22.8284 0.0000 $ 9.00 $ 5.85
47 1.5790057492 760.562 1 787.8116 5 792.8116 27.2494 0.0000 $ 8.00 $ 5.20
48 2.8492840183 763.411 1 792.8116 6 798.8116 29.4001 0.0000 $ 9.00 $ 5.85
49 13.374760934 776.786 1 798.8116 7 805.8116 22.0253 0.0000 $ 10.00 $ 6.50
50 24.6778048195 801.464 1 805.8116 8 813.8116 4.3475 0.0000 $ 11.00 $ 7.15
51 10.1783310508 811.642 1 813.8116 7 820.8116 2.1692 0.0000 $ 10.00 $ 6.50
52 7.0660767712 818.708 1 820.8116 7 827.8116 2.1031 0.0000 $ 10.00 $ 6.50
53 1.0659141444 819.774 1 827.8116 5 832.8116 8.0372 0.0000 $ 8.00 $ 5.20
54 2.0330968463 821.807 1 832.8116 8 840.8116 11.0041 0.0000 $ 11.00 $ 7.15
55 13.3345406408 835.142 1 840.8116 5 845.8116 5.6696 0.0000 $ 8.00 $ 5.20
56 3.5382592658 838.680 1 845.8116 7 852.8116 7.1313 0.0000 $ 10.00 $ 6.50
57 1.1924785343 839.873 1 852.8116 6 858.8116 12.9388 0.0000 $ 9.00 $ 5.85
58 4.2693229215 844.142 1 858.8116 5 863.8116 14.6695 0.0000 $ 8.00 $ 5.20
59 4.4384945144 848.581 1 863.8116 5 868.8116 15.2310 0.0000 $ 8.00 $ 5.20
60 5.9117757724 854.492 1 868.8116 8 876.8116 14.3192 0.0000 $ 11.00 $ 7.15
61 1.223762204 855.716 1 876.8116 7 883.8116 21.0955 0.0000 $ 10.00 $ 6.50
62 5.0491169606 860.765 1 883.8116 8 891.8116 23.0464 0.0000 $ 11.00 $ 7.15
63 8.6576228433 869.423 1 891.8116 7 898.8116 22.3887 0.0000 $ 10.00 $ 6.50
64 1.1499999778 870.573 1 898.8116 6 904.8116 28.2387 0.0000 $ 9.00 $ 5.85
65 2.5016277251 873.074 1 904.8116 8 912.8116 31.7371 0.0000 $ 11.00 $ 7.15
66 29.2473650543 902.322 1 912.8116 5 917.8116 10.4897 0.0000 $ 8.00 $ 5.20
67 4.4903606943 906.812 1 917.8116 5 922.8116 10.9994 0.0000 $ 8.00 $ 5.20
68 8.5164393045 915.329 1 922.8116 6 928.8116 7.4829 0.0000 $ 9.00 $ 5.85
69 2.85209317 918.181 1 928.8116 6 934.8116 10.6308 0.0000 $ 9.00 $ 5.85
70 10.3568749321 928.538 1 934.8116 8 942.8116 6.2740 0.0000 $ 11.00 $ 7.15
71 1.7735430283 930.311 1 942.8116 8 950.8116 12.5004 0.0000 $ 11.00 $ 7.15
72 20.2250782369 950.536 1 950.8116 7 957.8116 0.2753 0.0000 $ 10.00 $ 6.50
73 5.4654062221 956.002 1 957.8116 8 965.8116 1.8099 0.0000 $ 11.00 $ 7.15
74 19.8504166903 975.852 1 975.8520 6 981.8520 0.0000 10.0405 $ 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 7 1020.6866 1.8941 0.0000 $ 10.00 $ 6.50
77 12.9153721029 1024.708 1 1024.7079 5 1029.7079 0.0000 4.0213 $ 8.00 $ 5.20
78 3.9424064686 1028.650 1 1029.7079 8 1037.7079 1.0576 0.0000 $ 11.00 $ 7.15
79 27.7917550086 1056.442 1 1056.4420 6 1062.4420 0.0000 18.7342 $ 9.00 $ 5.85
80 17.2416222519 1073.684 1 1073.6837 8 1081.6837 0.0000 11.2416 $ 11.00 $ 7.15
81 1.3117950525 1074.995 0 0.0000 8 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 6 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 7 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 8 0.0000 $ - 0 $ - 0
95 7.2082456172 1179.717 0 0.0000 8 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 7 0.0000 $ - 0 $ - 0
98 6.4900880022 1208.979 0 0.0000 7 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