8 hours

May00
Simulation1.xls
Home>Business & Finance homework help>8 hours

Model

Last-Minute Gifts Model To run a trial of 20 days, press the F9 key
Decision variables
Min. capacity/all steps/day 1
Max capacity/step/day Step 1 6
Max capacity/step/day Step 2 6
Max capacity/step/day Step 3 6
Max capacity/step/day Step 4 6
Max capacity/step/day Step 5 6
Min. demand/day 1
Max. demand/day 6
Total demand & delivery Total holding cost Total slack Correlation Holds-Slack
Total demand 77 Holds $/Hold Hold$ Slack -0.35
Total shipped 53 Step 1 161 $1 $161 Step 1 0
Total not shipped 24 Step 2 42 $2 $84 Step 2 8
% shipped 68.83% Step 3 37 $3 $111 Step 3 12
% not shipped 31.17% Step 4 50 $5 $250 Step 4 4
Step 5 41 $7 $287 Step 5 16
Total 331 $893 40
Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
Demand 6 3 5 3 6 4 2 5 4 5 4 5 4 1 1 5 4 3 3 4
Step 1 Starts with 0 2 0 4 5 8 8 9 9 12 11 11 10 11 6 6 9 10 11 10
Receives 6 3 5 3 6 4 2 5 4 5 4 5 4 1 1 5 4 3 3 4
Has 6 5 5 7 11 12 10 14 13 17 15 16 14 12 7 11 13 13 14 14
Capacity 4 5 1 2 3 4 1 5 1 6 4 6 3 6 1 2 3 2 4 5
Moves 4 5 1 2 3 4 1 5 1 6 4 6 3 6 1 2 3 2 4 5
Holds 2 0 4 5 8 8 9 9 12 11 11 10 11 6 6 9 10 11 10 9
Slack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Holding Cost $2 $0 $4 $5 $8 $8 $9 $9 $12 $11 $11 $10 $11 $6 $6 $9 $10 $11 $10 $9
Step 2 Starts with 0 0 4 4 4 5 3 1 4 0 1 1 3 5 5 2 0 0 0 0
Receives 4 5 1 2 3 4 1 5 1 6 4 6 3 6 1 2 3 2 4 5
Has 4 5 5 6 7 9 4 6 5 6 5 7 6 11 6 4 3 2 4 5
Capacity 4 1 1 2 2 6 3 2 5 5 4 4 1 6 4 6 6 5 4 5
Moves 4 1 1 2 2 6 3 2 5 5 4 4 1 6 4 4 3 2 4 5
Holds 0 4 4 4 5 3 1 4 0 1 1 3 5 5 2 0 0 0 0 0
Slack 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2 3 3 0 0
Holding Cost $0 $8 $8 $8 $10 $6 $2 $8 $0 $2 $2 $6 $10 $10 $4 $0 $0 $0 $0 $0
Step 3 Starts with 0 0 0 0 0 0 2 0 1 1 1 2 2 0 1 2 5 3 4 5
Receives 4 1 1 2 2 6 3 2 5 5 4 4 1 6 4 4 3 2 4 5
Has 4 1 1 2 2 6 5 2 6 6 5 6 3 6 5 6 8 5 8 10
Capacity 4 5 2 6 3 4 5 1 5 5 3 4 5 5 3 1 5 1 3 2
Moves 4 1 1 2 2 4 5 1 5 5 3 4 3 5 3 1 5 1 3 2
Holds 0 0 0 0 0 2 0 1 1 1 2 2 0 1 2 5 3 4 5 8
Slack 0 4 1 4 1 0 0 0 0 0 0 0 2 0 0 0 0 0 0 0
Holding Cost $0 $0 $0 $0 $0 $6 $0 $3 $3 $3 $6 $6 $0 $3 $6 $15 $9 $12 $15 $24
Step 4 Starts with 0 1 0 0 1 1 0 4 0 4 8 6 4 5 5 3 3 3 2 0
Receives 4 1 1 2 2 4 5 1 5 5 3 4 3 5 3 1 5 1 3 2
Has 4 2 1 2 3 5 5 5 5 9 11 10 7 10 8 4 8 4 5 2
Capacity 3 3 2 1 2 5 1 5 1 1 5 6 2 5 5 1 5 2 5 4
Moves 3 2 1 1 2 5 1 5 1 1 5 6 2 5 5 1 5 2 5 2
Holds 1 0 0 1 1 0 4 0 4 8 6 4 5 5 3 3 3 2 0 0
Slack 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 2
Holding Cost $5 $0 $0 $5 $5 $0 $20 $0 $20 $40 $30 $20 $25 $25 $15 $15 $15 $10 $0 $0
Step 5 Starts with 0 0 0 0 0 1 1 0 0 0 0 4 5 4 3 4 0 4 2 6
Receives 3 2 1 1 2 5 1 5 1 1 5 6 2 5 5 1 5 2 5 2
Has 3 2 1 1 2 6 2 5 1 1 5 10 7 9 8 5 5 6 7 8
Capacity 3 3 5 6 1 5 2 5 1 6 1 5 3 6 4 6 1 4 1 1
Moves 3 2 1 1 1 5 2 5 1 1 1 5 3 6 4 5 1 4 1 1
Holds 0 0 0 0 1 1 0 0 0 0 4 5 4 3 4 0 4 2 6 7
Slack 0 1 4 5 0 0 0 0 0 5 0 0 0 0 0 1 0 0 0 0
Holding Cost $0 $0 $0 $0 $7 $7 $0 $0 $0 $0 $28 $35 $28 $21 $28 $0 $28 $14 $42 $49
Daily Day 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
totals Demand 6 3 5 3 6 4 2 5 4 5 4 5 4 1 1 5 4 3 3 4
Avg. capacity 3.60 3.40 2.20 3.40 2.20 4.80 2.40 3.60 2.60 4.60 3.40 5.00 2.80 5.60 3.40 3.20 4.00 2.80 3.40 3.40
Delivered 3 2 1 1 1 5 2 5 1 1 1 5 3 6 4 5 1 4 1 1
Holds 3 4 8 10 15 14 14 14 17 21 24 24 25 20 17 17 20 19 21 24
Holding cost $7 $8 $12 $18 $30 $27 $31 $20 $35 $56 $77 $77 $74 $65 $59 $39 $62 $47 $67 $82
Cum hold cost $7 $15 $27 $45 $75 $102 $133 $153 $188 $244 $321 $398 $472 $537 $596 $635 $697 $744 $811 $893
Slack 0 6 6 9 1 0 0 0 0 5 0 0 2 0 0 3 3 3 0 2
Correlation Holds-Slack
-0.3510580065

