Mosaic - CRM Phase 1.G - Projects Budget Forecast - 20120224 - Includes Timba Extension

Document Sample
Mosaic - CRM Phase 1.G - Projects Budget Forecast - 20120224 - Includes Timba Extension Powered By Docstoc
					               Month           Fees        Expenses         Total
         September-10         $30,344        $2,058        $32,402
           October-10        $109,363       $20,332       $129,695
         November-10         $156,760       $11,094       $167,854
         December-10         $155,731        $8,992       $164,723
           January-11        $177,192       $21,313       $198,504
          February-11        $241,280       $18,868       $260,148
             March-11        $282,650       $27,137       $309,787
               Totals       $1,153,319     $109,793      $1,263,113


*NOTE: These are only Baker Tilly invoices and do not include fees/travel for Mosaic or other contracted resources through Mo
*NOTE: These fees are only for work on Phase 1.0 and partial Hypercare, we finished billing to 1.0 on 3/22/11.


SECTION BELOW WAS CREATED ON 10/3/2011 TO ADDRESS BRIAN OLSON REQUEST TO PULL ALL PHASE 1.0 SUPP


Invoice Date               Invoice NumberFees
               6/30/2011   BT536113       $ 19,802.50
               5/26/2011   BT531104       $ 15,345.00
               4/29/2011   BT522163       $ 57,681.50
               3/31/2011   BT513852       $ 68,485.00    <--- Half of March Invoice
                                          $ 161,314.00
d resources through Mosaic



L ALL PHASE 1.0 SUPPORT BAKER TILLY HOURS FROM CAPITAL TO EXPENSE.
By Resource by Month
                                                                                                       Tom Stol f i                  Ma tt Therri en           B en Ha nson                 B en Ha nson                   Chri s Noe                   Sa nj i v                   Ti mba             B I Dev el opment           Ma tt Ha l l er         Mi ke Huzi nec           K ev i n Coona n            Sta n Al a sky           Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00       Fa rza na /Hol e/Quere       R uchi r P a tel        Ja nua ry -00          Ja nua ry -00       P OLEP ALLY, R AGU      P ATWAR DHAN, AMEY        P a tni _Of f shore         R i ghtnow         P ALANI SWAMY, S            Ha rtsone         GOR UGANTU, SHI VA         I T f rom Da v i na       R esource 38           R esource 39           R esource 40           R esource 41           R esource 42           R esource 43           R esource 44           R esource 45           R esource 46           R esource 47
       Res
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       shi /Tewa ri                                                                                                                                       Da ta                                                                                         K                    Sprea dsheet
                                          Budget                                                                                   B usi ness P rocess      B usi ness P rocess                 B usi ness                Appl i ca ti on              Sa l esf orce               Of f shore
       Role         A ctual Hours                         A ctual Fees      Budget Fees           P roj ect Ma na ger                                                                                                                                                                                  B I Dev el opment       Qua l i ty Assura nce           Cognos                    Cognos                    Cognos                Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00        Tech Dev el opment       Tech Dev el opment         Ja nua ry -00          Ja nua ry -00       Da ta Conv ersi ons      Da ta Conv ersi ons     Da ta Conv ersi ons     Da ta Conv ersi ons     Da ta Conv ersi ons    Da ta Conv ersi ons     SAP I ntegra ti ons        I T R esources           Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00
                                           Hours                                                                                           Lea d                    Ana l y st           Ef f ecti v eness Lea d       R ea di ness Lea d             I ntegra ti on             Dev el opment
      Rate                                                                                        $250              $250            $205         $205        $180             $180         $205           $205         $175            $175       $251             $251        $25           $25       $100          $100       $275           $275       $165          $165       $165           $165       $165           $165        $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0          $30          $30        $95           $95        $0          $0         $0          $0         $95          $95         $90          $90        $30          $30       $250         $250       $370        $370       $77          $77       $150          $150      $299,727     $299,727      $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0
                                                                                                 A ctual            SOW            A ctual       SOW        A ctual           SOW         A ctual         SOW         A ctual          SOW       A ctual           SOW        A ctual       SOW       A ctual        SOW       A ctual         SOW       A ctual        SOW       A ctual         SOW       A ctual         SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW        A ctual        SOW       A ctual        SOW      A ctual      SOW       A ctual      SOW       A ctual        SOW       A ctual        SOW      A ctual        SOW      A ctual       SOW       A ctual      SOW       A ctual       SOW      A ctual        SOW        A ctual       SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual
 September-10           138h                 0h             $30,344                $0                48.0h             0.0h            42.0h         0.0h          5.0h          0.0h          41.8h         0.0h          0.0h           0.0h          0.0h          0.0h         0.0h        0.0h          0.0h       0.0h          1.0h        0.0h         0.0h        0.0h          0.0h        0.0h          0.0h        0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h           0.0h      0.0h         0.0h        0.0h        0.0h       0.0h        0.0h       0.0h          0.0h      0.0h           0.0h      0.0h          0.0h      0.0h         0.0h       0.0h        0.0h       0.0h         0.0h      0.0h          0.0h       0.0h         0.0h        0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h
    October-10          506h                 0h             $109,363               $0              194.0h              0.0h          144.5h          0.0h        99.0h           0.0h          44.0h         0.0h         22.0h           0.0h          0.0h          0.0h         0.0h        0.0h          0.0h       0.0h          2.0h        0.0h         0.0h        0.0h          0.0h        0.0h          0.0h        0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h           0.0h      0.0h         0.0h        0.0h        0.0h       0.0h        0.0h       0.0h          0.0h      0.0h           0.0h      0.0h          0.0h      0.0h         0.0h       0.0h        0.0h       0.0h         0.0h      0.0h          0.0h       0.0h         0.0h        0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h
  November-10          1423h                 0h             $201,385               $0              252.0h              0.0h          161.0h          0.0h        91.0h           0.0h          67.5h         0.0h       163.5h            0.0h        80.0h           0.0h      465.0h         0.0h          0.0h       0.0h          7.0h        0.0h         0.0h        0.0h          0.0h        0.0h          0.0h        0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h           0.0h      0.0h      120.0h         0.0h        0.0h       0.0h        0.0h       0.0h        16.0h       0.0h           0.0h      0.0h          0.0h      0.0h         0.0h       0.0h        0.0h       0.0h         0.0h      0.0h          0.0h       0.0h         0.0h        0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h
  December-10          1607h                 0h             $492,165               $0              176.5h              0.0h          136.5h          0.0h      101.0h            0.0h          40.3h         0.0h       125.0h            0.0h        81.5h           0.0h      496.0h         0.0h          0.0h       0.0h          8.5h        0.0h         0.0h        0.0h          0.0h        0.0h          0.0h        0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h       101.0h        0.0h      160.0h         0.0h        0.0h       0.0h        0.0h       0.0h      160.0h        0.0h           0.0h      0.0h          0.0h      0.0h         4.0h       0.0h        0.0h       0.0h         0.0h      0.0h        16.0h        0.0h         1.0h        0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h
    January-11         3073h                 0h             $291,593               $0              229.5h              0.0h          190.0h          0.0h      114.0h            0.0h          88.0h         0.0h       210.0h            0.0h        92.5h           0.0h     1028.0h         0.0h        89.0h        0.0h          2.0h        0.0h         0.0h        0.0h          0.0h        0.0h          0.0h        0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h       626.0h        0.0h      168.0h         0.0h        0.0h       0.0h        0.0h       0.0h      160.0h        0.0h           0.0h      0.0h          0.0h      0.0h         0.0h       0.0h        1.0h       0.0h         0.0h      0.0h        75.2h        0.0h         0.0h        0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h
   February-11         3133h                 0h             $316,333               $0              232.0h              0.0h          224.0h          0.0h        30.0h           0.0h        192.0h          0.0h       197.5h            0.0h      100.0h            0.0h     1080.0h         0.0h      219.0h         0.0h        30.0h         0.0h         0.0h        0.0h          0.0h        0.0h          0.0h        0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h           0.0h      0.0h      156.0h         0.0h        0.0h       0.0h        0.0h       0.0h      160.0h        0.0h         53.0h       0.0h      441.0h        0.0h         0.0h       0.0h        0.0h       0.0h         0.0h      0.0h        18.8h        0.0h         0.0h        0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h
      March-11         2747h                 0h             $274,688               $0              223.0h              0.0h          170.0h          0.0h          2.0h          0.0h        152.0h          0.0h       175.0h            0.0h        32.5h           0.0h     1008.0h         0.0h      358.0h         0.0h          4.0h        0.0h         0.0h        0.0h          0.0h        0.0h          0.0h        0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h           0.0h      0.0h      189.0h         0.0h        0.0h       0.0h        0.0h       0.0h      120.0h        0.0h         63.0h       0.0h        99.0h       0.0h         0.0h       0.0h        0.0h       0.0h     123.3h        0.0h        28.0h        0.0h         0.0h        0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h
                                                                                                     1355                 0            1068             0           442             0            626             0        1003               0           387             0        4437            0           666          0            55           0             8          0            73           0           124           0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0            727         0        1129            0           0          0           0          0           616         0            116         0           556         0             4         0           1          0          123         0           142          0            1           0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0
          Totals      13657h                 0h           ########               $0             #######                  $0       #######             $0    $ 7 9 ,5 6 0           $0   #######                $0    #######                $0   $ 9 7 ,0 1 2           $0   #######             $0   $ 6 6 ,6 0 0        $0   $ 1 4 ,9 8 8         $0    $ 1 ,2 3 8         $0   $ 1 2 ,0 4 5         $0   $ 2 0 ,4 6 0         $0         $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0     $ 2 1 ,8 1 0       $0   #######             $0         $0         $0          $0         $0    $ 5 8 ,5 2 0       $0    $ 1 0 ,4 4 0       $0   $ 1 6 ,6 8 0       $0    $ 1 ,0 0 0        $0      $370           $0    $ 9 ,4 9 0       $0   $ 2 1 ,3 0 0        $0   #######            $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0

