ABCDEFGHIJKLMNOPQRSTUVWXY
1
Inflation Impact Calculator
2
3
4
5
BeforeInflationToday = Before + InflationIncrease My PriceTomorrow
6
7
Nr. Of Pools or Pool Stops
300 Pools
Price per month
$160.00
Reduced Nr. Of Pools
300 Pools
8
Price per Pool per month
$120.00
No extra Charges
$6.00
9
$5.00Months since last
New All-In prices
10
All-In Price /month $120.00Price Increase
Price per month
$160.00
New All-in Price / Month
$160.00
11
All-In Price per stop$27.6912price per stop$36.93
New All- In price / stop
$36.93
12
My Monthly Revenue
$36,000.00
My Monthly Revenue
$36,000.00
Price Increase of
33%
New Monthly Revenue
$48,000.00
13
14
Hours per tech per week
40.00 Hrs.
Hours per tech per week
40.00 Hrs.
15
Avg. Pools Per Route90 PoolsMy cost has gone up by:Avg. Pools Per Route90 Pools
Resulting Pools per Route
90 Pools
16
17
Cost of Chems Per Stop
$10.00Chems32%
Cost of Chems Per Stop
$13.20
Customer Loss %
0%
Cost of Chems Per Stop
$13.20
18
My Labor Hourly Rate$17.00
Hourly rate
6%My Labor Hourly Rate$18.02
Customers Lost
0 PoolsMy Labor Hourly Rate$18.02
19
Cost per pool per stop
$22.47
Cost per pool per stop
$26.41
Cost per pool per stop
$26.41
20
21
My Total Cost$29,204.42
(*) see table below if
My Total Cost$34,336.43My Total Cost$34,336.43
22
you need help calcu-
23
My Gross Margin$6,795.58
lating your Chems and
My Gross Margin$1,663.57My Gross Margin$13,663.57
24
Gross Margin %19%
Labor average inflation
Gross Margin %5%Gross Margin %28%
25
26
Admin Expenses15%Admin Expenses15%Admin Expenses11%
27
28
My Profit/Cash$1,395.58My Profit/Cash-$3,736.43My Profit/Cash$8,263.57
29
4%-10%17%
30
31
Cash Flow Reduction
-368%
Cash Flow Increase
492%
32
33
34
Key Questions:
How many customers can I afford to lose at the new price of $160.00/month and still maintain my original net margin of $1,396 ?
Answer:
You can afford to lose 36% or ~109 Customers.
35
How many customers can I afford to lose at the new price of $160.00/month and still maintain my original revenue of $36,000 ?
Answer:
25% or ~75 customers. Margin is now 10% or $3,559.
36
What is the minimum price to maintain $1,396 margin if I accept to lose .0% of my customers
Answer:
Minimum Price should be $137.11
37
38
Disclaimer: This spreadsheet uses certain hardwired assumptions that may not apply to all busineses. A detailed and insependent analysis is necessary before making any significant business decisions.
39
The numbers presented are for illustration purposes only and merely directional. They should not be taken as guidanc eon how to make changes to your buisness. Main purpose is to understand how to preserve cash flow.
40
For NPP internal use only. NPP is not repsonsible for any consequences, direct or indirect, stemming from the use of this tool outside it's own affiliate companies.
41
42
Chems Inflation help tool: (enter prices you know for at least some of the products below, and what type of routes you run)
Labor Inflation Help Tool
43
My Chem Prices
% of my routes where I use mostly:
My Hourly rates
44
12 Months Ago
TodayDelta %Liquid Chlorine80%
12 Months Ago
$17.00
/ Hr.
45
Liquid Chlorine$2.00 (*)$3.50 75%Tabs20%Today$18.00
/ Hr.
46
Tabs$5.00 (*)$6.00 20%Salt0%
47
Cal Hypo$3.00 $3.00 0% 100%
My benefits ( % of total pay roll)
48
Acid$7.00 $8.00 14%
12 Months Ago
of Payroll
49
Bicarb0%Today
of Payroll
50
Stabilizer0%
51
Calcium0%My estimated average Chems Inflation over the past 12 Months is:32%Average Labor Inflation in the past 12 Months is:6%
52
Salt0%
53
Enzymes0%
54
55
(*) If chem prices are left blank, the model will assume 0% inflation for that item - Prices Marked with (*) are mandatory
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