Profit Projection - Excel

Document Sample
Profit Projection - Excel Powered By Docstoc
					                                        Increased Profit Example using the Bear Clip

      $250                 Average revenue per square
          6                Square per day is average for a crew                67 clips per square
          3                Men per crew                            $        0.16 MSRP cost per clip
    $1,500                 Average daily revenue per crew          $       10.72 retail cost per square for clips
          8                Hours per day per man
$    35.00                 Average hourly wage per man                          200 workdays annually
$      840                 Avg daily labor costs for a crew
$      660                 Average daily gross profit per crew
       44%                 % Gross Profit
                                                                       Gross Profit Per Crew
                           Squares                Revenue less
                                                                        Daily        Annually
                           per Day     Revenue      Clip Cost
Current-->                    6         $1,500           -         $         660    $   132,000
                              7                   $        1,675   $         835    $   166,992
    Increased Production




                              8                   $        1,914   $       1,074    $   214,848
                              9                   $        2,154   $       1,314    $   262,704
                             10                   $        2,393   $       1,553    $   310,560




                                                                                                  Typical
                             11                   $        2,632   $       1,792    $   358,416
                             12                   $        2,871   $       2,031    $   406,272
                             13                   $        3,111   $       2,271    $   454,128
                             14                   $        3,350   $       2,510    $   501,984
                             15                   $        3,589   $       2,749    $   549,840
                             16                   $        3,828   $       2,988    $   597,696

--------------------------------
Input Variables are in Blue Text w/ Yellow Background