Model
Holds
Holding cost

Multiple Runs
Demand
Avg. capacity

Summary
Holds
Slack
WIP Holding Costs Totals Slack
Run Demand Shipments Step 1 Step 2 Step 3 Step 4 Step 5 Holds Holding Cost Step 1 Step 2 Step 3 Step 4 Step 5 Total
77 53 $161 $84 $111 $250 $287 331 $893 0 8 12 4 16 40
1 58 46 $75 $86 $45 $90 $112 167 $408 1 1 9 10 6 19 45
2 71 51 $92 $74 $93 $300 $98 234 $657 2 0 15 12 21 15 63
3 75 48 $99 $324 $132 $200 $189 372 $944 3 4 16 18 28 34 100
4 94 56 $230 $162 $126 $155 $161 407 $834 4 0 6 5 32 13 56
5 77 52 $201 $24 $39 $115 $133 268 $512 5 4 10 12 3 18 47
6 66 47 $77 $50 $168 $405 $189 266 $889 6 3 3 13 12 13 44
7 65 52 $112 $32 $84 $75 $119 188 $422 7 6 8 17 28 35 94
8 67 42 $149 $46 $183 $15 $21 239 $414 8 0 14 17 24 10 65
9 72 44 $59 $130 $273 $595 $189 361 $1,246 9 2 20 21 15 13 71
10 81 49 $44 $204 $504 $110 $238 370 $1,100 10 3 6 28 8 23 68
11 66 48 $134 $44 $120 $150 $119 243 $567 11 1 24 20 9 13 67
12 62 52 $27 $124 $30 $105 $301 163 $587 12 3 7 17 15 25 67
13 77 41 $143 $66 $417 $265 $455 433 $1,346 13 5 8 17 14 24 68
14 59 47 $72 $88 $18 $70 $84 148 $332 14 4 10 8 3 21 46
15 74 47 $115 $192 $132 $10 $140 277 $589 15 9 7 11 22 30 79
16 69 55 $46 $94 $12 $200 $252 173 $604 16 29 22 20 26 19 116
17 67 48 $89 $38 $60 $140 $119 173 $446 17 3 3 14 17 23 60
18 66 49 $59 $188 $36 $105 $315 231 $703 18 4 8 9 10 20 51
19 79 62 $103 $106 $84 $260 $231 269 $784 19 13 11 20 37 17 98
20 70 45 $212 $36 $39 $120 $91 280 $498 20 12 30 29 26 30 127
21 74 49 $78 $50 $75 $640 $98 270 $941 21 8 4 13 8 24 57
22 56 43 $70 $24 $27 $15 $91 107 $227 22 4 3 2 14 21 44
23 78 61 $74 $96 $114 $140 $119 205 $543 23 3 6 15 16 13 53
24 63 46 $42 $22 $60 $265 $0 126 $389 24 0 19 22 34 15 90
25 63 53 $44 $60 $135 $285 $294 218 $818 25 0 5 9 18 15 47
26 82 48 $202 $4 $108 $160 $280 312 $754 26 3 10 15 18 16 62
27 67 52 $98 $18 $99 $100 $14 162 $329 27 8 13 15 3 13 52
28 56 45 $39 $22 $30 $70 $56 82 $217 28 5 11 33 30 15 94
29 81 47 $267 $86 $111 $135 $49 381 $648 29 4 18 26 18 35 101
30 67 45 $149 $34 $105 $85 $56 226 $429 30 5 13 10 25 4 57
31 74 54 $81 $66 $390 $55 $210 285 $802 31 0 2 19 22 10 53
32 76 45 $23 $330 $297 $445 $91 389 $1,186 32 0 8 13 16 22 59
33 60 54 $13 $74 $87 $40 $98 101 $312 33 4 11 14 24 16 69
34 45 38 $14 $28 $48 $90 $112 78 $292 34 9 18 22 20 1 70
35 65 51 $62 $186 $12 $60 $56 179 $376 35 8 7 5 17 15 52
36 68 60 $83 $64 $66 $95 $77 167 $385 36 3 37 8 14 23 85
37 65 52 $35 $56 $282 $115 $84 192 $572 37 4 7 3 31 25 70
38 76 52 $192 $280 $93 $85 $84 392 $734 38 0 8 4 20 24 56
39 64 56 $20 $74 $90 $100 $161 130 $445 39 20 19 20 22 17 98
40 76 51 $102 $240 $78 $235 $126 313 $781 40 4 2 22 30 18 76
41 78 53 $127 $118 $168 $190 $273 319 $876 41 11 26 13 13 36 99
42 70 46 $138 $100 $102 $225 $294 309 $859 42 3 8 5 25 15 56
43 70 49 $44 $100 $333 $255 $182 282 $914 43 11 18 2 17 18 66
44 63 45 $59 $208 $54 $115 $63 213 $499 44 9 11 15 9 16 60
45 71 45 $37 $234 $78 $245 $266 267 $860 45 5 18 11 31 25 90
46 78 51 $175 $134 $93 $130 $168 323 $700 46 0 6 13 6 29 54
47 76 49 $40 $104 $267 $705 $140 342 $1,256 47 22 5 20 16 28 91
48 83 52 $137 $130 $234 $210 $532 398 $1,243 48 7 25 14 35 18 99
49 71 50 $105 $164 $90 $40 $126 243 $525 49 10 12 22 25 23 92
50 64 45 $61 $50 $33 $210 $56 147 $410 50 14 6 15 33 19 87
51 74 39 $26 $282 $423 $40 $378 370 $1,149 51 0 8 5 6 24 43
52 58 39 $90 $256 $102 $145 $21 284 $614 52 0 15 30 40 16 101
53 66 43 $62 $178 $141 $225 $245 278 $851 53 1 15 17 19 31 83
54 64 37 $27 $176 $426 $120 $175 306 $924 54 16 17 10 8 28 79
55 72 50 $30 $120 $222 $280 $105 235 $757 55 0 15 32 25 32 104
56 88 55 $56 $226 $198 $100 $266 293 $846 56 8 2 16 10 20 56
57 68 44 $163 $100 $105 $75 $84 275 $527 57 2 10 8 22 18 60
58 76 47 $82 $200 $72 $295 $112 281 $761 58 16 6 10 19 24 75
59 76 58 $131 $52 $114 $95 $126 232 $518 59 1 2 9 28 29 69
60 67 49 $53 $326 $36 $270 $126 300 $811 60 9 23 18 10 14 74
61 74 52 $87 $52 $138 $160 $154 213 $591 61 5 20 18 23 29 95
62 62 47 $129 $48 $177 $150 $175 267 $679 62 3 9 24 23 22 81
63 72 58 $70 $140 $60 $55 $98 185 $423 63 5 8 20 27 18 78
64 69 53 $40 $100 $192 $105 $273 214 $710 64 3 15 10 12 10 50
65 68 49 $59 $138 $402 $105 $413 342 $1,117 65 16 21 15 20 31 103
66 57 48 $20 $48 $111 $155 $91 125 $425 66 1 19 21 17 24 82
67 66 46 $88 $46 $108 $340 $147 236 $729 67 25 15 5 28 21 94
68 74 48 $254 $66 $39 $145 $161 352 $665 68 4 12 18 20 10 64
69 61 54 $48 $38 $15 $125 $203 126 $429 69 4 5 15 18 23 65
70 67 50 $37 $88 $138 $345 $280 236 $888 70 23 9 6 31 26 95
71 65 46 $95 $66 $39 $300 $126 219 $626 71 8 33 19 20 24 104
72 75 49 $218 $62 $36 $110 $245 318 $671 72 23 14 25 22 29 113
73 80 51 $93 $332 $138 $250 $329 402 $1,142 73 8 0 12 21 10 51
74 69 48 $94 $248 $45 $95 $84 264 $566 74 19 24 19 21 12 95
75 87 54 $154 $40 $105 $990 $77 418 $1,366 75 13 21 13 22 14 83
76 67 47 $51 $30 $174 $135 $343 200 $733 76 13 17 19 25 7 81
77 72 51 $53 $156 $198 $95 $77 227 $579 77 9 7 9 4 30 59
78 82 48 $244 $162 $129 $210 $245 445 $990 78 9 22 12 10 24 77
79 71 39 $137 $38 $129 $60 $791 324 $1,155 79 14 13 10 6 28 71
80 72 54 $87 $90 $156 $150 $203 243 $686 80 4 15 20 28 25 92
81 61 44 $49 $34 $3 $115 $7 91 $208 81 3 16 2 30 23 74
82 77 52 $154 $232 $180 $180 $203 395 $949 82 4 4 16 20 20 64
83 55 48 $66 $26 $24 $15 $147 111 $278 83 18 5 8 24 16 71
84 78 34 $100 $118 $114 $920 $35 386 $1,287 84 1 12 9 8 4 34
85 61 50 $50 $116 $87 $15 $273 179 $541 85 1 0 13 34 23 71
86 75 50 $239 $54 $114 $95 $56 331 $558 86 20 10 28 14 22 94
87 71 53 $51 $354 $123 $70 $161 306 $759 87 1 10 36 25 15 87
88 62 40 $25 $110 $162 $685 $210 301 $1,192 88 2 11 6 21 20 60
89 73 39 $28 $566 $27 $130 $35 351 $786 89 10 20 13 24 12 79
90 57 42 $42 $22 $315 $25 $70 173 $474 90 18 22 3 18 26 87
91 69 55 $42 $62 $48 $105 $224 142 $481 91 9 6 12 18 17 62
92 65 50 $55 $42 $93 $330 $77 184 $597 92 12 19 32 23 16 102
93 77 47 $96 $132 $135 $40 $238 249 $641 93 7 23 20 26 23 99
94 66 49 $70 $230 $60 $55 $133 235 $548 94 23 15 12 16 16 82
95 68 47 $18 $100 $438 $135 $315 286 $1,006 95 4 13 15 9 7 48
96 53 42 $18 $24 $177 $115 $252 148 $586 96 11 29 19 25 23 107
97 59 53 $42 $60 $135 $390 $224 227 $851 97 3 31 10 26 14 84
98 63 50 $50 $92 $78 $225 $273 206 $718 98 12 7 17 22 27 85
99 68 44 $68 $196 $87 $100 $84 227 $535 99 27 10 8 19 31 95
100 75 54 $78 $68 $108 $245 $140 217 $639 100 10 27 35 21 41 134
Demand Shipments Step 1 Step 2 Step 3 Step 4 Step 5 Holds Average Holding Cost Step 1 Step 2 Step 3 Step 4 Step 5 Average Total Slack
Average: 69.54 48.68 $89.40 $117.72 $132.09 $188.02 $172.37 254.51 $699.59 Average: 7.41 12.90 15.14 19.58 20.29 75.32
Percent shipped: 70.00% Min holding cost $208.00 Min slack 34.00
Percent holds: 30.00% Max holding cost $1,366 Max slack 134.00
St. dev. holding cost 273.541 St. dev. slack 20.47
Multiple run summary
Min. capacity/all steps/day 1
Max capacity/step/day Step 1 6
Max capacity/step/day Step 2 6
Max capacity/step/day Step 3 6
Max capacity/step/day Step 4 6
Max capacity/step/day Step 5 6
Min. demand/day 1
Max. demand/day 6
Production data
Demand Shipments Step 1 Step 2 Step 3 Step 4 Step 5 Holds Average Holding Cost
Average: 69.54 48.68 89.40 117.72 132.09 188.02 172.37 254.51 $699.59
Percent shipped: 70.00% Min holding cost $208.00
Percent holds: 30.00% Max holding cost $1,366.00
St. dev. holding cost $273.54
Slack data
Step 1 Step 2 Step 3 Step 4 Step 5 Average Total Slack
Average: 7.41 12.90 15.14 19.58 20.29 75.32
Min slack 34.00
Max slack 134.00
St. dev. slack 20.47