Calculation "Cost % complete" in MS Project Pro
Contents:
Create custom column "Cost % complete"
You can control the progress of project tasks by tracking project costs. This is a simpler implementation of the earned value method. You don't need to set the baseline or set the percent of complete. The method uses the sum of planned and actual costs. You create a custom column in which you calculate the earned value percentage. You can compare this column with other progress control columns.
Steps to create custom column "Cost % complete":
- Click the "Custom Fields" button in the "Properties" block in the "Project" item of the top menu.
- Select field type "Task" in the "Field" block.
- Select type "Number" in the "Type:" field.
- Select the empty field in the table and click the "Rename ...." button.
- Add the "Cost % complete" field.
- Click the "Formula ..." button.
- Add the formula: "IIf([Cost]=0;0;[Actual Cost]*100/[Cost])".
- Click the "Ok" button.
- Click the "Ok" button.
#msprojectpro, #oberemokii, #projectmanagment, #projectcostmanagement, #monitoringandcontrollingprocess