Spruce Enterprises anticipates fixed costs of $25,000. Variable costs and expenses are expected to be 60% of sales.

Spruce Enterprises anticipates fixed costs of $25,000. Variable costs and expenses are expected to be 60% of sales. The president has asked you to develop a worksheet to calculate sales needed to break even and sales needed to achieve any desired net income (file name DESNI). Your worksheet should include a Data Section that contains fixed costs, desired net income, and variable costs as a percentage of sales. Assume as initial input for your model that the company wishes to achieve a net income of $10,000.