; Calculator
Documents
User Generated
Resources
Learning Center

# Calculator

VIEWS: 15 PAGES: 7

• pg 1
```									                                               Installer Profit Calculator
< Enter Customers Name Here >
See instructions below.
Enter inputs in the gold boxes.
\$25,000
\$23,770
Assumptions
\$21,189
Customers per                              \$20,000
\$18,700
Day                     40
\$16,301
\$15,000                                                                   Petroleum Profit
Customers per                                                   \$13,989
Month              1200.00                        \$10,680                                                         Synthetic Profit
\$10,000
Petroleum Oil
Change Profit \$           8.90                                                                                      Gross Profit
\$5,000
Oil Change                                                                                                         Net Profit due to
Profit       \$       25.00                                                                                      Synthetics
*Percent                                    \$0
Customer
Growth                 1.0%

*Growth can be normal growth and/or can be additional customers served in the open slots provided by the synthetic
customers not coming in as often
Year Gross Profit Combo                  \$204,284
Claculator Tab                                        Year Profit from Synthetics               \$68,834
Click on the Calculator tab below to see              Petroleum Only Profit                    \$135,449
the annual results.                                   % Increase due to synthetics                   51
Installer Profit Calculator Instructions
**Important Notice**
While AMSOIL makes every effort to provide complete and accurate information for these spread sheets and other similar Dealer tools, there is no
guarantee that the information therein is current, complete, sufficient and/or suitable for the purposes for which the Dealer is using the tools. Use of the
tools is at the risk of the Dealer. Because of the potential for inaccurate results while using said tools, AMSOIL excludes and disclaims any guarantee or
warranty, express or implied, that said work tools are free from inaccuracy. Further, AMSOIL disclaims all liability for damages, direct or indirect,
consequential, incidental or special, arising out of the use of said work tools.

DETAILED CALCULATOR
Once the inputs are set, the corresponding figures will change automatically. Inputs (Gold Boxes) for this cost calculator include the
number of customers per day (1), the profit from a petroleum oil change (2), the profit from a synthetic oil change (3), and a percentage
growth rate (4).

Input Numbers
Customers per Day (input number 1)
Enter total daily number of customers receiving an oil change. As this input number changes all other numbers will change accordingly.
Total monthly customers will be your daily number of customers multiplied by 30.

Petroleum Oil Change Profit (input number 2)
Enter the amount of profit seen on each petroleum oil change.

Synthetic Oil Change Profit (input number 3)
Enter the amount of profit seen on each synthetic oil change.

Percent Customer Growth (input number 4)
Enter the amount each month that the customer base grows. Growth can be normal growth and/or can be additional customers served
in the open slots/bays provided by the synthetic customers not coming in as often.
Petroleum Changes:
Customers per month receiving petroleum oil changes at a % growth increase. Derived from multiplying the number of customers
(input number 1) by the % growth increase (input number 4) then multiplied by the percentage of total petroleum changes.
Ex. 1200 customers per month (from previous month) * 1% = 1212 customers (total now for current month) * .95 = 1151

Synthetic Changes:
Customers per month receiving synthetic oil changes at a % growth increase. Derived from multiplying the number of customers
(input number 1) by the % growth increase (input number 4) to get total number of changes. Subtract petroleum changes from total
changes to get the number of synthetic changes. Ex. 1200 customers per month (from previous month) * 1% = 1212 customers
(total now for current month) - number of petroleum changes = 61 (1212 - 1151 = 61)

Percent Synthetic:
Considering a 5% increase in synthetic customers per month, the number of synthetic changes will increase 5% each month.

Petroleum Profit:
Total number of petroleum changes multiplied by amount of profit from a petroleum change (input number 2). Ex. 1151 * \$8.90 = \$10,247

Synthetic Profit:
Total number of synthetic changes multiplied by amount of profit from a synthetic change (input number 3). Ex. 61 * \$25.00 = \$1,515

Gross Profit:
Total profits from adding together monthly petroleum profits and monthly synthetic profits. Ex. \$10,247 + \$1,515 = \$11,762 gross profit

Net Profit due to Synthetics:
This is the profit made purely by having synthetic oil changes. Derived from monthly gross profit minus the total number of customers
multiplied by petroleum profits. This is a way to show if all customers would have gotten a petroleum oil change how much money
they are missing out on from not having synthetic changes. Ex. \$11,762 - (1212 * \$8.90) = \$976

Year Gross Profit Combo:
The sum of all monthly gross profits for both petroleum and synthetic changes.

Year Profit from Synthetics:
The sum of all monthly net profits due to synthetic changes. Make sure you know the difference between Synthetic Profits and Net
Profits due to Synthetics.
Petroleum Only Profit
Total profit throughout the year if all customers had petroleum changes.

% Increase due to Synthetics
Percentage yielded from Year Gross Profit Combo divided by Petroleum Only Profit, then multiplied by 100, and the total subtracted
by 100. This is % increase because synthetics was added. Ex. ((\$204,284 / \$135,449) * 100) -100 = 51%
Quick Lube Cost Calculator
< Enter Customers Name Here >
January February    March     April      May      June      July      August    September    October    November      December
Petroleum
Changes           1200     1151      1102      1051       999       946       892       836          780        722          663           602
Synthetic
Changes              0       61       122       185       250       315       382       450          520        591          663           736
Percent
Synthetic            0        5        10        15        20        25        30        35           40         45             50          55
January February    March     April      May      June      July      August    September    October    November      December
Petroleum
Profit         \$10,680   \$10,247   \$9,805    \$9,353    \$8,891    \$8,419    \$7,936     \$7,443      \$6,939      \$6,424       \$5,899       \$5,362
Synthetic
Profit              \$0    \$1,515   \$3,060    \$4,636    \$6,244    \$7,883    \$9,554 \$11,257        \$12,994     \$14,765      \$16,569      \$18,409
Gross Profit   \$10,680   \$11,762   \$12,866   \$13,989   \$15,135   \$16,301   \$17,490   \$18,700      \$19,933    \$21,189      \$22,468      \$23,770
Net Profit
due to
Synthetics                 \$976    \$1,971    \$2,986    \$4,021    \$5,076    \$6,153     \$7,250      \$8,368      \$9,508      \$10,671      \$11,855

Year Gross Profit Combo              \$204,284
Year Profit from Synthetics            \$68,834
Petroleum Only Profit            \$ 135,449
% Increase due to synthetics                51

January February    March     April      May      June      July      August    September    October    November      December
Customers
per day           40     40.40     40.80     41.21     41.62     42.04     42.46     42.89        43.31      43.75        44.18         44.63
Customers
per month     1200.00   1212.00 1224.12 1236.36 1248.72 1261.21 1273.82 1286.56                 1299.43     1312.42      1325.55      1338.80

Total
Customers
per Year          15,219

```
To top
;