PLEASE SHOW SOLUTION ON EXCEL WITH FORMULAS

Cell Styles v Format v H24 x fx A B C D E F G H L L M $ $ $ 100.00 500.00 0.50 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 200,000 First, formulate the problem in Excel (1 point) and 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. 100 1,000 2,000 50,000 i Hiring Cost 2 Firing Cost 3 Inventory Carrying Cost 4 5 Production cost 6 regular time 7 8 Production Capacity 9 regular time 10 11 Beginning Workforce 12 Workers' productivity 13 14 Beginning inventory 15 Ending Inventory Requirement 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Period Spring Summer Fall Winter Demand 80000 50000 120000 150000 31 32