Using Excel to perform CVP Analysis

Using Goal Seek function in Excel.

a) What number must Derby Phones sell to break-even?

b) What number must Derby Phones sell to make an operating profit of $6000 per month?

Derby Phones is considering the introduction of a new model of headphones with the following price and cost characteristics. Sales price $ 270 per unit Variable costs 120 per unit Fixed costs 300,000 per month