WBS & Budget
gd1222
BudgetMiaclass.docxAnnouncements - Project Budget (MS Excel) Heads-Up
Class,
Your course syllabus states the following requirement regarding your Week 2 project budget.
Using Microsoft Excel, create a time-phased project budget containing cost estimates. Include direct and indirect costs for labor, machinery, equipment, supplies, and other elements applicable to the project.
Unfortunately, none of our course readings for Week 1 or Week 2 covers this topic. With that in mind I am providing an example of time phased budgeting. Please make sure your Excel Spreadsheet budget attachment for Week 2 is in this format.
Time Phased (Project Lifecycle) Project Budget
|
|
Project Initiation |
Project Planning |
Project Execution |
Project Shutdown |
Category Expense Totals |
|
Expense Category 1 |
|||||
|
Expense 1 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
|
Expense 2 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
|
Expense 3 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
|
|
|
|
|
|
$ 0.0 |
|
Expense Category 2 |
|||||
|
Expense 1 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
|
Expense 2 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
|
Expense 3 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
|
|
|
|
|
|
$ 0.0 |
|
Expense Category 3 |
|||||
|
Expense 1 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
|
Expense 2 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
|
Expense 3 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
|
|
|
|
|
|
$ 0.0 |
|
Expense Category 4 |
|||||
|
|
|
|
|
|
|
|
Expense 1 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
|
Expense 2 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
|
Expense 3 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
$ 0.0 |
|
|
|
|
|
|
$ 0.0 |
|
|
Total Project Initiation Cost $ 0.0 |
Total Project Planning Cost $ 0.0 |
Total Project Execution Cost $ 0.0 |
Total Project Shutdown Cost $ 0.0 |
Total Project Cost $ 0.0 |
Projects costs are recorded in the Lifecycle Phase they are budgeted.
The advantage of this budget format is that it gives the finance department an accurate investment time line. Remember that project spending is not linear with most of the spending happening in the execution phase.
