Question: Problem 3 (continued from P2) If the company can outsource the product for the cost of $250 per unit (with the max outsource capacity of

capacity of 80 units). What would be the optimized capacity plan? Show

Problem 3 (continued from P2) If the company can outsource the product for the cost of $250 per unit (with the max outsource capacity of 80 units). What would be the optimized capacity plan? Show the analysis to justify your recommendation (explain why your recommendation is the best option). A B D E E H F G Forecasted Sales Fixed cost 1.10 171.76 5 00 Sales of 1 Month Month product X 2 3 1 17-Apr 160 slope 4 2 17-May 150 intercept 5 3 17-Jun 156 6 4 17-Jul 190 7 5 17-Aug 260 8 6 17-Sep 272 9 7 17-Oct 80 10 8 17-Nov 164 11 9 17-Dec 154 12 10 18-Jan 160 13 11 18-Feb 188 14 12 18-Mar 250 15 13 18-Apr 270 16 14 18-May 84 17 15 18-Jun 168 18 16 18-Jul 154 19 17 18-Aug 166 20 18 18-Sep 192 21 19 18-Oct 270 22 20 18-Nov 280 23 21 18-Dec 74 24 22 19-Jan 174 25 23 19-Feb 164 26 24 19-Mar 196 27 25 19-Apr 206 28 19-May 288 172.86 $25,928.57 173.95 $ 26,092.86 175.05 $26,257.14 176.14 $ 26,421.43 177.24 $26,585.71 178.33 $ 26,750.00 179.43 $ 26,914.29 180.52 $ 27,078.57 181.62 $ 27,242.86 182.71 $ 27,407.14 183.81 $ 27,571.43 184.90 $27,735.71 186.00 $ 27,900.00 187.10 $ 28,064.29 188.19 $28,228.57 189.29 $ 28,392.86 190.38 $28,557.14 191.48 $28,721.43 192.57 $ 28,885.71 193.67 $29,050.00 194.76 $ 29,214.29 195.86 $ 29,378.57 196.95 $29,542.86 198.05 $ 29,707.14 199.14 $ 29,871.43 200.24 $ 30,035.71 26 AutoSave On Midterm - Saved File Home H Insert Draw View Formulas Data Page Layout Review X Cut ale Wrap Calibri v 11 ' ' [Copy = = Merc Paste BI UH V A Format Painter Clipboard Font Alignment D39 X fe A B D H E 280 74 174 164 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 18-Nov 18-Dec 19-Jan 19-Feb 19-Mar 19-Apr 19-May 19-Jun 19-Jul 19-Aug 19-Sep 19-Oct 19-Nov 19-Dec 20-Jan 196 206 288 288 96 F G 193.67 $ 29,050.00 194.76 $ 29,214.29 195.86 $ 29,378.57 196.95 $29,542.86 198.05 $ 29,707.14 199.14 $ 29,871.43 200.24 $30,035.71 201.33 $ 30,200.00 202.43 $30,364.29 203.52 $30,528.57 204.62 $30,692.86 205.71 $30,857.14 206.81 $31,021.43 207.90 S31,185.71 209.00 $31,350.00 Problem 3 (continued from P2) If the company can outsource the product for the cost of $250 per unit (with the max outsource capacity of 80 units). What would be the optimized capacity plan? Show the analysis to justify your recommendation (explain why your recommendation is the best option). A B D E E H F G Forecasted Sales Fixed cost 1.10 171.76 5 00 Sales of 1 Month Month product X 2 3 1 17-Apr 160 slope 4 2 17-May 150 intercept 5 3 17-Jun 156 6 4 17-Jul 190 7 5 17-Aug 260 8 6 17-Sep 272 9 7 17-Oct 80 10 8 17-Nov 164 11 9 17-Dec 154 12 10 18-Jan 160 13 11 18-Feb 188 14 12 18-Mar 250 15 13 18-Apr 270 16 14 18-May 84 17 15 18-Jun 168 18 16 18-Jul 154 19 17 18-Aug 166 20 18 18-Sep 192 21 19 18-Oct 270 22 20 18-Nov 280 23 21 18-Dec 74 24 22 19-Jan 174 25 23 19-Feb 164 26 24 19-Mar 196 27 25 19-Apr 206 28 19-May 288 172.86 $25,928.57 173.95 $ 26,092.86 175.05 $26,257.14 176.14 $ 26,421.43 177.24 $26,585.71 178.33 $ 26,750.00 179.43 $ 26,914.29 180.52 $ 27,078.57 181.62 $ 27,242.86 182.71 $ 27,407.14 183.81 $ 27,571.43 184.90 $27,735.71 186.00 $ 27,900.00 187.10 $ 28,064.29 188.19 $28,228.57 189.29 $ 28,392.86 190.38 $28,557.14 191.48 $28,721.43 192.57 $ 28,885.71 193.67 $29,050.00 194.76 $ 29,214.29 195.86 $ 29,378.57 196.95 $29,542.86 198.05 $ 29,707.14 199.14 $ 29,871.43 200.24 $ 30,035.71 26 AutoSave On Midterm - Saved File Home H Insert Draw View Formulas Data Page Layout Review X Cut ale Wrap Calibri v 11 ' ' [Copy = = Merc Paste BI UH V A Format Painter Clipboard Font Alignment D39 X fe A B D H E 280 74 174 164 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 18-Nov 18-Dec 19-Jan 19-Feb 19-Mar 19-Apr 19-May 19-Jun 19-Jul 19-Aug 19-Sep 19-Oct 19-Nov 19-Dec 20-Jan 196 206 288 288 96 F G 193.67 $ 29,050.00 194.76 $ 29,214.29 195.86 $ 29,378.57 196.95 $29,542.86 198.05 $ 29,707.14 199.14 $ 29,871.43 200.24 $30,035.71 201.33 $ 30,200.00 202.43 $30,364.29 203.52 $30,528.57 204.62 $30,692.86 205.71 $30,857.14 206.81 $31,021.43 207.90 S31,185.71 209.00 $31,350.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To determine the optimized capacity plan we need to analyze the decisions for each month based on th... View full answer

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 Finance Questions!

VARIETY ENTERPRISES CORPORATION: CAPITAL BUDGETING DECISION CASE INFORMATION ariety Enterprises Corporation (VEC) is planning to invest in a special manufacturing system to produce a new product. The...

VARIETY ENTERPRISES CORPORATION: CAPITAL BUDGETING DECISION CASE INFORMATION Variety Enterprises Corporation (VEC) is planning to invest in a special manufacturing system to produce a new product....

Please I am begging you this is urgent, and I'm having trouble with it. VARIETY ENTERPRISES CORPORATION: CAPITAL BUDGETING DECISION CASE INFORMATION Variety Enterprises Corporation (VEC) is planning...

Exercise 21-9 Contribution margin and break-even LO P2 Blanchard Company manufactures a single product that sells for $205 per unit and whose total variable costs are $164 per unit. The company's...

McGill Company produces a single product that sells for $25 per unit. At the company's current volume of 6,000 units per month, the costs of producing and selling the product are as follows: Per unit...

Please answer #6 and #7 in excel format with the formulas showing. Screenshots work perfectly! 7. Given the following forecast and cost information, determine the total cost of a chase plan that uses...

Problem 2: Problem 3 (Continued from Problem 2) If the company can outsource the product for the cost of \$250 per unit (with the max outsource capacity of 80 units). What would be the optimized...

Financial analysis you need to conduct: Financial of status quo: Cost of good sold? Variable cost? Contribution per unit? 5% increase of price will increase contribution by how much? Contribution...

These are the pages to read and the bottom is the questions Financial analysis you need to conduct: Financial of status quo: Cost of good sold? Variable cost? Contribution per unit? 5% increase of...

QUESTION 15 A project has one time investment of $1,000 and will save $400 each year for the next 3 years. The project's required rate of return is 8%. What is the project's net present value?

The accompanying stemplots depict ages of applicants who were unsuccessful in winning promotion and ages of applicants who were successful in winning promotion (based on data from Debating the Use of...

Q 9 . According to the Capital Asset Pricing Model ( CAPM ) , how can an asset's expected return be decomposed? Identify and explain each component in the CAPM formula for expected return. 1 . 5 pts

9. (15 points) A company is considering a new project that requires an investment of \$5 million. The project is expected to generate cash flows of $2 million in year 1,$3 million in year 2, and $4...

to promote and effect the cohesion of the organization: the corporate glue.

to facilitate a cultural and functional interchange in order to encourage managers to take a fresh look at problems and issues;

to gain top management involvement by ensuring that managers know the global resources of the organization;