Question: do the level plan, show steps how you completed spread sheet. 8 different columns Value 480 100 90 75 1900 1200 Description Maximum regular hours

do the level plan, show steps how you completed spread sheet. 8 different columns do the level plan, show steps how you completed
do the level plan, show steps how you completed
do the level plan, show steps how you completed
do the level plan, show steps how you completed
do the level plan, show steps how you completed
Value 480 100 90 75 1900 1200 Description Maximum regular hours per worker per quarter Maximum overtime hours per worker per quarter Maximum number of workers Starting workforce Hiring cost per worker Firing cost per worker Regular time wage Overtime wage Subcontract Cost Back order cost Holding cost per pair of shoes per quarter Ending Inventory Period 0 18 27 60 20 2 2200 E F Quarter Casual Athletic Running Total 1 9903 9910 10867 30680 2 10776 10006 10248 31030 H Aggregate Demand 3 4 5 11568 12446 16915 11420 14615 13734 11147 14509 16731 34135 41570 52380 6 18126 20469 19515 58110 7 11268 14478 14274 40020 10690 13745 14710 39145 7 LEVEL AGGREGATE PLAN 2 5 7 41570 40020 58110 30680 52380 39145 31030 34135 40609 40609 40609 40609 40609 40609 40609 40609 Period Forecast (DLH?) Production Regular Time Overtime Subcontract Total Production Number of Workers Inventory Beginning Ending Average Backlog 40609 75 2200 Labor Costs B D E F G H 75 2200 th 10 Number of Workers 11 Inventory 12 Beginning 13 Ending 14 Average 15 Backlog 16 17 Labor Costs 18 Regular 19 Overtime 20 Subcontract 21 Hire 22 Fire 23 Total Labor Cost 24 25 Inventory Costs 26 Holding Cost 27 Back Order 2 20 TIF Inventory Costs Holding Cost Back Order 201 Total Production Cost

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

create level aggregate plan using information below Description Maximum regular hours per worker per quarter Maximum overtime hours per worker per quarter Maximum number of workers Starting workforce...

Q:

create master production schedule using information below Control Sheet Chase Level Mix MPS MRP Aggregate Demand Quarter 10690 13745 Athletic Running Total 9900 9910 10567 360 10776 10006 1024 31010...

Q:

create materials requirement plan using information below Control Sheet Chase Level Mix MPS MRP Aggregate Demand Quarter Casual Athletic Running Total 9900 9910 10367 360 1076 10006 1034 31010 11568...

Q:

fill out figure 3 chase aggregate plan using figure 1&2 information figure 1 figure 2 figure 3 Value 480 100 90 Description Maximum regular hours per worker per quarter Maximum overtime hours per...

Q:

fill out figure 3 mix aggregate plan using figure 1&2 information figure 1 figure 2 figure 3 Value 480 100 90 Description Maximum regular hours per worker per quarter Maximum overtime hours per...

Q:

create mix aggregate plan using information below Description Maximum regular hours per worker per quarter Maximum overtime hours per worker per quarter Maximum number of workers Starting workforce...

Q:

create chase aggregate plan using information below Description Maximum regular hours per worker per quarter Maximum overtime hours per worker per quarter Maximum number of workers Starting workforce...

Q:

fill out figure 3 using figure 1 & 2 information. please note the rules. thank you! figure 1 figure 2 figure 3 rules Value 480 100 90 Description Maximum regular hours per worker per quarter Maximum...

Q:

fill out figure 3 using figure 1 & 2 information. please note the rules. thank you! figure 1 figure 2 figure 3 rules Value 480 100 90 Description Maximum regular hours per worker per quarter Maximum...

Q:

fill out figure 3 using figure 1 & 2 information. please note the rules. thank you! figure 1 figure 2 figure 3 rules Value 480 100 90 Description Maximum regular hours per worker per quarter Maximum...

Q:

The Sany Heavy Industry Co., Ltd is Chinas largest producer of heavy equipment. In fact, it is the fifth largest producer of this type of equipment globally. In 2014, its revenue was decreasing...

Q:

Techstreet.com is a small web design business that provides services for two main types of websites: brochure sites and e-commerce sites. One package involves an up-front payment of $90,000 and...

Q:

When bonds are issued at a discount and the effectil Multiple Choice More than if the bonds had been sold at a Less than the interest expense. Equal to the interest expense. Greater than the interest...

Q:

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...