Marketing Reinvestment Calculator 06/15/2023

	C	D	H	I	J	K	L	M	N	O	P	T	U	V
1
2
3	Marketing Reinvestment Calculator
4	Marketing Reinvestment Calculator
5
6
7
8	Marketing Allocation Calculator		Closed Deal Data Chart									Weekly Marketing Budget Breakdown
9	Deal Projection off Current Add Spend		Deal Name	Marketing Week Start	Marketing Hold %	Closed Revenue	Weeks Spread Out	Marketing Spend	Weekly Spend	Daily Spend	Marketing Week End	Week # in Quarter	Weekly Spend	Daily Spend
10	Cost Per Lead	$52.00	TEST	1	25.00%	$11,300.00	5	$2,825.00	$565.00	$80.71	5	1	$565.00	$80.71
11	Leads Per Deal	24.60	TEST	6	25.00%	$26,500.00	8	$6,625.00	$828.13	$118.30	13	2	$565.00	$80.71
12	Average Deal Size	$21,500.00	TEST	10	25.00%	$16,500.00	5	$4,125.00	$825.00	$117.86	14	3	$565.00	$80.71
13	Projected Deals Signed	27		15	25.00%	$22,000.00	6	$5,500.00	$916.67	$130.95	20	4	$565.00	$80.71
14	Projected Signed Revenue	$572,711.46		21	25.00%	$60,000.00	10	$15,000.00	$1,500.00	$214.29	30	5	$565.00	$80.71
15	Current Marketing Data For the Year											6	$828.13	$118.30
16	Total Closed Revenue	$136,300.00										7	$828.13	$118.30
17	Total Marketing Spend For The Quarter	$34,075.00										8	$828.13	$118.30
18	Average Daily Spend	$162.26										9	$828.13	$118.30
19	Total Closed Deals	5										10	$1,653.13	$236.16
20												11	$1,653.13	$236.16
21												12	$1,653.13	$236.16
22												13	$1,653.13	$236.16
23	Notes - If you are Having Trouble with what week of the year we are in here is a link. https://whatweekisit.com/											14	$825.00	$117.86
24												15	$916.67	$130.95
25												16	$916.67	$130.95
26												17	$916.67	$130.95
27												18	$916.67	$130.95
28												19	$916.67	$130.95
29												20	$916.67	$130.95
30												21	$1,500.00	$214.29
31												22	$1,500.00	$214.29
32												23	$1,500.00	$214.29
33												24	$1,500.00	$214.29
34												25	$1,500.00	$214.29
35												26	$1,500.00	$214.29
36												27	$1,500.00	$214.29
37												28	$1,500.00	$214.29
38												29	$1,500.00	$214.29
39												30	$1,500.00	$214.29
40												31
41												32
42												33
43												34
44												35
45												36
46												37
47												38
48												39
49												40
50												41
51												42
52												43
53												44
54												45
55												46
56												47
57												48
58												49
59												50
60												51
61												52
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100