Repeat Rate Worksheet

	B	D	F	H	J	L	N
1
2		A1	A2	B1	B2	C1	C2
3		Good	Good	OK	OK	Poor	Poor
4	Inputs	Low AOV	High AOV	Low AOV	High AOV	Low AOV	High AOV
5
6	Period 1 New Orders	500	500	1,000	1,000	1,000	1,000
7	Period 2 New Orders	1,500	1,500	1,500	1,500	1,000	1,000
8	Period 3 New Orders	3,000	3,000	2,000	2,000	1,000	1,000
9	Period 2 Repeat Rate	60%	50%	40%	35%	20%	15%
10	Period 3 Repeat Rate	80%	60%	50%	45%	30%	35%
11	AOV 1	$40	$125	$40	$125	$40	$125
12	AOV 2	$40	$125	$40	$125	$50	$150
13	AOV 3	$40	$125	$40	$125	$50	$150
14
15
16	Output
17
18	Period 1
19	New Orders	500	500	1,000	1,000	1,000	1,000
20	Repeat Orders
21	Repeat as % of Orders
22
23	New Revenue	$20,000	$62,500	$40,000	$125,000	$40,000	$125,000
24	Repeat Revenue
25	Repeat as % of Revenue
26
27	Period 2
28	New Orders	1,500	1,500	1,500	1,500	1,000	1,000
29	Repeat Orders	300	250	400	350	200	150
30	Repeat as % of Orders	17%	14%	21%	19%	17%	13%
31
32	New Revenue	$60,000	$187,500	$60,000	$187,500	$40,000	$125,000
33	Repeat Revenue	$12,000	$31,250	$16,000	$43,750	$10,000	$22,500
34	Repeat as % of Revenue	17%	14%	21%	19%	20%	15%
35
36	% of New Customers Repeat	60%	50%	40%	35%	20%	15%
37	% of Customer Base Repeats	60%	50%	40%	35%	20%	15%
38
39	Period 3
40	New Orders	3,000	3,000	2,000	2,000	1,000	1,000
41	Repeat Orders	1,140	900	800	683	260	203
42	Repeat as % of Orders	28%	23%	29%	25%	21%	17%
43
44	New Revenue	$120,000	$375,000	$80,000	$250,000	$40,000	$125,000
45	Repeat Revenue	$45,600	$112,500	$32,000	$85,313	$13,000	$30,375
46	Repeat as % of Revenue	28%	23%	29%	25%	25%	20%
47
48	% of New Customers Repeat	60%	50%	40%	35%	20%	15%
49	% of Customer Base Repeats	63%	51%	42%	37%	22%	18%
50
51
52
53
54
55
56
57
58
59
60
61
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