M os aic C apital D es ignation         ########
M os aic E xpens e D es ignation        $ 5 2 9 ,0 6 0
                                        ########

                                                                                                                 A ggregate
                                          A ctual          A ctual            A ctuals            A ctuals
                      A ctual                                                                                        Fee
     Period                              Monthly           Monthly          A ggregate          A ggregate
                    Monthly Fees                                                                                     w/
                                         Expenses           Totals              Fee              Expenses
                                                                                                                  Expenses
 September-10         $ 3 0 ,3 4 4           $0             $ 3 0 ,3 4 4      $ 3 0 ,3 4 4       $181,498        $ 2 1 1 ,8 4 1
    October-10       $ 1 0 9 ,3 6 3          $0            $ 1 0 9 ,3 6 3    $ 1 3 9 ,7 0 6      $181,498        $ 3 2 1 ,2 0 4
  November-10        $ 2 0 1 ,3 8 5          $0            $ 2 0 1 ,3 8 5    $ 3 4 1 ,0 9 1     $ 1 8 1 ,4 9 8   $ 5 2 2 ,5 8 9
  December-10        $ 4 9 2 ,1 6 5          $0            $ 4 9 2 ,1 6 5    $ 8 3 3 ,2 5 6     $ 1 8 1 ,4 9 8    #######
    January-11       $ 2 9 1 ,5 9 3          $0            $ 2 9 1 ,5 9 3   $ 1 ,1 2 4 ,8 4 9   $ 1 8 1 ,4 9 8    #######
   February-11       $ 3 1 6 ,3 3 3          $0            $ 3 1 6 ,3 3 3   $ 1 ,4 4 1 ,1 8 1   $ 1 8 1 ,4 9 8    #######
      March-11       $ 2 7 4 ,6 8 8          $0            $ 2 7 4 ,6 8 8   $ 1 ,7 1 5 ,8 6 9   $ 1 8 1 ,4 9 8    #######
       A ctuals     $ 1 ,8 1 0 ,8 1 4   $ 1 5 0 ,0 2 2                                                            #######
          SOW              $0           $ 1 5 3 ,2 0 0                                                           $ 3 4 3 ,8 2 4

                            Baker Tilly                             External                            Mosaic
                       A ctuals         SOW                 A ctuals         SOW                 A ctuals      SOW
 Fees - C apital    $ 1 ,1 8 4 ,6 0 9         $0            $ 9 7 ,1 4 5          $0                 $0               $0
Fees - E xpens e      $ 7 9 ,6 6 0            $0           $ 1 4 9 ,6 7 3         $0            $ 2 9 9 ,7 2 7        $0
     E xpens es      $ 1 1 0 ,0 6 8      $ 1 2 0 ,7 5 0     $ 1 0 ,9 5 7          $0             $ 2 8 ,9 9 6     $ 3 2 ,4 5 0
          T otals   $ 1 ,3 7 4 ,3 3 7    $ 1 2 0 ,7 5 0    $ 2 5 7 ,7 7 5         $0            $ 3 2 8 ,7 2 3    $ 3 2 ,4 5 0

     Miscellaneous Expenses
     eFeedbac k     $ 1 1 ,1 7 0
    I ntellitrans    $ 7 ,5 0 0
R esource 47           R esource 48           R esource 49           R esource 50

Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00

           $0         $0          $0         $0          $0         $0          $0
          SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW
             0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h
             0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h
             0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h
             0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h
             0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h
             0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h
             0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h
                0           0          0           0          0           0          0
              $0          $0         $0          $0         $0          $0         $0
By Resource by Month

     Res                                                                                     Tom Stol f i                  B en Ha nson                     Chri s Noe                 Ti mba Lea d                  Ti mba Dev                    Ti mba QA                 Ma tt Therri en           Etha n B a ch          Ma tt Ha l l er        Todd Wi l kerson       K urt Schroeder         Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00           R ob K ov a l sky              Joel Ta v a res            B ob P i ttma n              Chri s Ha ni l y            Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          R esource 41           R esource 42           R esource 43           R esource 44           R esource 45           R esource 46           R esource 47
                                     Budget                                                                            B usi ness P rocess                                                Of f -Shore                  Of f -Shore                  Of f -Shore            B usi ness P rocess                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        I ntegra ti on Ana l y st -   I ntegra ti on Ana l y st -
     Role         A ctual Hours                     A ctual Fees      Budget Fees        P roj ect Ma na ger                                          Sol uti on Archi tect                                                                                                                                QM                      QM                      QM                     QM                Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00                                                                        Testi ng                 Tra i ni ng Lea d            Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00
                                      Hours                                                                                      Lea d                                                 Dev el opment                Dev el opment                Dev el opment                     Lea d                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        SAP                            PI
    Rate                                                                                 $165            $165           $165            $165           $150           $150           $25             $25          $25             $25          $25             $25          $165         $165        $220         $0        $220           $0        $220         $0        $220        $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0           $75          $75              $75          $75           $75            $75           $75          $75            $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0
                                                                                        A ctual          SOW           A ctual          SOW           A ctual         SOW           A ctual         SOW          A ctual         SOW          A ctual         SOW          A ctual       SOW        A ctual      SOW       A ctual        SOW       A ctual      SOW       A ctual     SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW         A ctual       SOW             A ctual       SOW           A ctual         SOW          A ctual       SOW          A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual
       May-11         594h             731h           $39,663           $54,615             35.0h            51.0h          55.0h           80.0h          94.0h          96.0h       136.0h          128.0h       136.0h          128.0h       128.0h          128.0h          0.0h         0.0h        0.0h       0.0h        0.0h         0.0h        0.0h       0.0h        0.0h      0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h          4.0h         60.0h            5.5h         60.0h          0.0h            0.0h         0.0h          0.0h         0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h
      June-11         462h             800h           $28,173           $58,500             13.0h            44.0h          11.0h           56.0h        104.0h           84.0h       112.0h          112.0h       112.0h          112.0h       104.0h          112.0h          0.0h         0.0h        0.0h       0.0h        0.0h         0.0h        0.0h       0.0h        0.0h      0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h          2.5h         56.0h            3.0h         56.0h          0.0h          48.0h          0.0h      120.0h           0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h
                                                                                                48               95             66             136            198            180           248            240           248            240           232            240             0           0           0          0           0            0           0          0           0         0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0             7            116              9            116            0              48            0           120            0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0
        Totals       1055h            1531h          $ 6 7 ,8 3 5     $ 1 1 3 ,1 1 5     $ 7 ,9 2 0     $ 1 5 ,6 7 5   $ 1 0 ,8 9 0    $ 2 2 ,4 4 0   $ 2 9 ,7 0 0   $ 2 7 ,0 0 0    $ 6 ,2 0 0     $ 6 ,0 0 0    $ 6 ,2 0 0     $ 6 ,0 0 0    $ 5 ,8 0 0     $ 6 ,0 0 0          $0          $0          $0         $0          $0           $0          $0         $0          $0        $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0         $488        $ 8 ,7 0 0        $638        $ 8 ,7 0 0         $0        $ 3 ,6 0 0         $0      $ 9 ,0 0 0         $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0

                                                    ($ 6 7 ,8 3 5 )



                                                                                                      A ggregate
                                     A ctual         A ctual            A ctuals         A ctuals
                    A ctual                                                                               Fee
   Period                           Monthly          Monthly          A ggregate       A ggregate
                  Monthly Fees                                                                            w/
                                    Expenses          Totals              Fee           Expenses
                                                                                                       Expenses
      A pril-11         $0           $ 8 ,4 3 1        $ 8 ,4 3 1          $0            $8,431         $ 8 ,4 3 1
       May-11       $ 3 9 ,6 6 3       $41            $ 3 9 ,7 0 4     $ 3 9 ,6 6 3      $8,472        $ 4 8 ,1 3 5
      June-11       $ 2 8 ,1 7 3        $0            $ 2 8 ,1 7 3     $ 6 7 ,8 3 5      $8,472        $ 7 6 ,3 0 7
      A ctuals      $ 6 7 ,8 3 5     $ 8 ,4 7 2                                                        $ 7 6 ,3 0 7
         SOW       $ 1 0 3 ,4 8 8       $0                                                            $ 3 4 3 ,8 2 4

                          Baker Tilly                         External                         Mosaic
                     A ctuals         SOW             A ctuals         SOW              A ctuals      SOW
 C R0 1 - Fees      $ 6 6 ,7 1 0     $ 8 3 ,1 1 5         $0                $0          $ 1 ,1 2 5     $ 3 0 ,0 0 0
    E xpens es       $ 8 ,4 7 3          $0               $0                $0             $0              $0
        T otals     $ 7 5 ,1 8 3    $ 8 3 ,1 1 5          $0                $0          $ 1 ,1 2 5     $ 3 0 ,0 0 0
