Consulting Company Presentation - Excel

Document Sample
Consulting Company Presentation - Excel Powered By Docstoc
					Dollar-per-Hour Calculator                                                                     Instructions: Change only the yellow cells as desired.
                                                                                               Your target is at least $25 per hour.
Your Company Name
Dan Jensen Consulting                         dan@danjensen-consulting.com                              360-852-8300

Earnings from Retail Sales
Percent Earned                                                       5%           10%            15%           20%            25%           30%           35%           40%           45%         50%
Presentations per Week                                 2.0
Presentations resulting in a Sale                      2.0
Average Presentation / Show / Party (Guest)   $       500
Sales per Week                                $     1,000
Commissions per Presentation                                 $     25.00   $     50.00   $     75.00    $    100.00    $    125.00   $ 150.00      $ 175.00      $ 200.00      $ 225.00      $ 250.00
Hours Spent on Business per Week                       9.6
Gross $$ per Hour Before Costs                               $      5.21   $     10.42   $     15.63    $     20.83    $     26.04   $ 31.25       $ 36.46       $ 41.67       $ 46.88       $ 52.08
Costs per Presentation                        $     23.00    $     23.00   $     23.00   $     23.00    $     23.00    $     23.00   $ 23.00       $ 23.00       $ 23.00       $ 23.00       $ 23.00
Net Earnings per Presentation                                $      2.00   $     27.00   $     52.00    $     77.00    $    102.00   $ 127.00      $ 152.00      $ 177.00      $ 202.00      $ 227.00
Net $$ per Hour After Costs                                  $      0.42   $      5.63   $     10.83    $     16.04    $     21.25   $ 26.46       $ 31.67       $ 36.88       $ 42.08       $ 47.29
Total Earnings per Month from Sales                          $        17   $      227    $      437     $      647     $      857    $ 1,067       $ 1,277       $ 1,487       $ 1,697       $ 1,907

Earnings from Autoship Customers                                 Month 1       Month 2       Month 3        Month 4        Month 5       Month 6       Month 7       Month 8       Month 9   Month 10
Monthly New Autoship Customers                         2
Monthly attrition rate of Autoship                   10%
Total Monthly Autoship Customers                                       2            4               5              7            8             9            10            11            12          13
Average Retail Profit per Customer                $10.00
Total Retail Profit from AutoShip                            $     20.00   $     38.00   $     54.20    $     68.78    $     81.90   $     93.71   $ 104.34      $ 113.91      $ 122.52      $ 130.26
Cell used for Net Earnings per Presentation   G15
Net $$ per Hour from Retail & Autoship                       $     23.33   $     25.21   $     26.90    $     28.41    $     29.78   $     31.01   $     32.12   $     33.12   $     34.01   $   34.82



Monthly Commissions from Downline                                   $50          $100          $150           $200           $250          $300          $350          $400          $450        $500
Net $$ per Hour with Commissions, Autoship                   $ 24.57       $ 27.69       $    30.62     $ 33.37        $    35.98    $ 38.45       $ 40.80       $ 43.04       $ 45.17       $ 47.22
Total Monthly Earnings                                       $    87       $ 365         $     641      $  916         $    1,189    $ 1,461       $ 1,731       $ 2,001       $ 2,269       $ 2,537

Costs per Presentation                                                                   Time per Presentation
Supplies                                      $      3.00                                Hours Doing Actual Presentation                                  1.00
Hostess Gift                                  $     10.00                                Setup at Presentation                                            0.25         Enter time in a
Other Gifts (Guests, Hostess)                 $       -                                  Tear Down at Presentation                                        0.25         fractional hour
Gasoline, to and from presentation            $      6.00                                Hostess Coaching                                                 0.25         format. 1 hour
Invitation Cards                              $       -                                  Drive Time To & From                                             0.75         30 minutes
Hostess Packet                                $      3.50                                Socializing at Presentation                                      0.50         would be 1.5
Order Forms                                   $      0.50                                Taking Orders at Presentation                                    0.25         hours.
Catalogs                                      $       -                                  Presentation Entry / Setup                                       0.25
Promotional Flyers                            $       -                                  Order Receiving and Prep                                         0.00
Other                                         $       -                                  Delivery to Customers / Hostess                                  0.00
Other                                         $       -                                  Hostess Followup                                                 0.10
Other                                         $       -                                  Customer Service / Resolution                                    0.20
                                              $     23.00                                Hours per Presentation:                                          3.80

                                                                                         Other time during week:                                          2.00
                                                                                         Total Time per Week:                                              9.6

				
DOCUMENT INFO
Description: Consulting Company Presentation document sample