Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

explain in excel: 4. If the demand is said to follow a normal distribution, what information do you expected to be given? 6. If the

explain in excel:

image text in transcribed

image text in transcribedimage text in transcribed4. If the demand is said to follow a normal distribution, what information do you expected to be given? 6. If the demand is said to follow a uniform distribution, what information do you expected to be given?

NewTech Media Manufacturing company is looking into investing in a new headset customized for video game consoles. The company anticipates the selling price of the new headset will be $4.89. The fixed cost for the new headset is $30,000, the labor cost per unit is $2.09 and the material cost per unit is $1.74. Use MS Excel to build a model to calculate the profit/loss of NewTech Media. From the results of the developed model, answer the following questions. 1 point If the demand is 20,000 units, the profit/loss for the new headset is (answer to the nearest whole number) Due to the current supply chain problem, the company anticipates material costs will increase, so they seek out new supplies for the required product materials. Five new suppliers propose their material cost per unit as $1.54,$1.64,$1.74,$1.84,$2.04. Use the developed model and the five different material costs proposed, to vary the demand from 5,000 to 50,000 in increments of 5000 to assess the sensitivity of profit/loss (hint: use 2-input data table). If the material cost is at $1.64, the break-even lies in the range If the material cost is at $1.74, the break-even lies in the range If the material cost is at $1.84, the break-even lies in the range 1 point To earn $10,000 in profit, the company is expected to sell how many units? (answer in 4 decimal points)

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_2

Step: 3

blur-text-image_3

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

Frank Woods Business Accounting Volume 2

Authors: Frank Wood, Alan Sangster

13th Edition

1292085053, 9781292085050

More Books

Students also viewed these Accounting questions

Question

Explain the process of MBO

Answered: 1 week ago