Using Microsoft Excel to Perform CVP Analysis
Balance, Inc., is considering the introduction of a new energy snack with the following price and cost characteristics:
Sales price
$ 1.00 per unit
Variable costs
0.20 per unit
Fixed costs
400,000 per month
Required
Using the Goal Seek function in Microsoft Excel,
a. What number must Balance, Inc., sell to break even?
b. What number must Balance, Inc., sell to make an operating profit t of $8,000 per month?