Harvie Cost-Benefit Calculator
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Variables
2
Current software cost2.0%
3
Harvie percentage7.0%BenefitsCosts
4
CC percentage3.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.00Growth capability, extra income$10,500.00CC Fee$0.00
7
Average number of weeks delivered/year
35Admin time saved$5,600.00
Custom box packing
$2,734.38
8
Number of members250
Retention rates and cost of customer acquisition
$5,250.00Labels$262.50
9
Price increase for custom boxes5%Price increase$13,125.00
10
Cost per label$0.03Sales loss if no changes made$0.00
11
Extras sales / member / week$1.00Extras, increased sales$1,750.00
12
Gross profit margin20.0%
13
Total$62,475.00Total$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
% loss0%
Click Here for Instructions on How to Use this Spreadsheet!
20
Sales lost$0.00
21
22
Cost of box packing
23
Minutes per box1
24
Current weekly hours required to pack boxes
4.2
25
Average hourly wage$15.00
26
Harvie box packing increase rate1.25
27
% of shares being custom packed100.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 given10%
33
Current average retail box value$33.00
34
Savings on margin$26,250.00
35
36
Growth Capability
37
% growth goal20%
38
Number of new members50
39
Yearly sales for these members$52,500.00
40
41
Admin time
42
Admin cost/hour$20.00
43
Hours saved per week8
44
Hours saved per year280
45
ROI$5,600.00
46
47
Retention rates
48
Current Retention rate50.00%
49
Harvie retention Rate70.00%
50
Cost of Customer Acquisition (10% of yearly revenue per member)
$105.00
51
Lost customers per year50
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
Loading...
Main menu