Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer plz As the CEO of Hakoopian clothing company you want to decide whether to manufacture a particular product or outsource its production. Your business

image text in transcribed

Answer plz

image text in transcribed
As the CEO of Hakoopian clothing company you want to decide whether to manufacture a particular product or outsource its production. Your business analysis team develops a spreadsheet model and uses Excel's What-If analysis to analyze "Savings due to Outsourcing" based on different scenarios. The results below are provided to you as the CEO. LU Parameters y Z Outsourcing Cost per unit 4.50 Savings due to outsourcing per prod. volume Savings due to outsourcing per prod. volume and outsource cost per unit Prod.Vol. $ 14,500.00 HNm t nor Fixed Cost 14,500.00 S 4.20 $ 4.35 $ 4.50 $ 4.65 $ 4.80 25,000.00 10000 $21,500 10000 Material cost per unit $24,500 $23,000 $21,500 $20,000 $18,500 2.15 20000 $18,000 20000 $24,000 $21,000 Labor cost per unit $18,000 $15,000 $12,000 2.00 30000 $14,500 30000 $23,500 $19,000 $14,500 $10,000 $5,500 40000 $11,000 40000 $23,000 $17,000 $11,000 $5,000 ($1,000) Model 50000 $7,500 50000 $22,500 $15,000 $7,500 ($7,500) 9 Production Volume 30000 60000 $4,000 60000 $22,000 $13,000 $4,000 ($5,000) ($14,000) 70000 $500 70000 $21,500 $11,000 $500 ($10,000) ($20,500) 11 Total Outsource Cost $ 135,000.00 80000 ($3,000 80000 $21,000 $9,000 ($3,000) ($15,000) ($27,000 90000 ($6,500) 90000 $20,500 $7,000 ($6,500) ($20,000) ($33,500) 13 Total Fixed Cost 25,000.00 100000 ($ 10,000) 100000 $20,000 $5,000 ($10,000) ($25,000) ($40,000) 14 Total Material Cost 64,500.00 The outsourcing cost per unit is $4.50 The amounts in parantheses are negative (loss). 15 Total Labor Cost 60,000.00 The amounts in parantheses are negative ( loss). The first (left-most) column represents the production volume. 16 Total Cost $ 149,500.00 Left column represent production volume. The top row amounts represent "Outsourcing Cost per unit." Right column represent "Savings due to outsourcing" The amount in each cell represent "Savings due to outsourcing." 18 Savings due to outsourcing $ 14,500.00 Assuming that you outsource the production of 50,000 units and the company to which you outsource charges you $4.50 per unit, based on the results above, how much will be the savings (or loss) due to outsourcing? Note: . Do not use the $ sign in your answer. For example, if there is a saving of $99, the answer is 99 . Use a negative sign before the amount to show that it is a loss. For example, if there is a loss of $99, the answer is -99. If there is a saving of $99, then the answer is 99

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

Step: 3

blur-text-image

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

Geometry

Authors: David A Brannan, Matthew F Esplen, Jeremy J Gray

2nd Edition

1139200658, 9781139200653

More Books

Students also viewed these Mathematics questions

Question

6. Focus on one idea at a time, and avoid digressions.

Answered: 1 week ago