Aggregate Planning 1614614720244

Aggregate Plan Decision Variables

Ht Lt Wt Ot It St Ct Pt
Period # Hired # Laid off # Workforce Overtime Inventory Stockout Subcontract Production
0 0 0 80 0 1,000 0 0
1 0 16 64 0 1,960 0 0 2,560
2 0 0 64 0 1,520 0 0 2,560
3 0 0 64 0 880 0 0 2,560
4 0 0 64 0 0 220 140 2,560
5 0 0 64 0 140 0 0 2,560
6 0 0 64 0 500 0 0 2,560

Aggregate Plan Costs

Period Hiring Lay off Regular time Overtime Inventory Stockout Subcontract Production
1 $ - $ 8,000 $ 40,960 $ - $ 3,920 $ - $ - $ 25,600
2 $ - $ - $ 40,960 $ - $ 3,040 $ - $ - $ 25,600
3 $ - $ - $ 40,960 $ - $ 1,760 $ - $ - $ 25,600
4 $ - $ - $ 40,960 $ - $ - $ 1,100 $ 4,200 $ 25,600
5 $ - $ - $ 40,960 $ - $ 280 $ - $ - $ 25,600
6 $ - $ - $ 40,960 $ - $ 1,000 $ - $ - $ 25,600
Total Cost $ 422,660
Total Reve $640,000
Profit $ 217,340
Demand Price Constraints
# Workfor Capacity Inventory OT
1,600 40 0 0 - 640
3,000 40 0 0 - 640
3,200 40 0 0 - 640
3,800 40 0 0 - 640
2,200 40 0 0 - 640
2,200 40 0 0 - 640
1,600
3,000
3,200
3,800
2,200
2,200 Item Cost
Materials cost/unit $ 10
Inventory holding cost/unit/month $ 2
Marginal cost of stockout/unit/month $ 5
Hiring and training cost/worker $ 300
Layoff cost/worker $ 500
Labor hours required/unit $ 4
Regular time cost/hour $ 4
Over time cost/hour $ 6
Subcontracting cost/unit $ 30
0 0 0 80 0 1,000 0 0
1 0 16 64 0 2,560 0 0 2,560
2 0 0 64 0 2,120 0 0 2,560
3 0 0 64 0 880 0 0 2,560
4 0 0 64 0 0 1,220 140 2,560
5 0 0 64 0 0 660 0 2,560
6 0 0 64 0 500 0 0 2,560
1 $ - $ 8,000 $ 40,960 $ - $ 5,120 $ - $ - $ 25,600
2 $ - $ - $ 40,960 $ - $ 4,240 $ - $ - $ 25,600
3 $ - $ - $ 40,960 $ - $ 1,760 $ - $ - $ 25,600
4 $ - $ - $ 40,960 $ - $ - $ 6,100 $ 4,200 $ 25,600
5 $ - $ - $ 40,960 $ - $ - $ 3,300 $ - $ 25,600
6 $ - $ - $ 40,960 $ - $ 1,000 $ - $ - $ 25,600
Total Reve $640,000
Profit $ 206,920
1,000 40 0 0 - 640
3,000 40 0 0 - 640
3,800 40 0 0 - 640
4,800 40 0 0 - 640
2,000 40 0 0 - 640
1,400 40 0 0 - 640
Item Cost
0 0 0 80 0 1,000 0 0
1 0 35 45 0 1,200 0 0 1,800
2 0 0 45 0 0 0 0 1,800
3 42 0 87 0 280 0 0 3,480
4 1 0 88 0 0 0 0 3,520
5 0 27 61 0 240 0 0 2,440
6 0 0 61 0 500 0 20 2,440
1 $ - $ 1,750 $ 28,800 $ - $ 2,400 $ - $ - $ 18,000
2 $ - $ - $ 28,800 $ - $ - $ - $ - $ 18,000
3 $ 2,100 $ - $ 55,680 $ - $ 560 $ - $ - $ 34,800
4 $ 50 $ - $ 56,320 $ - $ - $ - $ - $ 35,200
5 $ - $ 1,350 $ 39,040 $ - $ 480 $ - $ - $ 24,400
6 $ - $ - $ 39,040 $ - $ 1,000 $ - $ 600 $ 24,400
Total Reve $640,000
Profit $ 227,230
1,600 40 0 0 - 450
3,000 40 0 0 - 450
3,200 40 0 0 - 870
3,800 40 0 0 - 880
2,200 40 0 0 - 610
2,200 40 0 0 - 610
1,600
3,000
3,200
3,800
2,200
2,200 Item Cost
0 0 0 80 0 1,000 0 0
1 0 15 65 0 600 0 0 2,600
2 0 0 65 0 800 0 0 2,600
3 0 0 65 0 840 0 0 2,600
4 0 0 65 0 0 300 60 2,600
5 0 0 65 0 100 0 0 2,600
6 0 0 65 0 500 0 0 2,600
1 $ - $ 7,500 $ 41,600 $ - $ 1,200 $ - $ - $ 26,000
2 $ - $ - $ 41,600 $ - $ 1,600 $ - $ - $ 26,000
3 $ - $ - $ 41,600 $ - $ 1,680 $ - $ - $ 26,000
4 $ - $ - $ 41,600 $ - $ - $ 1,500 $ 1,800 $ 26,000
5 $ - $ - $ 41,600 $ - $ 200 $ - $ - $ 26,000
6 $ - $ - $ 41,600 $ - $ 1,000 $ - $ - $ 26,000
Total Reve $643,400
Profit $ 221,320
3,000 39 0 0 - 650
2,400 40 0 0 - 650
2,560 40 0 0 - 650
3,800 40 0 0 - 650
2,200 40 0 0 - 650
2,200 40 0 0 - 650
1,600 3000 1,600

