FunMedia company is looking into investing in a new headset customized for IOS users. The company anticipates the selling price of the new headset will be $15.99. The fixed cost for the new product is $28,000 and the variable cost per unit at $12.00.
Use MS Excel to build a model to calculate the profit/loss of the new headset for the company.
Using the built model, answer the following questions. (round your answer to the nearest whole number and type the answer in the textbox).
a. If the demand quantity is 10,000 units, the profit/loss for the new headset is
b. To earn $18,000 in profit, the company is expected to sell units (demand quantity). Hint: use Goal Seek on this question.