operations
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:
12 years ago 5
- looking for wajera, she is a teacher here
- Q1 Investing in Zero-coupon Bonds Charles is considering zero-coupon bonds issued by Nationwide Company. These bonds were issued on January 1,...
- Assignment 2: LASA 1: The Costs of Production
- Week 4 DQ 1 Discussion question
- Can you please make a childrens/shortened version of the silver sword?
- Masters level Finance- risk and cost of capital-10 question quiz 1 hour 10 minutes to complete
- -7x + 7 < -56
- son name
- How are economic fluctuations linked among national economies? Could a recession in the United States trigger a recession abroad?
- One stockholder owned 950 shares on February 5 before the dividend. Compute the book value per share and total book...