Scribd
Upload
40 views6 pages

Demand Forecast and Capacity Analysis

1. The document presents supply and demand data for 3 periods. It lists regular time, overtime, and subcontracted work as well as beginning inventory and costs. 2. For each period it shows the supply from beginning inventory and current production as well as the demand. 3. It calculates the total available capacity as the sum of beginning inventory and period supply, and finds that the total capacity of 2090 units exceeds the total demand of 2030 units.

Uploaded by

DavidWatak
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
40 views6 pages

Demand Forecast and Capacity Analysis

1. The document presents supply and demand data for 3 periods. It lists regular time, overtime, and subcontracted work as well as beginning inventory and costs. 2. For each period it shows the supply from beginning inventory and current production as well as the demand. 3. It calculates the total available capacity as the sum of beginning inventory and period supply, and finds that the total capacity of 2090 units exceeds the total demand of 2030 units.

Uploaded by

DavidWatak
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

No.

16 Period Regular Overtime Subcontract Demand Forecast


1 500 50 120 550
2 500 50 120 700
3 500 50 100 750

Regular time cost per unit 60


Overtime cost 80
Subcontract cost 90
Inventory carrying cost 1
Backorder cost 3
Beginning inventory 100
Demand For

Supply From Period 1 Period 2 Period 3


Beginning 0 1
inventory 100
60 61
Regular 450 50
80 81
Overtime 50
Period 1

90 91
Subcontract 90
63 60
Regular 500
83 80
Overtime 10 40
Period 2

93 90
Subcontract 120
66 63
Regular 440
86 83
Overtime 50
Period 3

96 93
Subcontract 100

Demand 550 700 750


and For Total
capacity
Unused capacity available
Period 3 (dummy) (supply)
2 0
100
62 0
500
82 0
50
92 0
30 120
61 0
500
81 0
40 50
91 0
120 120
60 0
440 440
80 0
50 50
90 0
100 100

750 30 2090
No.
16 Period Regular Overtime Subcontract Demand Forecast
1 500 50 120 550
2 500 50 120 700
3 500 50 100 750

Regular time cost per unit 60


Overtime cost 80
Subcontract cost 90
Inventory carrying cost 1
Backorder cost 3
Beginning inventory 100
Demand For

Supply From Period 1 Period 2


Beginning 0 1
inventory 100
60 61
Regular 450 50
80 81
Overtime 50

Period 1
90 91
Subcontract 90
63 60
Regular 500
83 80
Overtime 10
Period 2

93 90
Subcontract
66 63
Regular
86 83
Overtime
Period 3

96 93
Subcontract

Demand 550 700


Demand For Total
capacity
Unused capacity available
Period 3 (dummy) (supply)
2 0
0 100
62 0
0 500
82 0
0 50
92 0
30 120
61 0
0 500
81 0
40 0 50
91 0
120 0 120
60 0
440 0 440
80 0
50 0 50
90 0
100 0 100

750 30 2030

You might also like