R esource 47           R esource 48           R esource 49           R esource 50

Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00

           $0         $0          $0         $0          $0         $0          $0
          SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW
             0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h
             0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h
                0           0          0           0          0           0          0
              $0          $0         $0          $0         $0          $0         $0
By Resource by Month
     Res                                                               Mike Huzinec              Stan              Kevin Coonan               Priya                Todd Duclos             Kevin Daly            Greg Barnes               Naren               Bob Pitman          Leah Billingsly        Chris Hanily
                 Actual      Budget                                                                                Cognos Report                                                                              IT Senior Business      Solution Delivery
     Role                               Actual Fees   Budget Fees    Project Oversight     Cognos Modeler                                Affinity Support       Project Manager       Lead Business Analyst                                                     Test Lead         Test Team Analyst         Training
                 Hours       Hours                                                                                    Developer                                                                                    Analysis                Analyst
    Rate                                                             $165        $165      $165         $165      $165       $165        $75          $75         $0         $0           $0         $0         $75         $75        $75         $75        $75       $75         $0         $0        $75       $75
                                                                     Actual      SOW       Actual       SOW       Actual      SOW       Actual        SOW       Actual      SOW         Actual      SOW       Actual       SOW        Actual      SOW        Actual     SOW       Actual      SOW       Actual     SOW
      July-11     343h        494h       $33,263        $38,640          7.5h       6.0h    112.0h        75.0h      73.0h     120.0h       0.0h         6.0h      40.0h      40.0h        90.0h      90.0h        0.0h       25.0h      20.0h       42.0h       0.0h      0.0h       0.0h      90.0h       0.0h      0.0h
    August-11     798h        774h       $69,180        $59,575          9.0h      10.0h    132.0h       116.0h    154.0h      184.0h       0.0h         9.0h      72.0h      72.0h      140.0h      140.0h        6.0h       39.3h      21.0h       64.0h       0.0h      0.0h    110.0h      140.0h       0.0h      0.0h
September-11      784h        804h       $57,893        $63,660         18.0h      26.0h      76.0h      109.0h    132.0h      176.0h       0.0h        15.0h      68.0h      68.0h      130.0h      130.0h       33.3h       35.6h      83.0h       74.0h      20.0h     20.0h    130.0h      130.0h      20.0h     20.0h
   October-11      0h          0h          $0             $0             0.0h       0.0h       0.0h        0.0h       0.0h       0.0h       0.0h         0.0h       0.0h       0.0h         0.0h       0.0h        0.0h        0.0h       0.0h        0.0h       0.0h      0.0h       0.0h       0.0h       0.0h      0.0h
                                                                           35         42        320         300        359        480           0          30        180        180          360        360          39         100        124         180         20        20        240        360         20        20
        Totals   1925h       2072h       $160,335      $161,875        $5,693     $6,930    $52,800     $49,500    $59,235    $79,200          $0      $2,250          $0        $0            $0        $0      $2,948      $7,495     $9,300     $13,500     $1,500    $1,500          $0        $0     $1,500    $1,500




                                                                              Aggregate
                  Actual     Actual       Actual       Actuals       Actuals
                                                                                 Fee
   Period        Monthly     Monthly     Monthly      Aggregate     Aggregate
                                                                                 w/
                   Fees     Expenses      Totals         Fee        Expenses
                                                                              Expenses
      July-11     $33,263      $0           $0          $33,263        $0         $0
    August-11     $69,180    $1,073       $70,253      $102,443        $0         $0
September-11      $57,893      $0         $57,893      $160,335        $0         $0
   October-11       $0         $0           $0         $160,335        $0         $0
      Actuals    $160,335    $1,073                                               $0
         SOW     $161,500    $5,000                                            $166,500




                      Baker Tilly               External                   Mosaic
                  Actuals       SOW       Actuals       SOW          Actuals      SOW
   CR03 - Fees   $145,088    $135,630       $0         $2,250        $15,248    $23,995
     Expenses     $1,073      $5,000        $0           $0            $0          $0
        Totals   $146,160    $140,630       $0         $2,250        $15,248    $23,995
By Resource by Month
     Res                                                                   Tom Stolfi             Ben Hanson             Andrew Walker                  BA 3                  Chris Noe            Configuration            Shannon              Jim Wierzba             Ethan Bach              Matt Haller         Todd Wilkerson        Kurt Schroeder         Kate Cowger          Matt Therrien         Ruchir Patel         Anoop Kumar            Rob Kovalsky           John Rogers         Bob Pittman             Kevin Daly            Christina           Greg Barnes           Chris Hanily         Translations
                  Actual      Budget                                                          Business Process          Business Process         Business Process                                    Application             Business           Project Quality        Project Quality                                                                                               Business Process                            Data Migration                                                                                               Communications        Cognos Reporting
    Role                                  Actual Fees   Budget Fees     Project Manager                                                                                   Solution Architect                                                                                                 Engagement Partner      Baker Tilly SME       Baker Tilly SME      Business Analyst                           Application Lead                            Integration Analyst    Security Analyst        Testing            Reports Analyst                                                  Training (Chris H)     Translations
                  Hours       Hours                                                                  Lead                    Analyst                  Analyst                                   Configuration Analyst   Effectiveness Lead       Management             Management                                                                                                          Lead                                     Analyst                                                                                                       Analyst                Query
    Rate                                                               $165         $165      $165        $165          $165        $165          $0           $0         $150        $150        $165        $165       $165        $165      $200        $200       $200        $200        $200        $200      $200        $200      $200        $200      $165       $165      $165        $165      $120       $120       $75         $75        $75         $75        $75       $75       $75          $75       $0         $0        $75         $75       $75        $75        $75        $75       $75       $75
                                                                       Actual       SOW       Actual      SOW           Actual       SOW         Actual       SOW         Actual      SOW         Actual      SOW       Actual       SOW       Actual      SOW        Actual      SOW         Actual      SOW       Actual      SOW       Actual      SOW       Actual     SOW       Actual      SOW       Actual     SOW       Actual       SOW       Actual       SOW       Actual     SOW      Actual        SOW      Actual     SOW       Actual       SOW      Actual      SOW       Actual      SOW      Actual     SOW
    March-11       75h         294h        $12,375       $48,170          35.0h       63.0h      40.0h      90.0h           0.0h       90.0h         0.0h        0.0h         0.0h      40.5h         0.0h       0.0h        0.0h       0.0h       0.0h        0.0h       0.0h        0.0h        0.0h       0.0h       0.0h       5.0h       0.0h       5.0h       0.0h      0.0h       0.0h       0.0h       0.0h      0.0h       0.0h        0.0h       0.0h        0.0h       0.0h     0.0h       0.0h        0.0h       0.0h      0.0h       0.0h       0.0h       0.0h       0.0h       0.0h      0.0h       0.0h     0.0h
     April-11      466h        591h        $77,110       $97,140         113.0h      126.0h     168.0h     180.0h           1.0h      180.0h         0.0h        0.0h        75.5h      81.0h         0.0h       0.0h        0.0h       0.0h       0.0h        0.0h       1.0h        0.0h        4.0h       0.0h      32.0h      12.0h       4.0h      12.0h       0.0h      0.0h      67.0h       0.0h       0.0h      0.0h       0.0h        0.0h       0.0h        0.0h       0.0h     0.0h       0.0h        0.0h       0.0h      0.0h       0.0h       0.0h       0.0h       0.0h       0.0h      0.0h       0.0h     0.0h
      May-11       436h        782h        $68,235       $117,510        137.0h      134.0h     130.0h     189.0h          50.0h      189.0h         0.0h        0.0h        24.0h      87.0h         0.0h       0.0h       11.0h       0.0h       0.0h        0.0h       0.0h        0.0h        1.0h       0.0h       8.0h      12.0h       3.0h      12.0h      19.0h      0.0h       0.0h       0.0h      19.0h     48.0h      22.0h       48.0h       9.0h       48.0h       0.0h     0.0h       0.0h        0.0h       0.0h      0.0h       0.0h       0.8h       0.0h       0.0h       0.0h      0.0h       0.0h     0.0h
     June-11       401h        467h        $54,095       $61,883          56.0h       55.0h      81.0h      81.0h          84.0h       81.0h         0.0h        0.0h         0.0h      20.3h         0.0h       0.0h        0.0h       0.0h       0.0h        0.0h       0.0h        0.0h        0.0h       0.0h       4.0h       6.0h       0.0h       6.0h       2.0h      0.0h       0.0h       0.0h      61.0h     64.0h      54.0h       64.0h      50.0h       64.0h       0.0h     0.0h       0.0h        0.0h       0.0h      0.0h       0.0h       6.4h       0.0h       0.0h       0.0h      0.0h       0.0h     0.0h
                                                                            341         378        419        540            135         540            0           0          100        229            0          0          11          0          0           0          1           0           5          0         44         35          7         35         21         0         67          0         80       112         76         112         59         112          0        0          0           0          0         0          0          7          0          0          0         0          0        0
       Totals     1377h       2134h        $211,815      $324,703       $56,265     $62,370    $69,135    $89,100        $22,275     $89,100           $0          $0      $14,925    $34,313           $0         $0      $1,815         $0         $0          $0       $200          $0      $1,000         $0     $8,800     $7,000     $1,400     $7,000     $3,465        $0    $11,055         $0     $9,600   $13,440     $5,700      $8,400     $4,425      $8,400         $0       $0         $0          $0         $0        $0         $0       $540         $0         $0         $0        $0         $0       $0
                              BT Fees      $190,335
                                            $19,605       $231,420


                                                                                  Aggregate
                   Actual      Actual       Actual       Actuals       Actuals
                                                                                      Fee
   Period         Monthly     Monthly      Monthly      Aggregate     Aggregate
                                                                                      w/
                    Fees     Expenses       Totals         Fee        Expenses
                                                                                  Expenses
    March-11       $12,375      $0            $0          $12,375        $0            $0
     April-11      $77,110    $1,684        $78,794       $89,485      $1,684       $78,794
      May-11       $68,235    $15,451       $83,686      $157,720      $17,135     $162,480
     June-11       $54,095    $6,069        $60,164      $211,815      $23,204     $222,644
      Actuals     $211,815    $23,204                                              $222,644   <-- $202,255 doesn’t have $62,000 removed for Pricing Programs Allocation
        SOW       $231,420      $0                                                 $343,824


                        Baker Tilly               External                   Mosaic
                   Actuals        SOW       Actuals        SOW         Actuals      SOW
          Fees    $190,335     $288,883     $11,355     $18,480        $10,125    $17,340
     Expenses      $17,675         $0        $228           $0         $5,301        $0
         Totals   $208,010     $288,883     $11,583     $18,480        $15,426    $17,340
      1.1 Fees     $62,280
      1.G Fees    $128,055
