OPS 928 Logistics Systems
Exercise 2
Daily Demand at Alloy Steel over Two-Week Period
Monday Tuesday Wednesday Thursday Friday Saturday
Week 1 19,970 17,470 11,316 26,192 20,263 8,381
Week 2 39,171 2,158 20,633 23,370 24,100 19,603
Two-day Response Time
Day Demand Quantity Shipped Cost ($)
1 19,970 19,970 299.70
2 17,470 17,470 274.70
3 11,316 11,316 213.16
4 26,192 26,192 361.92
5 20,263 20,263 302.63
6 8,381 8,381 183.81
7 25,377 25,377 353.77
8 39,171 39,171 491.71
9 2,158 2,158 121.58
10 20,633 20,633 306.33
11 23,370 23,370 333.70
12 24,100 24,100 341.00
13 19,603 19,603 296.03
14 18,442 18,442 284.42
276,446.00 276,446.00 $ 4,164.46
Sunday
25,377
18,442
OPS 928 Logistics Systems
Exercise 2
Daily Demand at Alloy Steel over Two-Week Period
Monday Tuesday Wednesday Thursday Friday Saturday Sunday
Week 1 19,970 17,470 11,316 26,192 20,263 8,381 25,377
Week 2 39,171 2,158 20,633 23,370 24,100 19,603 18,442
Two-day Response Three-day Response
Day Demand Quantity Shipped Cost ($) Quantity Shipped2 Cost ($)3
1 19,970 19,970 299.70 - -
2 17,470 17,470 274.70 37,440 474.4
3 11,316 11,316 213.16 - -
4 26,192 26,192 361.92 37,508 475.08
5 20,263 20,263 302.63 - -
6 8,381 8,381 183.81 28,644 386.44
7 25,377 25,377 353.77 - -
8 39,171 39,171 491.71 64,548 745.48
9 2,158 2,158 121.58 - -
10 20,633 20,633 306.33 22,791 327.91
11 23,370 23,370 333.70 - -
12 24,100 24,100 341.00 47,470 574.7
13 19,603 19,603 296.03 - -
14 18,442 18,442 284.42 38,045 480.45
276,446.00 276,446.00 4,164.46 276,446.00 3,464.46
700.00
OPS 928 Logistics Systems
Exercise 2
Daily Demand at Alloy Steel over Two-Week Period
Monday Tuesday Wednesday Thursday Friday Saturday
Week 1 19,970 17,470 11,316 26,192 20,263 8,381
Week 2 39,171 2,158 20,633 23,370 24,100 19,603
Two-day Response Three-day Response Four-day Response
Day Demand Quantity Shipped Cost ($) Quantity Shipped2 Cost ($)3 Quantity Shipped4
1 19,970 19,970 299.70 - - -
2 17,470 17,470 274.70 37,440.00 474.40 -
3 11,316 11,316 213.16 - - 48,756.00
4 26,192 26,192 361.92 37,508.00 475.08 -
5 20,263 20,263 302.63 - - -
6 8,381 8,381 183.81 28,644.00 386.44 54,836.00
7 25,377 25,377 353.77 - - -
8 39,171 39,171 491.71 64,548.00 745.48 -
9 2,158 2,158 121.58 - - 66,706.00
10 20,633 20,633 306.33 22,791.00 327.91 -
11 23,370 23,370 333.70 - - -
12 24,100 24,100 341.00 47,470.00 574.70 68,103.00
13 19,603 19,603 296.03 - - -
14 18,442 18,442 284.42 38,045.00 480.45 38,045.00
276,446.00 276,446.00 $ 4,164.46 276,446.00 $ 3,464.46 276,446.00
700.00
Sunday
25,377
18,442
ur-day Response
Cost ($)5
-
-
587.56
-
-
648.36
-
-
767.06
-
-
781.03
-
480.45
$ 3,264.46
200.00
OPS 928 Logistics Systems
Exercise 2
Daily Demand at Alloy Steel over Two-Week Period
Monday Tuesday Wednesday Thursday Friday Saturday Sunday
Week 1 19,970 17,470 11,316 26,192 20,263 8,381 25,377
Week 2 39,171 2,158 20,633 23,370 24,100 19,603 18,442
Two-day Response Three-day Response Four-day Response
Day Demand Quantity Shipped Cost ($) Quantity Shipped Cost ($) Quantity ShippCost ($)
1 19,970 19,970 299.70 - - - -
2 17,470 17,470 274.70 37,440 474.4 - -
3 11,316 11,316 213.16 - - 48,756 587.56
4 26,192 26,192 361.92 37,508 475.08 - -
5 20,263 20,263 302.63 - - - -
6 8,381 8,381 183.81 28,644 386.44 54,836 648.36
7 25,377 25,377 353.77 - - - -
8 39,171 39,171 491.71 64,548 745.48 - -
9 2,158 2,158 121.58 - - 66,706 767.06
10 20,633 20,633 306.33 22,791 327.91 - -
11 23,370 23,370 333.70 - - - -
12 24,100 24,100 341.00 47,470 574.7 68,103 781.03
13 19,603 19,603 296.03 - - - -
14 18,442 18,442 284.42 38,045 480.45 38,045 480.45
276,446.00 276,446.00 4,164.46 276,446.00 3,464.46 276,446.00 3,264.46
700.00 200.00