Docstoc

Calculator

Document Sample
Calculator Powered By Docstoc
					                                               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

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:15
posted:12/18/2011
language:
pages:7