Fundamentals of Cost Accounting 2nd Edition by William Lanen, Carolyn Wells, Michael Maher

Exercise 23

Using Microsoft Excel to Perform CVP Analysis
Refer to the data for Balance, Inc., in Exercise 3-23.
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 of $60,000 per month