By Resource by Month

     Res                                                                                        Tom Stol f i                  B en Ha nson                 Andrew Wa l ker                      BA 3                     Chri s Noe                Conf i gura ti on                  Sha nnon                      Ti mba 1                    Ti mba 2                    Ti mba 3                    Ti mba 4                    Ti mba 5                    Ti mba 6                    Ti mba 7                  Ti mba 8                R esource 16              R esource 17              SFDC R eports              Ji m Wi erzba                Ma tt Ha l l er           Todd Wi l kerson              K urt Schroeder                R esource 23           R esource 24           R uchi r P a tel                  Shi v a                      Cognos - 1                Cognos - 2               R esource 29           Anoop K uma r                   R ob K ov a l sky             John R ogers           B ob P i ttma n            K ev i n Da l y            Chri sti na                Greg B a rnes              Chri s Ha ni l y           Tra nsl a ti ons            R esource 39           R esource 40           R esource 41           R esource 42           R esource 43           R esource 44           R esource 45           R esource 46           R esource 47
                   A ctual           Budget                                                                               B usi ness P rocess            B usi ness P rocess             B usi ness P rocess                                         Appl i ca ti on                   B usi ness                   Of f -Shore                 Of f -Shore                 Of f -Shore                 Of f -Shore                 Of f -Shore                 Of f -Shore                 Of f -Shore               Of f -Shore               Of f -Shore               Of f -Shore            Sa l esf orce.com         P roj ect Qua l i ty                                                                                                                                                                                                           Cognos R eporti ng        Cognos R eporti ng                                 Da ta Mi gra ti on                                                                                                                     Communi ca ti ons             Cognos R eporti ng
     Role                                            A ctual Fees      Budget Fees         P roj ect Ma na ger                                                                                                     Sol uti on Archi tect                                                                                                                                                                                                                                                                                                                                                                                                              Enga gement P a rtner         B a ker Ti l l y SME          B a ker Ti l l y SME           Ja nua ry -00          Ja nua ry -00       Appl i ca ti on Lea d         I ntegra ti on Lea d                                                                   Ja nua ry -00                                       I ntegra ti on Ana l y st      Securi ty Ana l y st        Testi ng             R eports Ana l y st                                                              Tra i ni ng (Chri s H)        Tra nsl a ti ons            Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00
                   Hours              Hours                                                                                         Lea d                        Ana l y st                    Ana l y st                                          Conf i gura ti on            Ef f ecti v eness Lea d           Dev el opment               Dev el opment               Dev el opment               Dev el opment               Dev el opment               Dev el opment               Dev el opment             Dev el opment             Dev el opment             Dev el opment          R eporti ng Ana l y st        Ma na gement                                                                                                                                                                                                                  Model & B ui l d -1       Model & B ui l d -2                                     Ana l y st                                                                                                                             Ana l y st                     Query
    Rate                                                                                   $165             $165           $165            $165           $165             $165            $0             $0        $150           $150           $165            $165            $165           $165           $25            $28          $25            $28          $25            $28          $25            $28          $25            $28          $25            $28           $0             $0         $0             $0         $0             $0         $0             $0          $0            $0         $200         $200            $200          $200          $200           $200           $200          $200            $0          $0         $0          $0        $120           $120           $150             $150           $120        $120          $120        $120           $0          $0         $75              $75             $75            $75           $75          $75       $75            $75         $0            $0        $75             $75           $75         $75           $75           $75           $75          $75            $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0
                                                                                          A ctual           SOW           A ctual          SOW           A ctual           SOW           A ctual         SOW       A ctual         SOW           A ctual          SOW            A ctual         SOW           A ctual        SOW          A ctual        SOW          A ctual        SOW          A ctual        SOW          A ctual        SOW          A ctual        SOW          A ctual        SOW        A ctual        SOW        A ctual        SOW        A ctual        SOW        A ctual         SOW        A ctual       SOW            A ctual        SOW          A ctual         SOW           A ctual        SOW           A ctual      SOW       A ctual      SOW       A ctual         SOW           A ctual           SOW           A ctual      SOW          A ctual      SOW          A ctual      SOW       A ctual           SOW            A ctual         SOW           A ctual       SOW      A ctual         SOW       A ctual        SOW       A ctual         SOW           A ctual      SOW          A ctual        SOW          A ctual       SOW          A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW       A ctual
       May-11         0h                0h                $0               $0                    0.0h             0.0h           0.0h            0.0h           0.0h             0.0h         0.0h          0.0h          0.0h           0.0h         0.0h              0.0h           0.0h            0.0h         0.0h           0.0h         0.0h           0.0h         0.0h           0.0h         0.0h           0.0h         0.0h           0.0h         0.0h           0.0h         0.0h          0.0h        0.0h          0.0h        0.0h          0.0h        0.0h          0.0h         0.0h         0.0h         0.0h            0.0h         0.0h           0.0h           0.0h           0.0h         0.0h            0.0h         0.0h       0.0h        0.0h       0.0h          0.0h           0.0h          0.0h              0.0h         0.0h          0.0h        0.0h          0.0h        0.0h       0.0h          0.0h             0.0h            0.0h           0.0h         0.0h       0.0h        0.0h          0.0h        0.0h         0.0h        0.0h             0.0h         0.0h         0.0h         0.0h           0.0h         0.0h          0.0h         0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h
      June-11        655h              972h            $90,093          $115,360               88.0h          112.0h         127.0h          112.0h           95.0h          112.0h           0.0h          0.0h          6.0h         56.0h          0.0h              0.0h          56.0h          56.0h          0.0h           0.0h         0.0h           0.0h         0.0h           0.0h         0.0h           0.0h         0.0h           0.0h         0.0h           0.0h         0.0h          0.0h        0.0h          0.0h        0.0h          0.0h        0.0h          0.0h         0.0h         0.0h         0.0h            2.8h         0.0h           5.6h           8.0h         11.2h          0.0h          11.2h          0.0h       0.0h        0.0h       0.0h      112.0h         112.0h          21.0h             33.6h          0.0h          0.0h        0.0h          0.0h        0.0h       0.0h        88.0h          112.0h            53.5h        112.0h           0.0h       0.0h        0.0h          0.0h        0.0h       112.0h        0.0h           11.2h          0.0h         0.0h         0.0h           0.0h         0.0h          0.0h         0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h
       July-11      1063h             1388h            $143,554         $164,800             128.0h           160.0h         178.0h          160.0h         165.5h           160.0h           0.0h          0.0h        81.0h          80.0h          0.0h              0.0h          56.0h          80.0h          0.0h           0.0h         0.0h           0.0h         0.0h           0.0h         0.0h           0.0h         0.0h           0.0h         0.0h           0.0h         0.0h          0.0h        0.0h          0.0h        0.0h          0.0h        0.0h          0.0h         0.0h         0.0h         0.0h            4.0h         0.0h           8.0h         18.0h          16.0h          0.0h          16.0h          0.0h       0.0h        0.0h       0.0h      158.0h         160.0h          12.0h             48.0h          0.0h          0.0h        0.0h          0.0h        0.0h       0.0h      152.0h           160.0h          114.3h         160.0h           0.0h       0.0h        0.5h          0.0h        0.0h       160.0h        0.0h           16.0h          0.0h         0.0h         0.0h           0.0h         0.0h          0.0h         0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h
   A ugust-11        901h             1596h            $129,153         $189,520             180.0h           184.0h         200.0h          184.0h           74.0h          184.0h           0.0h          0.0h      116.0h           92.0h          0.0h              0.0h          10.0h          92.0h          0.0h           0.0h         0.0h           0.0h         0.0h           0.0h         0.0h           0.0h         0.0h           0.0h         0.0h           0.0h         0.0h          0.0h        0.0h          0.0h        0.0h          0.0h        0.0h          0.0h         0.0h         0.0h         3.0h            4.6h         0.0h           9.2h         16.0h          18.4h          4.0h          18.4h          0.0h       0.0h        0.0h       0.0h      184.0h         184.0h            0.0h            55.2h          0.0h          0.0h        0.0h          0.0h        0.0h       0.0h        72.0h          184.0h            41.5h        184.0h           0.0h       0.0h        0.0h          0.0h        0.0h       184.0h        0.0h           18.4h          0.0h         0.0h         0.0h           0.0h         0.0h          0.0h         0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h
