Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed please show both answers and formula view
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Hospitality Management Accounting

Authors: Michael M. Coltman, Martin G. Jagels, Martin Jagels

7th Edition

0471348848, 978-0471348849

More Books

Students also viewed these Accounting questions

Question

How are the residuals used in estimating ?????

Answered: 1 week ago