Docstoc

Project Budget Template

Document Sample
Project Budget Template Powered By Docstoc
					Put your logo here                                                  Project Budget Form                                                Your Organization
                                                                                                                                             Name Here



                                                               Source of Project Cost

        Project Name:
     Project Manager:

Instructions:
 > Enter project tasks specific to your project
    > Enter budget information into white cells
    > Totals are calculated automatically
    >To add rows, unprotect sheet (Tools/Protection/Unprotect). Protect when done to safeguard data entry.
                                                                              Labor       Labor     Material    Travel     Other     Total per
                                Project Task
                                                                              Hours      Cost ($)   Cost ($)   Cost ($)   Cost ($)     Task
1                              Project Design

1.1                            Develop Functional Specifications                0          $0         $0         $0         $0          $0
1.2                            Develop System Architecture                      0          $0         $0         $0         $0          $0
1.3                            Develop Preliminary Design Specification         0          $0         $0         $0         $0          $0
1.4                            Develop Detailed Design Specifications           0          $0         $0         $0         $0          $0
1.5                            Develop Acceptance Test Plan                     0          $0         $0         $0         $0          $0
                               Subtotal                                         0          $0         $0         $0         $0          $0
2                              Project Development
2.1                            Develop Components                               0          $0         $0         $0         $0          $0
2.2                            Procure Software                                 0          $0         $0         $0         $0          $0
2.3                            Procure Hardware                                 0          $0         $0         $0         $0          $0
2.4                            Development Acceptance Test Package              0          $0         $0         $0         $0          $0
2.5                            Perform Unit/Integration Test                    0          $0         $0         $0         $0          $0
                               Subtotal                                         0          $0         $0         $0         $0          $0



Project Budget Form Rev. 2.0, 09/07/2003                                   Page 1 of 7                                                   Print Date: 11/1/2011
Put your logo here                                                   Project Budget Form                           Your Organization
                                                                                                                         Name Here

3                              Project Delivery
3.1                            Install System                                         0        $0   $0   $0   $0   $0
3.2                            Train Customers                                        0        $0   $0   $0   $0   $0
3.3                            Perform Acceptance Test                                0        $0   $0   $0   $0   $0
3.4                            Perform Post Project Review                            0        $0   $0   $0   $0   $0
3.5                            Provide Warranty Support                               0        $0   $0   $0   $0   $0
3.6                            Archive Materials                                      0        $0   $0   $0   $0   $0
                               Subtotal                                               0        $0   $0   $0   $0   $0
9                              Project Management
9.1                            Customer Progress Meetings/Reports                     0        $0   $0   $0   $0   $0
9.2                            Internal Status Meetings/Reports                       0        $0   $0   $0   $0   $0
9.3                            Third-Party Vendor Interface                           0        $0   $0   $0   $0   $0
9.4                            Interface to Other Internal Departments                0        $0   $0   $0   $0   $0
9.5                            Configuration Management                               0        $0   $0   $0   $0   $0
9.6                            Quality Assurance                                      0        $0   $0   $0   $0   $0
9.7                            Overall Project Management                             0        $0   $0   $0   $0   $0
                               Subtotal                                               0        $0   $0   $0   $0   $0
10 - Other                     Other cost                                             0        $0   $0   $0   $0   $0
11 - Other                     Other cost                                             0        $0   $0   $0   $0   $0
                                                                   Sub-Totals:        0        $0   $0   $0   $0   $0
                                                          Risk (Contingency):         0        $0   $0   $0   $0   $0
                                                          TOTAL (scheduled):          0        $0   $0   $0   $0   $0
Comments:




Project Budget Form Rev. 2.0, 09/07/2003                                         Page 2 of 7                        Print Date: 11/1/2011
Put your logo here                                                Project Budget Template                              Your Organization
                                                                                                                             Name Here



                                                        Expenditures Over Time

                           Project Name: 0
                        Project Manager: 0

 >Enter anticipated specific sources of cost, date of expenditure and reason
 >To add rows, unprotect sheet (Tools/Protection/Unprotect). Protect when done to safeguard data entry.
Item                                                   Date         Cost                      Reason for Expenditure
Initiation
                                                                     $0
                                                                     $0
                                                                     $0
                                                                     $0
                                                                     $0
                                                                     $0
                                        Subtotal              $               -
Planning (RFP)
                                                                     $0
                                                                     $0
                                                                     $0
                                                                     $0
                                                                     $0
                                                                     $0
                                        Subtotal              $               -




