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	$26,250.00	Harvie extra cost	$13,125.00
6	Average share cost/week	$30.00	Growth capability, extra income	$10,500.00	CC Fee	$0.00
7	Average number of weeks delivered/year	35	Admin time saved	$5,600.00	Custom box packing	$2,734.38
8	Number of members	250	Retention rates and cost of customer acquisition	$5,250.00	Labels	$262.50
9	Price increase for custom boxes	5%	Price increase	$13,125.00
10	Cost per label	$0.03	Sales loss if no changes made	$0.00
11	Extras sales / member / week	$1.00	Extras, increased sales	$1,750.00
12	Gross profit margin	20.0%
13			Total	$62,475.00	Total	$16,121.88
14	Calculations
15	Average yearly spend	$1,050.00			Total Yearly ROI	$46,353.13
16	Yearly sales volume	$262,500.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	4.2
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	$78.13
29	Yearly cost of custom box packing	$2,734.38
30
31	Savings on margin
32	% above box value given	10%
33	Current average retail box value	$33.00
34	Savings on margin	$26,250.00
35
36	Growth Capability
37	% growth goal	20%
38	Number of new members	50
39	Yearly sales for these members	$52,500.00
40
41	Admin time
42	Admin cost/hour	$20.00
43	Hours saved per week	8
44	Hours saved per year	280
45	ROI	$5,600.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)	$105.00
51	Lost customers per year	50
52	Cost	$5,250.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