Cost Calculations
Task and project costs in SharedPlan are calculated using the following fields:
• Task percent complete (entered by you)
• Task fixed cost (entered by you)
• Task fixed cost accrual method (entered by you)
• Task assignments (entered by you)
• Resource information (entered by you)
• Planned cost is calculated by Pro as the sum of cost for each resource + fixed cost (using Planned Start and Planned Duration)
• Actual cost is calculated by Pro as the sum of cost for each resource + fixed cost (using Actual Start and Actual Duration)
How SharedPlan calculates fixed cost:
• If "Accrue at" is Start and task start date has passed then fixed cost = value otherwise it is 0
• If "Accrue at" is Finish and task end date has passed then fixed cost = value otherwise it is 0
• If "Accrue at" is Prorated and task start date has passed then fixed cost = value * % complete
How SharedPlan calculates resource cost (planned or actual duration are used depending on whether planned or actual resource cost is being calculated):
• If "Accrue at" is Start and task start date has passed
o If worktime or overtime have been entered then resource cost = worktime * std rate + overtime * overtime rate + resource cost/use otherwise it is 0
o If worktime or overtime have not been entered then resource cost = assignment allocation * resource max units * standard rate * duration
• If "Accrue at" is Finish and task end date has passed
o If worktime or overtime have been entered then resource cost = worktime * std rate + overtime * overtime rate + resource cost/use otherwise it is 0
o If worktime or overtime have not been entered then resource cost = assignment allocation * resource max units * standard rate * duration
• If "Accrue at" is Prorated and task start date has passed
o If worktime or overtime have been entered then resource cost = (worktime * std rate + overtime * overtime rate + resource cost/use) * % complete
o If worktime or overtime have not been entered then resource cost = (assignment allocation * resource max units * standard rate * duration) * % complete
Note that * in the above formulas is used to denote multiplication (e.g. 2 * 3 = 6).
Conventions:
• Cost of summary tasks is the sum of all costs in its subtasks
It’s simpler than it looks. The best way to understand cost calculation in SharedPlan is to create a simple project with one task, one resource, and one assignment and then play around with the values for fixed costs and resource costs to see how they affect the total.
SharedPlan offers multiple ways to manage the cost associated with your project. You may associate costs with a resource and with a task. You may then generate project and task level reports showing detailed cost information.
Cost information is entered into the Resource Editor (Tools->Resource Editor) and, for assignments, the Task Information Editor (Select the task and then choose Edit->Task or double click on a task).
The Project Cost Report provides complete task cost information. The Project Report (Reports->Project Report) summarizes the project cost. The Tasks Report (Reports->Tasks Report) and the Resources Report (Reports->Resources Report) provide information on the costs associated with each task and resource, respectively.
