Share via

How to get the "baseline cumulative cost" for resources in MS project

Anonymous
2024-10-30T02:32:55+00:00

I am trying to track the cumulative progress of a resource (material) in MS project against a set baseline.

I managed to plot the "cumulative work" vs the "baseline cumulative work", but I need the "cumulative cost" and the "baseline cumulative cost" instead.

I can find the "cumulative cost" in the options to pick, but there is no "baseline cumulative cost". There is "baseline cost" but not "baseline cumulative cost".

I find that very weird that there is a "baseline cumulative work" and not a "baseline cumulative cost".

Any idea why and way around?

Thank you.

Microsoft 365 and Office | Project | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2024-10-30T04:16:43+00:00

    Damien Deffieux, you're right, it's not there. Seems like a reasonable thing that should be there, but why not is a mystery.

    How are you plotting this, in MSP reports, or export (copy/paste) the data into excel and graph there?

    It is easy to copy the baseline cost from the task usage view, paste in excel, make formula to cumulate, and graph.

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-10-30T12:55:01+00:00

    Hi Trevor,

    Thank you for your reply.

    Yes it is easy to do copy / paste in Excel, I know how to do it, and I was doing that.

    But I am trying to find a way to have it plotting automatically in MSP.

    Previously I was using the "work" to track the progress of my resources, but I prefer to track it with the "cost", because I am tracking multiple resources and I am looking at the overall progress. Some have low quantity but high $/unit, and some have high quantity and low $/unit. So if I am tracking the "work" (the unit produced), the high $ items will be diluted into the mix with the low $ items, whereas if I track the overall cost, it gives a better picture.

    I hope it makes sense.

    0 comments