Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
please show both answers and formula view
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started