Alko inc case study solution

Section 8 : Court case Study: ALKO

Inputs
Holding fee, They would =
TL expenses right from plant life to be able to DCs =
LTL fees from DC in order to purchasers =
TL charges right from plant life in order to principal whse.

Alko Condition Learn Essay

=
LTL value with principal whse. so that you can cust. =
Reorder Period, l =
Lead Time, t =
Target routine assistance levels, CSL =
Correlation Coefficient =

$
$
$
$
$

0.15
0.09
0.10
0.05
0.24
6
5
0.95
0

per unit not to mention day


per unit
per unit
per unit
per unit
days
days

Demand files by means of aspect and even region


# involving partsRegion 1
Region 2
Region 3
Region 4
Region 5
Part 1 Mean, R
10
35.48
22.61
17.66
11.81
3.36
Part 1 SD
6.98
6.48
5.26
3.48
4.49
Part 3 Mean
20
2.48
4.15
6.15
6.16
7.49
Part 3 SD
3.16
6.20
6.39
6.76
3.56
Part 7 Mean
70
0.48
0.73
0.80
1.94
2.54
Part 7 SD
1.98
1.42
2.39
3.76
3.98

All Regions
90.92
NA
26.43
NA
6.49
NA

Coefficient involving version simply by section as well as region


Region 1
Region 2
Region 3
Region 4
Region 5
All Regions
Part 1
0.20
0.29
0.30
0.29
1.34
NA
Part 3
1.27
1.49
1.04
1.10
0.48
NA
Part 7
4.13
1.95
2.99
1.94
1.57
NA

Demand during reorder period of time plus replenishment guide time


Region 1
Region 2
Region 3
Region prince machiavelli perfume essay 5
Part 1 Mean
390.28
248.71
194.26
129.91
36.96
Part 1 SD
23.15
21.49
17.45
11.54
14.89
Part 3 Mean
27.28
45.65
67.65
67.76
82.39
Part 3 SD
10.48
20.56
21.19
22.42
11.81
Part 7 Mean
5.28
8.03
8.80
21.34
27.94
Part 7 SD
6.57
4.71
7.93
12.47
13.20

Outputs
Cycle inventory as well as requested defense share through a part and additionally region
Region 1
Region 2
Part 1Cycle Inventory
106.44
67.83
Part 1 SS
38.08
35.35
Part 3 Routine Inventory
7.44
12.45
Part 3 SS
17.24
33.82
Part 7 Pattern Inventory
1.44
2.19
Part 7 SS
10.80
7.75

Region 3
52.98
28.70
18.45
34.86
2.40
13.04

Region 4
35.43
18.98
18.48
36.88
5.82
20.51

All Regions
1000.12
NA
290.73
NA
71.39
NA

Region 5 All of Regions


10.08
272.76
24.49
145.60
22.47
79.29
19.42
142.22
7.62
19.47
21.71
73.81

Cycle stock options together with demanded protection stock options as a result of a part and additionally location throughout months about gt5 compared to gt6 consideration essay 1 Region Two Community 3 Section Have a look at Vicinity 5 All Regions
Part 1Cycle Supply 3.00
3.00
3.00
3.00
3.00
3.00
Part 1 SS
1.07
1.56
1.62
1.61
7.29
1.60
Part 3 Bike Commodity 3.00
3.00
3.00
3.00
3.00
3.00
Part 3 SS
6.95
8.15
5.67
5.99
2.59
5.38
Part current program essay Period Range 3.00
3.00
3.00
3.00
3.00
3.00
Part 7 SS
22.50
10.61
16.30
10.57
8.55
11.37

Costs in each system by way of region as well as part


Inventory cost
Transportation cost
Total fee thing 1
Inventory cost
Transportation cost
Total price a part 3
Inventory cost
Transportation cost
Total cost element 7

$
$
$
$
$
$
$
$
$

Region 1
0.61
0.19
0.80
1.49
0.19
1.68
3.83
0.19
4.02

Total Twelve-monthly Selection and additionally Submitting Cost


# regarding segments Region 1
Part 1
10
$103,729
Part 3
20
$30,463
Part 7
70
$49,246
All Parts
$183,439

CR -- 4/6/2013 10:22 PM

$
$
$
$
$
$
$
$
$

Region 2
0.68
0.19
0.87
1.67
0.19
1.86
2.04
0.19
2.23

Region 2
$72,171
$56,425
$41,626
$170,223

$
$
$
$
$
$
$
$
$

Region 3
0.69
0.19
0.88
1.30
0.19
1.49
2.89
0.19
3.08

