Contract on It Consulting by evn13501

VIEWS: 28 PAGES: 7

Contract on It Consulting document sample

More Info
									                                                                      Commonwealth of Massachusetts
                                                                      Information Technology Division
                                                                             CW Budget Plan


  Project Name                                                                                                                            SAM

  Project Manager                                                                                                                         PMO Manager
                                                                                                                                          Reporting
  Project Sponsor
                                                                                                                                          Manager


                                                                               Project Budget Status
                                                                                                  Approved                                                           Total Actual                      Revised Budget vs.
             Project Budget                                     Initial Budget                                                              Revised Budget
                                                                                                 Adjustments                                                          Expenses                              Actuals

  Employee Labor                                                $                       -        $                                   -        $              -   $                                 -   $                                           -
  Contract/Consulting Labor                                     $                       -        $                                   -        $              -   $                                 -   $                                           -
  Overtime                                                      $                       -        $                                   -        $              -   $                                 -   $                                           -
  Hardware                                                      $                       -        $                                   -        $              -   $                                 -   $                                           -
  Software                                                      $                       -        $                                   -        $              -   $                                 -   $                                           -
  Material & Services                                           $                       -        $                                   -        $              -   $                                 -   $                                           -
  Training                                                      $                       -        $                                   -        $              -   $                                 -   $                                           -
  Travel                                                        $                       -        $                                   -        $              -   $                                 -   $                                           -
  Miscellaneous                                                 $                       -        $                                   -        $              -   $                                 -   $                                           -
  (other replace)                                               $                       -        $                                   -        $              -   $                                 -   $                                           -
  (other replace)                                               $                       -        $                                   -        $              -   $                                 -   $                                           -
  (other replace)                                               $                       -        $                                   -        $              -   $                                 -   $                                           -

  Totals                                                        $                       -        $                                   -        $              -   $                                 -   $                                           -


                                                                                 Project Budget Status
                                                                               Total Actual Expenses                               Revised Budget vs. Actuals


    $1
    $1
    $1
    $1
    $1
    $1
    $0
    $0
    $0
    $0
    $-
                                                                                                                                         Training
                               Contract/Consulting




                                                                                      Software




                                                                                                                                                    Travel




                                                                                                                                                                                 (other replace)



                                                                                                                                                                                                           (other replace)



                                                                                                                                                                                                                             (other replace)
                                                     Overtime
              Employee Labor




                                                                    Hardware




                                                                                                                                                                 Miscellaneous
                                                                                                         Material & Services
                                     Labor




                                                                                                     Budget Categories




d197f417-0030-4f88-9706-2890b5a776a4.xls                                                                                       1                                                                                                               1/12/2011
                                           Commonwealth of Massachusetts
                                           Information Technology Division
                                                 CW Budget Status


                                                          Budget
                                                                             Approved
                          Project Budget           Initial Budget                                 Revised Budget
                                                                            Adjustments

               Employee Labor                  $                    -   $                 -   $                    -

               Contract/Consulting Labor       $                    -   $                 -   $                    -

               Overtime                        $                    -   $                 -   $                    -

               Hardware                        $                    -   $                 -   $                    -

               Software                        $                    -   $                 -   $                    -

               Material & Services             $                    -   $                 -   $                    -

               Training                        $                    -   $                 -   $                    -

               Travel                          $                    -   $                 -   $                    -

               Miscellaneous                   $                    -   $                 -   $                    -

               (other replace)                 $                    -   $                 -   $                    -

               (other replace)                 $                    -   $                 -   $                    -

               (other replace)                 $                    -   $                 -   $                    -

               Totals                          $                    -   $                 -   $                    -




d197f417-0030-4f88-9706-2890b5a776a4.xls                       7                                                       1/12/2011
                              Commonwealth of Massachusetts
                              Information Technology Division
                                  CW Recurring Expenses
                                       Recurring Expenses
                                                      Incremental          Number of       Recurring Cost
Post Implementation Annual Recurring Expenses         Costs per Unit       Units             Estimate

Mainframe                                             $                -               $                    -
Servers                                               $                -               $                    -
Mid-Range Services                                    $                -               $                    -
Chassis                                               $                -               $                    -
CPUs                                                  $                -               $                    -
Network                                               $                -               $                    -
Network Connections (consider both size & number)     $                -               $                    -
Database Type (Oracle, SQL)                           $                -               $                    -
Database Licensing Model (enterprise, standard)       $                -               $                    -
Database Structure (on a cluster)                     $                -               $                    -
Storage Type (Symmetrics, Clarion, NAS, Local)        $                -               $                    -
Storage Size                                          $                -               $                    -
LAN Support                                           $                -               $                    -
Messaging                                             $                -               $                    -
Financial/Payroll                                     $                -               $                    -
Mail/Print                                            $                -               $                    -
PBX                                                   $                -               $                    -
(other replace)                                       $                -               $                    -
(other replace)                                       $                -               $                    -
(other replace)                                       $                -               $                    -

