operations

profilesmartkid
prob_6.docx

Part A)

Given the projected demands for the next six months below, use the first editable worksheet to prepare a level workforce aggregate production plan that uses inventory, regular time, overtime, and backorders. A maximum of 30 units per month of overtime production are allowed at a cost of $30 per unit. Any units that must be backordered incur a cost of $40 each. Inventory holding cost is $6 per unit, and regular time labor cost is $25 per unit produced. An aggregate planning worksheet is provided for you if you choose to use it. The current workforce level is not to be changed. There are currently 70 employees on the payroll and each employee can produce 2 units per month in regular production time. Hiring cost is $700 and layoff cost is $850. Assume an employee hired must work the entire month.

MONTH FORECAST

===== ========

1 180

2 170

3 140

4 175

5 130

6 150

Part B)

Use the second editable worksheet to prepare a second aggregate production plan using the same information as Part A but following a chase demand strategy adjusting the workforce size only.

Aggregate Planning Worksheet

Period

1

2

3

4

5

6

7

8

Σ

Forecast

Beg Inventory

Prod Needed

Reg Time Prod

Overtime Prod

Subcontract

Backorder

End Inventory

Workforce

Δ Workforce

COSTS

Reg Time Labor

Overtime Labor

Subcontract

Backorder

Invent Holding

Hire

Fire

Total Cost:

Aggregate Planning Worksheet

Period

1

2

3

4

5

6

7

8

Σ

Forecast

Beg Inventory

Prod Needed

Reg Time Prod

Overtime Prod

Subcontract

Backorder

End Inventory

Workforce

Δ Workforce

COSTS

Reg Time Labor

Overtime Labor

Subcontract

Backorder

Invent Holding

Hire

Fire

Total Cost: