| Aggregate Scheduling Model |
|
|
|
|
|
|
|
|
|
|
|
| Input Values |
|
|
|
|
|
|
| Units
produced/worker/period |
10 |
|
|
|
|
|
| Hiring cost/worker |
$
10.00 |
|
|
|
|
|
| Layoff cost/worker |
$
15.00 |
|
|
|
|
|
| Holding cost/unit/period |
$
2.00 |
|
|
|
|
|
| Backorder
cost/unit/period |
$
4.00 |
|
|
|
|
|
| Workforce level |
40 |
38 |
38 |
38 |
38 |
36 |
| Period: |
1 |
2 |
3 |
4 |
5 |
6 |
|
|
|
|
|
|
|
| Demand, units |
420 |
360 |
390 |
350 |
420 |
340 |
|
|
|
|
|
|
|
| Production & Labor |
|
|
|
|
|
|
| Production, units |
400 |
380 |
380 |
380 |
380 |
360 |
| Last workforce |
38 |
40 |
38 |
38 |
38 |
38 |
| Workforce change |
2 |
(2) |
- |
- |
- |
(2) |
|
|
|
|
|
|
|
| Inventory |
|
|
|
|
|
|
| Units available |
400 |
380 |
380 |
380 |
400 |
360 |
| Units required |
420 |
380 |
390 |
360 |
420 |
360 |
| Net inventory |
(20) |
- |
(10) |
20 |
(20) |
- |
| Ending inventory |
- |
- |
- |
20 |
- |
- |
| Units backordered |
20 |
- |
10 |
- |
20 |
- |
|
|
|
|
|
|
|
| Costs |
|
|
|
|
|
|
| Turnover costs |
$ 20 |
$ 30 |
$ -
|
$ -
|
$ -
|
$ 30 |
| Holding costs |
$ -
|
$ -
|
$ -
|
$ 40 |
$ -
|
$ -
|
| Backorder costs |
$ 80 |
$ -
|
$ 40 |
$ -
|
$ 80 |
$ -
|
| Total costs |
$ 100 |
$ 30 |
$ 40 |
$ 40 |
$ 80 |
$ 30 |
|
|
|
|
|
|
|
| Cumulative costs |
$ 100 |
$ 130 |
$ 170 |
$ 210 |
$ 290 |
$ 320 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|