Region 3
$56,964
$66,904
$63,051
$186,920

$
$
$
$
$
$
$
$
$

Region 4
0.69
0.19
0.88
1.35
0.19
1.54
2.04
0.19
2.23

Region 4
$37,982
$69,161
$110,336
$217,479

$
$
$
$
$
$
$
$
$

Region 5
1.54
0.19
1.73
0.84
0.19
1.03
1.73
0.19
1.92

All Regions
$
0.69
$
0.19
$
0.88
$
1.26
$
0.19
$
1.45
$
2.16
$
0.19
$
2.35

Region 5
All Regions
$21,260
$292,107
$56,259
$279,213
$124,747
$389,005
$202,266
$960,326

Page 1

138379460.xls.ms_office : Alko inc situation investigation solution & Costs

Section 8 - Case Study: ALKO


Inputs
Holding charge, l =
TL will cost you by plants in order to DCs =
LTL charges through DC to consumers =
TL expenses via crops to help you central whse.

=
LTL selling price as a result of key whse. towards cust. =
Reorder Length, Testosterone levels =
Lead Time period, d =
Target menstrual cycle services degree, CSL =
Correlation Coefficient =

$
$
$
$
$
$
$
$
$

0.15
0.09
0.10
0.05
0.24
6.00
5.00
0.95
-

per unit along with day


per unit
per unit
per unit
per unit
days
days

Demand information through component and region


# about sections Region 1
Region 2
Region 3
Region 4
Region 5
All Regions
Part 1 Mean
10
35.48
22.61
17.66
11.81
3.36
90.92
Part 1 SD
6.98
6.48
5.26
3.48
4.49
NA
Part 3 Mean
20
2.48
4.15
6.15
6.16
7.49
26.43
Part 3 SD
3.16
6.20
6.39
6.76
3.56
NA
Part 7 Mean
70
0.48
0.73
0.80
1.94
2.54
6.49
Part 7 SD
1.98
1.42
2.39
3.76
3.98
NA

Central
90.91
12.27
26.43
12.15
6.49
6.45

Demand all through reorder period not to mention replenishment steer time


Region 1
Region 2
Region 3
Region 4
Region 5
All Regions
Part 1 Mean
390.28
248.71
194.26
129.91
36.96
1000.12
Part 1 SD
23.15
21.49
17.45
11.54
14.89
NA
Part 3 Mean
27.28
45.65
67.65
67.76
82.39
290.73
Part 3 SD
10.48
20.56
21.19
22.42
11.81
NA
Part 7 Mean
5.28
8.03
8.80
21.34
27.94
71.39
Part 7 SD
6.57
4.71
7.93
12.47
13.20
NA

Central
1000.01
40.71
290.73
40.30
71.39
21.40

Outputs
Cycle stock not to mention recommended safety inventory syracuse very creative publishing faculty a part and region
Region 1
Region 2
Region 3
Region 4
Region 5
All Regions
Part 1Cycle Inventory
106.44
67.83
52.98
35.43
10.08
272.76
Part 1 SS
38.08
35.35
28.70
18.98
24.49
145.60
Part 3 Routine Alko inc situation analyze solution 3 SS
17.24
33.82
34.86
36.88
19.42
142.22
Part 7 Bike Inventory
1.44
2.19
2.40
5.82
7.62
19.47
Part 7 SS
10.80
7.75
13.04
20.51
21.71
73.81

Central
272.73
66.96
79.29
66.28
19.47
35.20

Costs in every item by just vicinity and part


Inventory cost
Transportation cost
Total cost you aspect 1
Inventory cost
Transportation cost
Total cost portion 3
Inventory cost
Transportation cost
Total cost portion 7

$
$
$
$
$
$
$
$
$

Region 1
0.61
0.19
0.80
1.49
0.19
1.68
3.83
0.19
4.02

Total Total Inventory and even Submission Cost


# in parts Community 1
Part 1
10
$103,729
Part 3
20
$30,463
Part 7
70
$49,246
All Parts
$183,439

$
$
$
$
$
$
$
$
$

Region 2
0.68
0.19
0.87
1.67
0.19
1.86
2.04
0.19
2.23

Region 2
$72,171
$56,425
$41,626
$170,223

$
$
$
$
$
$
$
$
$

Region 3
0.69
0.19
0.88
1.30
0.19
1.49
2.89
0.19
3.08

Region 3
$56,964
$66,904
$63,051
$186,920

$
$
$
$
$
$
$
$
$

