2.pdf

(9 KB) Pobierz
Direct Mail Profit Worksheet Formulas.xls
A
B
C
D
E
1
Note: Fill In Or Change Only The Cells Highlighted in Yellow!
2
Do NOT Change Any of the Other Cells -- Data Will Automatically Be Calculated For You
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
SUREFIRE DIRECT MAIL PROFIT WORKSHEET™
Name of Mailing:
Tracking Code:
Comments:
GENERAL INFO
Name of List:
Size of Mailing:
Date Dropped:
Rental List Cost
Select Charges
House List
#Pieces Sent
Date
$$$$$
$$$$$
Back-End Expenses
Telephone costs/literature fufilmnt/sales
Expenses <<List>>
$$$$
<<List>>
<<List>>
$$$$
$$$$
MAILING COSTS
Printing
Postage/Piece
Addressing
Other
Mail List Costs
Mail Costs
Printing Costs
TOTAL MAIL PIECE COSTS:
Back End Costs
$$$$
$$
$$$$
$$$$
{=B14+B15}
{=(B19*B11)+B20+B21}
{=B18}
{=B23+B24+B25}
{=SUM(E12:E14)}
RESPONSE
Inquiries Received
#Sales
Dollar Amount
#
#
$$$$$
(Do Not Alter Formulas)
TOTAL COSTS:
Response %
Cost Per Lead
Cost Per Sale
Total Cost Per Lead
Total Cost Per Sale
© 2000 Surefire Marketing, Inc.
{=B26+B27}
{=E18/B11}
{=B26/E18}
{=B26/E19}
{=B28/E18}
{=B28/E19}
PROFIT/LOSS
Total Revenue
EXPENSES
{=E20}
{=B28}
NET INCOME
ROI %
{=E32-E33}
{=E32/E33}
Copyright 2000 Surefire Marketing, Inc.
Direct Mail Profit Worksheet Formulas.xls
F
1
2
3
4
5
6
7
8
9
10
11
call, etc.
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
G
Copyright 2000 Surefire Marketing, Inc.

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin