312448290-case-study-andrew-carter-inc.xls
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View 312448290-case-study-andrew-carter-inc.xls as PDF for free.
More details
- Words: 425
- Pages: 10
W1 Plant 1 Plant 2 Plant 3
0.5 0.4 0.56 9000
W2 0.44 0.52 0.53 13000
W3
W2
W3
0.49 0.5 0.51 11000
W4 0.46 0.56 0.54 15000
W5 0.56 0.57 0.35 8000
W4
W5
34000 25000 31000
Solution W1 Plant 1 Plant 2 Plant 3
Fixed Cost Plant 1 Plant 2 Plant 3 Variable Cost Plant 1 Plant 2 Plant 3
1 1 1 3
1 1 1 3
1 1 1 3
14000 12000 15000
14 13.9 13.6
Total Production Cost Plant 1 14014 Plant 2 12013.9 Plant 3 15013.6 Total 41041.5
Total Distribution Cost 7.49
1 1 1 3
1 1 1 3
5 5 5
Normal Capacity 27000 20000 25000
Jika Plant 1 ditutup, total cost = Jika Plant 2 ditutup, total cost = Jika Plant 3 ditutup, total cost = Jika semua Plant beroperasi, total cost = Kesimpulan: Hentikan operasi pabrik 2
Total Cost 41,048.99
Overtime Production
, total cost = p, total cost = , total cost = eroperasi, total cost =
0 0 0
$B$9:$F$11 by
(All)
Row Labels $B$14 Pabrik 1 Ditutup 221,532.62 Pabrik 2 Ditutup 219,068.34 Pabrik 3 Ditutup 222,430.00 Semua Pabrik Beroperas 220,730.00
W1 Plant 1 Plant 2 Plant 3 Demand
0.5 0.4 0.56 9000
W2 0.44 0.52 0.53 13000
W3 0.49 0.5 0.51 11000
W4 0.46 0.56 0.54 15000
Total W5 Capacity 0.56 34000 0.57 25000 0.35 31000 8000
W2
W3
W4
W5
Normal Capacity 27000 20000 25000
Solution
W1 Plant 1 Plant 2 Plant 3
1 1 1 3
Total Cost 41048.99
1 1 1 3
1 1 1 3
1 1 1 3
Total Produksi 1 1 1 3
Normal Capacity 5 5 5
27000 20000 25000
NOT Overtime Capacity OPR FC OPR FC Reg. VC 7000 14000 6000 2.8 5000 12000 5000 2.78 6000 15000 7500 2.72
Overtime Production
Transport ation Cost FC VC 0 2.45 14000 0 2.55 12000 0 2.49 15000
14 13.9 13.6
OT. VC 3.52 3.48 3.42
Semua Pabrik Beroperasi
0 9000 0
13000 0 0
0 0 11000
Page 6
10029 0 4971
0 0 8000
Pabrik 1 Ditutup
0 8999 1
0 8261 4739
0 1991 9009
Page 7
0 5749 9251
0 0 8000
Pabrik 2 Ditutup
8702 0 298
9041 0 3959
407 0 10593
Page 8
6849 0 8151
1 0 7999
Pabrik 3 Ditutup
0 9000 0
13000 0 0
3000 8000 0
Page 9
15000 0 0
0 8000 0
-PABRIK 3 DITUTUP
0 9000 0
13000 0 0
0 11000 0
Page 10
15000 0 0
3000 5000 0
0.5 0.4 0.56 9000
W2 0.44 0.52 0.53 13000
W3
W2
W3
0.49 0.5 0.51 11000
W4 0.46 0.56 0.54 15000
W5 0.56 0.57 0.35 8000
W4
W5
34000 25000 31000
Solution W1 Plant 1 Plant 2 Plant 3
Fixed Cost Plant 1 Plant 2 Plant 3 Variable Cost Plant 1 Plant 2 Plant 3
1 1 1 3
1 1 1 3
1 1 1 3
14000 12000 15000
14 13.9 13.6
Total Production Cost Plant 1 14014 Plant 2 12013.9 Plant 3 15013.6 Total 41041.5
Total Distribution Cost 7.49
1 1 1 3
1 1 1 3
5 5 5
Normal Capacity 27000 20000 25000
Jika Plant 1 ditutup, total cost = Jika Plant 2 ditutup, total cost = Jika Plant 3 ditutup, total cost = Jika semua Plant beroperasi, total cost = Kesimpulan: Hentikan operasi pabrik 2
Total Cost 41,048.99
Overtime Production
, total cost = p, total cost = , total cost = eroperasi, total cost =
0 0 0
$B$9:$F$11 by
(All)
Row Labels $B$14 Pabrik 1 Ditutup 221,532.62 Pabrik 2 Ditutup 219,068.34 Pabrik 3 Ditutup 222,430.00 Semua Pabrik Beroperas 220,730.00
W1 Plant 1 Plant 2 Plant 3 Demand
0.5 0.4 0.56 9000
W2 0.44 0.52 0.53 13000
W3 0.49 0.5 0.51 11000
W4 0.46 0.56 0.54 15000
Total W5 Capacity 0.56 34000 0.57 25000 0.35 31000 8000
W2
W3
W4
W5
Normal Capacity 27000 20000 25000
Solution
W1 Plant 1 Plant 2 Plant 3
1 1 1 3
Total Cost 41048.99
1 1 1 3
1 1 1 3
1 1 1 3
Total Produksi 1 1 1 3
Normal Capacity 5 5 5
27000 20000 25000
NOT Overtime Capacity OPR FC OPR FC Reg. VC 7000 14000 6000 2.8 5000 12000 5000 2.78 6000 15000 7500 2.72
Overtime Production
Transport ation Cost FC VC 0 2.45 14000 0 2.55 12000 0 2.49 15000
14 13.9 13.6
OT. VC 3.52 3.48 3.42
Semua Pabrik Beroperasi
0 9000 0
13000 0 0
0 0 11000
Page 6
10029 0 4971
0 0 8000
Pabrik 1 Ditutup
0 8999 1
0 8261 4739
0 1991 9009
Page 7
0 5749 9251
0 0 8000
Pabrik 2 Ditutup
8702 0 298
9041 0 3959
407 0 10593
Page 8
6849 0 8151
1 0 7999
Pabrik 3 Ditutup
0 9000 0
13000 0 0
3000 8000 0
Page 9
15000 0 0
0 8000 0
-PABRIK 3 DITUTUP
0 9000 0
13000 0 0
0 11000 0
Page 10
15000 0 0
3000 5000 0
More Documents from "AndriGunawan"