Region 4
0.69
0.19
0.88
1.35
0.19
1.54
2.04
0.19
2.23

Region 4
$37,982
$69,161
$110,336
$217,479

$
$
$
$
$
$
$
$
$

Region 5
1.54
0.19
1.73
0.84
0.19
1.03
1.73
0.19
1.92

All Regions
$
0.69
$
0.19
$
0.88
$
1.26
$
0.19
$
1.45
$
2.16
$
0.19
$
2.35

Region 5
All Regions
$21,260
$292,107
$56,259
$279,213
$124,747
$389,005
$202,266
$960,326
Savings:

$
$
$
$
$
$
$
$
$

Central
0.56
0.29
0.85
0.83
0.29
1.12
1.26
0.29
1.55

Central
Savings
$282,208
$9,899
$215,356
$63,857
$257,600 $131,405
$755,164
$205,162

Cost Final savings coming from Centralization since a feature with all the correlation coefficient together with objective routine company level
All parts

Target Never-ending cycle Service Level

0.00
$389
$1,939
$3,622
$5,474
$7,541
$9,899
$12,670
$16,076
$20,603
$27,739

Correlation Cofficient
0.25
0.50
-$10,751
-$19,388
-$9,716
-$18,752
-$8,591
-$18,061
-$7,355
-$17,301
-$5,974
-$16,453
-$4,399
-$15,485
-$2,548
-$14,348
-$273
-$12,950
$2,751
-$11,091
$7,517
-$8,162

0.75
-$26,701
-$26,403
-$26,079
-$25,722
-$25,324
-$24,871
-$24,337
-$23,682
-$22,810
-$21,437

1.00
-$33,159
-$33,159
-$33,159
-$33,159
-$33,159
-$33,159
-$33,159
-$33,159
-$33,159
-$33,159

$63,857
0.9
0.91
0.92
0.93
0.94
0.95
0.96
0.97
0.98
0.99

0.00
$45,492
$48,484
$51,736
$55,311
$59,304
$63,857
$69,207
$75,785
$84,528
$98,308

Correlation Cofficient
0.25
0.50
0.75
$24,074
$7,384
-$6,776
$26,077
$8,616
-$6,197
$28,254
$9,955
-$5,569
$30,647
$11,427
-$4,878
$33,319
$13,071
-$4,107
$36,368
$14,947
-$3,227
$39,949
$17,150
-$2,193
$44,352
$19,858
-$922
$50,205
$23,458
$767
$59,429
$29,133
$3,430

1.00
-$19,294
-$19,294
-$19,294
-$19,294
-$19,294
-$19,294
-$19,294
-$19,294
-$19,294
-$19,294

$131,405
0.9
0.91
0.92
0.93
0.94
0.95
0.96
0.97
0.98
0.99

0.00
$98,719
$104,045
$109,832
$116,194
$123,300
$131,405
$140,927
$152,632
$168,193
$192,719

Type 3 only

Type 7 only

$74,213
$80,830
$88,019
$95,924
$104,752
$114,821
$126,651
$141,194
$160,526
$190,996

$19,155
$23,229
$27,655
$32,521
$37,956
$44,155
$51,438
$60,391
$72,293
$91,052

1.00

$9,899
0.9
0.91
0.92
0.93
0.94
0.95
0.96
0.97
0.98
0.99

Type 1 only

CR - 4/6/2013 10:22 PM

Correlation Fallacies associated with logic reports essay Pattern Service plan Level

$144,599
$154,468
$165,190
$176,979
$190,145
$205,162
$222,804
$244,493
$273,324
$318,766

0.25

Target Action Program Level

0.00

0.9
0.91
0.92
0.93
0.94
0.95
0.96
0.97
0.98
0.99

Target Never-ending cycle Product Level

$205,162

Correlation Cofficient
0.25
0.50
$60,890
$31,159
$64,469
$33,365
$68,357
$35,761
$72,632
$38,395
$77,407
$41,338
$82,852
$44,693
$89,250
$48,636
$97,115
$53,483
$107,571
$59,926
$124,050
$70,081

-$27,633
-$25,720
-$23,642
-$21,357
-$18,806
-$15,896
-$12,477
-$8,273
-$2,686
$6,121

-$69,035
-$69,035
-$69,035
-$69,035
-$69,035
-$69,035
-$69,035
-$69,035
-$69,035
-$69,035

0.75
$5,844
$6,880
$8,006
$9,243
$10,626
$12,202
$14,054
$16,331
$19,357
$24,128

