The Money Files

by
A blog that looks at all aspects of project and program finances from budgets and accounting to getting a pay rise and managing contracts.

About this Blog

RSS

Recent Posts

4 Reasons Why People Need Estimates

Ask The Expert: Jack Appleman

5 Tips for Better Buying [Video]

How To Motivate Your Team

3 Ways To Procure Without Competition

5 Common Approaches for Performance Measurement

How do you track the performance of your project? Here are 5 ways that you can do it.

1. Fixed Formula

This is pretty easy. Assign a fixed percentage when the work starts. Then make it up to 100% by allocating the rest when the task finishes.

The Pareto principle is a good one to use if you don’t know how to split your task percentages. Assign 20% complete to the job when it starts, and the remaining 80% when your team member reports the work complete (because at that point it’s 100% complete).

It’s simple to work out but it’s not terribly accurate. It’s only good for small pieces of work and short tasks where it would be too difficult or not worth it to work out percent complete across a couple of days. It can also be used where the task is no longer than a week long. If you are updating your project plan once a week, and the task is no longer than a week long, the task is either started or finished so the 20/80 split (or 50/50 or whatever you think is appropriate) works out pretty well.

2. Weighted Milestones

When you’ve got plenty of milestones along the way, you can work out project performance by tracking how many you’ve hit.

In other words, you can pre-assign progress (percent complete) to certain milestones or parts of tasks. When you hit Milestone 1 you can say the project is 15% complete, at Milestone 2 it goes up to 20%, at Milestone 3 you’re 65% complete and so on. Until your final milestone at project completion where your project (or task) gets updated to be 100% complete.

This is also a way to split payments to vendors – many contracts have a schedule of payments linked to the achievement of key milestones. Your budget could be weighted in the same way as how you track performance.

3. Percentage Complete

We’ve talked about % complete already, but this version of it is just based on the project manager’s guess best professional judgement. They update the schedule or tracker weekly (or whenever it’s appropriate) with their take on project performance by assigning a percent complete.

This isn’t hugely accurate either – although it depends on the project manager. It takes experience to be able to pick a percentage out of the air and have it reflect reality. Generally, project management tools can help with this by playing back to you the % complete of your project schedule, so at least in that case you should have something underpinning the number you give.

4. Percentage Complete with Gates

This is similar to weighted milestones but instead of waiting to hit the ‘gate’ point, you can report any percentage complete up to the approved limit for that milestone.

For example, when you hit Milestone 1 you can say the project is 15% complete, as we saw above. With weighted milestones, until that point the project would be 0% complete. With gates, you can set a % complete every day if you like, working up to 15% at the point of hitting the gate (the target milestone date or achievement).

It’s like a blend of using your professional judgement but being constrained to not say you are too far ahead because you can only ever hit a certain percent complete through the nature of where you are on the project.

It sounds complicated to explain but this is my favourite approach for measuring project performance.

5. Level of Effort

Finally, you can track effort against the elapsed time. Alternatively, you can track against some other task or work package on the plan. For example, ‘Complete Testing Documentation’ might be linked to ‘Complete Testing’ and the two activities progress in parallel.

You’d track performance for ‘Complete Testing’ and then, as you know that testing documents are being updated as you go, apply the same % complete to ‘Complete Testing Documentation.’

Which one(s) of these do you use? And which do you avoid? Do you use these as standalone techniques or do they link to your Earned Value Management activities? Let us know in the comments below!

Posted on: April 23, 2017 11:59 PM | Permalink | Comments (5)

5 Project Management resolutions with a financial theme

It’s the time of year when project managers (and everyone else) are looking to make resolutions. You know, the kind of promises you make to yourself in the dark days of winter and then have completely forgotten by Easter.

On the off chance that you’ll be making resolutions this year, here are some you could consider. They all have a money-related theme, so if you want to brush up your budgeting or polish your financial management skills in 2013, these could be great resolutions for you to adopt. So here we go: 5 promises for better money management over the next 12 months.

1. I will look at historical data for forecasts

When you are managing projects that are repetitive in nature and that the team has a lot of experience of, it’s very tempting to simply let them estimate the length of tasks and assume that they know what they are doing. Most of the time, they probably will. But it is worth validating their estimates against historical data from timesheets and previous project schedules. Use your online project management software to pull up reports of how long things took the last time you did them.