Template: Project Budget Template [Rev. 2.1 8-30-04]                       Page 3 of 7                                  Print Date: 11/1/2011
Put your logo here                                         Project Budget Template   Your Organization
                                                                                           Name Here
Planning 2
                                                              $0
                                                              $0
                                                              $0
                                                              $0
                                                              $0
                                                              $0
                                        Subtotal       $              -
Construction
                                                              $0
                                                              $0
                                                              $0
                                                              $0
                                                              $0
                                                              $0
                                        Subtotal       $              -
Test & Delivery
                                                              $0
                                                              $0
                                                              $0
                                                              $0
                                                              $0
                                                              $0
                                   Subtotal            $              -
                             PROJECT TOTAL             $              -




Template: Project Budget Template [Rev. 2.1 8-30-04]               Page 4 of 7        Print Date: 11/1/2011
Put your logo here                                                           Project Budget Template                                  Your Organization
                                                                                                                                            Name Here



                                                                         Cumulative Project Cost


Instructions:
To enter/edit data in the Cumulative Project Cost chart below:
 > Click on the Data Worksheet tab (bottom of page)
 > Enter new data / modify existing data into the Projected Monthly Cost and Actual Monthly Cost columns
 > Return to this worksheet to see the updated chart
 >The blue markers represent projected costs (baseline)
 > Red markers represent actual costs
 > This graph may be copied into a Word document

Click File/Save to save your changes.




                                                                             Cumulative Project Cost

                                                      $350
                               Cumulative Cost ($K)




                                                      $300
                                                      $250
                                                      $200                                                                  Series1
                                                      $150                                                                  Series2
                                                      $100
                                                      $50
                                                        $0
                                                             1   3   5   7     9     11     13    15    17   19   21   23
                                                                                   Month of Project




Template: Project Budget Template [Rel. 2.1 8-30-04]                                      Page 5 of 7                                  Print Date: 11/1/2011
Put your logo here                           Project Budget Template                       Your Organization
                                                                                                 Name Here



                                    Project Cumulative Cost Chart

Instructions:
 >Adjust number of rows to match duration of project
 > Delete dummy data (white cells)
 >Enter projected monthly costs into column B
 >Enter actual monthly costs into column D
 >Projected and Actual Cumulative Costs are calculated values.
 > Numbers entered here directly affect the chart on the Cumulative Project Cost tab

                           Projected Monthly   Projected             Actual Monthly    Actual Cumulative
  Month of Project                Cost       Cumulative Cost             Cost                 Cost
                       1                 $1               $1                      $2                  $2
                       2                 $3               $4                      $4                  $6
                       3                 $5               $9                      $6                $12
                       4                 $7              $16                      $8                $20
                       5                 $9              $25                     $12                $32
                       6                $11              $36                     $10                $42
                       7                $13              $49                     $15                $57
                       8                $15              $64                     $20                $77
                       9                $17              $81                     $14                $91
                      10                $19             $100                     $23               $114
                      11                $21             $121                     $26               $140
                      12                $23             $144                     $30               $170
                      13                $25             $169                     $17               $187
                      14                $23             $192                     $21               $208
                      15                $21             $213                     $10               $218
                      16                $19             $232                     $10               $228
                      17                $17             $249                     $12               $240
                      18                $15             $264                      $6               $246
                      19                $13             $277                     $27               $273
                      20                $11             $288                     $19               $292
                      21                 $9             $297                      $6               $298
                      22                 $7             $304                      $7               $305
                      23                 $5             $309                      $2               $307
                      24                 $3             $312                      $1               $308




Template: Project Budget Template [Rel. 2.1 8-30-04]   Page 6 of 7                          Print Date: 11/1/2011
Put your logo here                           Project Budget Template   Your Organization
                                                                             Name Here




Template: Project Budget Template [Rel. 2.1 8-30-04]   Page 7 of 7      Print Date: 11/1/2011
010
				
DOCUMENT INFO
Shared By:
Stats:
views:23388
posted:1/10/2008
language:English
pages:7
Description: This form provides a template spreadsheet to create a project budget. A project manager should list all of the tasks required for a certain project. This template breaks down project activities into these stages: product design, product development, product delivery, and product management. The project manager should then list the labor hours needed per and all other costs associated with a given task. This spreadsheet can also be used to calculate and record project expenditures over time and can further provide a graph of cumulative project cost.
This document is also part of a package IT Policies and Procedures 49 Documents Included