September-11         307h             1173h            $44,433          $113,710               48.0h            88.0h          18.0h           88.0h          73.0h            88.0h          0.0h          0.0h        43.0h          44.0h          0.0h            40.0h            0.0h          44.0h          0.0h         40.0h          0.0h         40.0h          0.0h         40.0h          0.0h         40.0h          0.0h         40.0h          0.0h         40.0h          0.0h          0.0h        0.0h          0.0h        0.0h          0.0h        0.0h          0.0h         0.0h         0.0h         0.0h            2.2h         2.0h           4.4h         12.0h            8.8h         0.0h            8.8h         0.0h       0.0h        0.0h       0.0h        88.0h          88.0h           0.0h            26.4h          0.0h          0.0h        0.0h          0.0h        0.0h       0.0h          8.0h           88.0h           14.5h          88.0h          0.0h       0.0h        0.0h         10.0h        0.0h        88.0h        0.0h             8.8h         0.0h       40.0h          0.0h         40.0h          0.0h        40.0h          0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h        0.0h
                                                                                                  444              544            523             544            408              544            0             0           246            272            0                40            122             272             0            40             0            40             0            40             0            40             0            40             0            40             0            0            0            0            0            0            0            0            0             0           3              14            2             27             54             54            4              54            0          0           0          0           542            544            33               163            0             0           0             0           0          0           320              544             224            544            0          0           1            10           0          544           0               54            0           40            0             40            0            40            0          0           0          0           0          0           0          0           0          0           0          0           0          0           0          0           0
        Totals      2925h             5129h          $ 4 0 7 ,2 3 1    $ 5 8 3 ,3 9 0     $ 7 3 ,2 6 0     $ 8 9 ,7 6 0   $ 8 6 ,2 9 5    $ 8 9 ,7 6 0   $ 6 7 ,2 3 8     $ 8 9 ,7 6 0          $0           $0    $ 3 6 ,9 0 0   $ 4 0 ,8 0 0         $0          $ 6 ,6 0 0   $ 2 0 ,1 3 0    $ 4 4 ,8 8 0         $0       $ 1 ,1 2 0         $0       $ 1 ,1 2 0         $0       $ 1 ,1 2 0         $0       $ 1 ,1 2 0         $0       $ 1 ,1 2 0         $0       $ 1 ,1 2 0         $0            $0          $0            $0          $0            $0          $0            $0            $0           $0       $600       $ 2 ,7 2 0        $400        $ 5 ,4 4 0   $ 1 0 ,8 0 0   $ 1 0 ,8 8 0      $800       $ 1 0 ,8 8 0         $0         $0          $0         $0    $ 6 5 ,0 4 0   $ 6 5 ,2 8 0    $ 4 ,9 5 0      $ 2 4 ,4 8 0         $0            $0          $0            $0          $0         $0    $ 2 4 ,0 0 0     $ 4 0 ,8 0 0    $ 1 6 ,7 8 1   $ 4 0 ,8 0 0         $0          $0        $38          $750          $0            $0         $0         $ 4 ,0 8 0         $0     $ 3 ,0 0 0         $0       $ 3 ,0 0 0         $0      $ 3 ,0 0 0         $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0         $0          $0




                                                                                                         A ggregate
                  A ctual           A ctual           A ctual            A ctuals          A ctuals
                                                                                                             Fee
   Period         Monthly          Monthly            Monthly          A ggregate        A ggregate
                                                                                                             w/
                   Fees            Expenses            Totals              Fee            Expenses
                                                                                                          Expenses
       May-11          $0              $0                  $0                $0               $0              $0
      June-11      $ 9 0 ,0 9 3    $ 1 6 ,9 7 6       $ 1 0 7 ,0 6 8     $ 9 0 ,0 9 3     $ 1 6 ,9 7 6   $ 1 0 7 ,0 6 8
       July-11    $ 1 4 3 ,5 5 4   $ 1 6 ,2 0 0       $ 1 5 9 ,7 5 4    $ 2 3 3 ,6 4 6    $ 3 3 ,1 7 6   $ 2 6 6 ,8 2 2
   A ugust-11     $ 1 2 9 ,1 5 3    $ 5 ,8 2 8        $ 1 3 4 ,9 8 1    $ 3 6 2 ,7 9 9    $ 3 9 ,0 0 4   $ 4 0 1 ,8 0 3
September-11       $ 4 4 ,4 3 3      $574              $ 4 5 ,0 0 7     $ 4 0 7 ,2 3 1    $ 3 9 ,5 7 9   $ 4 4 6 ,8 1 0
      A ctuals    $ 4 0 7 ,2 3 1   $ 3 9 ,5 7 9                                                          $ 4 4 6 ,8 1 0   <- - A c tuals = $ 3 9 8 k BT + E xternal + M os aic
         SOW      $ 5 8 3 ,3 9 0   $ 7 4 ,8 0 0                                                               $0



                        Baker Tilly                            External                          Mosaic
                   A ctuals       SOW                  A ctuals         SOW               A ctuals      SOW
          Fees    $ 2 9 6 ,4 2 3    $ 3 9 8 ,2 0 0     $ 6 9 ,9 9 0     $ 8 9 ,7 6 0      $ 4 0 ,8 1 9    $ 9 5 ,4 3 0
    E xpens es     $ 3 0 ,8 4 5      $ 5 5 ,0 0 0       $ 4 ,0 7 7                         $ 4 ,6 5 8     $ 1 9 ,8 0 0    <- - C urrently not broken out by BT , E xternal, M os aic
        T otals   $ 3 2 7 ,2 6 7   $ 4 5 3 ,2 0 0      $ 7 4 ,0 6 7     $ 8 9 ,7 6 0      $ 4 5 ,4 7 7   $ 1 1 5 ,2 3 0
R esource 47           R esource 48           R esource 49           R esource 50

Ja nua ry -00          Ja nua ry -00          Ja nua ry -00          Ja nua ry -00

           $0         $0          $0         $0          $0         $0          $0
          SOW       A ctual      SOW       A ctual      SOW       A ctual      SOW
             0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h
             0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h
             0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h
             0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h
             0.0h        0.0h       0.0h        0.0h       0.0h        0.0h       0.0h
                0           0          0           0          0           0          0
              $0          $0         $0          $0         $0          $0         $0