This could be at the level of an individual task, like completing a particular piece of coding, or a project phase, like testing. Or both. The purpose of checking is to make sure that your estimates really are sound and that the people who are estimating are not making the same mistakes about task duration on every project.

2. I will do my timesheets in a timely fashion

This is a personal resolution for you, although you could extend it to all your project team members. The risk of not doing your timesheets on time is that you forget exactly what it was that you were doing. As a result, you block out 8 hours per day for a task called ‘project management’ which doesn’t give you any breakdown of how you actually spent the time. Worse, you could be booking time to one project when in reality you got pulled off that project to spend half a day on some other project. These things happen in real life, to you and your team members.

By aiming to complete your timesheets at least weekly you’ll not have long enough to forget what you were working on!

Training

3. I will understand Earned Value Analysis (or teach someone else how to do it)

If you don’t understand EVA, make 2013 the year when you get your books out and study how it works. If you do understand EVA, make a resolution to share your knowledge with someone else this year. Even if you don’t use EVA on your projects, it is a very useful skill to have.

4. I will do my expenses on time

Most project managers will incur expenses in the course of their job, such as travel to meetings. Not doing your expenses on time means that you are out of pocket. Many companies only pay expenses once a month in the monthly pay run, so don’t let your expense bill mount up – that’s effectively a loan to your company.

Get your personal paperwork in order by keeping receipts together, noting down your mileage after every trip and understanding the schedule for submitting expenses so that you don’t miss the deadlines.

If your expenses are being cross-charged to your project it is even more important to get your expenses in on time. If you don’t, your project budget will reflect that you have more ‘in the bank’ than you actually do.

5. I will review my budget quarterly

You do this already, don’t you? If not, make 2013 the year when you review your project budget forecasts regularly. If your project runs over two quarters you’ll probably be asked to do this by your finance team anyway, but even if you are not, it is still good practice to get out your spreadsheets and just check that you are still on track to stick within your budget tolerance limits.

Have you chosen any of these as your resolutions for 2013? If not, what are you having as your resolutions instead?

Elizabeth Harrin is Director of The Otobos Group, a project management communications consultancy. Find her on and Facebook.

Posted on: January 17, 2013 03:10 PM | Permalink | Comments (0)

Are project forecasters “fools or liars”?

Categories: forecasting, research

Oxford University“The majority of forecasters are fools or liars,” says Professor Bent Flyvbjerg from the BT Centre for Major Programme Management, at the Sa?d Business School, University of Oxford, in a new paper on inaccurate estimates for major projects.

The paper, published in the International Journal of Project Management, sees Professor Flyvbjerg criticising the way that forecasts for projects are put together. He says they are inaccurate and provide poor material from which to make decisions about cost and benefits.

“Estimates are commonly poor predictors of the actual value and viability of projects, and cannot be trusted as the basis for informed decision-making,” he says. “These forecasts frequently misinform decision makers on projects instead of informing them. Some of the inaccuracy comes from genuine forecasting mistakes arising from over-optimism, but some estimates are deliberately misleading, designed to secure financial or political support for a project.”

You probably know of examples of where a project manager has padded estimates for one reason or another, by Prof. Flyvberg is pretty scathing about forecasting methods and the people who use them.

“Many forecasts are garbage and can be shown to be worse than garbage,” he is quoted as saying in a press release from the university. “These reports give the client, investors and others the impression that they are being informed about future demand, or the costs involved in a major project, when they are being misinformed. Instead of reducing risk, reports like this increase risk by systematically misleading decision-makers and investors about the real risks involved.”

What’s the answer?

Prof. Flyvbjerg says that the answer is for everyone to be a bit better at not putting up with this (I paraphrase). For example, he recommends that clients should ask for their money back when they receive reports which later prove to be significantly inaccurate and misleading. He even goes as far as saying that they could demand compensation (some contracts must have a clause for this in anyway). His most radical idea is that in some cases criminal action would be justified. “Merely firing the forecaster may be letting them off too easily,” he says. “Some forecasts are so grossly misrepresented and have such dire consequences that we need to consider suing them for the losses incurred as a result. In a few cases where forecasters foreseeably produce deceptive forecasts, criminal penalties may be warranted.”

Personally, I can’t see many project managers ending up in court because of poor scheduling, but as this has come from the Centre for Major Programme Management, Prof. Flyvbjerg is really talking about complex, mega projects.

