How much must sales increase to cover an

increase in the marketing budget of $X?

Previous period total sales:

% Sales

Previous period Direct Job Costs (Cost of Goods Sold):

Previous period Fixed Costs (Operating and Overhead):

Previous period Break-even Sales:

Amount to be added to Advertising budget ($X):

Average contract price of new project:

Average contribution margin for each project:

Expected Gross Profit per Project based on current contribution margin:

Adjusted annual break-even:

Change in annual sales necessary to afford additional marketing expense and still break-even:

Will an increase in marketing effort provide additional revenue to at least cover the expense of the advertising? If the "Change in Annual Sales Necessary…" is a reasonable expected increase in sales because of the marketing campaign, you should make the bet.

Number of new projects necessary to cover additional marketing expense:

Effect on profit if:

Adjusted Profit

ROI

no new projects are sold ($):

1 new project is sold ($):

2 new projects are sold ($):

3 new projects are sold ($):

The results above assume that all current financial ratios (%COGS, $Fixed Costs) remain constant.