Project Management Plan Excel Template Org

Document Sample
Project Management Plan Excel Template Org Powered By Docstoc
					    INSTRUCTIONS FOR USING THE PM411.ORG BUDGET TEMPLATE

1




2




3




4




5




6




7




8
INSTRUCTIONS FOR USING THE PM411.ORG BUDGET TEMPLATE
This template allows you to track your project's spending to current and original plan by phase and by month
within the phase. The Excel workbook is broken into 3 worksheets - INSTRUCTIONS (this tab), DASHBOARD,
AND BUDGET

The DASHBOARD worksheet is meant to give you an overview of your project budget by phase (for up to 5
project phases) and the total project expenses. Under "Current Phase Dates" on the DASHBOARD worksheet,
enter the project team start date and the completion date of each of the 4 phases. If your project has more than 4
phases, you can combine the phases. If you decided to modify the worksheet to include more (or less phases),
please be aware that you are doing so at your own risk. You can easily submit your budget as a report and add
some high level detail to the "Project Budget Comments" section, describing any changes to your budget or

The BUDGET worksheet is broken down into 3 categories of expenses - General Expenses, Capital Expenses,
and Labor Expenses. You can easily modify the descriptions of each (in blue text) to reflect your
organization/project accounts and labor force.

Based on the Project start and Phase Completion dates you added on the DASHBOARD sheet, the BUDGET
sheet should automatically populate with the appropriate monthly columns in each phase. Under each month,
simply enter the actual amount spent per account or resource. Note that resources are listed by hour rather than
by dollar. There is a cell on the BUDGET sheet (near the bottom of the "B" column) that allows you to enter a set
estimated labor rate. This template does not allow you to enter individual resource labor rates (maybe the next

For each phase, there is a column called PHASE ACTUALS that automatically totals all the monthly expenses
across the phase. There is a similar column on the far right side of the spreadsheet for the PROJECT ACTUALS
that totals all phase actuals.

Likewise there is a column in each phase called PHASE CURRENT PLAN, where you can manually enter your
current estimates for each account / resource by phase. Also, there is a column in each phase called PHASE
CONTRACT, where you put your original contracted estimations. This allows you to compare your current
actuals to your current plan and original plan estimates. These columns are also totaled automatically at the far
right side of the worksheet.

Note that there are grouping buttons (the little plus/minus buttons) at the top and the left side of the BUDGET
worksheet. This allows you to expand or contract detail. Note that the graphs on the DASHBOARD sheet will
only appear if the groupings are fully expanded (visible).

Once you have filled in the actual, planned, and original data into the BUDGET spreadsheet, you should see
graphs appear on the DASHBOARD worksheet. The blue line in each phase chart represents a linear "burn rate"
for the phase. In otherwords, it looks at the total amount you plan on spending per phase (that you entered under
the PHASE PLANNED columns for each phase on the BUDGET worksheet) and divides the amount equally over
each month in the phase. This gives you a yardstick to compare your actual Expense, Capital, and Labor
expenses against.
MPLATE
                 PROJECT NAME:                                 PROJECT NAME                           PROJECT BUDGET COMMENTS
                 PROJECT MANAGER:                              YOUR NAME                              This is a space to enter information concerning project actuals versus plan and any variances.

                 REPORT DATE:                                  April, 2007

                               CURRENT PHASE DATES
                 Team Start Date                                             01/01/07
                 Phase 1 Completion Date                                     06/15/07
                 Phase 2 Completion Date                                     09/01/07
                 Phase 3 Completion Date                                     09/15/07
                 Phase 4 Completion Date                                     12/01/07
                 Phase 5 Completion Date                                     01/01/08

                        CONTRACT TOLERANCE WARNINGS
                 PHASE 1                        3%                                  50%
                 PHASE 2                        5%                                  10%
                 PHASE 3                        5%                                  10%
                 PHASE 4                        5%                                  10%
                 PHASE 5                        5%                                  10%
                 PROJECT TOTALS                 5%                                  10%

                 PHASE 1                                         Jan-07    Feb-07   Mar-07   Apr-07    May-07    Jun-07                                    PHASE 2                                      Jun-07      Jul-07    Aug-07      Sep-07
                 (A) ACTUAL TOTALS                                 $0.0k    $0.0k    $0.0k    $0.0k     $0.0k     $0.0k                                    (A) ACTUAL TOTALS                              $0.0k     $0.0k      $0.0k       $0.0k
                 (B) CUMULATIVE ACTUALS                            $0.0k    $0.0k    $0.0k    $0.0k     $0.0k     $0.0k                                    (B) CUMULATIVE ACTUALS                         $0.0k     $0.0k      $0.0k       $0.0k
                 (C) CUMULATIVE CURRENT PLAN                       $0.0k    $0.0k    $0.0k    $0.0k     $0.0k     $0.0k                                    (C) CUMULATIVE CURRENT PLAN                    $0.0k     $0.0k      $0.0k       $0.0k
                 (B) MINUS (C)                                     $0.0k    $0.0k    $0.0k    $0.0k     $0.0k     $0.0k                                    (B) MINUS (C)                                  $0.0k     $0.0k      $0.0k       $0.0k


                                                                                                                                                               $1.00
                       $1.00

                       $0.90                                                                                                                                   $0.90

                       $0.80                                                                                    CUMULATIVE GENERAL                             $0.80
                                                                                                                EXPENSES
                       $0.70                                                                                                                                   $0.70
                                                                                                                CUMULATIVE CAPITAL                                                                                                                              CUMULATIVE GENERAL EXPENSES
                       $0.60                                                                                    EXPENSES
                                                                                                                                                               $0.60
                                                                                                                CUMULATIVE LABOR                                                                                                                                CUMULATIVE CAPITAL EXPENSES
                       $0.50                                                                                    EXPENSES                                       $0.50
                       $0.40                                                                                    CUMULATIVE CURRENT PLAN                                                                                                                         CUMULATIVE LABOR EXPENSES
                                                                                                                                                               $0.40
                       $0.30
                                                                                                                                                                                                                                                                CUMULATIVE CURRENT PLAN
                                                                                                                                                               $0.30
                       $0.20
                                                                                                                                                               $0.20
                       $0.10

                       $0.00                                                                                                                                   $0.10
                                  Jan-07 Feb- Mar- Apr-07 May- Jun-07
                                          07   07          07                                                                                                  $0.00
                                                                                                                                                                           Jun-07   Jul-07   Aug-07   Sep-07




                 PHASE 3                                        Sep-07                                                                                     PHASE 4                                      Sep-07     Oct-07     Nov-07      Dec-07
                 (A) ACTUAL TOTALS                                 $0.0k                                                                                   (A) ACTUAL TOTALS                              $0.0k     $0.0k      $0.0k       $0.0k
                 (B) CUMULATIVE ACTUALS                            $0.0k                                                                                   (B) CUMULATIVE ACTUALS                         $0.0k     $0.0k      $0.0k       $0.0k
                 (C) CUMULATIVE CURRENT PLAN                       $0.0k                                                                                   (C) CUMULATIVE CURRENT PLAN                    $0.0k     $0.0k      $0.0k       $0.0k
                 (B) MINUS (C)                                     $0.0k                                                                                   (B) MINUS (C)                                  $0.0k     $0.0k      $0.0k       $0.0k


                     $1.00                                                                                                                                    $1.00

                     $0.90                                                                                                                                    $0.90

                     $0.80                                                                                                                                    $0.80

                     $0.70                                                                                                                                    $0.70
                                                                                                                          CUMULATIVE GENERAL
                                                                                                                          EXPENSES
                     $0.60                                                                                                                                    $0.60                                                                                               CUMULATIVE GENERAL EXPENSES
                                                                                                                          CUMULATIVE CAPITAL
                                                                                                                          EXPENSES                                                                                                                                CUMULATIVE CAPITAL EXPENSES
                     $0.50                                                                                                                                    $0.50
                                                                                                                          CUMULATIVE LABOR                                                                                                                        CUMULATIVE LABOR EXPENSES
                     $0.40                                                                                                EXPENSES                            $0.40                                                                                               CUMULATIVE CURRENT PLAN
                                                                                                                          CUMULATIVE CURRENT PLAN
                     $0.30                                                                                                                                    $0.30

                     $0.20                                                                                                                                    $0.20

                     $0.10                                                                                                                                    $0.10

                     $0.00                                                                                                                                    $0.00
                                 Sep-07                                                                                                                                Sep-07       Oct-07   Nov-07    Dec-07




                 PHASE 5                                        Dec-07     Jan-08                                                                          PROJECT TOTAL                              PHASE 1     PHASE 2    PHASE 3    PHASE 4    PHASE 5        TOTALS
                 (A) ACTUAL TOTALS                                 $0.0k    $0.0k                                                                          (A) ACTUAL TOTALS                              $0.0k     $0.0k      $0.0k       $0.0k     $0.0k          $0.0k
                 (B) CUMULATIVE ACTUALS                            $0.0k    $0.0k                                                                          (B) CUMULATIVE ACTUALS                         $0.0k     $0.0k      $0.0k       $0.0k     $0.0k          $0.0k
                 (C) CUMULATIVE CURRENT PLAN                       $0.0k    $0.0k                                                                          (C) CUMULATIVE CURRENT PLAN                    $0.0k     $0.0k      $0.0k       $0.0k     $0.0k          $0.0k
                 (B) MINUS (C)                                     $0.0k    $0.0k                                                                          (D) CUMULATIVE ORIG. PLAN                      $0.0k     $0.0k      $0.0k       $0.0k     $0.0k          $0.0k


                       $1.00                                                                                                                                   $1.00
                                                                                                                                                                                                                                                                      CUMULATIVE GENERAL
                       $0.90                                                                                                                                   $0.90                                                                                                  EXPENSES

                       $0.80                                                                                                                                   $0.80                                                                                                  CUMULATIVE CAPITAL
                                                                                                                           CUMULATIVE GENERAL EXPENSES                                                                                                                EXPENSES
                       $0.70                                                                                                                                   $0.70
                                                                                                                           CUMULATIVE CAPITAL EXPENSES                                                                                                                CUMULATIVE LABOR
                       $0.60                                                                                                                                   $0.60                                                                                                  EXPENSES

                       $0.50                                                                                               CUMULATIVE LABOR EXPENSES           $0.50                                                                                                  CUMULATIVE ORIG. PLAN

                       $0.40                                                                                                                                   $0.40
                                                                                                                           CUMULATIVE CURRENT PLAN
                                                                                                                                                                                                                                                                      CUMULATIVE CURRENT PLAN
                       $0.30                                                                                                                                   $0.30

                       $0.20                                                                                                                                   $0.20

                       $0.10                                                                                                                                   $0.10

                       $0.00                                                                                                                                   $0.00
                                 Dec-07 Jan-08                                                                                                                                PHASE 1             PHASE 2           PHASE 3            PHASE 4        PHASE 5

                                                                                                                                                                                                                                                                                                        PRINTED:
VER.1.20070328                                                                                                                                                                                                                                                                                  7/17/2010 6:38 PM
                 pm411.org                                                                                                                                                                                                                                      Page 5                                                                                                                                                                                                     7/17/2010




                                         Jan-07       Feb-07       Mar-07       Apr-07       May-07       Jun-07                                   Jun-07   Jul-07       Aug-07       Sep-07                                           Sep-07                                                            Sep-07       Oct-07       Nov-07       Dec-07                                           Dec-07       Jan-08



GENERAL EXPENSES               ACCOUNT
SCRAP                           XXXX0             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
LABOR MODELS AND PROTOTYPES     XXXX1             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
TRAVEL                          XXXX2             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
MEALS AND ENTERTAINMENT         XXXX3             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
OFFICE SUPPLIES                 XXXX4             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
POSTAGE AND FREIGHT             XXXX5             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
OPERATING SUPPLIES              XXXX6             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
SMALL TOOLS AND DIES            XXXX7             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
PRODUCTION MATERIAL             XXXX8             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
MODELS AND PROTOTYPES           XXXX9             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
COMPETITIVE PRODUCTS            XXX10             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
PRODUCTS FOR TESTING            XXX11             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
PC SOFTWARE                     XXX12             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
BOOKS - COMPANY LIBRARY         XXX13             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
AWARDS AND RECOGNITION          XXX14             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
MATERIALS FROM STOCK            XXX15             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
OUTSOURCED PCB                  XXX16             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
OUTSOURCED PACKAGING            XXX17             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
CONSULTANTS                     XXX18             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
INTELLECTUAL PROPERTY           XXX19             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
OUTSIDE SERVICES                XXX20             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
AGENCY LABOR                    XXX21             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
U.S. REGULATORY SERVICES        XXX22             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
INT'L REGULATORY SERVICES       XXX23             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
INDUSTRIAL DESIGN/STYLING       XXX24             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
SOFTWARE DESIGN CONSULTING      XXX25             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
LEGAL CONSULTING                XXX26             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
USER GUIDE TRANSLATION          XXX27             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
MECHANICAL DESIGN CONSULTING    XXX28             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
AUDIO/ACOUSTICS CONSULTING      XXX29             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
DUES                            XXX30             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
SUBSCRIPTIONS                   XXX31             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
TECHNICAL CONFERENCES           XXX32             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -            -            -   -   -   -   -   -   -   -   -   -   -   -   -               -   -
ASSOCIATE TRAINING              XXX33             -            -            -            -            -            -   -   -   -   -   -   -   -        -            -            -            -   -   -   -   -   -   -   -   -   -            -   -   -   -     -      -   -   -   -   -   -   -   -            -            -            -            -   -   -   -   -   -   -   -   -   -

				
DOCUMENT INFO
Description: Project Management Plan Excel Template .Org document sample