By Resource by Month
     Res                                                                     Tom Stolfi              Ben Hanson             Jon Carlson             Chris Noe             Harish Guntaka          Kate Cowger          Adrian Caretti       Mauricio Diaz        Gonzalo Parada       Alfonso Barros         Bruno Viera         Elisa Ferrando            Stan                 Mike/Kevin               Deepi                Ethan Bach          Don Kolenda           Todd Wilkerson        Kurt Schroeder           Anoop Kumar             Rob Kovalsky           John Rogers           Bob Pittman          GregB/Narender           Joel Tavares           SFDC Data             SAP ABAP           Ben Hanson           Kate Cowger
                   Actual      Budget                                                                                     Business Process                                  Application         Business Process           Off-Shore            Off-Shore            Off-Shore            Off-Shore            Off-Shore           Off-Shore                                Cognos - Report Dev    Cognos - Report Dev                           Project Quality                                                                            Integration Analyst -                                                                     Integration Analyst -
     Role                                  Actual Fees    Budget Fees     Project Manager        Business Process Lead                          Solution Architect                                                                                                                                                                                   Cognos - Modeler                                                     Engagement Partner                            Baker Tilly SME       Baker Tilly SME      Data Migration Analyst                             Security Lead         Testing Lead       Data Analyst/Sources                           SFDC Data Loader      ABAP Programmer      BEL & Training       BEL & Training
                   Hours       Hours                                                                                           Analyst                                 Configuration Analyst          Analyst        Development (Timba) Development (Timba) Development (Timba) Development (Timba) Development (Timba) Development (Timba)                                          1                      2                                    Management                                                                                         SAP                                                                                       PI
    Rate                                                                  $165        $165         $165        $165       $165        $165      $150        $150         $165         $165      $165         $165      $25         $25      $25         $25      $25         $25      $25         $25      $25         $25      $25        $25        $165        $165        $165      $165         $135      $135        $200       $200      $200       $200        $200        $200      $200        $200         $75        $75          $75         $75        $75        $75        $75       $75         $75        $75         $75         $75        $95        $95        $50       $50      $165       $165      $165       $165
                                                                         Actual       SOW          Actual      SOW       Actual        SOW      Actual      SOW         Actual        SOW       Actual        SOW     Actual       SOW     Actual       SOW     Actual       SOW     Actual       SOW     Actual       SOW     Actual      SOW       Actual       SOW        Actual      SOW        Actual      SOW        Actual     SOW       Actual     SOW         Actual      SOW       Actual      SOW         Actual      SOW         Actual       SOW       Actual      SOW       Actual     SOW        Actual      SOW        Actual       SOW       Actual      SOW       Actual     SOW      Actual     SOW       Actual     SOW
September-11        638h        1526h        $65,640       $110,200         80.0h       80.0h         38.0h      80.0h       0.0h        0.0h      42.0h       40.0h       72.0h        80.0h       0.0h        0.0h     76.0h       80.0h    24.0h       80.0h    16.0h       80.0h    80.0h       80.0h    24.0h       80.0h     0.0h      80.0h       0.0h        0.0h        0.0h       0.0h        0.0h       0.0h        2.0h      2.0h       0.0h        4.0h       6.0h       8.0h       0.0h       8.0h        16.0h      80.0h        16.0h       80.0h       0.0h       8.0h       0.0h      0.0h        0.0h      80.0h        0.0h        0.0h       0.0h      80.0h       0.0h     0.0h       0.0h      0.0h       0.0h      0.0h
   October-11      2297h        3209h       $200,953       $231,520        136.0h      168.0h       152.0h      168.0h       0.0h        0.0h    108.0h        84.0h      102.0h       168.0h       0.0h        0.0h    168.0h      168.0h  168.0h       168.0h  168.0h       168.0h  168.0h       172.0h  168.0h       168.0h  168.0h      168.0h      64.0h        0.0h       88.0h       0.0h      118.0h       0.0h        6.0h      4.2h       4.0h        8.4h       8.0h      16.8h       0.0h      16.8h        62.0h     168.0h        49.5h      168.0h       0.0h      16.8h       1.0h      0.0h        0.0h     168.0h        0.0h        0.0h      32.0h     168.0h      81.0h     0.0h       0.0h      0.0h       0.0h      0.0h
 November-11       3153h        3309h       $271,085       $234,025        160.0h      160.0h       140.0h      160.0h     160.0h        0.0h    179.0h        80.0h        0.0h       160.0h      30.0h        0.0h    168.0h      160.0h  164.0h       160.0h  176.0h       160.0h  176.0h       165.0h  164.0h       160.0h  176.0h      160.0h     144.0h        0.0h      161.0h       0.0h      160.0h       0.0h        4.0h      4.0h       0.0h        8.0h      10.0h      16.0h       0.0h      16.0h        94.0h     160.0h        39.0h      160.0h       0.0h      16.0h       9.0h    100.0h        0.0h     160.0h       49.0h       80.0h    160.0h      160.0h    118.8h      0.0h      41.0h      0.0h      94.0h      0.0h
 December-11       3223h        3116h       $265,360       $227,585        136.0h      152.0h         94.0h     152.0h     128.0h        0.0h    185.0h        76.0h        0.0h       152.0h      26.0h        0.0h    176.0h      152.0h  160.0h       152.0h  176.0h       152.0h  160.0h       152.0h  176.0h       152.0h  176.0h      152.0h     152.0h        0.0h      131.0h       0.0h      152.0h       0.0h        2.0h      3.4h       3.6h        7.6h       8.0h      15.2h       0.0h      15.2h        88.0h     152.0h        79.0h      152.0h       0.0h      15.2h      18.0h     95.0h     122.0h      152.0h       66.0h       76.0h    152.0h      152.0h    180.0h      0.0h      48.0h      0.0h    100.0h       0.0h
   January-12      2893h        3412h       $280,670       $247,555        172.0h      168.0h         88.0h     168.0h     166.0h        0.0h    146.0h        84.0h        0.0h       168.0h      29.0h        0.0h    176.0h      168.0h  176.0h       168.0h  176.0h       168.0h  176.0h       168.0h  176.0h       168.0h  117.0h      168.0h     160.0h        0.0h      152.0h       0.0h      168.0h       0.0h        4.0h      4.2h       3.0h        8.4h       8.0h      16.8h       0.0h      16.8h      204.0h      168.0h        74.0h      168.0h       0.0h      16.8h      25.0h    105.0h       61.0h     168.0h       59.0h       84.0h    176.0h      176.0h       0.0h     0.0h      90.0h      0.0h    111.0h       0.0h
  February-12      2501h        3394h       $240,045       $245,595        144.0h      168.0h         60.0h     168.0h     168.0h        0.0h    168.0h        84.0h        0.0h       168.0h      18.0h        0.0h    172.0h      168.0h  160.0h       168.0h  168.0h       168.0h  174.0h       168.0h  172.0h       168.0h  162.0h      168.0h     104.0h        0.0h      163.0h       0.0h      154.0h       0.0h        0.0h      4.2h       0.0h        8.4h       8.0h      16.8h       0.0h      16.8h      104.0h      168.0h        33.0h      168.0h       0.0h      16.8h       0.0h    105.0h       24.0h     168.0h       63.0h       84.0h      64.0h     168.0h       0.0h     0.0h    118.0h       0.0h    100.0h       0.0h
     March-12      1816h        3555h       $149,160       $257,290        176.0h      176.0h          0.0h     176.0h      56.0h        0.0h    176.0h        88.0h        0.0h       176.0h       0.0h        0.0h    176.0h      176.0h  176.0h       176.0h  176.0h       176.0h  176.0h       176.0h  176.0h       176.0h  176.0h      176.0h       0.0h        0.0h        0.0h       0.0h        0.0h       0.0h        0.0h      4.4h       0.0h        8.8h       0.0h      17.6h       0.0h      17.6h         0.0h     176.0h         0.0h      176.0h       0.0h      17.6h       0.0h    110.0h        0.0h     176.0h        0.0h       88.0h       0.0h     176.0h       0.0h     0.0h    176.0h       0.0h    176.0h       0.0h
                                                                             1004        1072           572       1072        678           0       1004         536         174         1072        103           0      1112        1072     1028        1072     1056        1072     1110        1081     1056        1072      975       1072        624           0         695          0         752          0          18        26         11          54         48        107          0        107          568       1072          291        1072          0        107         53       515         207       1072         237         412        584       1080        380        0        473         0        581         0
        Totals    16520h       21520h      $1,472,913     $1,553,770     $165,660    $176,880       $94,380   $176,880   $111,870          $0   $150,600     $80,400     $28,710     $176,880    $16,995          $0   $27,800     $26,800  $25,700     $26,800  $26,400     $26,800  $27,750     $27,025  $26,400     $26,800  $24,375    $26,800   $102,960          $0    $114,675         $0    $101,520         $0      $3,600    $5,280     $2,120    $10,720      $9,600    $21,440         $0    $21,440      $42,600    $80,400      $21,788     $80,400         $0     $8,040     $3,975   $38,625     $15,525    $80,400     $17,775     $30,900    $55,480   $102,600    $18,990       $0    $78,045        $0    $95,865        $0

                                           ($1,472,913)


                                                                                    Aggregate
                   Actual        Actual      Actual        Actuals       Actuals
                                                                                       Fee
   Period         Monthly       Monthly     Monthly       Aggregate     Aggregate
                                                                                        w/
                    Fees       Expenses      Totals          Fee        Expenses
                                                                                    Expenses
September-11       $65,640       $725        $66,365        $65,640       $725        $66,365
   October-11      $200,953     $6,363      $207,315        $266,593     $7,088      $273,681
 November-11       $271,085     $8,511      $279,596        $537,678     $15,599     $553,276
 December-11       $265,360    $11,246      $276,606        $803,038     $26,845     $829,882
   January-12      $280,670    $19,991      $300,661       $1,083,708    $46,835    $1,130,543
  February-12      $240,045       $4        $240,049       $1,323,753    $46,839    $1,370,592
     March-12      $149,160       $0        $149,160       $1,472,913    $46,839    $1,519,752
       Actuals    $1,472,913   $46,839                                              $1,519,752
         SOW      $1,109,665   $173,200                                              $343,824


                        Baker Tilly                 External                   Mosaic
                    Actuals       SOW        Actuals         SOW         Actuals      SOW
   Fees-Capital    $840,120   $1,007,825     $30,240      $101,840
