Track Budget Cost and Budget Work
Browse Search
HOWTO: Track Budget Cost and Budget Work
Created on: 08-Dec-10. Print Article
Last Modified on: 04-Jan-11. Email Article
Skill Level: Beginner.
Article has been viewed: 960 times.
Rated: 3 out of 10 based on 1 vote.
KB.12603
APPLIES TO:

Project managers need to make sure that a project's scope, time and resources align with the project's budget. PM Central R2.0 allows project managers to create budget cost and budget work and compare the planned cost and work for the project.

This article contains the following sections:
Adding Budget Cost and Budget Work to the Project
About the Bamboo Budget Work Custom Column
About the Bamboo Budget Cost Custom Column

Adding Budget Cost and Budget Work to the Project
1) Navigate to the project site's Project Info section. Click the project name to go to the Project Health List.

go to the Project Health List

2) Use the ribbon to edit the list. Enter in the project's Budget Cost and Budget Work. Click OK.

enter the Budget Cost and Budget Work

3) Add tasks to the project in the Tasks > All Tasks tab and assign resources with their standard rate. Read
KB.12477: Using PM Central for SharePoint 2010 in 10 Steps for more information.

add tasks and resources

4) Go to the Progress Management tab and click Update Project Cost & Schedule. This updates the Project Duration, Project Cost and Project Work based on the tasks in the project.

update project cost and schedule

duration, cost and work are updated

5) Return to the Project Health List and view the key performance indicator (KPI) statuses for
Budget Cost and Budget Work. They are custom Bamboo KPI Columns used in PM Central.

view the KPI statuses

About the Bamboo Budget Work Status Custom Column

The Budget Work Status Column compares the value of the Budget Work to the Project Work. If your planned values are on track with the budget, then the green status indicator is displayed. If the planned values are more than the budget but are within a certain threshold that you can tolerate, then the yellow status indicator is displayed. If the planned values are more than the threshold, then the red status indicator is displayed as an alert. Use these status indicators to decide if you can tolerate being over budget, or readjust the schedule and resources so that you can stay within budget.

  • If Budget Work - Project Work is 0 or better, then the green KPI icon for Met Goal is displayed.
  • If Budget Work - Project Work is -1,000, where the Project Work will be larger than 0 and less than 1,000 hours in comparison to the Budget Work, then the yellow KPI icon for Warning is displayed.
  • If Budget Work - Project Work is more than 1,000 hours, then the red KPI icon for Over budget is displayed.

For example, if the budget work is 6,000 hours and the "planned" project work is 6,500 hours, then 6,000 - 6,500 = -500, meaning that the project work is 500 hours over budget. Because the value is between 0 and -1,000, the status is Warning.

Budget Work KPI values

These values can be configured to meet your organization's needs by navigating to the Project Health List's list settings. Under Columns, click Budget Work Status. Make your modifications under Additional Column Settings and click OK.

modify the columns

About the Bamboo Budget Cost Status Custom Column

The Budget Cost Status Column compares the value of the Budget Cost to the Project Work. If your planned values are on track with the budget, then the green status indicator is displayed. If the planned values are more than the budget but are within a certain threshold that you can tolerate, then the yellow status indicator is displayed. If the planned values are more than the threshold, then the red status indicator is displayed as an alert. Use these status indicators to decide if you can tolerate being over budget, or readjust the schedule and resources so that you can stay within budget.

  • If Budget Cost - Project Cost is 0 or better, then the green KPI icon for Met Goal is displayed.
  • If Budget Cost - Project Work is -10,000, where the Project Cost will be larger than 0 and less than $10,000 in comparison to the Budget Cost, then the yellow KPI icon for Warning is displayed.
  • If Budget Cost - Project Work is more than 10,000, then the red KPI icon for Over budget is displayed.

For example, if the budget cost is $50,000 and the "planned" project cost is $50,000, then $50,000 - $50,000 = 0. Because the value is 0 or better, the project is within budget, and the status is Met Goal.

However, if the budget cost is $50,000 and the "planned" project cost is $65,000, then $50,000 - $65,000 = -$15,000. Because the value is more than $10,000, the project is over budget, and the status is Over budget.

Budget Cost KPI values

These values can be configured to meet your organization's needs by navigating to the Project Health List's list settings. Under Columns, click Budget Cost Status. Make your modifications under Additional Column Settings and click OK.

modify the column

Related Articles
Q12477 - HOWTO: Use PM Central for SharePoint 2010 in 10 Steps

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help Us Improve This Article
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
   
Approved Comments
No user comments available for this article.