Time Phased Cost
Forum Sponsor
Top Posters
Julian Pegg
1 posts
Peter Nagy
2 posts
Raymund de Laza
17 posts
Syed_Asad
0 posts
Tony Greyvenstein
0 posts
Ahmed Al-Jubouri
13 posts
Umar Alvi
3 posts
Sibusiso Mahlalela
0 posts
Michael Samanyayi
3 posts
Simon Gumede
0 posts
Hi Philip
Here is what I am trying to do. I need to track 3 separate cost in ms project.
1. Hardware Payment Milestones
2. Monthly Labor Cost
3. Change Order Cost
I need to be able to capture all of these cost at the work package level and project level and create s curves for each
work package and for the project.
I am not creating a resource loaded schedule except to the extent required to get time phased data in the schedule for labor cost and chage order cost. My approach is to create a new task/resource for each labor account or change order and prorate it for the duration of the project and at the end of each month actualize the amount to be invoiced.
After I have done all of that I need to be able to export to excel and create a pivot table and create s curves keeping in mind that data has to be grouped at work package level and project level.
Regards, Kelly
Hi Kelly,
I have a couple of questions:
1: What type of project are you working on?
2: When you talk about cost are you talking about, manhours (ie Labour resources) or overall project cost in monetary terms (ie labour, materials, craneage etc)?
The reason I ask is that the answers will determine the spread. It is easy to fudge things, but if you want the correct results, it takes more efort.
Erik,
Change the view as Taks or resource usage then edit the resource distribution manually as per need then work contour will change as contoured. Then it will show in drop down box also.
Kelly,
If you update the schedule the remaining work will get updated so the remaining cost will automatically get redistributed. You can try to fill actual work as scheduled for that period of time while updating your scheudle.
Your second question- You map the desired data ( Like task, resource, total cost etc) and export that into excel. But then you cant export the distributed table. So then you can do it manually as to create similar column and rows environment in excel after exporting data in excel then copy the distributed table from MSP and paste it into your spread sheet. I hope this will work as you wanted.
Hi Raj,
How do you edit your MSP default work contours?
Regards,
Erik
RAJ,
I have tried your suggestion and it works well but it leads me to ask 2 more questions. I have distributed my cost over time by month however, if I do not actulize the total cost for the month the remaining cost gets redistributed into the next month. I do not want remaining cost to be distributed into other months. How can I avoid this???
Next problem! After my cost is distributed in either task or resource usage in spread sheet form, how can I get that time phased cost into an excel spreadsheet by month???
Thanks, Kelly
Assign resource to the CTR where you want to distribute the cost non linear and distribute the work non linear ( In open resource usage and define work "contour" and edit resource distribution non linear and assign the proper unit rate to the resource). I hope this will work as you want and you no need to assign milestone for that.