Project Budget Template
Project Name: Alpha Omega
Department: Marketing
Supervisor Name: Oliver Jones
Planned Labor
Hours Actual Hours
WBS Project Tasks Assigned To:
1.0 Task Dave Johnson 8.0 8.0
2.0 Task Sarah Goldman 8.0 8.0
3.0 Task Melissa Shaw
3.1 SubTask
3.2 SubTask
3.3 SubTask
3.4 SubTask
4.0 Task
5.0 Task
SUBTOTAL
Materials
$/HR UNITS $/UNITS Travel Equipment Fixed Misc.
$30.00 100.0 $5.00 $50.00
$15.00 30.0 $100.00
50.0 $11.00
$360.00 $1,050.00 30.0 $150.00 0.0
BALANCE
BUDGETED ACTUAL UNDER/OVER
$ 700.00 $ 1,590.00 $ (890.00)
300.00 790.00 (490.00)
300.00 250.00 50.00
100.00 550.00 (450.00)
- - -
- - -
- - -
- - -
- - -
- - -
700.00 $1,590.00 (890.00)
Introduction
Use this project budget template to track all of your project expenses at a task level. Simply enter
data into the fields, and your over/under will be automatically calculated. Remember, a successful
project is one that comes in under budget.
Definition of Terms
WBS: Work breakdown structure lets you see the hierarchy of tasks as a number
Task: Enter the name of the task being worked on.
Assigned To: Who is responsible for the task
Planned HR: Enter the number of hours you expect the task to take.
Actual HR: Enter the number of billable hours the work actuallty took.
Labor $/HR: Enter how much money per hour that labor cost you.
Materials UNITS: Enter how many units of material you needed to complete the task.
Materials $/UNITS: Enter how much money each unit cost.
Travel: Enter the total travel expenses.
EQUP/SPACE: Enter how much your equipment or office space costs.
FIXED: Enter any costs that are fixed and unchanging.
MISC: Enter any other known costs.
BUDGET: Enter your budget for the task.
ACTUAL: This field will be automatically calculated based on the other costs entered in the row.
UNDER/OVER: This will be automatically calculated based on the budget vs actual fields.
SUBTOTAL: This row sums all the rows above it to give you a subtotal for the project.
