This is a Red Tomato Aggregate Planning question. In class the professor solved it using the solver in excel, and I would appreciate someone showing me how to use that software to solve this problem step by step. Thank you! I need answers for constraint formulas and min cost answer is 422,660

Materials cost/unit Inventory holding cost/unit/month Marginal cost of stockout/unit/month Hiring and training cost/worker Layoff cost/worker Labor hours required/unit Regular time cost/hour Over time cost/hour Marginal subcontracting cost/unit Ht Lt Wt Period # Hired # Laid off #Workforce 80 0 1 2 3| 4 5 6 Period 1 2 3 4 5 6 Hiring Lay off $10 $2 $5 $300 $500 4 $4.0 $6.0 $30 Inptut Parameters Unit Price Starting Workforce Starting Inventory Working days per month Working hours per day Max overtime per worker per month End Stockout End Inventory Decision Variables Ot It St Ct Pt Overtime Inventory Stockout Subcontract Production 1,000 Calculations Costs Regular time Overtime Inventory Stockout Subcontract Material $40 80 1,000 20 8 10 0 500 Period 1 2 3 4 5 6 Period 1 2 3 4 5 6 Demand 1,600 3,000 3,200 3,800 2,200 2,200 Objective Function Total Cost Total Revenue = Profit= Constraints Workforce Inventory Extra Balance Balance Capacity Extra Over time New Demand Period Demand 1 2 3 4 5 6 1,000 3,000 3,800 4,800 2,000 1,400 Materials cost/unit Inventory holding cost/unit/month Marginal cost of stockout/unit/month Hiring and training cost/worker Layoff cost/worker Labor hours required/unit Regular time cost/hour Over time cost/hour Marginal subcontracting cost/unit Ht Lt Wt Period # Hired # Laid off #Workforce 80 0 1 2 3| 4 5 6 Period 1 2 3 4 5 6 Hiring Lay off $10 $2 $5 $300 $500 4 $4.0 $6.0 $30 Inptut Parameters Unit Price Starting Workforce Starting Inventory Working days per month Working hours per day Max overtime per worker per month End Stockout End Inventory Decision Variables Ot It St Ct Pt Overtime Inventory Stockout Subcontract Production 1,000 Calculations Costs Regular time Overtime Inventory Stockout Subcontract Material $40 80 1,000 20 8 10 0 500 Period 1 2 3 4 5 6 Period 1 2 3 4 5 6 Demand 1,600 3,000 3,200 3,800 2,200 2,200 Objective Function Total Cost Total Revenue = Profit= Constraints Workforce Inventory Extra Balance Balance Capacity Extra Over time New Demand Period Demand 1 2 3 4 5 6 1,000 3,000 3,800 4,800 2,000 1,400