Harvie Cost-Benefit Calculator

	A	B	D	E	G	H
1	Variables
2	Current software cost	2.0%
3	Harvie percentage	7.0%	Benefits		Costs
4	CC percentage	3.0%
5	Current average processing percentage	3.0%	Savings on margin for pulling boxes values to retail	$10,125.00	Harvie extra cost	$5,062.50
6	Average share cost/week	$25.00	Growth capability, extra income	$4,050.00	CC Fee	$0.00
7	Average number of weeks delivered/year	30	Admin time saved	$4,800.00	Custom box packing	$1,265.63
8	Number of members	135	Retention rates and cost of customer acquisition	$2,025.00	Labels	$121.50
9	Price increase for custom boxes	5%	Price increase	$5,062.50
10	Cost per label	$0.03	Sales loss if no changes made	$0.00
11	Extras sales / member / week	$1.00	Extras, increased sales	$810.00
12	Gross profit margin	20.0%
13			Total	$26,872.50	Total	$6,449.63
14	Calculations
15	Average yearly spend	$750.00			Total Yearly ROI	$20,422.88
16	Yearly sales volume	$101,250.00
17
18	Sales loss if no changes made
19	% loss	0%	Click Here for Instructions on How to Use this Spreadsheet!
20	Sales lost	$0.00
21
22	Cost of box packing
23	Minutes per box	1
24	Current weekly hours required to pack boxes	2.3
25	Average hourly wage	$15.00
26	Harvie box packing increase rate	1.25
27	% of shares being custom packed	100.00%
28	Extra cost/week	$42.19
29	Yearly cost of custom box packing	$1,265.63
30
31	Savings on margin
32	% above box value given	10%
33	Current average retail box value	$27.50
34	Savings on margin	$10,125.00
35
36	Growth Capability
37	% growth goal	20%
38	Number of new members	27
39	Yearly sales for these members	$20,250.00
40
41	Admin time
42	Admin cost/hour	$20.00
43	Hours saved per week	8
44	Hours saved per year	240
45	ROI	$4,800.00
46
47	Retention rates
48	Current Retention rate	50.00%
49	Harvie retention Rate	70.00%
50	Cost of Customer Acquisition (10% of yearly revenue per member)	$75.00
51	Lost customers per year	27
52	Cost	$2,025.00
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