Ask a Question Sign up for Free 70 Experts currently online. Ask Questions for Free!

forcast the budget implications of staffing - Microsoft Project

How can Project help me forcast the budget implications of different staffing plans? We have few project tasks outlined, but may change staffing (and so, rates) on multiyear projects. MS Project does not appear to help here. What am i missing?...

Results 1 to 4 of 4

  1. #1

    forcast the budget implications of staffing

    How can Project help me forcast the budget implications of different staffing
    plans? We have few project tasks outlined, but may change staffing (and so,
    rates) on multiyear projects. MS Project does not appear to help here.
    What am i missing?
  2. #2

    RE: forcast the budget implications of staffing


    There are several approaches to this, but here's some food for thought:

    From an MSP perspective, you'll probably want to use a resource pool...
    especially if you have multiple projects lined up. Two main approaches to
    setting up your resources for forecasting are a) generic resources by labor
    category or skill set or specific resources. There are advantages to both
    where "a" is probably easier / quicker to set up and gives you an "FTE"
    approach to forecasting and "b" can be more realistic and shows over
    allocations for specific resource much easier. Either approach can handle
    rates using the Cost Rate tables where you can set up to 5 different rates
    for each resource and also can set date ranges where the rates can change
    based on contractual terms, fiscal/calendar years, etc.

    You'll need to set up your schedules with tasks where you assign resources
    to them. Whether or not you develop high-level / top-down estimated
    schedules or detailed schedules, you'll need to have resource assignments for
    a greater degree of accuracy. I prefer the "b" approach because you can
    re-use the resource or actually start managing and tracking to the schedules.
    Conversely, the generic resource method is for estimation / forecasting and
    would take a little effort to convert to specific resources.

    This is high level and there are certainly other approaches / methods.
    Other considerations / views/ tools to use are a master schedule with
    inserted "sub" schedules. This gives you a portfolio / program view of your
    schedules and is also another way to see resource allocations across all of
    your projects.

    Hope this helps!


    Ian Coletti, PMP

    "GeoFru" wrote:
  3. #3

    RE: forcast the budget implications of staffing

    thanks. that helps alot.

    If I use "b", will I see over/under use of *each* employee for period? Can
    period be a month?
    Can I grab actual expense $ from an ODBC source and use in my project
    report? And add or subtract the ODBC $ to cal a budget ramaining?

    "Ian Coletti" wrote:
  4. #4

    RE: forcast the budget implications of staffing

    Hi George,

    Using a "Resoure Usage" view, you will be able to see the allocations for an
    employee by whatever timescale you choose. Once in that view, select
    "Format" then "Timescale" and you can adjust the timescale to show "Months"
    and "Weeks" (the version of Project you use will dictate whether you have 2
    levels of timescale or 3). I find Months/Weeks useful because you can see
    whether folks are allocated around 40 hours / week. Also, if you right click
    on the right side (or time-phased) of the screen, you can add or delete rows
    for further ysis (see below for specifc fields).

    As for the second part of your question, you've switched from a forecasting
    to a managing and tracking issue. Typically, we'll use project to enter
    actual hours for tasks by resource. If the rates are set up properly for
    each resource and all of your tasks (either high level or detailed) are
    captured, you should be able to both baseline at the beginning (which will
    give you a "budgeted amount") AND enter actual hours... which will give you
    "actual cost." This is not something that you can do overnight if you are
    trying to develop a fully robust management system.

    I use this method every day for my clients, but our processes have been in
    place for a while. I also compare what was submitted in terms of hours on my
    schedules to what was billed to the program. Being disciplined about this...
    you can achieve realistic results with very little varience plus you get the
    added benefit of project management reporting and ysis with MS Project.

    Back to your first question, you can add Baseline Work & Cost to the Task
    Usage view as well as Actual Work, Actual Cost, and Overallocation.

    I have a couple custom views that shows summary level data as well as
    detailed Earnved Value data. You can do the same thig with the "Task Usage"
    view to look at the same type of data at the project or task level instead of
    from a resource perspective.

    Also, I know lots of people either try to or actually use ODBC connections
    or macros to populate Project with actuals from other systems. This is an
    option, but we usually enter this stuff manually for the most control over
    and subsequent ysis of our data. Since there are a lot of calculations
    going on behind the scenes in Project, I try to avoid automated entry into
    the system where possible (with the exception of Project Server, of course).

    Hope this helps!

    Ian Coletti, PMP

    "GeoFru" wrote:

Similar Threads

  1. Deployment and AD implications & VMware
    By Adam in forum Microsoft CRM Deployment
    Replies: 2
    Last Post: 02-02, 03:30 PM
  2. Monthly Budget?
    By The in forum Mac Excel
    Replies: 4
    Last Post: 04-16, 01:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100