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)