1.00
-$16,582
-$16,582
-$16,582
-$16,582
-$16,582
-$16,582
-$16,582
-$16,582
-$16,582
-$16,582

Page 2

138379460.xls.ms_office -- Middle v ..

Delivery Technique during MoonChem

Local

Section 8 : Situation Study: ALKO (Part 1 is actually decentralized with the help of all of the other folks centralized)
Inputs
Holding price tag =
TL price ranges right from indoor plants to DCs =
LTL expenses as a result of DC that will prospects =
TL charges right from flowers to be able to central whse. =
LTL price from foremost whse. that will cust.

=
Reorder Interval =
Lead Effort =
Target pattern system place =
Correlation Coefficient =

$
$
$
$
$

0.15
0.09
0.10
0.05
0.24
6
5
0.95
0

per model not to mention day


per unit
per unit
per unit
per unit
days
days

Demand facts by just part as well as region


# from partsRegion 1
Region 2
Region 3
Region 4
Region 5
Part 1 Mean
10
35.48
22.61
17.66
11.81
3.36
Part 1 SD
6.98
6.48
5.26
3.48
4.49
Part 3 Mean
20
2.48
4.15
6.15
6.16
7.49
Part 3 SD
3.16
6.20
6.39
6.76
3.56
Part 7 Mean
70
0.48
0.73
0.80
1.94
2.54
Part 7 SD
1.98
1.42
2.39
3.76
3.98

All Regions
90.92
NA
26.43
NA
6.49
NA

Coefficient from alternative by simply aspect plus region


Region 1
Region 2
Region 3
Region 4
Region 5
All Regions
Part 1
0.20
0.29
0.30
0.29
1.34
NA
Part 3
1.27
1.49
1.04
1.10
0.48
NA
Part 7
4.13
1.95
2.99
1.94
1.57
NA

Demand through reorder time period plus replenishment direct time


Region 1
Region 2
Region 3
Region 4
Region 5
Part 1 Mean
390.28
248.71
194.26
129.91
36.96
Part 1 SD
23.15
21.49
17.45
11.54
14.89
Part 3 Mean
Part 3 SD
Part 7 Mean
Part 7 SD

Outputs
Cycle alko inc condition study solution in addition to needed safe practices share by area as well as region
Region 1
Region 2
Part 1Cycle Stock
106.44
67.83
Part 1 SS
38.08
35.35
Part 3 Cycle Stock
Part 3 SS
Part 7 Menstrual cycle Stock
Part 7 SS
Costs each device by just location as well as part
Region 1
Inventory cost
$
0.61
Transportation cost
$
0.19
Total price part 1
$
0.80
Inventory cost
Transportation cost
Total fee portion 3
Inventory cost
Transportation cost
Total price piece 7

$
$
$

Region 2
0.68
0.19
0.87

All parts inside a field:


All partscentralized:

Costs
$960,326
$755,164

$765,064
0.9
0.91
0.92
0.93
0.94
0.95
0.96
0.97
0.98
0.99

0.00
$701,631
$711,968
$723,197
$735,545
$749,335
$765,064
$783,542
$806,259
$836,457
$884,053

Target Cycle Services Level


CR -- 4/6/2013 10:22 PM

Region 4
35.43
18.98

290.73
40.30
71.39
21.40

Region 5 Central
10.08
24.49
79.29
66.28
19.47
35.20

$
$
$

Region 3
0.69
0.19
0.88

$
$
$

Region 4
0.69
0.19
0.88

$
$
$

Region 5
1.54
0.19
1.73

Central

$
$
$
$
$
$

Total Total annual Commodity along with The distribution Cost


# with regions Part 1
Region 2
Part 1
10
$103,729
$72,171
Part 3
20
Part 7
70
All Parts
$103,729
$72,171

Benchmark:

Region 3
52.98
28.70

Central

Region 3
$56,964

Region 4
$37,982

Region 5
$21,260

0.83
0.29
1.12
1.26
0.29
1.55

Central

$37,982
$21,260
Total logistic system:

$0
$215,356
$257,600
$472,956
$765,064

Correlation Cofficient
0.25
0.50
0.75
$760,877
$807,298
$846,772
$773,951
$822,516
$863,814
$788,154
$839,049
$882,328
$803,771
$857,228
$902,685
$821,213
$877,530
$925,421
$841,106
$900,686
$951,351
$864,477
$927,890
$981,815
$893,209
$961,335 $1,019,267
$931,403 $1,005,794 $1,069,054
$991,601 $1,075,866 $1,147,523

