Matchstick simulation.

profilel3o0hd_s
Problem1617Studentworksheet311.xlsx
Home>Business & Finance homework help>Operations Management homework help>Matchstick simulation.

Sheet1

Time Beginning Random Demand Sold Ending Inv. Position Lost Place Random Lead arrival day Carrying Costs Lost Sales Ordering Costs Total Cost Demand for Mercedes Freq. Probability Cumulative Probability Random # Interval
1 30 1 8 8 22 22 No 440 0 0 440
2 22 47 6 6 16 16 No 320 0 0 320 6 3 0.083 0.083 00-08
3 16 96 9 9 7 7 Yes 79 2 5 140 0 570 710 7 4 0.111 0.194 09-19
4 7 16 9 7 0 0 2 Yes 1 5 0 8700 570 9270 8 6 0.167 0.361 20-36
5 0 85 8 0 0 28 8 No 560 34800 0 35360 9 12 0.333 0.694 37-69
6 28 45 10 10 18 18 No 360 0 0 360 10 9 0.25 0.944 70-94
7 18 42 10 10 8 8 Yes 46 1 8 160 0 570 730 11 1 0.028 0.972 95-97
8 8 48 9 8 0 14 1 No 280 4350 0 4630 12 1 0.028 1 98-99
9 14 33 9 9 5 5 Yes 1 10 100 0 570 670 36
10 5 48 6 5 0 14 1 No 70 280 4350 0 4630
11 14 10 7 7 7 7 Yes 2 13 140 0 570 710
12 7 50 9 7 0 0 2 Yes 1 13 0 8700 570 9270
13 0 74 9 0 0 28 9 No 59 560 39150 0 39710 Lead Prob. Cumulative Probability Random # Interval
14 28 88 10 10 18 18 No 360 0 0 360
15 18 46 8 8 10 10 Yes 1 16 200 0 570 770 1 0.44 0.44 0-44
16 10 81 10 10 0 14 No 87 280 0 0 280 2 0.33 0.77 45-77
17 14 16 8 8 6 6 Yes 1 18 120 0 570 690 3 0.16 0.93 78-93
18 6 44 8 6 0 14 2 No 280 8700 0 8980 4 0.07 1 94-99
19 14 25 9 9 5 5 Yes 1 20 100 0 570 670
20 5 25 10 5 0 14 5 No 91 280 21750 0 22030 Ordering amount Reorder Point
21 14 2 9 9 5 5 Yes 2 23 100 0 570 670 14 12
22 5 9 9 5 0 0 4 Yes 1 23 0 17400 570 17970
23 0 5 10 0 0 28 10 No 560 43500 0 44060
24 28 29 9 9 19 19 No 86 380 0 0 380
209 165 146 44 6000 191400 6270 $ 203,670

Sheet2

Time Beginning Random Demand Sold Ending Inv. Position Lost Place Random Lead arrival day Carrying Costs Lost Sales Ordering Costs Total Cost Demand for Mercedes Freq. Probability Cumulative Probability Random # Interval
1 30 1 12 12 18 18 No 360 0 0 360
2 18 47 10 10 8 8 Yes 1 3 160 0 570 730 6 3 0.083 0.083 00-08
3 8 96 9 8 0 20 1 No 79 400 4350 0 4750 7 4 0.111 0.194 09-19
4 20 16 10 10 10 10 No 200 0 0 200 8 6 0.167 0.361 20-36
5 10 85 7 7 3 3 Yes 1 6 60 0 570 630 9 12 0.333 0.694 37-69
6 3 45 9 3 0 20 6 No 400 26100 0 26500 10 9 0.25 0.944 70-94
7 20 42 8 8 12 12 No 46 240 0 0 240 11 1 0.028 0.972 95-97
8 12 48 8 8 4 4 Yes 4 12 80 0 570 650 12 1 0.028 1 98-99
9 4 33 7 4 0 0 3 Yes 2 11 0 13050 570 13620 36
10 0 48 9 0 0 0 9 Yes 70 1 11 0 39150 570 39720
11 0 10 10 0 0 40 10 No 800 43500 0 44300
12 40 50 6 6 34 54 No 1080 0 0 1080
13 54 74 10 10 44 44 No 59 880 0 0 880 Lead Prob. Cumulative Probability Random # Interval
14 44 88 9 9 35 35 No 700 0 0 700
15 35 46 10 10 25 25 No 500 0 0 500 1 0.44 0.44 0-44
16 25 81 9 9 16 16 No 87 320 0 0 320 2 0.33 0.77 45-77
17 16 16 10 10 6 6 Yes 2 19 120 0 570 690 3 0.16 0.93 78-93
18 6 44 6 6 0 0 Yes 1 19 0 0 570 570 4 0.07 1 94-99
19 0 25 9 0 0 40 9 No 800 39150 0 39950
20 40 25 9 9 31 31 No 91 620 0 0 620 Ordering amount Reorder Point
21 31 2 11 11 20 20 No 400 0 0 400 20 10
22 20 9 9 9 11 11 No 220 0 0 220
23 11 5 9 9 2 2 Yes 2 25 40 0 570 610
24 2 29 8 2 0 0 6 Yes 86 2 26 0 26100 570 26670
214 170 279 44 8380 191400 5130 $ 204,910

