aggregate planning

please show the formulas used to get the answers

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