ABCDEFGHIJKLMNOPQR
1
2
ROI Calculator
3
4
How to use the calculator:
Step 1: Make a copy of this sheet or download as an excel fille.
Step 2: Variable fields are in white boxes. Adjust the values in each of these areas to discover the current cost of order workflow management to the savings you can achieve leveraging OrderEase integrations and electronic data exchange.
5
Contact us with any questions or if you would like to schedule a demo to see more of the OrderEase solution. sales@orderease.com
6
7
Order Workflow InputsCurrent Order Management Cost (per year)$113,900
8
Cost per Order$5.58
9
SalesMargin Impact2.23%
10
Monthly number of orders across channels and/or PDF's1,700Y1 Order Automation Savings$81,400
11
Average order size$250ROI250%
12
Annual order volume20,400Cost per Order1.59
13
Approximate annual order value$5,100,000Margin Impact0.64%
14
Payback Months4.79
15
LaborY2 Order Automation Savings$89,900
16
Average yearly cost per order entry person$55,000ROI375%
17
Cost per Order1.18
18
Order WorkflowMargin0.47%
19
Time spent entering an average order (minutes)8
20
Year 1 Calculations
21
Order ErrorsOnboarding / ERP Integration Fees - One Time ($) 5,000
22
Average % system order error rate5%Monthly subscription cost ($) 2,000
23
Average $ cost per error$75Channel connections 14
24
Channel connection fee - Per channel ($) 250
25
Channel Integration Savings VariablesTotal channel connection fees ($) 3,500
26
Conversion of existing manual order management to digital orders100%Annual subscription cost ($) 24,000
27
Projected time to manage an order (minutes)4
28
Projected % order error rate0.00%Total Year 1 Cost of Software$32,500
29
Year 2 Calculations
30
Order Management Cost CalculationMonthly subscription cost ($) 2,000
31
# of orders per year20,400Annual subscription cost ($) 24,000
32
# of minutes per order 4
33
Total minutes saved per year81,600Total Year 2 Cost of Software$24,000
34
% Efficiency gained50%
35
Full time employee savings (In Years)0.68
36
Full time employee yearly cost$55,000
37
38
Yearly Order Management Cost $37,400
39
Order Error Cost Calculation
40
Order entry error %5.00%
41
Average $ Cost per Error$75
42
Yearly Error Cost $76,500
43
44
45
46
47
48
49
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