This web page contains a live and functional spreadsheet created with
SpreadsheetConverter
. Please enable JavaScript in your web browser for the live calculations to work properly.
Section 1 (Breakeven Calculations):
Mailing Cost /1000
Premium / Incentive cost per order
Gross margin $'s per order
Marketing ROI (100% equals breakeven) (defaults to 100% - adjust up or down to fit your desired profit % goal.)
% of responders that buy (defaults to 100% the maximum - adjust down to meet your goals for this activity.)
ROAI Response Rate - Minimum response rate required to achieve desired Marketing ROI (ROAI Response Rate) based on % of responders that actually buy and the specified Marketing ROI %
Breakeven Response Rate - Based on Achieving Marketing ROI of 100% at the specified % of responders that buy (best case scenario, 100% of responders buy)
Section 2 (Circulation Calculations):
2a.
ROAI Sample Circulation Calculations
Check this box to use
ROIA Response Rate
above in test mailing sizing parameters.
-- OR --
To use a different response rate than the ROIA Response Rate above, enter it here.
(The ROIA box must be unchecked.)
Choose the Confidence Level you want (90%, 95%, 99%).
Please Select
90
95
99
Anticipated response rate percentage that you expect for this program.
Select the Confidence Interval (Margin of Error) % (+ or -) for this program.
Please Select
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
The minimum mail circulation sample size required for testing this program is:
Minimum response rate given limit of
error:
Maximum response rate given limit of error:
2b.
Breakeven Sample Circulation Calculations
Check this box to use the
Breakeven Response Rate
response rate above in test mailing sizing parameters.
-- OR --
To use a different response rate than the Breakeven Response Rate above, enter it here.
(The use Breakeven Response Rate box must be unchecked.)
Choose the Confidence Level you want (90%, 95%, 99%).
Please Select
90
95
99
Anticipated response rate percentage that you expect for this program.
Select the Confidence Interval (Margin of Error) % (+ or -) for this program.
Please Select
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
The minimum mail circulation sample size required for testing this program is:
Minimum response rate given limit of
error:
Maximum response rate given limit of error:
Reset
Print