Fees-Expenses      $426,420                    $0                       $176,133     $437,445
     Expenses      $58,447     $120,750        $0          $20,000         $0         $32,450
        Totals    $1,324,987 $1,128,575      $30,240      $121,840      $176,133     $469,895
                                                                                                               Actual
                                                                             Budget                                         Actual                                   Variance                                                North America      All Geographies
                    Project Phases                         Budget Fees                   Budget Totals       /Forecast                 Total        Variance $$$                                                                                                        Totals
                                                                            Expenses                                       Expenses                                  Percent                                                 Rollout (FY11)      Rollout (FY12)
                                                                                                                Fees
Phase 1.0 Final - BT/Contractors - Capital                   $1,145,000      $114,000       $1,259,000        $1,281,754               $1,281,754        ($22,754)        1.8%          Software Implementation Consulting         $1,145,000          $1,163,000          $2,308,000
Phase 1.0 Final - BT/Contractors - Expense                           $0            $0               $0          $229,333    $121,025     $350,358       ($350,358)      100.0%          Contingency (10%)                           $115,000            $116,000    $     231,000.00
Phase 1.0 Final - Mosaic                                      $414,000        $71,000         $485,000          $299,727     $28,996     $328,723        $156,277       -47.5%          Capital Interest                              $31,000             $30,000   $      61,000.00
Phase 1.0 Final - Misc Expenses                                      $0            $0               $0                $0     $18,670      $18,670        ($18,670)      100.0%             Capital Subtotal                        $1,291,000          $1,309,000          $2,600,000
Phase 1.0 Final - Cognos Reports                                $46,000       $14,000          $60,000           $56,500      $3,500      $60,000              $0         0.0%          Mosaic IT                                   $414,000            $450,000    $     864,000.00
Interim Agreement - Pricing Programs                            $62,280                        $62,280           $62,280                  $62,280              $0         0.0%          Primary Business Resources                  $334,000            $200,000    $     534,000.00
P1 CR01 - Pricing Programs - BT                               $103,488                        $103,488           $66,710      $8,473      $75,183         $28,305       -37.6%          Travel (External / Internal)                $185,000            $302,000    $     487,000.00
P1 CR01 - Pricing Programs - Mosaic                             $24,192                        $24,192            $1,125          $0       $1,125         $23,067     -2050.4%          Training                                      $40,000             $20,000   $      60,000.00
P1 CR02 - Cognos Reports - BT                                 $135,630         $5,000         $140,630          $145,088      $1,073     $146,160         ($5,530)        3.8%          Translation                                                       $55,000   $      55,000.00
P1 CR02 - Cognos Reports - Mosaic                               $26,245                        $26,245           $15,248          $0      $15,248         $10,998       -72.1%             Expense Subtotal                         $973,000           $1,027,000   $   2,000,000.00
Contingency (10%)                                             $115,000                        $115,000                $0          $0           $0        $115,000    #DIV/0!            TOTALS                                     $2,264,000          $2,336,000   $   4,600,000.00
Capital Interest                                                $31,000                        $31,000                $0          $0           $0         $31,000    #DIV/0!                                                       $559,000             $577,000
Training                                                        $40,000                        $40,000                       $43,000      $43,000         ($3,000)        7.0%                                                    $1,930,000           $2,136,000
                                        Phase 1.0 Totals     $2,142,835      $204,000       $2,346,835       $2,157,764     $224,737   $2,382,501        ($35,666)        1.5%
Interim Agreement - 1.G Prep                                    $92,000                        $92,000          $85,370      $17,675     $103,045        ($11,045)       10.7%
Interim Agreement - 1.G Prep Extension - BT                     $46,000                        $46,000          $42,685                   $42,685          $3,315        -7.8%
Interim Agreement - 1.G Prep Extension - EXT                                                        $0          $11,355        $228       $11,583        ($11,583)      100.0%
Interim Agreement - 1.G Prep Extension - MOSAIC                                                     $0          $10,125       $5,301      $15,426        ($15,426)      100.0%
Phase 1.G - Plan and Analyze - BT                              $387,667       $50,333         $438,000        $296,423       $30,845     $327,267        $110,733       -33.8%
Phase 1.G - Plan and Analyze - EXT                                                                  $0          $69,990           $0      $69,990        ($69,990)      100.0%
Phase 1.G - Plan and Analyze - MOSAIC                          $150,000       $50,333         $200,333          $40,819       $8,735      $49,553        $150,780      -304.3%
Phase 1.G - BT/Contractors - Capital                           $775,333      $100,667         $876,000        $870,360                   $870,360          $5,640        -0.6%
Phase 1.G - BT/Contractors - Expenses                                                               $0        $426,420       $58,447     $484,867       ($484,867)      100.0%
Phase 1.G - Design to Deploy - MOSAIC                          $300,000      $100,667         $400,667        $176,133            $0     $176,133        $224,534      -127.5%
Contingency (10%)                                              $116,000                       $116,000               $0                        $0        $116,000         0.0%
Capital Interest                                                $30,000                        $30,000               $0                        $0         $30,000         0.0%
Training                                                        $20,000                        $20,000               $0                        $0         $20,000         0.0%
Translation                                                     $55,000                        $55,000               $0      $27,390      $27,390         $27,610      -100.8%
CR01 - AppExchange Packages-Marketing (3)                                                           $0                        $4,188       $4,188         ($4,188)      100.0%
CR02 - Extend App Team (included in line 26/27)                                                     $0                                         $0              $0    #DIV/0!
CR04 - Brazil Travel Expenses for Training                                                          $0                       $37,000      $37,000        ($37,000)      100.0%
CR03 - Extend Cognos Team                                                                           $0                                         $0              $0    #DIV/0!
                                       Phase 1.G Totals      $1,972,000      $302,000       $2,274,000       $2,029,679     $189,809   $2,219,488         $54,512        -2.5%
                                    Phase Grand Totals       $4,114,835      $506,000       $4,620,835       $4,187,443     $414,547   $4,601,989         $18,846        -0.4%
                                                                                                                                                                                                                                 363.6363636
                     Variance from Capital Request                                           1.G Steps / Schedule           Weeks
Phase 1 Capital Request                                       $4,600,000                       Detailed Planning              8
Phase 1 Total Cost                                           ($4,601,989)                 Requirements / Design / CM         16                     $     15,000 Estimated International Travel
Business Resource Reduction                                    ($534,000)                             Build                   9                     $      8,000 Estimated Domestic Travel
Software Spend                                                 ($401,800)                       System Testing                5                                  Estimated Fees for 1.G Tam
Salesforce Training Spend                                       ($43,800)                          Data Testing               2                     $    100,000 Estimated Rees for Cognos Team
                                                                                           User Acceptance Testing            3                     $     40,000 Estimated Brazil training fees
                                                  Total       ($981,589)                   Train / Deploy / Hypercare        10                     $    148,000

                                                                                                     Total                    53


*Note: Cognos reduction = $47,500. Drops total fees/expenses to SOW amount of $60,000.
                                     CR NA Budget    NA Actuals                   Pricing
                                                                    Cognos
                                        (FY11)         (FY11)                    Program
Software Implementation Consulting      $1,145,000    $1,281,754       $56,500      $128,990
Contingency (10%)                         $115,000
Capital Interest                           $31,000
   Capital Subtotal                     $1,291,000    $1,281,754       $56,500      $128,990
Mosaic IT+Fees-Expense                    $414,000      $529,060                      $1,125
Primary Business Resources                $334,000
Travel (External / Internal)              $185,000     $150,022         $3,500        $8,473
Training                                   $40,000      $61,670
Translation
   Expense Subtotal                       $973,000      $740,752        $3,500        $9,598
TOTALS                                  $2,264,000    $2,022,506       $60,000      $138,588




                                                                      Total
                                     CR NA Budget    Actuals to
                                                                   Forecasted Total Overrun
                                        (FY11)        Sep2011
                                                                     Spend
Software Implementation Consulting      $2,308,000    $1,857,534     $2,875,602   ($567,602)
Contingency (10%)                         $231,000            $0             $0     $231,000
Capital Interest                           $61,000            $0             $0      $61,000
   Capital Subtotal                     $2,600,000    $1,857,534     $2,875,602   ($275,602)
Mosaic IT                                 $864,000      $425,395       $572,172     $291,828
Primary Business Resources                $534,000            $0             $0     $534,000
Travel (External / Internal)              $487,000      $414,547       $540,907    ($53,907)
Training                                   $60,000            $0             $0      $60,000
Translation                                $55,000            $0             $0      $55,000
   Expense Subtotal                     $2,000,000      $839,942     $1,113,079     $886,921
TOTALS                                  $4,600,000    $2,697,476     $3,988,681     $611,319
                          CR Global                   Global
