This problem is similar to Aggregate Planning 1; however, in this problem, the company can use overtime to produce the units. Here you can see that every worker can produce 300 units per season during the overtime. Formulate the problem first in Excel (1.5 point) and then in Solver (1.5 point) to see (1) how many products you want to produce, and (2) how many worker you want to hire or fire in each period to minimize the total cost.

Hiring Cost Firing Cost Inventory Carrying Cost $ $ $ 100.00 500.00 0.50 Production cost regular time $2 Production Capacity regular time 200,000 Beginning Workforce Workers' productivity 100 1,000 Beginning inventory Ending Inventory Requirement 2.000 50,000 Period Spring Summer Fall Winter Demand 80000 50000 120000 150000 Hiring Cost Firing Cost Inventory Carrying Cost $ $ $ 100.00 500.00 0.50 Production cost regular time $2 Production Capacity regular time 200,000 Beginning Workforce Workers' productivity 100 1,000 Beginning inventory Ending Inventory Requirement 2.000 50,000 Period Spring Summer Fall Winter Demand 80000 50000 120000 150000