About Planning Tools
Use of MS Project is unfortunately seen as synonymous with project planning. Ignoring that annoying reality and looking at what can be done to make MSP more useful, lets talk about how to get real benefit in a typical NPD project by using MSP2007 to help plan it.
Sometimes the first thing I do is to use a mindmapping tool such as Mind Manager to organize my thoughts about a job (see example below). I’ll be thinking about scope, parties involved, goals, risks, cool ideas that might be woven in, team, relevant patents competitors and products. I find mindmaps great for exploring and clarifying a brief. People like mindmaps and are alienated even by 50 line MSP plans - it pays to use the right tool for the job at hand.
Use of mindmapping in job planning
With a reasonably clear scope in hand, now its time to rough out a project plan to estimate the job. Remember – 80% of planning effectiveness is about process. So use templates. I use the same basic template to plan all my NPD jobs, based on the taxonomy of stages detailed in my earlier posting in this series. Templates help ensure quality and consistency as well as partially automate the drudgery of proposal generation.
Here’s what I do: I load my template project plan for product inno jobs, do a Save As to create a new file, and use the Show Outlining icon to hide all the lower level detail by showing only Level 1 and 2 tasks (see below). That allows me to play with the names of top-level Stages and the title and start date of the project. I can also adjust the linkages between Stages – sequential or parallel – as appropriate and I can delete Stages that are not appropriate.
Level 1, 2 tasks view for getting the basic plan achitecture right
Notice the emphasis my template has on flagging up late tasks and on auto-calculation of financials. That is because I am a consultant and generally have a number of these things running live at the same time. I need to be able to review my portfolio of projects swiftly and I am paid for my time. Money is the vocabulary of my clients, so I need a convenient way of translating proposed consulting activity into cash. I find that MSP2007 is a better environment to play with such numbers than Excel. I also need to monitor my projects carefully for signs of impending departure from plan. Tracking earned value is one way to do this – so I monetize activity as far as possible. The template has some simple programming to alert me to tasks which run late, provided I use Baselines and update Task Completion regularly. This is good for helping the team stay focused and I generally share this with clients at review meetings. I also highlight tasks where client participation is required, as a courtesy.
I now turn on the next level of tasks (Level 3) using Show Outlining (see next pic). That brings up all the Sub-Stages of the project which are the meat and potatoes from my point of view as a planner. Again, the task is to trim the superfluous and rename blocks of work in language that makes sense to the client as far a possible. Also to adjust the logical connections.
Level 1, 2 and 3 tasks shown
Next, I move to Level 4 which deals with ‘jobs to be done’. These are all technical procedures which my colleagues and I understand very well. They are skilled pieces of creative work or administration which have important deliverables, like specification-writing, building a QFD or FMEA or performing a tolerance analysis. At this level I do not normally discuss methodology with clients unless the activity involves client participation. Once again, I am adding and subtracting ‘jobs’ from the plan according to the requirements of the project.
There is a final Level 5, which deals with tasks at man-hour level. Adjusting time allocation at this level comes next. Then, I turn on my Resource Sheet and add/subtract team members, key suppliers and hourly billing rates. Holidays, Christmas and Chinese New Year shutdowns are all coded in the Calendars in the template.
With the basics now done, it is time to run through the plan line by line, adding materials and other fixed costs of performing tasks to the Fixed Costs column. Task Work is adjusted to suit my judgement of what is appropriate. Note that I almost never change MSP2007’s Task Duration fields. I prefer to use the Task Form to tweak Work contributions from the team members assigned to each task. MSP2007 will do the rest. (see pic below) I also don’t generally prescribe dates for tasks - this really fouls up project levelling and defeats much of the benefit of the planning process by forcing the plan to fit time constraints which are usually arbitrary. I have rarely seen a client project that was not time constrained. Finally, I carefully look for opportunities to trim overall project duration at minimum risk, by introducing additional overlap between Sub-Stages.
Editing the plan at the ‘jobs to do’ level
Now it is time to get ones colleagues to buy in to your plan. If you are a true team, and understand one another’s professions this is relatively straightforward. But actually doing it, including checking holiday bookings and forward workload is critical.
Now it is time to review the outputs of all this slog. First, I look at the calculated total time and fees required to deliver the project. I then do a rough calculation of how many man-months of work I think the project ‘ought’ to take, based on gut feel, and reconcile this with the numbers MSP is giving me. This is usually painful – MSP is remorseless at highlighting the economies that are needed to fit a project into a client’s budget. When that is about right, it is time to extract some reports for the project proposal or to discuss the project budget with the client
MSP2007 has a Visual Reports data-out function which (in combination with Excel’s Pivot Tables) allows semi-automated production of goodies like monthly cash ‘burn-rate’, earned value and resource utilization charts. (see pics below)
Project-related Capex & Revenue per month
Who, When plot for key project resources
Hopefully there will be at least one or two aspects of this process-heavy approach to NPD project planning which will stimulate better planning in people who read this. Equally, if others have ideas to add I’d love to hear them…
Tags: No Comments.






