Question: I figured part 'A' out, i don't how i got this one wrong! please help! Thank You!!! SummerFun, Inc, produces a variety of recreation and

I figured part 'A' out, i don't how i got this one wrong! please help! Thank You!!!
I figured part 'A' out, i don't how i got this
I figured part 'A' out, i don't how i got this
I figured part 'A' out, i don't how i got this
SummerFun, Inc, produces a variety of recreation and leisure products. The production manager has developed an aggregate forecast Month Forecast Mar 5e Apr May 55 Jun 60 Jul Se 44 Aug 40 Sep 51 Total 350 Use the following information to develop aggregate plans. Backorder cost Beginning inventory $20 per unit e units Regular production cost Overtime production cost Regular capacity Overtime capacity Subcontracting cost Subcontracting capacity Holding cost $ 80 per unit $120 per unit 40 units per month 8 units per month $ 140 per unit 12 units per month $10 per unit per month Develop an aggregate plon using each of the following guidelines and compute the total cost for each plan. Hint You will need extra output in April and August to accommodate demand in the following months . Use regular production Supplement using inventory, overtime, and subcontracting as needed No backlogs allowed (Round your Average values to 1 decimal place. Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter"0" wherever required.) Answer is complete and correct. M Apr May Jun JU Sop 50 44 55 60 50 40 51 350 40 40 40 8 20 40 8 0 40 8 3 40 8 12 40 8 S 00 280 51 19 0 4 0 3 Forecast Output Regular Overtime Subcontract Output Forecast Inventory Beginning Ending Average Backlog Costs Regular 0 0 4 0 40 30 0 0 0 0 0 0 OOOO 0 0 0 0 0 15 20 0 2 0 3 15 0 7 0 3,200 > 3.200 $3,200 960 280 >> Overtime Subcontract Inventory 960 3.200 980 0 20 3,200 960 3.200 980 1.680 0 3,200 960 280 0 420 20 C 22.400 6,120 2,660 70 360 0 15 0 0 15 4 175 Total $4440 4,180 4,600 5,840 4,440 3,575 31.250 b. Develop an aggregate plan using the same strategy from porta, except that backlogs are allowed here. There should be no backlog remaining at the end of September. Hint Use a maximum backlog of 5 in any given month You will need to develop a set of rules regarding which capacity option (regular, overtime, subcontracting) is always preferable, and regarding the timing of these options de is it cost-effective to build ahead (and thus carry inventory) or to incur a backlog (Round your Average values to 1 decimal place. Negative amounts should be indicated by a minus sign. Leave no cells blank.be certain to enter "0" wherever required.) Answer is complete but not entirely correct. Period MA Apr May Jun Jul Aug Sep Tote Forecast 50 44 55 60 50 40 51 350 50 50 $ 50 3503 50 % 0 0 503 0% 503 O 0 % 50 & 0 % 03 OX 0 6% 09 0 % -10 o 0 % 0 0 10 0 18 5 03 Output Regular Overtime Subcontract Output - Forecast Inventory Beginning Ending Average Backlog Costs 0 0 0 0 0 1 x 0 6X 3 0 6 % 1 4 0 0 13 0 10 0 0 103 183 9 0 10 & 18 9 0 4.000 4,000 4.000 40003 Regular Overtime $4,000 3 0 4,000 4.000 0 % 0 0X 08 03 28.000 0 03 0 3 X 0 % 0 Subcontract Inventory Backlog 0 o 0 03 03 40 0 4,040 30 0 10 180 4,190 10 % 0 08 0 103 0 4,010 180 41803 08 100 X 360 % 5 28 480 Total $ 4,000 X 4,030 4010

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!