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
Member for
21 years
Member for21 years
Submitted by Philip Jonker on Sat, 2004-11-13 03:16
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.
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.
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.
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???
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.
Member for
22 years 3 monthsRE: Time Phased Cost
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
Member for
21 yearsRE: Time Phased Cost
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.
Member for
21 years 3 monthsRE: Time Phased Cost
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.
Member for
21 years 3 monthsRE: Time Phased Cost
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.
Member for
22 years 6 monthsRE: Time Phased Cost
Hi Raj,
How do you edit your MSP default work contours?
Regards,
Erik
Member for
22 years 3 monthsRE: Time Phased Cost
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
Member for
21 years 3 monthsRE: Time Phased Cost
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.