When we say ‘everyone’, Prof. Flyvberg includes the professional bodies in that too. He calls on them to use their codes of ethics to penalise and possibly exclude members who produce unethical forecasts. “This needs to be debated openly within the relevant professional organisations,” he says. “Malpractice in project management should be taken as seriously as malpractice in other professions like medicine and law.” How many project managers genuinely produce unethical forecasts and how many are just incompetent? I think it would be hard to decide if someone was acting in good faith and to the best of their abilities or whether they were deliberately altering estimates for political gain.

A better way of forecasting

As you would hope from someone who is so outspoken about this, Prof. Flyvberg has all the answers. His answer is to turn to his own work and in this IJPM paper he sets out the case for quality control and due diligence to be applied to the evaluation of front-end forecasts. Unfortunately, I think his answer only works for massive projects and not for the type of forecasting and estimating most project managers do on their projects.

“Recent research has developed the concepts, tools and guidance on incentives that could help curb both delusional and deceptive forecasts,” he says. “Whether forecasters are unwittingly or deliberately under-estimating the costs, completion times, and risks of projects, and over-estimating their benefits, we need to have a systematic basis for evaluating their findings in order to make informed investment decisions. Given the high cost of major infrastructure projects, the irreversibility of decisions, and the limited availability of resources, this is clearly critical for both public sector and private sector projects. Significantly more accurate forecasts can be produced by looking at the evidence available from previous similar projects which have been already completed – what I call, taking an ‘outside view’. This seems so simple, but in practice it is transformative and leads to much more accurate forecasting.”

In other words, take large data sets or statistically relevant data for projects in your sector, apply due diligence, estimate from the basis of past experience and critically evaluate the forecasts. You’ve spotted it – the big downside to this estimating approach is that you need large, validated data sets to draw benchmark data from previous, relevant, projects. If your PMO has been up and running for years and has gathered all this, and you never do any projects which innovate or deliver something new in a way you haven’t done before, then you could make use of this technique.

If you don’t have all that data to hand, then this method of forecasting will not scale from mega projects and programmes to the humble projects that you and I work on. While using historical data is great and we should all look to the past to better predict the future, we would be wrong to expect this model to work for all projects.

Posted on: December 19, 2012 04:45 PM | Permalink | Comments (4)

5 things to consider for resource planning

Categories: forecasting, resources

TimelineNormally on a project you will plan out the tasks required to do the work, and then add in the resources needed to carry out those tasks. Here are 5 things to take into account when doing resource planning on your project.

1. Holidays

All team members need holidays or vacation time. Remember to plan for this when you are scheduling resources – you may find that a critical resource has already planned to take leave during a time on the project when you would really rather that they are around. Talk to the line managers of your team members about when they already have holiday time approved.

Also factor in religious and other cultural holidays. Team members may want to take time off around these times – and that goes for school holidays too.

2. Sickness absence

Unfortunately, team members can go off sick without any notice. While the option to work from home allows many people to soldier on when they may be too ill to make it to the office, you can’t rely on people to not be ill.

One way allow for this is to consider how you will backfill a project role if the person currently doing it is away from work. While you shouldn’t allocate two resources to every task just on the off chance that someone will get the flu, you should have a plan in mind just in case someone drops out of the team due to sickness absence at short notice.

3. Single point of failure

When task planning, look at who on your resource plan is the single point of failure. Who has worked on all on the Finance tasks and has all the operational knowledge? On long projects it can be particularly difficult to switch someone in at the last moment if your single point of failure person hands in their resignation.

4. Negotiating with line managers

If you don’t have direct responsibility for the team member concerned, you will have to negotiate their time on the project with their line manager. This can be tricky, especially if you only need them on a part-time basis. You may find that they can’t do the job they used to do before the project on a part-time basis, and their line manager may not find it convenient to have them back. It may be possible to job share the role in this case.

You should also consider what would happen if your schedule slips and you end up needing the team member for a longer period of time – how will you negotiate this with their line manager?

5. The triple constraint

If you lose a resource back to their day job or for any other reason, you will have to consider the impact that this will have on your task scheduling. The traditional triple constraint, for all its faults, is a good place to start discussions with your sponsor. If you have fewer resources, can you negotiate a longer time to deliver the project? Could you negotiate more money to pay for additional resources so that you have more confidence about reaching the original milestones?

In the end this will be your project sponsor’s decision, but you can at least take him or her some options to consider.

