Firing Cost Inventory Carrying Cost $ 5,000.00 0.50 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. Production cost regular time Overtime $2 $3 Production Capacity regular time 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. 200,000 Beginning Workforce 100 Workers' productivity regular time Overtime 1,000 300 Beginning inventory Ending Inventory Requirement 2,000 50,000 Demand 80000 Period Spring Summer Fall Winter 50000 120000 150000