Cognos      NA Variance                 Global                    Global Variance
                           Budget                    Forecast                      Variance Total
Rollup        (FY11)                    Interim                       (FY12)
                           (FY12)                     (FY12)
 $145,088    ($467,332)    $1,163,000     $139,410     $1,236,773      ($213,183)       ($680,514)
               $115,000      $116,000                                    $116,000         $231,000
                $31,000       $30,000                                      $30,000         $61,000
 $145,088    ($321,332)    $1,309,000     $139,410     $1,236,773        ($67,183)      ($388,514)
  $15,248    ($131,432)      $444,000      $10,125       $643,371      ($209,496)       ($340,929)
               $334,000      $200,000                                    $200,000         $534,000
   $1,073       $21,933      $302,000      $23,204       $166,605        $112,191         $134,124
              ($21,670)       $20,000                                      $20,000         ($1,670)
                     $0       $55,000      $27,390                         $27,610         $27,610
  $16,320      $202,830    $1,021,000      $60,720       $809,976        $150,304         $353,135
 $161,408    ($118,501)    $2,330,000     $200,130     $2,046,748          $83,122       ($35,379)
                                                    Actual/Estimate                             Budget
Workstreams                                 Capital     Expense     Total          Capital      Expense
CRM Phase 1
  Phase 1                                  $1,338,254    $350,893 $1,689,147
  1.1 Pricing Program                       $128,990       $9,598  $138,588
  1.1 Rollup Reports                        $145,088      $16,320  $161,408
  TOTAL                                    $1,612,332    $376,812 $1,989,143 $1,291,000          $973,000

CRM Phase 1.G
  Part A: Plan & Analyze                    $424,478     $195,073  $619,550
  Part B: Design to Deploy                  $870,360     $660,999 $1,531,359
  TOTAL                                    $1,294,838    $856,072 $2,150,910 $1,309,000 $1,027,000

GRAND TOTAL                                $2,907,169 $1,232,884 $4,140,053 $2,600,000 $2,000,000

Assumptions/Comments:
Actual/Estimate Capital columns are costs associated with only Baker Tilly fees
Actual/Estimate Expense columns are MosaicIT fees, Patni Fees, Clerisys Fees, and expenses for all project resources
Contingency fees and capital interest are included in the Budget Capital Column; cells E4 & E11
Training & Translation from Capital Request are not include anywhere in this model.
Business resource costs or expenses from Capital Request are not included anywhere in this model
 Budget                                Variance
                 Total     Capital     Expense     Total




              $2,264,000   -$321,332    $596,188   $274,857




              $2,336,000    $14,163     $170,928   $185,090

              $4,600,000   -$307,169    $767,116   $459,947



r all project resources
          Summary             Budget        Actual         Diff        Percent

Capital                      $2,600,000    $2,875,602     -$275,602     111%                  <---- As of 02/29/12
Expense                      $2,000,000    $1,520,988      $479,012         76%               <---- As of 02/29/12
 Total                       $4,600,000    $4,396,589      $203,411         96%               <---- As of 02/29/12

          NOTE: Actual vs. budget for full 2 year CRM Commitment Request.



                                                            Capital Expenditues by Project by Month

                                           Pricing       Cognos        Interim  1.G Plan & 1.G Design
                            Phase 1.0
                                          Programs       Reports      Agreement Analyze     to Deploy

     September-10             $30,344
        October-10           $109,363
     November-10             $156,760
      December-10            $155,731
        January-11           $177,192
       February-11           $241,280
          March-11           $141,325                                   $9,844
           April-11                                                    $74,579
            May-11                         $39,100                     $65,704
           June-11                         $27,610                     $51,564      $79,888
            July-11                                      $28,180                   $133,349
         August-11                                       $64,098                   $118,948
     September-11                                        $52,810                    $34,228     $65,640
        October-11                                                                             $200,953
     November-11                                                                               $271,085
      December-11                                                                              $265,360
        January-12                                                                             $280,670
       February-12
          March-12


                                                                                                    Expense Expenditues by P
                                                                       Mosaic                   Mosaic
                              BT 1.0      Mosaic 1.0 BT Pricing                   BT Cognos
                                                                       Pricing                 Cognos
                             Expense       Expense    Expense                      Expense
                                                                      Expense                  Expense
     September-10              $2,058
        October-10            $20,332
     November-10              $11,094
      December-10              $8,992
        January-11            $21,313
       February-11            $18,868
          March-11           $168,462      $347,393
           April-11
            May-11                                        $8,431        $563
           June-11                                         $41          $563
      July-11     $0     $5,083
    August-11   $1,073   $5,083
September-11      $0     $5,083
   October-11
November-11
 December-11
   January-12
  February-12
     March-12
---- As of 02/29/12
---- As of 02/29/12
---- As of 02/29/12




Month
              Capital     Aggregate
            Expense per     Capital
              Month        Expense
              $30,344       $30,344
             $109,363      $139,707
             $156,760      $296,467
             $155,731      $452,198
             $177,192      $629,389
             $241,280      $870,669
             $151,169     $1,021,838
              $74,579     $1,096,417
             $104,804     $1,201,221
             $159,062     $1,360,282
             $161,529     $1,521,811
             $183,045     $1,704,856
             $152,678     $1,857,534
             $200,953     $2,058,487                          $4,545,749
             $271,085     $2,329,572
             $265,360     $2,594,932
             $280,670     $2,875,602
                $0        $2,875,602
                $0        $2,875,602


     Expense Expenditues by Project by Month
                           Mosiac      BT 1.G    Mosaic 1.G    BT 1.G      Mosaic 1.G  Capital     Aggregate
             BT Interim
                           Interim     Plan &     Plan &      Design to    Design to Expense per     Capital
             Agreement
                          Agreement    Analyze    Analyze      Deploy       Deploy     Month        Expense
                                                                                         $2,058      $2,058
                                                                                        $20,332     $22,390
                                                                                        $11,094     $33,484
                                                                                         $8,992     $42,476
                                                                                        $21,313     $63,788
                                                                                        $18,868     $82,656
                 $0        $2,531                                                      $518,387    $601,043
               $1,684      $2,531                                                        $4,215    $605,258
              $15,451      $2,531                                                       $26,976    $632,234
               $6,069      $2,531      $16,976    $10,205                               $36,385    $668,619
$16,200   $10,205                         $31,487    $700,106
 $5,828   $10,205                         $22,188    $722,294
  $574    $10,205     $725     $29,355    $45,942    $768,236
                     $6,363    $29,355    $35,718    $803,954
                    $115,116   $29,355   $144,471    $948,426
                    $117,851   $29,355   $147,207   $1,095,632
                    $126,596   $29,355   $155,951   $1,251,583
                    $240,049   $29,355   $269,404   $1,520,988
                    $149,160             $149,160   $1,670,148
           Aggregat
Monthly
              e
MosaicIT
           MosaicIT
 Spend
            Spend




$331,255   $331,255
  $2,531   $333,786
  $3,094   $336,880
 $13,298   $350,178
$15,287   $365,465
$15,287   $380,753
$44,643   $425,395
$29,355   $454,751
$29,355   $484,106
$29,355   $513,461
$29,355   $542,817
$29,355   $572,172
  $0      $572,172
By Resource by Month

     Res                                                                    January-00               Mike Huzinec
                    Actual      Budget
     Role                                  Actual Fees    Budget Fees       January-00            Cognos Reports Lead
                    Hours       Hours
     Rate                                                                 $0            $0         $225        $225
                                                                         Actual        SOW         Actual      SOW
  December-11        48h          54h       $10,800        $12,240           0.0h          0.0h       48.0h      54.4h
    January-12       52h          67h       $11,700        $15,120           0.0h          0.0h       52.0h      67.2h
   February-12       0h           58h         $0           $12,960           0.0h          0.0h        0.0h      57.6h
                                                                                 0            0         100        179
           Totals    100h        179h       $22,500         $40,320             $0           $0     $22,500     $40,320

                                              ($22,500)


                                                                                     Aggregate
                     Actual      Actual      Actual        Actuals       Actuals
                                                                                        Fee
    Period          Monthly     Monthly     Monthly       Aggregate     Aggregate
                                                                                        w/
                      Fees     Expenses      Totals          Fee        Expenses
                                                                                     Expenses
  December-11       $10,800        $0       $10,800         $10,800        $0         $10,800
    January-12      $11,700        $0       $11,700         $22,500        $0         $22,500
   February-12        $0           $0         $0            $22,500        $0         $22,500
       Actuals      $22,500        $0                                                 $22,500
          SOW       $40,320      $4,000                                               $40,320


                         Baker Tilly                External                   Mosaic
                    Actuals        SOW       Actuals         SOW         Actuals      SOW
    Fees-Capital    $22,500      $40,320       $0             $0
  Fees-Expenses       $0                       $0                          $0           $0
       Expenses       $0          $4,000       $0                          $0
          Totals    $22,500      $44,320       $0             $0           $0           $0

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:18
posted:8/23/2012
language:Latin
pages:23