operations

0 comments

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:

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}