please show both answers and formula view
x fx B D E H Acompany manufactures and sells face masks. The owner has developed a spreadsheet to calculate the costs associated with the aggregate plan. She wants to find the plan that minimizes the total costs. The beginning and ending workforce are 100 people. The beginning inventory is 500 units, and she wants to have an inventory of at least 500 at the end of the year. In the meantime, she wants to meet the demand each month. Please complete the plan. Fixed Information Labor hours per unit Worker hours per month Beginning and ending workforce Beginning and ending inventory 5 60 100 500 Production cost per unit Hiring cost Firing cost Holding cost per unit per month $ $ $ $ 10 Total production cost 200 Total hiring cost 250 Total firing cost 2 Inventory cost Total cost Sales forecast Sales (in hours) Sales (in workers) Actual workers Actual Production Hirings 100 Ending Inventory Firings 500 Month Beginning Jan Feb Mar Apr May Jun Aug Sep Oct Nov Dec End Totals Acompany manufactures and sells face masks. The owner has developed a spreadsheet to calculate the costs associated with the aggregate plan. She wants to find the plan that minimizes the total costs. The beginning and ending workforce are 100 people. The beginning Inventory Is S00 units, and she wants to have an inventory of at least 500 at the end of the year. In the meantime, she wants to meet the demand each month. Please complete the plan. I Fixed Information Labor hours per unit Worker hours per month Beginning and ending workforce Beginning and ending inventory 5 60 100 500 $ Production cost per unit $ Hiring cost Firing cost $ Holding cost per unit per months 10 Total production cost 200 Total hiring cost 250 Total firing cost 2 Inventory cost Total cost Sales forecast Sales (in hours) Sales (in workers) Actual workers Actual Production Hirings Firing Month Beginning Jan Ending Inventory 500 100 Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec End 5000 6000 5600 7000 8000 8000 9000 8500 10,000 12,000 11,000 13,000 Totals