Transcript KELOMPOK 1 - PLANNING AGGREGAT AND FORECAST

PLANNING AGGREGAT AND FORECAST
Group I :
Graditasari (11)
Helmi Indra Irfany (12)
Karenita
Bagus Tirtayasa (27)
CASE STUDY
The EGAD Bottling Company
The EGAD Bottling Company has decided to introduce a new line of
premium bottled water that will include several designed flavors
PREDICTION
Marketing Manager “Georgianna Mercer” Prediction :
Upturn in demand based on the new offerings
the increased public awareness of the health
AGGREGATE FORECAST
Month
May
Jun
Jul
Aug
Sep
Oct
Total
Forecast
50
60
70
90
80
70
420
OTHER INFORMATION FROM PRODUCTION
MANAGER
Regular production cost
Regular production capacity
Overtime production cost
Subcontracting cost
Holding cost
Beginning inventory
$10 per unit
60 units
$16 per unit
$18 per unit
$2 per unit per month
0 units
ALTERNATIVE SOLUTION 1
Period
May
June
July
August
Sept
October
Total
50
60
70
90
80
70
420
60
10
-
60
10
-
60
10
-
60
10
-
60
10
-
360
-Subcontract
60
10
-
Output
Forecast
20
10
0
–20
–10
0
-
-Beginning
0
20
30
30
10
0
-Ending
20
30
30
10
0
0
-Regular
600
600
600
600
600
600
3600
-Overtime
160
160
160
160
160
160
960
-inventory
40
60
60
20
0
0
180
TOTAL
800
820
820
780
760
760
4740
Forecast
Output
-Regular
-Overtime
60
-
Inventory
COST
ALTERNATIVE SOLUTION 2
Period
May
June
July
August
Sept
October
Total
50
60
70
90
80
70
420
60
10
-
60
10
-
60
10
10
60
10
-
60
10
-
360
-Subcontract
60
-
Output
Forecast
10
10
0
–10
–10
0
-
-Beginning
0
10
20
20
10
0
-Ending
10
20
20
10
0
0
-Regular
600
600
600
600
600
600
3600
-Overtime
-
160
160
160
160
160
800
-subcontract
-
-
-
180
-
-
180
-inventory
20
40
40
20
0
0
120
TOTAL
800
820
820
780
760
760
4700
Forecast
Output
-Regular
-Overtime
50
10
Inventory
COST
ALTERNATIVE SOLUTION 3
Period
May
June
July
August
Sept
October
Total
50
60
70
90
80
70
420
60
5
-
60
15
-
60
15
-
60
15
-
60
10
-
360
-Subcontract
60
-
Output
Forecast
10
5
5
–15
–5
0
-
-Beginning
0
10
15
20
5
0
-Ending
10
15
20
5
0
0
-Regular
600
600
600
600
600
600
3600
-Overtime
-
80
240
240
240
160
960
-subcontract
-
-
-
-
-
-
-
-inventory
20
30
40
10
0
0
100
TOTAL
620
710
880
850
840
760
4660
Forecast
Output
-Regular
-Overtime
60
-
Inventory
COST
CONCLUSION
Since the lowest cost is alternative solution 3 ($4600)
The Company should choose the third strategy