Docstoc

Basis - Excel

Document Sample
Basis - Excel Powered By Docstoc
					                                                          Typical Team Comparison
                                  BJ                                         15
                                  Tonee                     4              1.42
                                  Cindy                 2000               21.3
                                  Rhonda                 21.3
                                                      170400
                                                  309,818.18 $       70,328.73
                                                           48        73,426.91
                                        4                             3,098.18
                                                                      1,858.91      464.73


                                                   Bid GP%
                                                    22.70%
                                                    3,405,000
G & A Cost and Factors Matrix                    Closed GP %      award
Factor      G&A % Quality Service $   15,000,000    23.70%          3%
                                                  $ 3,555,000     4500
     25%     4.75%    6      6    $      712,500
     50%        5%    7      7    $      675,000                Per person
    100%     4.25%    8      8    $      637,500 Benchmark
    110%        4%   8.5    8.5   $      562,500 G & A Factor
    120%     3.50%    9      9    $      525,000 $      5,400 $         1,350
    130%     3.25%   9.5    9.5   $      487,500 Quality Factor
    140%     3.00%   10     10    $      450,000 $      5,940 $         1,485
    150%     2.75%                $      412,500 Service Factor
    160%     2.50%                $      375,000 $      5,940 $         1,485
    170%     2.25%                $      337,500
                              Quality Process
Number of Measurable Process Improvements initiated

Improvements            1         2          3          4         5          6           More
Score                   6         7          8         8.5        9         9.5           10


                                           Service

                                 Customer Team Rating Sheet
                Service Attributes Rated 1-10 (10 is highest rating)     1/12/2004
                           Quartery Evaluation FY 04 Q1                    Score
            1      Professional approach to work                            8.5
            2      Knowledge of human resources criteria and processes      7.1      *
            3      Knowledge of accounting skills and processes             8.1
            4      Conformance to policy                                    8.3
            5      Work ethics and work environment                         7.9      *
            6      Efficiency & completeness of work                        8.8
            7      Supportive of operations & sales                         8.0
            8      Timeliness                                               8.8
            9      Appearance of finished work                              9.2
           10      Cooperation                                              7.0      *
                   Total (average score)                                    8.2

        Quarterly ratings by:
                    Team Leaders                 1
                    Team Supervisors             1
                    Project Managers             1
                    APMs                         1
                    Executives                   1
                                                 5
Service Ratings 1/12/04
           TL          S            M           PM         APM         Total Avg
         1           8          9           9          8         8.6       8.5
         2           8          6           6          7         8.5       7.1
         3           9          8           7          9         7.6       8.1
         4           8          9           9          8         7.4       8.3
         5           9          8           8          5         9.4       7.9
         6           9          9           9          8         8.8       8.8
         7           8          8           8          8         8.2       8.0
         8          10          9           9          7         9.2       8.8
         9           9          9           9          9         9.8       9.2
        10           9          6           6          7           7       7.0
Total              8.7        8.1         8.0        7.6         8.5      8.17


Description of Quality Projects 1/12/04
                                                                G&A Overhead
                                                           2002 Overhead
                                        G& A     Salaries       105435              110707
                                      756-780    T&I             43228 148663.4      1.09%
                                          730    Bank            18362
                                          732    Shop to Jobs    -3372
                                          763    Interest        42945
                                          765    Misc Shop       13945
                                          770    Office          25705
                                          771    Plans/Courier 32687
                                          774    Postage          4942   116852      0.86%
                                                                          91954      0.67%
                                          777    R&M Equip       56282
                                          790    Tele            62995
                                          795    Utilities       47644   166921      1.22%

                                                                        524390.4     3.84%


                                                              240617

                                                 Revenue     13651228 240617.4       1.76%
        Sept 03 Numbers
        Ptg            Powder   Total
              12902726 1668055        14570781
                                                     Books




               2980614   415633        3396247                               Field KPI
                23.10%   24.92%         23.31%                         Bid GP     Actual GP
              11699398 1668055        13367453                           2756746 2593456
                                                     KPI




               2593456   415633        3009089                               Gain/Loss
                22.17%   24.92%         22.51%                          $       (163,289.93)
Contr         14232736 1668055        15900791                              Team Share
                                                     Bid




Est           10879056 1267722        12146778                          $        (97,973.96)
                23.56%   24.00%         23.61%                                 Loss
       11 Months                        Sept Powder Ohead
2003 Overhead               Revenue                          1668055
  101481                    Direct Cost                      1013701
   41607    143089    1.25% Job costOH
   21240                           955 Depr          31081
      732                          956 Bad Debt        170
   29201                           960 Shell Gas     41267
   21543                           965 GA Power      33417
   17416                           968 Tax PR         7200
   27570                           970 Supplies      81618
     6200   123902    1.08%        972 Misc           1440
              74057   0.65%        985 R & M          5674
   27398                           986 Equip R/M     36854
   85044                                                      238721
   42858    155300    1.35%           Total Job Cost         1252422
                                      Gross Profit            415633
           496347.8   4.33%                                    24.9%




11463474    217146    1.89%
                                 G & A KPI                 Sept 03 Q4 Closed/Q4 WIP
                                                                                                                                           5%    Under
               Bid GP% 23.6%                        Actual GP% 23.3%                                  GP % Gain -0.3%                         Bid
                                                                                                                                         G&A Gain Threshold

  03 Income thru Sept $              14,570,781        B-D Gain    $       (43,764.52) Under Bid Threshold $                         -

       Benchmarks:       2002 G&A Cost             $                   240,617                 % of 02 Revenue          1.76%

               Thru Sept 03 G&A Cost (Enter) $                     222,910                % of 03 Rev thru Aug           1.53%
   225785
    Service Score              8.0             Quality Score           10.0                    Each Person          $          310                                       Sept FY02
                                                                                                                                         Sept FY03 List of Accounts     Benchmark
    Factor     % G&A          G&A $       Service Service $           Quality        Quality $     G&A Team        Each Person            712 Salaries $ 101,481        $ 105,435
     50%        2.25%       $       -         6     $         -          6       $             -                                         756-80 T&I      $   41,607     $   43,228
     75%        2.00%       $       -         7     $         -          7       $             -         BJ                               730 Bank       $   21,962     $   18,362
    100%        1.76%       $       -         8     $         885        8       $             -       Tonee'                             763 Interest $     33,327     $   42,945
    110%        1.60%       $       -        8.5    $         -         8.5      $             -        Cindy                             770 Office     $   17,702     $   25,705
    120%        1.50%       $       -         9     $         -          9       $             -       Rhonda                             774 Postage $       6,830     $    4,942
                                                                                                                    $      310
    130%        1.40%       $       -        9.5    $         -         9.5      $             -                                                Total    $ 222,910      $ 240,617
    140%        1.30%       $       -        10     $         -         10       $          1,240
    150%        1.20%       $       -
    160%        1.10%       $       -
    170%        1.00%       $       -                                                                     4
Team Totals                 $       885             $         885                $          1,240                                        Hey! The company gain is negative; the following will apply:
Hey! The company gain is negative; the following will apply:                          5% of Overhead Reductions                            5% of Overhead Reductions
If the B-D gain is zero or negative the alternate below will include the gain in G & A cost plus service and quality factors
GA Gain      $ 17,708 $             885             $         885                $          1,240 Per Person        $    309.88

If the B-D gain is zero or negative the alternate below will include the gain in G & A cost plus service and quality factors

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:17
posted:3/25/2010
language:English
pages:6