Linda Carpenter owns a small business in New Hampshire. A friend has asked to partner with her in the business. In order to know if she wants to expand the business, Linda wants to run some computations to better understand the existing business.

Budgeted data for the next 12 months includes:

Revenues $600,000 Fixed costs $150,000 Variable costs $425,000

Variable costs will change based on the number of products sold. Use an Excel spreadsheet to compute expected operating income for each of the following scenarios:

A 5% increase in contribution margin, but keeping revenues steady

A 5% decrease in fixed costs

A 10% increase in units sold

A 15% increase in units sold and a 5% increase in fixed cost

A 5% decrease in variable costs and a 5% decrease in fixed cost

Within the Excel spreadsheet, after the above computations, please address the following question: what conclusions can you draw based on the analysis you performed?