Wednesday, May 02, 2012 8:49 PM
We are using MSP 2007 Standard. We have a project schedule that is minimized for “clarity”. It has been dictated to us by a “superior force”. The schedule’s only resources are Cost Resources represented by the four budget categories, “Engineering”, “Materials”, “Mechanical Construction”, & “Electrical Construction”. In addition there have Cost Resources for “Variance 01”, “Variance 02”, “Var…” (not to be confused with the MSP Variance Field).
The Variance resources are variances (change orders) to the Baseline Budget. This seems to work fine until there is a negative Variance (money was moved from one budget category to another). The company I represent handles this with two Variances – one for adding money to a budget category, another for removing money from a different budget category. The problem is that MSP2007 does not allow for negative costs in Cost Resources (nor possibly any resource).
I am looking for a work-around, or another place to post these costs (they are assigned to multiple Tasks). Can anybody shed some light on this?
Thanks, DLMcKirdy, Sr. Proj. Controls Spec.
Wednesday, May 02, 2012 10:33 PMHello,
MS Project is not a great cost budgeting tool when used in this manner. I recommend that you use another tool to track this type of information. You can also search on "cost budgeting" in this forum to see other suggestions.
Hope this helps.
Gregg D. Richie, PMP, MCTS; Author, Microsoft Project 2010, Microsoft Official Academic Course Series
- Edited by Gregg D. Richie, PMP, MCTS Wednesday, May 02, 2012 10:33 PM spelling
Thursday, May 03, 2012 3:50 AMModeratorYour only alternative is to subtract teh -ve value from an existing Assignment and add a note to teh task to explain. Not great, but it does work.
Rod Gill Project Management
Thursday, May 03, 2012 7:36 AMModeratorAdding to Gregg and Rod, you can also try to store the in custom cost fields and then use them for calculation adding your custom formula. You have 10 Custom Cost fields in MS Project.
Thursday, May 03, 2012 10:29 AMModeratorJust to provide additional options:1) Enter negative costs in the task Fixed Cost column.2) You can create a material cost with negative standard rate and then assignit to the task. So create a material resource called "Change 1" and assignit a standard rate of -10K.You'll note that you can use material resources to emulate the functionalityof Cost resources.
Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky
- Marked As Answer by dlmckirdy Thursday, May 03, 2012 6:02 PM
Thursday, May 03, 2012 6:04 PM
Thank you Andrew, and everyone else for your input. I will do some testing with your second suggestion to see if this approach fits our needs.
- Edited by dlmckirdy Thursday, May 03, 2012 6:06 PM