Sheet3

customer interarrival time(min) arrival minute service type service time(min) minute out Queue length income inter arrival time
1 4 4 a La Carte 3 7 0 $ 3.00 service type prob cum. Prob price Time between arrivals No.of. Occurences prob cumulative(prob)
2 2 6 a La Carte 3 9 1 $ 3.00 Value meals 0.25 0.25 2.25 1 100 0.2 0.2
3 1 7 a La Carte 2 9 2 $ 3.00 a La Carte 0.75 1 3 2 150 0.3 0.5
4 2 9 Value meals 4 13 2 $ 2.25 3 125 0.25 0.75
5 3 12 Value meals 2 14 1 $ 2.25 Total income $ 123.75 4 100 0.2 0.95
6 1 13 a La Carte 1 14 2 $ 3.00 5 25 0.05 1
7 4 17 Value meals 4 21 0 $ 2.25
8 2 19 a La Carte 3 22 1 $ 3.00
9 2 21 a La Carte 3 24 2 $ 3.00
10 4 25 a La Carte 4 29 0 $ 3.00 service time (a La Carte)
11 1 26 a La Carte 4 30 1 $ 3.00 Time between arrivals No.of. Occurences prob cumulative(prob)
12 4 30 a La Carte 3 33 1 $ 3.00 1 50 0.1 0.1
13 2 32 a La Carte 4 36 1 $ 3.00 2 125 0.25 0.35
14 5 37 a La Carte 3 40 0 $ 3.00 3 175 0.35 0.7
15 4 41 a La Carte 2 43 0 $ 3.00 4 150 0.3 1
16 2 43 Value meals 4 47 1 $ 2.25
17 5 48 Value meals 3 51 0 $ 2.25
18 3 51 a La Carte 4 55 1 $ 3.00 service time (value meals)
19 2 53 a La Carte 1 54 1 $ 3.00 Time between arrivals No.of. Occurences prob cumulative(prob)
20 3 56 a La Carte 2 58 0 $ 3.00 1 100 0.2 0.2
21 1 57 a La Carte 4 61 1 $ 3.00 2 175 0.35 0.55
22 4 61 a La Carte 2 63 1 $ 3.00 3 125 0.25 0.8
23 1 62 a La Carte 2 64 1 $ 3.00 4 100 0.2 1
24 4 66 a La Carte 1 67 0 $ 3.00
25 2 68 a La Carte 2 70 0 $ 3.00
26 3 71 Value meals 3 74 0 $ 2.25
27 2 73 a La Carte 2 75 1 $ 3.00
28 1 74 Value meals 4 78 2 $ 2.25
29 3 77 Value meals 3 80 1 $ 2.25
30 3 80 a La Carte 3 83 1 $ 3.00
31 3 83 Value meals 3 86 1 $ 2.25
32 3 86 a La Carte 3 89 1 $ 3.00
33 2 88 Value meals 2 90 1 $ 2.25
34 2 90 Value meals 4 94 1 $ 2.25
35 4 94 a La Carte 2 96 1 $ 3.00
36 2 96 Value meals 3 99 1 $ 2.25
37 2 98 a La Carte 3 101 1 $ 3.00
38 4 102 a La Carte 2 104 0 $ 3.00
39 4 106 Value meals 3 109 0 $ 2.25
40 1 107 a La Carte 2 109 1 $ 3.00
41 1 108 a La Carte 3 111 2 $ 3.00
42 4 112 Value meals 2 114 0 $ 2.25
43 1 113 Value meals 2 115 1 $ 2.25
44 3 116 a La Carte 4 120 0 $ 3.00
45 2 118 a La Carte 3 121 1 $ 3.00
46 4 Closed Closed Closed Closed 0 $ - 0
47 Closed Closed Closed Closed Closed 0 $ - 0
48 Closed Closed Closed Closed Closed 0 $ - 0
49 Closed Closed Closed Closed Closed 0 $ - 0
50 Closed Closed Closed Closed Closed 0 $ - 0
51 Closed Closed Closed Closed Closed 0 $ - 0
52 Closed Closed Closed Closed Closed 0 $ - 0
53 Closed Closed Closed Closed Closed 0 $ - 0
54 Closed Closed Closed Closed Closed 0 $ - 0
55 Closed Closed Closed Closed Closed 0 $ - 0
56 Closed Closed Closed Closed Closed 0 $ - 0
57 Closed Closed Closed Closed Closed 0 $ - 0
58 Closed Closed Closed Closed Closed 0 $ - 0
59 Closed Closed Closed Closed Closed 0 $ - 0
60 Closed Closed Closed Closed Closed 0 $ - 0
61 Closed Closed Closed Closed Closed 0 $ - 0
62 Closed Closed Closed Closed Closed 0 $ - 0
63 Closed Closed Closed Closed Closed 0 $ - 0
64 Closed Closed Closed Closed Closed 0 $ - 0
65 Closed Closed Closed Closed Closed 0 $ - 0
66 Closed Closed Closed Closed Closed 0 $ - 0
67 Closed Closed Closed Closed Closed 0 $ - 0
68 Closed Closed Closed Closed Closed 0 $ - 0
69 Closed Closed Closed Closed Closed 0 $ - 0
70 Closed Closed Closed Closed Closed 0 $ - 0
71 Closed Closed Closed Closed Closed 0 $ - 0
72 Closed Closed Closed Closed Closed 0 $ - 0
73 Closed Closed Closed Closed Closed 0 $ - 0
74 Closed Closed Closed Closed Closed 0 $ - 0
75 Closed Closed Closed Closed Closed 0 $ - 0
76 Closed Closed Closed Closed Closed 0 $ - 0
77 Closed Closed Closed Closed Closed 0 $ - 0
78 Closed Closed Closed Closed Closed 0 $ - 0
79 Closed Closed Closed Closed Closed 0 $ - 0
80 Closed Closed Closed Closed Closed 0 $ - 0
81 Closed Closed Closed Closed Closed 0 $ - 0
82 Closed Closed Closed Closed Closed 0 $ - 0
83 Closed Closed Closed Closed Closed 0 $ - 0
84 Closed Closed Closed Closed Closed 0 $ - 0
85 Closed Closed Closed Closed Closed 0 $ - 0
86 Closed Closed Closed Closed Closed 0 $ - 0
87 Closed Closed Closed Closed Closed 0 $ - 0
88 Closed Closed Closed Closed Closed 0 $ - 0
89 Closed Closed Closed Closed Closed 0 $ - 0
90 Closed Closed Closed Closed Closed 0 $ - 0
91 Closed Closed Closed Closed Closed 0 $ - 0
92 Closed Closed Closed Closed Closed 0 $ - 0
93 Closed Closed Closed Closed Closed 0 $ - 0
94 Closed Closed Closed Closed Closed 0 $ - 0
95 Closed Closed Closed Closed Closed 0 $ - 0
96 Closed Closed Closed Closed Closed 0 $ - 0
97 Closed Closed Closed Closed Closed 0 $ - 0
98 Closed Closed Closed Closed Closed 0 $ - 0
99 Closed Closed Closed Closed Closed 0 $ - 0
100 Closed Closed Closed Closed Closed 0 $ - 0
101 Closed Closed Closed Closed Closed 0 $ - 0
102 Closed Closed Closed Closed Closed 0 $ - 0
103 Closed Closed Closed Closed Closed 0 $ - 0
104 Closed Closed Closed Closed Closed 0 $ - 0
105 Closed Closed Closed Closed Closed 0 $ - 0
106 Closed Closed Closed Closed Closed 0 $ - 0
107 Closed Closed Closed Closed Closed 0 $ - 0
108 Closed Closed Closed Closed Closed 0 $ - 0
109 Closed Closed Closed Closed Closed 0 $ - 0
110 Closed Closed Closed Closed Closed 0 $ - 0
111 Closed Closed Closed Closed Closed 0 $ - 0
112 Closed Closed Closed Closed Closed 0 $ - 0
113 Closed Closed Closed Closed Closed 0 $ - 0
114 Closed Closed Closed Closed Closed 0 $ - 0
115 Closed Closed Closed Closed Closed 0 $ - 0
116 Closed Closed Closed Closed Closed 0 $ - 0
117 Closed Closed Closed Closed Closed 0 $ - 0
118 Closed Closed Closed Closed Closed 0 $ - 0
119 Closed Closed Closed Closed Closed 0 $ - 0
120 Closed Closed Closed Closed Closed 0 $ - 0