Forum Discussion
Solved
How to add a cost for each respective summary task
Hi,
I'm working on a large server upgrade project - the path I have chosen is to have all clients under one big project instead of having different projects for each clients, which by the way will be easy of course.
So here's what it looks like
Client A (this is a summary task)
task a
task b
task c
Client B (this is a summary task) --- a field here to show only cost for this client
task for b
task for b
task for b
What I want is a field which only calculate the cost per client.
Thanks in advance
- ThePM-CA --
In Microsoft Project, the cost for each task is calculated as the number of hours of Work for each resource, multiplied by the resource's Standard Rate. For example, suppose that a task has two resources assigned named Mickey Cobb and Calvin Baker. The Standard Rate for Mickey Cobb is $100/hour and the Standard Rate for Calvin Baker is $50/hour. On a particular task, you have Mickey Cobb and Calvin Baker each assigned to work 40 hours on the task. The cost for this task will be calculated as:
Mickey Cobb = 40h x $100/h = $4,000
Calvin Baker = 40h x $50/h = $2,000
Total task cost = $4,000 + $2,000 = $6,000
For each task in your project schedule, the Cost field will show the calculated cost for the task. Since each summary task represents the work for each client, the Cost column for the summary tasks will show the Cost for each client. So, there is nothing special you need to do to show the cost per client. This is assuming, however, that you have specified a Standard Rate for each resource in your project. Please let us know if that is not the case. Hope this helps.
3 Replies
- ThePM-CA --
In Microsoft Project, the cost for each task is calculated as the number of hours of Work for each resource, multiplied by the resource's Standard Rate. For example, suppose that a task has two resources assigned named Mickey Cobb and Calvin Baker. The Standard Rate for Mickey Cobb is $100/hour and the Standard Rate for Calvin Baker is $50/hour. On a particular task, you have Mickey Cobb and Calvin Baker each assigned to work 40 hours on the task. The cost for this task will be calculated as:
Mickey Cobb = 40h x $100/h = $4,000
Calvin Baker = 40h x $50/h = $2,000
Total task cost = $4,000 + $2,000 = $6,000
For each task in your project schedule, the Cost field will show the calculated cost for the task. Since each summary task represents the work for each client, the Cost column for the summary tasks will show the Cost for each client. So, there is nothing special you need to do to show the cost per client. This is assuming, however, that you have specified a Standard Rate for each resource in your project. Please let us know if that is not the case. Hope this helps.Dale_HowardMVP thank you very much. I don’t know where my mind was lol.
I also like the how to do change request you had in ms projectthank you again 👍
- ThePM-CA -- Thank you very much for your kind comments, my friend! 🙂