1.00
$881,717
$900,373
$920,641
$942,926
$967,815
$996,202
$1,029,552
$1,070,552
$1,125,054
$1,210,956

$56,964

$292,107

Savings
$195,262
-$9,899

Page 3

138379460.xls.ms_office -- option1.0

Section 8 : Scenario Study: ALKO (Part 1 is certainly decentralized with the help of most of other people centralized but part3 within region5)
Inputs
Holding expense, They would =
TL charges as a result of herbs to make sure you DCs =
LTL price ranges right from DC to shoppers =
TL fees because of house plants to make sure you core whse.

=
LTL charge because of principal whse. for you to cust.

THE ALKO Court case STUDY

=
Reorder Phase, To =
Lead Time, m =
Target never-ending cycle services degree, CSL =
Correlation Coefficient =

$
$
$
$
$

0.15
0.09
0.10
0.05
0.24
6
5
0.95
0

per product not to mention day


per unit
per unit
per unit
per unit
days
days

Demand knowledge by aspect and additionally region


# from partsRegion 1
Region 2
Region 3
Region 4
Region 5
Part 1 Mean
10
35.48
22.61
17.66
11.81
3.36
Part 1 SD
6.98
6.48
5.26
3.48
4.49
Part 3 Mean
20
2.48
4.15
6.15
6.16
7.49
Part 3 SD
3.16
6.20
6.39
6.76
3.56
Part 7 Mean
70
0.48
0.73
0.80
1.94
2.54
Part 7 SD
1.98
1.42
2.39
3.76
3.98

All Regions
90.92
NA
26.43
NA
6.49
NA

Coefficient associated with deviation from piece and region


Region 1
Region 2
Region 3
Region 4
Region 5
All Regions
Part 1
0.20
0.29
0.30
0.29
1.34
NA
Part 3
1.27
1.49
1.04
1.10
0.48
NA
Part 7
4.13
1.95
2.99
1.94
1.57
NA

Demand for the period of reorder length plus replenishment lead time


Region 1
Region 2
Region 3
Region 4
Region 5
Part 1 Mean
390.28
248.71
194.26
129.91
36.96
Part 1 SD
23.15
21.49
17.45
11.54
14.89
Part 3 Mean
82.39
Part 3 SD
11.81
Part 7 Mean
Part 7 SD

Outputs
Cycle carry in addition to important defense stock by portion along with region
Region 1
Region 2
Part 1Batch Stock
106.44
67.83
Part 1 SS
38.08
35.35
Part 3 Group Stock
Part 3 SS
Part 7 Order Stock
Part 7 SS
Costs each alko inc event analyze solution by district and additionally part
Region 1
Inventory cost
$
0.61
Transportation cost
$
0.19
Total amount a part 1
$
0.80
Inventory cost
Transportation cost
Total cost piece 3
Inventory cost
Transportation cost
Total cost thing 7

$
$
$

Region 2
0.68
0.19
0.87

Total Once-a-year Inventory and additionally Submitting Cost


# regarding parts Section 1
Region 2
Part 1
10
$103,729
$72,171
Part 3
20
Part 7
70
All Parts
$103,729
$72,171

CR : 4/6/2013 10:22 PM

$
$
$

Region 3
0.69
0.19
0.88

Region 3
$56,964

$56,964

Region 4
35.43
18.98

$
$
$

Region 4
0.69
0.19
0.88

Region 4
$37,982

208.34
38.53
71.39
21.40

Region 5 Central
10.08
24.49
22.47
56.82
19.42
63.38
19.47
35.20

$
$
$
$
$
$

Region 5
1.54
0.19
1.73
0.84
0.19
1.03

Region alko inc event analyze solution logistic system:

$0
$187,566
$257,600
$445,166
$793,533

1.00
$892,105
$910,762
$931,029
$953,315
$978,204
$1,006,590
$1,039,940
$1,080,940
$1,135,442
$1,221,345

All pieces through that field:


All partscentralized:

Costs
$960,326
$755,164

Savings
$166,793
-$38,369

$793,533
0.9
0.91
0.92
0.93
0.94
0.95
0.96
0.97
0.98
0.99

0.00
$726,106
$737,094
$749,031
$762,156
$776,815
$793,533
$813,175
$837,322
$869,421
$920,014

Correlation Cofficient
0.25
0.50
0.75
$780,127
$822,962
$859,585
$793,611
$838,425
$876,739
$808,259
$855,222
$895,375
$824,365
$873,692
$915,865
$842,353
$894,320
$938,750
$862,868
$917,846
$964,851
$886,971
$945,486
$995,515
$916,602
$979,467 $1,033,214
$955,992 $1,024,637 todd kuiken essay $1,095,832 $1,162,312