Resource allocation will no doubt change your task plan. You really need to review both the tasks and the resources in parallel so that you can put the two together and come up with an effective and realistic schedule. What other tips do you have for successful resource scheduling? Let us know in the comments.

Posted on: December 16, 2012 04:16 AM | Permalink | Comments (2)

Managing Money Q&A (Part 4): Why do projects go over budget?

CalculatorIt was a while ago now that I gave a webinar on managing money on projects, but it is taking a long time to answer all the questions that I didn’t get round to doing during the live session.  Thanks to all the fabulous participants, who asked such brilliant questions!  I am still trawling through them hoping to answer them all, and here is today’s batch of managing money Q&A.  

What is the difference between the contingency and a reserve?

Nothing.  Call it whatever you want.  The idea behind both contingency and a reserve is to have a pot of money put aside in case of unforeseen developments.  Regardless of what you call it, you can’t draw on it as a matter of course.  Accessing the contingency fund is only done with the permission of the sponsor – it’s not there for you to use as a buffer because you haven’t managed to keep the project costs on track.

If you choose the biggest number in the range of total project cost, would you then use that as the basis for applying a percentage as contingency?

What you are talking about here is presenting budget figures as a range to key stakeholders during the decision making process.  This is a great idea, and it encourages people at the early stages of a project to take into account the fact that the planning is not yet completely finished.  If you then want to apply a percentage amount as contingency – say, 10% - choose the biggest number in the range. So if your budget prediction is a range of £250k to £280k, you would work out 10% contingency as 10% of £280k, giving you £28k.  You can always hand your contingency back if you don’t need it, or reforecast it to a more accurate level later.

How we can handle project cost in a software product development company where the same resources are being used both for Development and production support and trouble shooting the issues of the live product?

Timesheets!  The project costs you must be referring to here are resource costs.  All other costs could be attributed directly to the cost of brining a new product to market, like buying a new server to host it on or marketing for new clients.  Accurately predicting and monitoring resource costs on a project are going to be hard unless you know how your teams are spending their time. Get them to do timesheets for a couple of months to get a baseline of what percent of their time is spent on support and troubleshooting.  This will give you a basis on which to forecast going forward.

On the other hand, if you aren’t worried enough now to be tracking time and working out how much effort your teams put into managing projects, why do you want to going forward?  Consider the reasons why knowing this information is important to you before going to the effort of introducing a time recording system that won’t give you all the data you need to make useful business decisions.

Would you say an initial budget has a +/- % deviation and encourage revisiting the initial estimate to reduce the deviation or wait till you expect to exceed initial budget?

Never wait until you expect to exceed the initial budget to reforecast.  Typically, project budgets are reforecasted at the same time as the rest of the company accounts are reforecasted, so once a quarter is normal, if the project is large or costly.  You can set points in the project lifecycle where it is sensible for you to revisit the costs.  For example, after the first phase, or once the development is complete could both be good examples of where it is an appropriate time to look again at your projections.  

I would say a budget has a +/-% deviation, and I think this is a good habit for sponsors to get into – they should be used to looking at ranges of numbers, and you can then revisit this estimate to reduce the deviation once more detail is known.

What are the reasons for going over budget and how can I control it early?

Where do I start?!  Here are some reasons:  poor estimating, equipment costing more than you first thought, forgetting to add in the tax (I’ve done that), not calculating formulae properly so your sums are wrong before you start (done that too), a risk materialising and not having budgeted for problem resolution, resources costing more than you thought i.e. having to pay for overtime or weekend working. The list goes on, and I’m sure you have your own suggestions of why projects go over budget.

Mainly it all comes down to poor monitoring and control.   If you have estimated accurately, keep the project on track, manage the resources effectively, and forecast estimate to complete properly, you should at least have an early warning that you are going to go over budget, and you can address this appropriately.  That could be through increasing the budget, using the contingency fund, trimming down the scope or dropping the quality of some deliverables, or through other means.

Read Part 1 here
Read Part 2 here
Read Part 3 here

You can see the whole presentation online here, via a recording of the webinar.  I’ll have some more Q&A for you soon!
 

Posted on: August 06, 2010 04:45 PM | Permalink | Comments (0)
ADVERTISEMENTS

"He who asks is a fool for five minutes, but he who does not ask remains a fool forever."

- Chinese Proverb

ADVERTISEMENT

Sponsors