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?