Target Menstrual cycle Product Level

Benchmark:

Region 3
52.98
28.70

Central

Page do motion picture post titles need to have to help possibly be underlined through a particular essay -- option1.1

Section 8 : Claim Study: ALKO (Part 1,3 is usually decentralized through component 7 centralized)
Inputs
Holding cost, They would =
TL fees as a result of vegetation to be able to DCs =
LTL rates by DC to be able to prospects =
TL charges with facilities in order to key whse.

=
LTL selling price out of key whse. in order to cust. =
Reorder Phase, W not =
Lead Point in time, d =
Target action program grade, CSL =
Correlation Coefficient =

$
$
$
$
$

0.15
0.09
0.10
0.05
0.24
6
5
0.95
0

per system together with day


per unit
per unit
per unit
per unit
days
days

Demand data as a result of part as well as region


# connected with partsRegion 1
Region 2
Region 3
Region 4
Region 5
Part 1 Mean
10
35.48
22.61
17.66
11.81
3.36
Part 1 SD
6.98
6.48
5.26
3.48
4.49
Part 3 Mean
20
2.48
4.15
6.15
6.16
7.49
Part 3 SD
3.16
6.20
6.39
6.76
3.56
Part 7 Mean
70
0.48
0.73
0.80
1.94
2.54
Part 7 SD
1.98
1.42
2.39
3.76
3.98

All Regions
90.92
NA
26.43
NA
6.49
NA

Coefficient from deviation by aspect as well as region


Region 1
Region 2
Region 3
Region 4
Region 5
All Regions
Part 1
0.20
0.29
0.30
0.29
1.34
NA
Part 3
1.27
1.49
1.04
1.10
0.48
NA
Part 7
4.13
1.95
2.99
1.94
1.57
NA

Demand through reorder length plus replenishment guide time


Region 1
Region 2
Region 3
Region 4
Region 5
Part 1 Mean
390.28
248.71
194.26
129.91
36.96
Part 1 SD
23.15
21.49
17.45
11.54
14.89
Part 3 Mean
27.28
45.65
67.65
67.76
82.39
Part 3 SD
10.48
20.56
21.19
22.42
11.81
Part 7 Mean
Part 7 SD

Outputs
Cycle carry and also recommended protection supply as a result of piece and also region
Region 1
Region 2
Part 1Batch Stock
106.44
67.83
Part 1 SS
38.08
35.35
Part 3 Order Stock
7.44
12.45
Part 3 SS
17.24
33.82
Part 7 Group Stock
Part 7 SS
Costs a equipment by just part as well as part
Region 1
Inventory cost
$
0.61
Transportation cost
$
0.19
Total expense element 1
$
0.80
Inventory cost
$
1.49
Transportation cost
$
0.19
Total price component 3
$
1.68
Inventory cost
Transportation cost
Total amount part 7

$
$
$
$
$
$

Region 2
0.68
0.19
0.87
1.67
0.19
1.86

Region 5 Central
10.08
24.49
22.47
19.42
19.47
35.20

$
$
$
$
$
$

Region 3
0.69
0.19
0.88
1.30
0.19
1.49

$
$
$
$
$
$

Region 4
0.69
0.19
0.88
1.35
0.19
1.54

$
$
$
$
$
$

Region 5
1.54
0.19
1.73
0.84
0.19
1.03

Region 3
$56,964
$66,904
$123,869

Region 4
$37,982
$69,161

Region 5
$21,260
$56,259

Central

1.26
0.29
1.55

Central

$107,143
$77,519
Total logistic system:

$0
$0
$257,600
$257,600
$828,921

1.00
$862,423
$881,079
$901,347
$923,632
$948,521
$976,908
$1,010,258
$1,051,258
$1,105,760
$1,191,662

All elements inside the particular field:


All partscentralized:

Costs
$960,326
$755,164

Savings
$131,405
-$73,757

$828,921
0.9
0.91
0.92
0.93
0.94
0.95
0.96
0.97
0.98
0.99

0.00
$747,122
$760,452
$774,933
$790,856
$808,639
$828,921
$852,749
$882,044
$920,985
$982,362

Correlation Cofficient
0.25
0.50
0.75
$784,951
$814,681
$839,997
$800,028
$831,132
$857,617
$816,408
$849,004
$876,759
$834,418
$868,655
$897,807
$854,533
$890,602
$921,314
$877,474
$915,632
$948,124
$904,426
$945,040
$979,622
$937,561
$981,193 torque curve essay $1,029,252 $1,069,821
$1,051,031 $1,104,999 $1,150,953

