If you save another baseline after editing baseline costs, your edits are overwritten by the new baseline values. If you edit the contents of the Baseline Cost field, it does not affect any baseline resource cost calculations, nor any timephased baseline costs for the resource. The baseline cost for the resource would be $2,000. Better yet, use the Cost Variance field to compare the two fields.Įxample You have a resource at $20 per hour assigned to 10 different tasks for a total of 100 hours. Compare the values in the Baseline Cost and Cost fields to determine if the task is still on track within your budget. Review these baseline costs to help set your resource budget. Add the Baseline Cost field to a resource sheet when you want to review total baseline costs for resources. This is the same as the contents of the Cost field when the baseline is saved.īaseline Cost = (Work * Standard Rate) + (Overtime Work * Overtime Rate) + Per Use Costīest Uses The baseline cost information for the resource becomes available when you set cost information for the resource and set a baseline for the tasks to which the resource is assigned. How Calculated The baseline cost is calculated as the sum of the planned costs of the resource, including scheduled work, scheduled overtime, and per-use costs for all work assigned to the resource. The baseline cost does not change after it has been saved, even if work values change. If you edit the contents of the Baseline Cost field, it does not affect any baseline task cost calculations, nor any timephased baseline costs for the task. You set a baseline in the Set Baseline dialog box. Remarks The Baseline Cost field contains 0.00 until you set a baseline for the project, which you can do even after the project has been started. When the task is 50 percent complete, the Actual Cost field will be calculated at $100. The baseline cost for the task would be $200. The Cost Variance field compares these two fields.Įxample You have a task with a 10-hour duration and a single resource assigned at $20 per hour. You can compare the values in the Baseline Cost and Cost fields to determine whether the task is still on track within your budget. You can review the baseline cost for the task to help set your budget for the task and the project. Add the Baseline Cost field to a task sheet when you want to review total planned costs for tasks. This is the same as the contents of the Cost field when the baseline is saved.īaseline Cost = (Work * Standard Rate) + (Overtime Work * Overtime Rate) + Resource Per Use Cost + Task Fixed Costīest Uses The baseline cost information becomes available when you set cost information for the assigned resources and set the baseline for the task.
#MICROSOFT EXCEL COST TO DEVELOPE PLUS#
How Calculated The baseline cost is calculated as the sum of the planned costs of all the assigned resources plus any fixed costs associated with the task. There are several categories of Baseline Cost fields. The timephased versions of these fields show values distributed over time. Baseline cost is also referred to as budget at completion (BAC), an earned value field. The Baseline Cost fields show the total planned cost for a task, a resource for all assigned tasks, or for work to be performed by a resource on a task.
0 kommentar(er)
