Project Management

How to handle resource costs in Microsoft Project 2013

From the The Money Files Blog
by
A blog that looks at all aspects of project and program finances from budgets, estimating and accounting to getting a pay rise and managing contracts. Written by Elizabeth Harrin from RebelsGuideToPM.com.

About this Blog

RSS

Recent Posts

How to learn AI the sensible way

Making sense of project cost reports

How real PM mentoring actually works

The Accidental Product Manager: What project managers need to know

How healthy are your project finances?

Categories

accounting, agile, ai, appraisals, Artificial Intelligence, audit, Backlog, Benchmarking, benefits, Benefits Management, Benefits Realization, Bias, books, budget, Business Case, business case, business case, Career Development, Career Development, carnival, case study, Change Management, checklist, collaboration tools, communication, Communications Management, competition, complex projects, Conferences, config management, consultancy, contingency, contracts, corporate finance, corporate finance, cost, Cost Management, cost management, credit crunch, CRM, data, data security, debate, Decision Making, delegating, digite, earned value, Education, Energy and Utilities, Estimating, events, FAQ, financial management, financial management, forecasting, future, GDPR, general, Goals, Governance, green, Information Technology, Innovation, insurance, interviews, it, Knowledge Management, Leadership, Lessons Learned, measuring performance, Mentoring, merger, methods, metrics, multiple projects, negotiating, Networking, news, Olympics, organization, Organizational Culture, outsourcing, personal finance, Planning, pmi, PMO, PMO, Portfolio Management, portfolio management, presentations, privacy policy, process, procurement, product management, productivity, Program Management, project closure, project data, project delivery, Project Success, project testing, prototyping, qualifications, Quality, quality, Quarterly Review, records, recruitment, reports, requirements, research, resilience, Resource Management, resources, risk, Risk Management, ROI, salaries, Schedule Management, Scheduling, scope, Scope Management, security, small projects, Social Impact, social impact, social media, software, software, software, Stakeholder Management, stakeholders, Strategy, success factors, supplier management, team, Teams, testing, testing, timesheets, tips, training, transparency, trends, value management, vendors, video, virtual teams, workflow

Date

linkedin twitter facebook Request to reuse this  

Categories: resources, software


Microsoft Project 2013 gives you a number of ways for handling resource costs including standard rate, overtime rate, cost per use and another field to let you accrue resources at a cost. Let’s take a look at these and see when you might want to use them.

Standard Rate

If you use resource costs in Microsoft Project at all, this is the cost field that you will find the most useful. It’s, as you would expect, the normal pay rate for someone or something over a time period. For people, Project will default to a per hourly rate but you can use a different unit of time if you want – just change the setting. Or you can work out their hourly rate based on their monthly or weekly rate and enter that if you want to keep everyone standard by calculating hourly rates for all your resources.

Non-people resources are not calculated on an hourly rate. Instead, they are worked out by price per unit. You’ll have to work out what units you want to use. Use the Material Label field to record what unit you have set. For example, if you are hiring a software testing lab at $1500 per day, you can use the Material Label field to record ‘daily lab fees’. Then Project does the calculation for you – quantity multiplied by standard rate.

Cost per use

Only use this if you have certain resources where you only pay each time you use the resource, and it’s a flat fee. An example would be a call out fee for a plumber for your new office conversion. Each time you call on the plumber, Project will calculate the hourly rate plus the call out fee. You can also use this for delivery charges.

Overtime Rate

Another field that does exactly what it says, but it doesn’t apply to non-people resources. Leave it blank unless you pay your team members overtime for hours worked above and beyond their contracted hours. If you do want to use the overtime function, you’ll have to assign overtime hours to the resource, otherwise Project will assume they are either salaried and don’t get any extra payments or that they earn the same amount regardless of how many hours they work.

Of course, you don’t have to use Project to calculate overtime payments for your team, and it can get quite complicated to keep on top of what’s an overtime hour assignment and what’s normal working time. But if you are expecting Project to calculate your total project budget for you, you’ll need to make time to record all this data otherwise your expense figures will be out.

Accrue At

This field is only useful if you are bothered about when the money is spent. On many projects, this won’t make any difference at all, as your project sponsor will only be interested in the overall budget and estimate to complete. But there might be times when you need to know if you’re paying out the money in advance or after the job is done.

You’ve got three choices here:

  1. Start
  2. Pro-rated
  3. End

They are pretty self-explanatory. ‘Start’ means the cost goes at the start of the task, so you’ve paid upfront. ‘Pro-rated’ means it is spread out across the duration of the task. And ‘End’ means you pay when the work is completed.

It’s fine to record this level of detail in your project plan for expense tracking purposes, but you’ll need to know how to read the reports to interpret it! That’s beyond the scope of this article. But hopefully this has given you a flavour of how to use the different resource cost settings in Microsoft Project and you can choose which ones (if any) are useful to you on your project.


Posted on: January 20, 2014 05:26 AM | Permalink

Comments (0)

Please login or join to subscribe to this item


Please Login/Register to leave a comment.

ADVERTISEMENTS

"Nothing so needs reforming as other people's habits."

- Mark Twain

ADVERTISEMENT

Sponsors