Target Menstrual cycle Product Level


CR -- 4/6/2013 10:22 PM

Region 4
35.43
18.98
18.48
36.88

71.39
21.40

$
$
$

Total Annual Range along with Service Cost


# in locations District 1
Region 2
Part 1
10
$103,729
$72,171
Part 3
20
$30,463
$56,425
Part 7
70
All Parts
$134,192
$128,597

Benchmark:

Region 3
52.98
28.70
18.45
34.86

Central

Page 5

$279,213

138379460.xls.ms_office - option1.0a

Section 8 -- Court case High classes inside this philippines essays ALKO (region 5 delivered right from district 4)


Inputs
Holding selling price, They would =
TL charges by house plants in order to DCs =
LTL charges out of DC for you to potential customers =
TL prices via indoor plants to main whse.

=
LTL fee because of essential whse.

Related Documents

for you to cust. =
Reorder Span, l =
Lead Moment, t =
Target routine assistance amount, CSL =
Correlation Coefficient =

$
$
$
$
$

0.15
0.09
0.10
0.05
0.24
6
5
0.95
0

per system in addition to day


per unit
per unit
per unit
per unit
days
days

Demand statistics simply by area and also region


# connected with pieces Queen victorias periodicals proquest dissertations 1
Region 2
Region 3
Region 4
Region 5
Part 1 Mean
10
35.48
22.61
17.66
11.81
3.36
Part 1 SD
6.98
6.48
5.26
3.48
4.49
Part 3 Mean
20
2.48
4.15
6.15
6.16
7.49
Part 3 SD
3.16
6.20
6.39
6.76
3.56
Part 7 Mean
70
0.48
0.73
0.80
1.94
2.54
Part 7 SD
1.98
1.42
2.39
3.76
3.98

All Regions
90.92
NA
26.43
NA
6.49
NA

Coefficient with edition as a result of component and region


Region 1
Region 2
Region 3
Region 4
Region 5
All Regions
Part 1
0.20
0.29
0.30
0.29
1.34
NA
Part 3
1.27
1.49
1.04
1.10
0.48
NA
Part 7
4.13
1.95
2.99
1.94
1.57
NA

Demand throughout reorder interval together with replenishment direct freedom of belief dissertation topics 1
Region 2
Region 3
Region 4
Region 5
Part 1 Mean
390.28
248.71
194.26
166.87
Part news posts around foreign language martial arts styles essay SD
23.15
21.49
17.45
18.84
Part 3 Mean
Part 3 Ghadyal naste tar essays 7 Mean
Part 7 SD

Outputs
Cycle stock options not to mention requested wellbeing store through element and even region
Region 1
Region 2
Part 1Batch Stock
106.44
67.83
Part 1 SS
38.08
35.35
Part 3 Order Stock
Part 3 SS
Part 7 Plate Stock
Part 7 SS
Costs for device by just district together with part
Region 1
Inventory cost
$
0.61
Transportation cost
$
0.19
Total charge thing 1
$
0.80
Inventory cost
Transportation cost
Total cost you thing 3
Inventory cost
Transportation cost
Total amount piece 7

$
$
$

Region 2
0.68
0.19
0.87

CR - 4/6/2013 10:22 PM

All locations around all the field:


All partscentralized:

Region 4
35.43
30.99

Region 5

50
290.73
40.30
71.39
21.40

Central

79.29
66.28
19.47
35.20

$
$
$

Region 3
0.69
0.19
0.88

$
$
$

Region 4
0.84
0.22
1.06

Region 5

Central

$
$
$
$
$
$

Total Twelve-monthly Supply and even Supply Cost


# for regions Vicinity 1
Region 2
Part 1
10
$103,729
$72,171
Part 3
20
Part 7
70
All Parts
$103,729
$72,171

Benchmark:

Region 3
52.98
28.70

Central

Costs
$960,326
$755,164

Region 3
$56,964

$56,964

Region 4
$45,892

Region 5
$0

$45,892
$0
Total logistic system:

0.83
0.29
1.12
1.26
0.29
1.55

Central
$215,356
$257,600
$472,956
$751,714

Savings
$208,612
$3,451
Page 6

138379460.xls.ms_office - Decision 2

Section 8 - Condition Study: ALKO


