Question

The management of Madeira Manufacturing Company is considering the introduction of a new product. The fixed cost to begin theThe management of Madeira Manufacturing Company is considering the introduction of a new product. The fixed cost to begin the

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Profit = Sales - variable cost - fixed cost

Let c = variable cost per unit and X = demand.

a)

Thus, the profit model is as follows

Profit = Sales - variable cost - fixed cost

Profit = $35X - cX - $27,000

b)

Base case- Demand will be 1500 units and variable cost per unit = $19

Substituting the values in the profit model, we get

Profit = $35 * 1500 - $19 * 1500 - $27,000

Profit = $52,500 - $28,500 - $27,000

Profit = -$3,000

Best case- Demand will be 2000 units and variable cost per unit = $16

Substituting the values in the profit model, we get

Profit = $35 * 2000 - $16 * 2000 - $27,000

Profit = $70,000 - $32,000 - $27,000

Profit = $11,000

Worst case- Demand will be 700 units and variable cost per unit = $22

Substituting the values in the profit model, we get

Profit = $35 * 700 - $22 * 700 - $27,000

Profit = $24,500 - $15,400 - $27,000

Profit = -$17,900

Thus, there is a loss of $17,900

Que 2:

Ans:

  • Given,selling price =  $50 per unit.
  • Also Variable cost per unit is uniformly distributed between $16 to $24. (Let it be denoted by VC)
  • The demand is a Normal distribution .
  • Mean of Normal distribution is 1200 units and a standard deviation SD of 300 units. (Let it be denoted by SD).
  • Fixed cost(FC) =  $30,000.
  • Profit = SD(50 – VC) – 30,000

a) Using 500 simulation trials, formula used are displayed below:

C н A SP/unit Fixed Cost B 50 30000 Uniform d Normal Summary Statistics mean 5519.46 min -19666.9 max 42013.2 s.d 9608.9 prob

- fi E10 A SP/unit Fixed Cost =NORMINV(D10,$E$6,$E$7) D B C HT 50 30000 Uniform Normal Summary Statistics mean 5519.46 min -1

Mean profit of the simulation:Profit for 500 simulation Trials

fx F10 A SP/unit Fixed Cost =E10*($B$1-C10)-$B$2 D E C G - B 50 30000 H I Uniform d Normal Summary Statistics mean 5519.46 mi

From the Summary Statistics , Mean profit is $5519.46

b) The probability that the project will lead to a loss,

17 A SP/unit Fixed Cost fx =(COUNTIF(F10:F509,<0)/COUNT(F10:F509)) D E F G C B 50 30000 c Uniform Normal Summary Statistics

The probability that the project will lead to a loss is  0.294

Add a comment
Know the answer?
Add Answer to:
The management of Madeira Manufacturing Company is considering the introduction of a new product. The fixed...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT