Acompany manufactures and sells face masks. The owner has developed a spreadsheet to calculate the costs...

 

Transcribed Image Text:

Acompany manufactures and sells face masks. The owner has developed a spreadsheet to calculate the costs assoclated 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. Fxed Information Labor hours per unit Worker hours per month 60 100 500 Beginning and ending workforce Beginning and ending inventory Production cost per unit 10 Total production cost Hiring cost Firing cost Holding cost per unit per month $ 200 Total hiring cost 250 Total firing cost 2 Inventory cost Total cost Sales (in Ending Sales (in workers) Actual workers Sales Month forecast hours) Actual Production Hirings Firings Inventory Beginning 100 500 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec End Acompany manufactures and sells face masks. The owner has developed a spreadsheet to calculate the costs assoclated 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. Fxed Information Labor hours per unit Worker hours per month 60 100 500 Beginning and ending workforce Beginning and ending inventory Production cost per unit 10 Total production cost Hiring cost Firing cost Holding cost per unit per month $ 200 Total hiring cost 250 Total firing cost 2 Inventory cost Total cost Sales (in Ending Sales (in workers) Actual workers Sales Month forecast hours) Actual Production Hirings Firings Inventory Beginning 100 500 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec End

Answer rating: 100% (QA)

onth Sales Forecast Sales in hours Sales in workers Actual workers ActualProduction Hirings Firings ... View the full answer