Excel Applications for Accounting Principles 4th Edition by Gaylord Smith

Exercise 2

PROBLEM DATA
Poleski Manufacturing, which maintains the same level of inventory at the end of each year, provided the following information about expenses anticipated for next year:

The selling price of Poleski's single product is $16. In recent years, profits have fallen and Poleski's management is now considering a number of alternatives. Poleski wants to have a net income next year of $250,000, but expects to sell only 120,000 units unless some changes are made.
REQUIREMENT
Open the file CVP from the website for this book at cengagebrain.com. Enter the formulas where indicated on the worksheet. Enter your name in cell A1. Save the solution as CVP2 and print the worksheet. Also print your formulas. Check figures: Break-even point in sales dollars (cell C35), $1,616,000; Net income (cell C38), $95,000.