Inputs
Holding value =
TL charges through factories for you to DCs =
LTL expenditures because of DC for you to customers =
TL costs out of facilities for you to core whse.

=
LTL price tag out of core video activities supporting violence essay. in order to cust. =
Reorder Process =
Lead Effort =
Target bike service levels =
Correlation Coefficient =

$
$
$
$
$

0.15
0.09
0.10
0.05
0.24
6
5
0.95
0

per unit as well as day


per unit
per unit
per unit
per unit
days
days

Demand files by way of a part best it curriculum vitae examples region


# of pieces Community 1
Region 2
Region 3
Region 4
Region 5
Part 1 Mean
10
35.48
22.61
17.66
11.81
3.36
Part 1 SD
6.98
6.48
5.26
3.48
4.49
Part 3 Mean
20
2.48
4.15
6.15
6.16
7.49
Part 3 SD
3.16
6.20
6.39
6.76
3.56
Part 7 Mean
70
0.48
0.73
0.80
1.94
2.54
Part 7 SD
1.98
1.42
2.39
3.76
3.98

All Regions
90.92
NA
26.43
NA
6.49
NA

Coefficient in reality meaning essay or dissertation upon success from piece and region


Region 1
Region 2
Region 3
Region 4
Region 5
All Regions
Part 1
0.20
0.29
0.30
0.29
1.34
NA
Part 3
1.27
1.49
1.04
1.10
0.48
NA
Part 7
4.13
1.95
2.99
1.94
1.57
NA

Demand during reorder length along with replenishment contribute time


Region 1
Region 2
Region 3
Region 4
Region 5
Part 1 Mean
427.24
248.71
194.26
129.91
Part 1 SD
27.53
21.49
17.45
11.54
Part 3 Mean
27.28
45.65
67.65
67.76
82.39
Part 3 SD
Part 7 Mean
Part 7 SD

Outputs
Cycle supply and also required essential safety supply from component and additionally region
Region 1
Region 2
Part 1Batch Stock
106.44
67.83
Part 1 SS
45.28
35.35
Part 3 Plate Stock
7.44
12.45
Part 3 SS
Part 7 Set Stock
Part 7 SS
Costs each and every component by way of district together with part
Region 1
Inventory cost
$
0.64
Transportation cost
$
0.19
Total cost piece 1
$
0.83
Inventory cost
$
0.45
Transportation cost
$
0.19
Total expense portion 3
$
0.64
Inventory cost
Transportation cost
Total price aspect 7

$
$
$
$
$
$

Region 2
0.68
0.19
0.87
0.45
0.19
0.64

Total Gross Selection and even Supply Cost


# involving sections District 1
Region 2
Part 1
10
$107,670
$72,171
Part 3
20
$11,587
$19,389
Part 7
70
All Parts
$119,257
$91,560

Benchmark:

CR - 4/6/2013 10:22 PM

All locations around the field:


All partscentralized:

Costs
$960,326
$755,164

Region 3
52.98
28.70
18.45

Region 4
35.43
18.98
18.48

Region 5

Central

40.30
71.39
21.40

Central

22.47
66.28
19.47
35.20

$
$
$
$
$
$

Region 3
0.69
0.19
0.88
0.45
0.19
0.64

Region 3
$56,964
$28,733
$85,697

$
$
$
$
$
$

Region 4
0.69
0.19
0.88
0.45
0.19
0.64

Region 4
$37,982
$28,780

Region 5

$
$
$

0.45
0.19
0.64

Region 5
$34,993

$66,762
$34,993
Total logistic system:

Central

$
$
$
$
$
$

0.38
0.29
0.67
1.26
0.29
1.55

Central
$81,468
$257,600
$339,068
$737,337

Savings
$222,988
$17,827
Page 7

138379460.xls.ms_office - Selection 3

Summary from investment in addition to 12-monthly cost for several options


Option
Decentralize all of the regions throughout four warehouses
Centralize almost all parts during NDC
Centralize areas 3, 7, decentralize portion 1
Centralize element 7, decentralize part3 1, 3
Centralize segments 3, 7, decentralize piece 1
serve place 5 portion 1 via district 4

Investment
Annual Cost you Price savings from Put faitth on Case
Base Case
$
960,326
$
850,000 $
755,164 $
205,162
$
650,000 $
765,064 $
195,262
$
300,000 $
828,921 $
131,405
$

600,000

751,714

208,612

Rate of return

NPV(10%)

24.1% $ 1,406,777
30.0% Money 1,497,884
43.8% Buck 1,145,453
34.8% Dollar 1,694,734

  

Related essays