Aggregate Planning Problem. In this problem, the forecasted demand of the four seasons are given in B19:C23; for example, the expected demand of Spring is 80,000 units. Other parameters are also provided in columns A and B; for example, at the beginning of the time horizon, the available inventory is 2,000 units, and the available workforce is 100 workers. Formulate the problem first in Excel (1 point) and then in Solver (1 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