Totals                                                                                 $                    -




d197f417-0030-4f88-9706-2890b5a776a4.xls          7                                             1/12/2011
                                                                                                            Commonwealth of Massachusetts
                                                                                                            Information Technology Division
                                                                                                              CW Monthly Actual Expenses




                                                                                                                         Monthly Actual Expenses
                                                                                                                                                                                                                                                         Total Actual
               Expense Category             Jul-08           Aug-08           Sep-08           Oct-08           Nov-08            Dec-08           Jan-09           Feb-09           Mar-09           Apr-09           May-09           Jun-09
                                                                                                                                                                                                                                                          Expenses

            Employee Labor              $            -   $            -   $            -   $            -   $             -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $                  -


            Contract/Consulting Labor   $            -   $            -   $            -   $            -   $             -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $                  -


            Overtime                    $            -   $            -   $            -   $            -   $             -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $                  -


            Hardware                    $            -   $            -   $            -   $            -   $             -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $                  -


            Software                    $            -   $            -   $            -   $            -   $             -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $                  -


            Material & Services         $            -   $            -   $            -   $            -   $             -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $                  -


            Training                    $            -   $            -   $            -   $            -   $             -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $                  -


            Travel                      $            -   $            -   $            -   $            -   $             -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $                  -


            Miscellaneous               $            -   $            -   $            -   $            -   $             -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $                  -


            (other replace)             $            -   $            -   $            -   $            -   $             -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $                  -


            (other replace)             $            -   $            -   $            -   $            -   $             -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $                  -


            (other replace)             $            -   $            -   $            -   $            -   $             -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $                  -


            Totals                      $            -   $            -   $            -   $            -   $             -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $                  -




d197f417-0030-4f88-9706-2890b5a776a4.xls                                                                                               7                                                                                                                                    1/12/2011
                                                                                                  Commonwealth of Massachusetts
                                                                                                  Information Technology Division
                                                                                                      CW Budget Adjustments



                                                                                                               Budget Adjustments

            Adjustment Category       Jul-08           Aug-08           Sep-08           Oct-08           Nov-08           Dec-08           Jan-09           Feb-09           Mar-09           Apr-09           May-09           Jun-09           Total


           Employee Labor         $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $           -

           Contract/Consulting
                                  $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $           -
           Labor

           Overtime               $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $           -


           Hardware               $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $           -


           Software               $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $           -


           Material & Services    $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $           -


           Training               $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $           -


           Travel                 $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $           -


           Miscellaneous          $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $           -


           (other replace)        $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $           -


           (other replace)        $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $           -


           (other replace)        $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $           -


           Totals                 $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $            -   $           -




d197f417-0030-4f88-9706-2890b5a776a4.xls                                                                                       7                                                                                                                              1/12/2011
                                       Commonwealth of Massachusetts
                                       Information Technology Division
                                           CW Budget Assumptions


                                              Budget Assumptions




d197f417-0030-4f88-9706-2890b5a776a4.xls              7                  1/12/2011
                                       Commonwealth of Massachusetts
                                       Information Technology Division
                                              CW Instructions

                                                    General Instructions

Data in the grey cells are auto calculated. Data can be input only into white cells in the respective tables in each worksheets.



                                            Overall Budget Status Instructions

 Complete the Project Name, Project Manager Name, Project Sponsor Name, SAM Name, PMO Reporting Manager Name
and Reporting Manager Name Fields in the Overall Budget Status Tab
 The Financial information is linked to other worksheets i.e. Budget , Adjustments & Actuals. This table will be updated
automatically.



                                                     Budget Instructions
Enter Initial Budget on the Budget Sheet. All other columns are calculated.


Change any of the budget categories but change on budget tab. Other worksheets will be updated automatically
 Add additional budget categories by changing the (other replace) category. Change on budget tab only. Changes will be
reflected in other worksheets.



                                             Recurring Expense Instructions
Before approving a project, sponsors want to understand the full cost of the project - including recurring costs. Add these
recurring costs under the Recurring Expenses tab. Add additional recurring expense categories by changing the (other
replace) category.



                                               Actual Expenses Instruction
Enter Actual Expenses in actual expense tab. These will be reflected on the Budget tab.



                                                   Adjustment Instruction

Enter any increases or decreases in the budget in the Adjustments tab. These will be reflected on the Budget tab.



                                                  Assumptions Instruction
Estimates are based upon best-guess statements (i.e. Number of Resources, Duration of Project, Types of Training, Types of
Resources. Please list these to help shape the estimates.



                                                  File Saving Instructions
Save the template as "<Project Name>_Budget"
Steps
Step 1: Click File and select "Save As".
Step 2: Select the location on your hard drive where you wish to store the file and save.
Step 3: In the "File name" box, enter the file name in this format "<Project Name>_Budget"
Step 4: In the "Save as type" box, click Microsoft office Excel Workbook.
Step 5: Click Save.




d197f417-0030-4f88-9706-2890b5a776a4.xls                        7                                                     1/12/2011

								
To top