RE: Material Cost changes during Project Execution

Hi Paul

Thank you for your question.

If the rate for the material is changed MS Project applies the new rate across the whole project, including work that has already taken place.

If you wish to record a rate change part way through the project try this instead. On the resource sheet double click the material resource. In the Resource information sheet click on Costs. In the A table use the first available blank row to enter the start date for the new rate, what the rate will be. MS Project will now apply this rate for this resource from the effective date.

To see the changes in costs over the life of the project switch to Task Usage view, right click on the table on the right side of the screen and select Actual costs.

You can also see the variance between baseline and actual by going to View > Table > Cost

To switch the table back to the default Entry table go to View > Table > Entry


I hope this helps - do let us know if you have any further questions.


Kind regards,
Andrew