Answered step by step
Verified Expert Solution
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:
4. 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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started