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
$10,125.00
Harvie extra cost
$5,062.50
6
Average share cost/week$25.00Growth capability, extra income$4,050.00CC Fee$0.00
7
Average number of weeks delivered/year
30Admin time saved$4,800.00
Custom box packing
$1,265.63
8
Number of members135
Retention rates and cost of customer acquisition
$2,025.00Labels$121.50
9
Price increase for custom boxes5%Price increase$5,062.50
10
Cost per label$0.03Sales loss if no changes made$0.00
11
Extras sales / member / week$1.00Extras, increased sales$810.00
12
Gross profit margin20.0%
13
Total$26,872.50Total$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
% 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
2.3
25
Average hourly wage$15.00
26
Harvie box packing increase rate1.25
27
% of shares being custom packed100.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 given10%
33
Current average retail box value$27.50
34
Savings on margin$10,125.00
35
36
Growth Capability
37
% growth goal20%
38
Number of new members27
39
Yearly sales for these members$20,250.00
40
41
Admin time
42
Admin cost/hour$20.00
43
Hours saved per week8
44
Hours saved per year240
45
ROI$4,800.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)
$75.00
51
Lost customers per year27
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
Loading...