This video show how to create a custom field in Microsoft Project to manage overhead cost rates. This information could then be used at a cost-reporting level, in manual or calculated methods.
- Sometimes in your organization you need to have…an overhead rate for a given resource.…Now to do that, we'll create…a new column on the Resource sheet,…so we're going to go to the Resource Sheet view…in Microsoft Project.…And on the Resource Sheet view,…as you recall, we have all our resources entered in.…I want to create a Rate column that's an overhead rate,…so I'm going to right-click on my Overtime column…and Insert a new column,…and I'm going to call it,…since it's going to be a cost column,…we'll select Cost,…and I'll use Cost2 as my overhead rate function.…
And I'll right-click on it and rename it…into Overhead Rate, and press OK.…Now I can put in the values…for that particular resource's overhead rate…into that column.…Now, you could also use this as a calculation,…if you wanted to create a multiplier field,…and then calculate your overhead rate…based on that multiplier,…you would just go through the process…of creating a multiplier number column…and creating a formula that would do that…from the standard rate.…
Note: This course was designed in collaboration with author Bonnie Biafore.
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Setting up budget resource costs
- Setting up rate tables
- Creating budget resources
- Entering values for budget cost and work and expense resources
- Comparing costs to budget values
- Reviewing costs
- Managing and reducing project costs
- Adding actual costs