3,000 2400 3,000
3,200 2560 3,200
3,800 3,800 5,060
2,200 2,200 1,760
2,200 2,200 1,760 Item Cost
0 0 0 80 0 1,000 0 0
1 0 14 66 0 2,040 0 0 2,640
2 0 0 66 0 1,680 0 0 2,640
3 0 0 66 0 1,120 0 0 2,640
4 0 0 66 0 0 1,260 40 2,640
5 0 0 66 0 0 380 0 2,640
6 0 0 66 0 500 0 0 2,640
1 $ - $ 7,000 $ 42,240 $ - $ 4,080 $ - $ - $ 26,400
2 $ - $ - $ 42,240 $ - $ 3,360 $ - $ - $ 26,400
3 $ - $ - $ 42,240 $ - $ 2,240 $ - $ - $ 26,400
4 $ - $ - $ 42,240 $ - $ - $ 6,300 $ 1,200 $ 26,400
5 $ - $ - $ 42,240 $ - $ - $ 1,900 $ - $ 26,400
6 $ - $ - $ 42,240 $ - $ 1,000 $ - $ - $ 26,400
Total Reve $650,140
Profit $ 211,220
1,600 40 0 0 - 660
3,000 40 0 0 - 660
3,200 40 0 0 - 660
5,060 39 0 0 - 660
1,760 40 0 0 - 660
1,760 40 0 0 - 660
1,600 3000 1,600

3,000 2400 3,000
3,200 2560 3,200
3,800 3,800 5,060
2,200 2,200 1,760
2,200 2,200 1,760 Item Cost
0 0 0 80 0 1,000 0 0
1 0 16 64 0 1,960 0 0 2,560
2 0 0 64 0 1,520 0 0 2,560
3 0 0 64 0 880 0 0 2,560
4 0 0 64 0 0 220 140 2,560
5 0 0 64 0 140 0 0 2,560
6 0 0 64 0 500 0 0 2,560
1 $ - $ 8,000 $ 40,960 $ - $ 3,920 $ - $ - $ 25,600
2 $ - $ - $ 40,960 $ - $ 3,040 $ - $ - $ 25,600
3 $ - $ - $ 40,960 $ - $ 1,760 $ - $ - $ 25,600
4 $ - $ - $ 40,960 $ - $ - $ 1,100 $ 4,200 $ 25,600
5 $ - $ - $ 40,960 $ - $ 280 $ - $ - $ 25,600
6 $ - $ - $ 40,960 $ - $ 1,000 $ - $ - $ 25,600
Total Reve $640,000 I6 is greater than or equal to 500
Profit $ 217,340
1,600 40 0 0 - 640
3,000 40 0 0 - 640
3,200 40 0 0 - 640
3,800 40 0 0 - 640
2,200 40 0 0 - 640
2,200 40 0 0 - 640
1,600
3,000
3,200
3,800
2,200
2,200 Item Cost
or equal to 500 Hiring and training cost/worker $ 300

Aggregate Planning 1614614720244

Uploaded by

Copyright:

Available Formats

Aggregate Planning 1614614720244

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Aggregate Planning 1614614720244

Uploaded by

Copyright:

Available Formats

Aggregate Plan Decision Variables

Aggregate Plan Costs

Total Cost $ 422,660

Total Reve $640,000

Aggregate Plan Costs

Total Cost $ 433,080

Total Reve $640,000

Aggregate Plan Costs

Total Cost $ 412,770

Total Reve $640,000

Aggregate Plan Costs

Total Cost $ 422,080

Total Reve $643,400

1,600 3000 1,600

Aggregate Plan Costs

Total Cost $ 438,920

Total Reve $650,140

1,600 3000 1,600

Aggregate Plan Costs

Total Cost $ 422,660

Total Reve $640,000 I6 is greater than or equal to 500

You might also like