Download - Project Budget Planner
-
8/14/2019 Project Budget Planner
1/42
Project Budget PlannerYour Organizat
Name h
Project Budget Planner
GENERAL PROJECT INFORMATION
Project Name:
Project Manager:
12. Cost Curve worksheets have their own instructions.
Instructions:Follow the steps below to develop a baseline Project Budget. These worksheets are highly automated. Fill in worksheets sequentially fromleft to right, starting with this worksheet, to make best use of data automation features.
1. Enter general project information on the Instructions & Project Info tab
2. In the Labor Hrs Yeartab, enter the years in which the project will be implemented plus 5 years for maintenance and operations. Thenenter each role that will be needed in the project in the Labor and Contractor tables. Then enter the hours per year that each role will beneeded in each year.
3. In the Labor Hrs Costtab, enter the hourly rate for each project role. Project costs are calculated automatically.
4. In the Non-Labor Costs Yeartab, enter each item that will be purchased during the project in the appropriate category. Indicatenumber of items required and unit cost; total cost per item is calculated automatically. Enter years in which costs will be incurred, e.g. 2items may be purchased but in different years. Total costs per item and per year are calcuated for you.
5. In the Maint & Ops Yeartab, list all maintenance and operations items and then indicate their costs in the years in which they will beincurred.
6. The Cost Summary Yearworksheet automatically summarizes labor and non-labor budget details from other "Year" worksheets.
7. Enter the hours per phase for each project role in the Labor Hrs Phase worksheet. All other information is transferred automaticallyfrom prior worksheets.
8. The entire Labor Cost Phase worksheet is calculated automatically.
9. Enter the phase is which non-labor costs will be incurred in the Non Labor Costs Phase worksheet. All other information is transferredautomatically from prior worksheets.
10. The Cost Summary Phaseworksheet automatically summarizes labor and non-labor budget details from other "Year" worksheets.
11. Use the Cost Responsibilityworksheet to indicate the source of funding for each broad category of project expense. Enter FundCenters and percent of cost covered by each Fund Center. All other information is calculated automatically.
-
8/14/2019 Project Budget Planner
2/42
Project Budget PlannerYour Organization
Name here
Template: Project Budget Planner [Rel. 1.0 1/8/2006] Page 2 of 42 Print Date: 07/18/2009
You must have "Tools/Options/View/Comment Indicator Only" checked in order to see on-line help.
-
8/14/2019 Project Budget Planner
3/42
Project Budget PlannerProject Labor Hours
Project Labor Hours
Part 1. Employees
HOURS BY YEAR
Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7
1. Employee Role No. 1 0 0 0 0 0 0 0
2. Employee Role No. 2 0 0 0 0 0 0 0
3. Employee Role No. 3 0 0 0 0 0 0 0
4. Employee Role No. 4 0 0 0 0 0 0 0
5. Employee Role No. 5 0 0 0 0 0 0 0
6. Employee Role No. 6 0 0 0 0 0 0 0
7. Employee Role No. 7 0 0 0 0 0 0 0
8. Employee Role No. 8 0 0 0 0 0 0 0
9. Employee Role No. 9 0 0 0 0 0 0 0
10. Employee Role No. 10 0 0 0 0 0 0 0
11. Employee Role No. 11 0 0 0 0 0 0 0
12. Employee Role No. 12 0 0 0 0 0 0 0
Total Labor Hours 0 0 0 0 0 0 0
Do not delete o
Instructions - Part 1:Use the tables below to estimate the number of Hours per Year for each EMPLOYEE project role that will charge time to the project.Distribute hours for each role by Year of project. Only enter data in white cells; all color cells are automatically calculated.
LABOR RESOURCES(List by project role)
-
8/14/2019 Project Budget Planner
4/42
Project Budget PlannerProject Labor Hours
Part 2. Contractors
HOURS BY YEAR
Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7
1. Contract Role 1 0 0 0 0 0 0 0
2. Contract Role 2 0 0 0 0 0 0 0
3. Contract Role 3 0 0 0 0 0 0 0
4. Contract Role 4 0 0 0 0 0 0 0
5. Contract Role 5 0 0 0 0 0 0 0
6. Contract Role 6 0 0 0 0 0 0 0
7. Contract Role 7 0 0 0 0 0 0 0
8. Contract Role 8 0 0 0 0 0 0 0
9. Contract Role 9 0 0 0 0 0 0 0
10. Contract Role 10 0 0 0 0 0 0 0
11. Contract Role 11 0 0 0 0 0 0 0
12. Contract Role 12 0 0 0 0 0 0 0
Total Contract Labor 0 0 0 0 0 0 0
Do not delete o
Total Hours per Year 0 0 0 0 0 0 0
Instructions - Part 2:Use the worksheet below to estimate the number of Hours per Year for each CONTRACT project role that will charge time to theproject. Distribute hours for each role by Year of project.
LABOR RESOURCES(List by project role)
-
8/14/2019 Project Budget Planner
5/42
Project Budget PlannerProject Labor Costs
T l t P j t B d t Pl [R 1 0 1/8/2006] P 5 f 42
Project Labor Costs - Implementation
Part 1. Employee Labor
EMPLOYEE LABOR COST BY YEAR
Year 1 Year 2 Year 3 Year 4 Year 5 Year 6
1. Employee Role No. 1 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
2. Employee Role No. 2 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
3. Employee Role No. 3 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
4. Employee Role No. 4 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
5. Employee Role No. 5 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
6. Employee Role No. 6 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 7. Employee Role No. 7 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
8. Employee Role No. 8 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
9. Employee Role No. 9 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10. Employee Role No. 10 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
11. Employee Role No. 11 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
12. Employee Role No. 12 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Total Employee Labor Costs ===> $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Instructions - Part 1:Enter the Hourly Rate for each resource that will be used on the project. Labor Resources and Hours by Year are transferredautomatically from the Labor Hours worksheet. Yearly Costs and Total Costs are calculated automatically. Only enter data intowhite cells. Color cells are calculated automatically.
LABOR RESOURCES(List by project role)
HOURLYRATE
-
8/14/2019 Project Budget Planner
6/42
Project Budget PlannerProject Labor Costs
Part 2. Contractor Labor
CONTRACTOR LABOR COST BY YEAR
Year 1 Year 2 Year 3 Year 4 Year 5 Year 6
1. Contract Role 1 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
2. Contract Role 2 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
3. Contract Role 3 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
4. Contract Role 4 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
5. Contract Role 5 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
6. Contract Role 6 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
7. Contract Role 7 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
8. Contract Role 8 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
9. Contract Role 9 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 10. Contract Role 10 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
11. Contract Role 11 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
12. Contract Role 12 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Total Contractor Labor Costs ===> $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Total Project Labor Cost ===> $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Instructions - Part 2:Enter the Hourly Rate for each CONTRACT resource that will be used on the project. Labor Resources and Hours by Year will betransferred from the Labor Hours worksheet. Yearly Costs and Total Costs will be calculated automatically.
LABOR RESOURCES(List by project role)
HOURLYRATE
-
8/14/2019 Project Budget Planner
7/42
Project Budget PlannerProject Non-Labor Costs
Non-Labor Costs - Implementation
PR
NON-LABOR COST CATEGORY Quantity Year 1 Year 2 Year 3 Ye
1. 0 $- $0.00 $- $- $-
2. 0 $- $0.00 $- $- $-
3. 0 $- $0.00 $- $- $-
4. 0 $- $0.00 $- $- $-
5. 0 $- $0.00 $- $- $-
6. 0 $- $0.00 $- $- $-
7. 0 $- $0.00 $- $- $-
8. 0 $- $0.00 $- $- $-
9. 0 $- $0.00 $- $- $-
10. 0 $- $0.00 $- $- $- 11. 0 $- $0.00 $- $- $-
12. 0 $- $0.00 $- $- $-
13. 0 $- $0.00 $- $- $-
14. 0 $- $0.00 $- $- $-
15. 0 $- $0.00 $- $- $-
A. Subtotal, Hardware ===> $0.00 $0.00 $0.00
Instructions:Use this template to estimate a project's Non-Labor Costs. Category Subtotals and Total Costs are calculated automatically. Only enter data into white cellsautomatically. Change Non-Labor Cost Category names to suit your business.
>For each item, enter the quantity and unit cost. It is permissable to group like items (e.g. include 5 new widgets in one item line).>Item SubTotal 1 will show you the extended cost of that item.>Indicate in which year(s) the cost for each item will be incurred. For example, purchase 2 widgets during 2002 and 3 more during 2003.>Item SubTotal 2 will show you the extended cost of the item across years.>Item SubTotal 2 will turn redwhenever it does not match Item SubTotal 1 (scroll right to see Sub Total 2).
UnitCost
Item SubTotal1
A. Hardware (List new servers, storage devices, PC's, printers, peripherals, networkingequipment)
-
8/14/2019 Project Budget Planner
8/42
Project Budget PlannerProject Non-Labor Costs
1. 0 $- $0.00 $- $- $-
2. 0 $- $0.00 $- $- $-
3. 0 $- $0.00 $- $- $-
4. 0 $- $0.00 $- $- $-
5. 0 $- $0.00 $- $- $-
6. 0 $- $0.00 $- $- $-
7. 0 $- $0.00 $- $- $-
8. 0 $- $0.00 $- $- $-
9. 0 $- $0.00 $- $- $-
10. 0 $- $0.00 $- $- $-
11. 0 $- $0.00 $- $- $-
12. 0 $- $0.00 $- $- $-
13. 0 $- $0.00 $- $- $-
14. 0 $- $0.00 $- $- $-
15. 0 $- $0.00 $- $- $-
C. Subtotal, Enterprise / Hosting Costs ===> $0.00 $0.00 $0.00
1. 0 $- $0.00 $- $- $-
2. 0 $- $0.00 $- $- $-
3. 0 $- $0.00 $- $- $-
4. 0 $- $0.00 $- $- $-
5. 0 $- $0.00 $- $- $-
6. 0 $- $0.00 $- $- $-
7. 0 $- $0.00 $- $- $- 8. 0 $- $0.00 $- $- $-
9. 0 $- $0.00 $- $- $-
10. 0 $- $0.00 $- $- $-
11. 0 $- $0.00 $- $- $-
12. 0 $- $0.00 $- $- $-
13 0 $- $0 00 $- $- $-
C. Enterprise and Hosting Costs (List any applicable costs for CPU or transaction usage,application hosting, enterprise system maintenance and support, etc.)
D. Travel (List estimated cost for Employee or Contractor travel, including airfare, groundtransportation, lodging, conference fees, etc.)
-
8/14/2019 Project Budget Planner
9/42
Project Budget PlannerProject Non-Labor Costs
1. 0 $- $0.00 $- $- $-
2. 0 $- $0.00 $- $- $-
3. 0 $- $0.00 $- $- $-
4. 0 $- $0.00 $- $- $-
5. 0 $- $0.00 $- $- $-
6. 0 $- $0.00 $- $- $-
7. 0 $- $0.00 $- $- $-
8. 0 $- $0.00 $- $- $-
9. 0 $- $0.00 $- $- $-
10. 0 $- $0.00 $- $- $-
11. 0 $- $0.00 $- $- $-
12. 0 $- $0.00 $- $- $-
13. 0 $- $0.00 $- $- $-
14. 0 $- $0.00 $- $- $-
15. 0 $- $0.00 $- $- $-
E. Subtotal, Facilities
===>$0.00 $0.00 $0.00
1. 0 $- $0.00 $- $- $-
2. 0 $- $0.00 $- $- $-
3. 0 $- $0.00 $- $- $-
4. 0 $- $0.00 $- $- $-
5. 0 $- $0.00 $- $- $-
6. 0 $- $0.00 $- $- $-
7.0 $- $0.00 $- $- $-
8. 0 $- $0.00 $- $- $-
9. 0 $- $0.00 $- $- $-
10. 0 $- $0.00 $- $- $-
11. 0 $- $0.00 $- $- $-
12. 0 $- $0.00 $- $- $-
13. 0 $- $0.00 $- $- $-
E. Facilities (List leases, utilities, telecommunications and other related facility expenses)
F. Miscellaneous Implementation Cost (List printing and copying, office supplies, trainingexpenses and other miscellaneous costs not categorized elsewhere)
-
8/14/2019 Project Budget Planner
10/42
Project Budget PlannerProject Non-Labor Costs
Item SubTotal 2
$0.00
$0.00$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00$0.00
$0.00
$0.00
-
8/14/2019 Project Budget Planner
11/42
Project Budget PlannerProject Non-Labor Costs
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00$0.00
$0.00
$0.00
$0.00
$0.00
-
8/14/2019 Project Budget Planner
12/42
Project Budget PlannerProject Non-Labor Costs
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00$0.00
$0.00
$0.00
$0.00
$0.00
-
8/14/2019 Project Budget Planner
13/42
Project Budget PlannerMaintenance and Operatio
5 Years Maintenance & Operations
Maintenance & Operations Cost Category Quantity Year 1 Year 2 Yea
A. Maintenance
1. 0 $- $0.00 $- $- 2. 0 $- $0.00 $- $-
3. 0 $- $0.00 $- $-
4. 0 $- $0.00 $- $-
5. 0 $- $0.00 $- $-
6. 0 $- $0.00 $- $-
7. 0 $- $0.00 $- $-
8. 0 $- $0.00 $- $-
9. 0 $- $0.00 $- $-
10. 0 $- $0.00 $- $-
11. 0 $- $0.00 $- $- 12. 0 $- $0.00 $- $-
13. 0 $- $0.00 $- $-
14. 0 $- $0.00 $- $-
15. 0 $- $0.00 $- $-
A. Subtotal Maintenance ===> $0.00 $0.00 $0
Instructions:Use this template to estimate a project's 5 years Operation & Maintenance Costs. Total Costs are calculated automatically. Only enter data inautomatically.
>For each item, enter the quantity and unit cost. It is permissable to group like items (e.g. include 5 equipment upgrades in one item line).>Item SubTotal 1 will show you the extended cost of that item.>Indicate in which year(s) the cost for each will occur>Item SubTotal 2 will turn redwhenever it does not match Item SubTotal 1. (Scroll right to see SubTotal 2)
UnitCost
Item SubTotal1
-
8/14/2019 Project Budget Planner
14/42
Project Budget PlannerMaintenance and Operations
Item SubTotal 2
$0.00
$0.00
$0.00$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00$0.00
$0.00
$0.00
-
8/14/2019 Project Budget Planner
15/42
Project Budget Planner
Template: Project Budget Planner [Rev. 1.0 1/8/2006] Page 15 of 42
Project Annual Budget Summary
Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7
LABOR HOURS
Employee 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Contractor 0.0 0.0 0.0 0.0 0.0 0.0 0.0
Labor Hour Totals 0.0 0.0 0.0 0.0 0.0 0.0 0.0
LABOR COSTS
Employee $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Contractor $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Labor Cost Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Non-Labor Cost Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Maint & Operations
Maintenance $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Operations $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Total Maint & Ops $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL COSTS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Instructions:DO NOT ENTER DATA INTO THIS TABLE.
These data summarize the preceding worksheets.
-
8/14/2019 Project Budget Planner
16/42
Project Budget PlannerProject Labor Hours
Your OrganizationName here
Project Labor Hours
Part 1. Employee Labor
HOURS BY PHASE
1. Employee Role No. 1 0 0 0 0 0 0
2. Employee Role No. 2 0 0 0 0 0 0
3. Employee Role No. 3 0 0 0 0 0 0
4. Employee Role No. 4 0 0 0 0 0 0
5. Employee Role No. 5 0 0 0 0 0 0
6. Employee Role No. 6 0 0 0 0 0 0
7. Employee Role No. 7 0 0 0 0 0 0
8. Employee Role No. 8 0 0 0 0 0 0
9. Employee Role No. 9 0 0 0 0 0 0
10. Employee Role No. 10 0 0 0 0 0 0
11. Employee Role No. 11 0 0 0 0 0 0
12. Employee Role No. 12 0 0 0 0 0 0
Total Employee Labor 0 0 0 0 0 0
Do not delete or change this cell 0.0
Instructions - Part 1:Use the tables below to estimate the number of Hours by Phase for each employee who will charge time to the project. Distribute hoursfor each resource by project phase. Only enter data into white cells. Color cells are calculated automatically.
LABOR RESOURCES
(List by name or title)
Initiation
Phase
Planning
Phase
Execution
Phase
Implementation
Phase
Closing
Phase
TOTAL
HOURS
-
8/14/2019 Project Budget Planner
17/42
Project Budget PlannerProject Labor Hours
Your OrganizationName here
Part 2. Contractor Labor
HOURS BY PHASE
1. Contract Role 1 0 0 0 0 0 0
2. Contract Role 2 0 0 0 0 0 0
3. Contract Role 3 0 0 0 0 0 0
4. Contract Role 4 0 0 0 0 0 0
5. Contract Role 5 0 0 0 0 0 0
6. Contract Role 6 0 0 0 0 0 0
7. Contract Role 7 0 0 0 0 0 0
8. Contract Role 8 0 0 0 0 0 0
9. Contract Role 9 0 0 0 0 0 0
10. Contract Role 10 0 0 0 0 0 011. Contract Role 11 0 0 0 0 0 0
12. Contract Role 12 0 0 0 0 0 0
Total Contractor Labor 0 0 0 0 0 0
Do not delete or change this cell 0.0
Total Hours per Phase 0 0 0 0 0
Instructions - Part 2:Use the worksheet below to estimate the number of Hours by Phase for each CONTRACT employee who will charge time to theproject.
LABOR RESOURCES(List by name or title)
InitiationPhase
PlanningPhase
ExecutionPhase
ImplementationPhase
ClosingPhase
TOTALHOURS
-
8/14/2019 Project Budget Planner
18/42
Project Budget PlannerProject Labor Hours
Your OrganizationName here
Template: Project Budget Planner [Rev. 1.0 1/8/2006] Page 18 of 42 Print Date: 07/18/2009
0
0
0
0
0
0
0
0
0
0
0
0
Total hours from theLabor Hrs Year
worksheet
-
8/14/2019 Project Budget Planner
19/42
Project Budget PlannerProject Labor Hours
Your OrganizationName here
Template: Project Budget Planner [Rev. 1.0 1/8/2006] Page 19 of 42 Print Date: 07/18/2009
0
0
0
0
0
0
0
0
0
0
0
0
-
8/14/2019 Project Budget Planner
20/42
Project Budget PlannerProject Labor Costs
Your OrganizatioName her
Project Labor Costs
Part 1. Employee Labor
NCDOT IT LABOR COST BY PHASE
1. Employee Role No. 1 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
2. Employee Role No. 2 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
3. Employee Role No. 3 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
4. Employee Role No. 4 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
5. Employee Role No. 5 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
6. Employee Role No. 6 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
7. Employee Role No. 7 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
8. Employee Role No. 8 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
9. Employee Role No. 9 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10. Employee Role No. 10 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
11. Employee Role No. 11 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
12. Employee Role No. 12 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Total Employee Labor Costs ===> $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Do not delete or change this cell 0.0
InstructionsAll data on this worksheet are calculated automatically.
LABOR RESOURCES
(List by name or title)
HOURLY
RATE
Initiation
Phase
Planning
Phase Execution Phase
Implementation
Phase
Closing
Phase
TOTAL
COST
-
8/14/2019 Project Budget Planner
21/42
Project Budget PlannerProject Labor Costs
Your OrganizatioName he
Part 2. Contractor Labor
CONTRACT LABOR COST BY PHASE
LABOR RESOURCES
1. Contract Role 1 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
2. Contract Role 2 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
3. Contract Role 3 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.004. Contract Role 4 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
5. Contract Role 5 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
6. Contract Role 6 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
7. Contract Role 7 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
8. Contract Role 8 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
9. Contract Role 9 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
10. Contract Role 10 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
11. Contract Role 11 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
12. Contract Role 12 $- $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Total Contractor Cost ===> $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Do not delete or change this cell 0.0
HOURLYRATE
InitiationPhase
PlanningPhase
Execution PhaseImplementation
PhaseClosingPhase
TOTALHOURS
-
8/14/2019 Project Budget Planner
22/42
Project Budget PlannerNon-Labor Costs
Non-Labor Costs
COST BY PROJECT PHAS
NON-LABOR COST CATEGORY Quantity
1. 0 0 0 $0.00 $- $-
2. 0 0 0 $0.00 $- $-
3. 0 0 0 $0.00 $- $-
4. 0 0 0 $0.00 $- $-
5. 0 0 0 $0.00 $- $-
6. 0 0 0 $0.00 $- $- 7. 0 0 0 $0.00 $- $-
8. 0 0 0 $0.00 $- $-
9. 0 0 0 $0.00 $- $-
10. 0 0 0 $0.00 $- $-
11. 0 0 0 $0.00 $- $-
12. 0 0 0 $0.00 $- $-
13. 0 0 0 $0.00 $- $-
14. 0 0 0 $0.00 $- $-
15. 0 0 0 $0.00 $- $-
A. Subtotal, Hardware ===> $0.00 $0.00 $0.00
1. 0 0 0 $0.00 $- $-
2. 0 0 0 $0.00 $- $-
3 0 0 0 $0 00 $- $-
Instructions:Use this template to estimate a project's Non-Labor Costs by Project Phase. Only enter data into white cells. Category Subtotals and Total Costs ar
>Indicate in which phase(s) the cost for that item will be incurred. For example, purchase 2 widgets during Planning, 3 during Execution.>Item SubTotal 2 will show you the extended cost of the item across phases.>Change Non-Labor Cost Categor names to suit your business.>Item SubTotal 2 will turn redwhenever it does not match Item SubTotal 1.
UnitCost
Item SubTotal1 Planning
PhaseExecution
PhaseImplementa
PhaseA. Hardware (List new servers, storage devices, PC's, printers, peripherals, networkingequipment)
B. Software/Middleware (List new application tools & licenses required for development andimplementation)
-
8/14/2019 Project Budget Planner
23/42
Project Budget PlannerNon-Labor Costs
1. 0 0 0 $0.00 $- $-
2. 0 0 0 $0.00 $- $-
3. 0 0 0 $0.00 $- $-
4. 0 0 0 $0.00 $- $-
5. 0 0 0 $0.00 $- $-
6. 0 0 0 $0.00 $- $-
7. 0 0 0 $0.00 $- $-
8. 0 0 0 $0.00 $- $-
9. 0 0 0 $0.00 $- $-
10. 0 0 0 $0.00 $- $-
11. 0 0 0 $0.00 $- $-
12. 0 0 0 $0.00 $- $-
13. 0 0 0 $0.00 $- $-
14. 0 0 0 $0.00 $- $-
15. 0 0 0 $0.00 $- $-
C. Subtotal, Enterprise & Hosting Costs ===> $0.00 $0.00 $0.0
1. 0 0 0 $0.00 $- $-
2. 0 0 0 $0.00 $- $-
3. 0 0 0 $0.00 $- $-
4. 0 0 0 $0.00 $- $-
5. 0 0 0 $0.00 $- $-
6. 0 0 0 $0.00 $- $-
7. 0 0 0 $0.00 $- $-
8. 0 0 0 $0.00 $- $-
9. 0 0 0 $0.00 $- $-
10. 0 0 0 $0.00 $- $-
11. 0 0 0 $0.00 $- $-
12. 0 0 0 $0.00 $- $-
13. 0 0 0 $0.00 $- $-
14. 0 0 0 $0.00 $- $-
15. 0 0 0 $0.00 $- $-
D Subtotal Travel ===> $0 00 $0 00 $0 0
C. Enterprise and Hosting Costs (List any applicable costs for CPU or transaction usage,
application hosting, enterprise system maintenance and support, etc.)
D. Travel (List estimated cost for Employee or Contractor travel, including airfare, groundtransportation, lodging, conference fees, etc.)
-
8/14/2019 Project Budget Planner
24/42
-
8/14/2019 Project Budget Planner
25/42
Project Budget PlannerNon-Labor Costs
000000000
000000
00
0000000
Total non-Laborcosts from the Non-
Labor Cost Yearworksheet
-
8/14/2019 Project Budget Planner
26/42
Project Budget PlannerNon-Labor Costs
000000000000
000
00000
0000000000
-
8/14/2019 Project Budget Planner
27/42
Project Budget PlannerNon-Labor Costs
000000000000
000
0000
00000
000000
or change this cell 0.0
P j t B d t Pl
-
8/14/2019 Project Budget Planner
28/42
Project Budget PlannerProject Phase Budget Summary
Your OrganizationName here
Template: Project Budget Planner [Rev. 1.0 1/8/2006] Page 28 of 42 Print Date: 07/18/2009
Project Phase Budget Summary
Execution Phase TOTALS
LABOR HOURS
Employee 0.0 0.0 0.0 0.0 0.0 0.0
Contractor 0.0 0.0 0.0 0.0 0.0 0.0
Labor Hour Totals 0.0 0.0 0.0 0.0 0.0 0.0
LABOR COSTS
Employee $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Contractor $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Labor Cost Totals $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Non-Labor Cost Totals N/A $0.00 $0.00 $0.00 $0.00 $0.00
TOTAL COSTS $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Instructions:DO NOT ENTER DATA INTO THIS TABLE.These data summarize the preceding worksheets. Note: There are no Maintenance & Ops Costs included in this worksheet.
InitiationPhase
PlanningPhase
ImplementationPhase
ClosingPhase
-
8/14/2019 Project Budget Planner
29/42
Project Budget PlannerProject Cost Responsibility
Project Cost Responsibility
Instructions:For each source of project-implementation cost (e.g. Non-Labor Cost), enter the Funding Center (e.g. Cost Center - across the top only) that will fund the cost and then e
percent that it will cover. Example: Cost Center 1 might cover 40% of Non-Labor Costs,and Cost Center 2 cover 60%.
>Enter data only in white cells. Color cells are calculated automatically.>Scroll to right to see error checking in "Total Percent" column
-
8/14/2019 Project Budget Planner
30/42
Project Budget PlannerProject Cost Responsibility
Percent of Costs per Funding Center
Source of Cost
Employee Labor Cost$0.00 0% 0% 0% 0% 0%
Employee Labor $ per Cost Center ===>$0 $0 $0 $0 $0 $
Contractor Labor Cost $0.00 0% 0% 0% 0% 0%
Contractor Labor $ per Cost Center ===> $0 $0 $0 $0 $0 $
Non-Labor Cost$0.00 0% 0% 0% 0% 0%
Non-Labor $ per Cost Center ===>$0 $0 $0 $0 $0 $
Maintenance & Operations Cost$0.00 0% 0% 0% 0% 0%
Maintenance & Ops $ per Cost Center ===>
$0 $0 $0 $0 $0 $
Summary
Total Project-Implementation Costs $0.00
Project-Implementation $ per Cost Center ===> $0 $0 $0 $0 $0 $
Project-Implementation % per Cost Center ===> 0.0% 0.0% 0.0% 0.0% 0.0% 0
Total Maintenance & Ops Costs $0.00
Maintenance & Ops $ per Cost Center ===> $0 $0 $0 $0 $0 $
M i t & O % C t C t > 0 0% 0 0% 0 0% 0 0% 0 0% 0
ProjectExpense
Cost Center /Internal Order/
WBS 1
Cost Center /Internal Order/
WBS 2
Cost Center /Internal Order/
WBS 3
Cost Center /Internal Order/
WBS 4
Cost Center /Internal Order/
WBS 5
Cost CInterna
WB
Total ProjectExpense Cost Center /
Internal Order/WBS 1
Cost Center /Internal Order/
WBS 2
Cost Center /Internal Order/
WBS 3
Cost Center /Internal Order/
WBS 4
Cost Center /Internal Order/
WBS 5
Cost CInterna
WB
P j t B d t Pl Y O
-
8/14/2019 Project Budget Planner
31/42
Project Budget PlannerProject Cost Responsibility
Your OrgaNam
Project Budget Planner Y O
-
8/14/2019 Project Budget Planner
32/42
Project Budget PlannerProject Cost Responsibility
Your OrgaNa
otal Percent
0%
$0
0%
$0
0%
$0
0%
$0
C l ti C t C D tYour Organization
-
8/14/2019 Project Budget Planner
33/42
Cumulative Cost Curve DataYour Organization
Name here
Template: Project Budget Planner [Rev 1 0 1/8/2006] Page 33 of 42 Print Date: 07/18/2009
Project Name:
Reporting Periods: 7/05 8/05 9/05 10/05 11/05 5/06
Planned Phase Costs
Initiation $0 $5,000
Planning $0 $5,000 >
Execution $0
Implement $0
Close $0
Project Total Planned Cost: $0 Time unit of project: Months
$0 $5,000 $5,000 $0 $0 $0 $0 $0 $0 $0 $0
Cumulative Plan Cost: $0 $5,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Actual Cost:
Cumulative Actual Cost: $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Instructions:
Before you enter any data, do the following:- Use prior worksheets to determine the total cost of each project phase- Determine the number of reporting periods that each project phase will last (e.g. 3 months)
Budgeted Cost per
Reporting Period:
Cumulative Cost Curve DataYour Organization
-
8/14/2019 Project Budget Planner
34/42
Cumulative Cost Curve Datag
Name here
Template: Project Budget Planner [Rev. 1.0 1/8/2006] Page 34 of 42 Print Date: 07/18/2009
- Determine (or guestimate) the dollar cost that will occur during each reporting period for each phase
To enter planned project values (note: all data entry cells are white):
1. Enter reporting periods in cells D4 through AA4 (e.g. weeks, months or quarters as dates (shown) or month1, month2, etc.)
4. Enter time unit of the project. This is "Months" in the example. This is used as a label on the chart.5. Planned cost per reporting period displays in the 'Budgeted Cost per Reporting Period" line6. Planned Cumulative Cost displays in the "Cumulative Planned Cost" line7. Enter Actual Costs per reporting period as the data become available. The cumulative actual cost will display in the
When should you use this template:- Use this template when you need a Cumulative Cost Curve and you have a good idea of how your costs will be broken
out over the course of your project.
2. Cost of each project phase under Planned Phase Costs is entered automatically from Cost Summary Phase tab
3. Enter the phase cost planned for each Reporting Period in the white cells provided. (see Initiation and Planning for anexample of how this is done). Leave unused cells blank for white cell or 0 for color cell.
Planned Phase Cost will be red until the total cost for all reporting periods in a phase equals the planned phase cost in the CostSummary Phase tab.
Cumulative Actual Cost line. It is normal for the last correct cumulative cost figure to repeat through all succeedingmonths. Do NOT delete these numbers!
8. Modify the graph in the Cost Curve Graph tab as explained on that sheet
- This template is useful for projects that last between 4 and 24 reporting periods and where dol lar estimates of costper reporting period are available.
- See companion document "CumulativeCostCurve_Dollars_SampleData.xls" to see what a c ompleted project lookslike.
C l ti C t C D tYour Organ
-
8/14/2019 Project Budget Planner
35/42
Cumulative Cost Curve DataYour Organ
Nam
6/06 7/06 8/06 9/06 10/06 11/06 12/06 1/07 2/07 3/07 4/07 5/07 6/0
Do not change this cell 0
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $
$10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $
Cumulative Cost Curve DataYour Organization
N h
-
8/14/2019 Project Budget Planner
36/42
Cumulative Cost Curve DataName here
Template: Project Budget Planner [Rev. 1.0 1/8/2006] Page 36 of 42 Print Date: 07/18/2009
Cumulative Cost CurveYour Organization
Name here
-
8/14/2019 Project Budget Planner
37/42
Name here
Template: Project Budget Planner [Rev. 1.0 1/8/2006] Page 37 of 42 Print Date: 07/18/2009
Initial Setup
For example, if your project will last 12 months you will have planned data in columns D through O, so the value for Raw Data should
Once you have entered all of your Planned data in the Cost Curve Data tab, do the following:
- Click once on the chart to select it and then click Chart on the toolbar
- Click Source Data and then Series
- Click Budgeted Cost and then in the Values box change "Raw data" to inlcude only the columns in which you have entered planning data.
Column D Column E Column F Column G Column H$0
$1,000
$2,000
$3,000
$4,000
$5,000
$6,000
$7,000
$8,000
$9,000
$10,000
Row 22
Row 27
Months
CumulativeCost
Cumulative Cost CurveYour Organization
Name here
-
8/14/2019 Project Budget Planner
38/42
Name here
Template: Project Budget Planner [Rev. 1.0 1/8/2006] Page 38 of 42 Print Date: 07/18/2009
be ='Raw Data'!$D$26:$O$26
Adding Actual Cost Data
the example we have Actual data for 3 months, so the last Actual data is in Column F. The value for Raw Data shouldbe ='Raw Data'!$D$30:$F$30
As you add Actual Cost values, click once on the chart and then click Chart on the toolbar
- Click Source Data and then Series
- Click Actual Cost and then in the Values box change "Raw data" to inlcude the latest column in which you have Actual Cost data. In this-
Note: this chart is easily added to a Word document. Just click on the chart, right click and Copy, then Paste into the Word document.
Cumulative Cost CurveYour Organization
Name here
-
8/14/2019 Project Budget Planner
39/42
Name here
Template: Project Budget Planner [Rev. 1.0 1/8/2006] Page 39 of 42 Print Date: 07/18/2009
Cumulative Cost CurveYour Organization
Name here
-
8/14/2019 Project Budget Planner
40/42
Name here
Template: Project Budget Planner [Rev. 1.0 1/8/2006] Page 40 of 42 Print Date: 07/18/2009
-
8/14/2019 Project Budget Planner
41/42
Cost Curve Data Tab
Instructions:Before you enter any data, do the following:
- Use prior worksheets to determine the total cost of each project phase
- Determine the number of reporting periods that each project phase will last (e.g. 3 months)- Determine (or guestimate) the dollar cost that will occur during each reporting period for each phase
To enter planned project values (note: all data entry cells are white):
1. Enter reporting periods in cells D4 through AA4 (e.g. weeks, months or quarters as dates (shown) or month1, month2, etc.)
4. Enter time unit of the project. This is "Months" in the example. This is used as a label on the chart.5. Planned cost per reporting period displays in the 'Budgeted Cost per Reporting Period" line6. Planned Cumulative Cost displays in the "Cumulative Planned Cost" line7. Enter Actual Costs per reporting period as the data become available. The cumulative actual cost will display in the
When should you use this template:- Use this template when you need a Cumulative Cost Curve and you have a good idea of how your costs will be broken
out over the course of your project.
- See companion document "CumulativeCostCurve_Dollars_SampleData.xls" to see what a completed project looks like.
2. Cost of each project phase under Planned Phase Costs is entered automatically from Cost Summary Phase tab
3. Enter the phase cost planned for each Reporting Period in the white cells provided. (see Initiation and Planning for an example ofhow this is done). Leave unused cells blank for white cell or 0 for color cell.
Planned Phase Cost will be red until the total cost for all reporting periods in a phase equals the planned phase cost in the CostSummary Phase tab.
Cumulative Actual Cost line. It is normal for the last correct cumulative cost figure to repeat through all succeeding months. DoNOT delete these numbers!
8. Modify the graph in the Cost Curve Graph tab as explained on that sheet
- This template is useful for projects that last between 4 and 24 reporting periods and where dollar estimates of cost perreporting period are available.
-
8/14/2019 Project Budget Planner
42/42
Cost Curve Graph tab
Initial Setup
Once you have entered all of your Planned data in the Raw Data tab, do the following:
For example, if your project will last 12 months you will have planned data in columns D through O, so the value for Raw Data shouldbe ='Raw Data'!$D$26:$O$26
Adding Actual Cost Data
the example we have Actual data for 3 months, so the last Actual data is in Column F. The value for Raw Data shouldbe ='Raw Data'!$D$30:$F$30
- Click once on the chart to select it and then click Chart on the toolbar
- Click Source Data and then Series- Click Budgeted Cost and then in the Values box change "Raw data" to inlcude only the columns in which you have entered planning data.
As you add Actual Cost values, click once on the chart and then click Chart on the toolbar
- Click Source Data and then Series-
Note: this chart is easily added to a Word document. Just click on the chart, right click and Copy, then Paste into the Word document.