Hello,
I recently updated a construction programme of works after cost loading it. The cost is fixed (Lump Sum project) and the % Complete Type is set to duration. Thus, the calculate cost from units is not checked and a budgeted cost was allocated to each resrouce (material resource). Now, after I've updated my programme for the first time, I was expecting the remaining cost and actual cost to update based on the activity's duration percentage assigned. The activities' cost did not update and the remaining cost is still equal to the budgeted cost, which obviously returns an actual cost of zero. On the other hand, the earned value is displaying the correct amount i.e. Masonry works allocated a budgeted cost of $10,000, % complete = 50%, actual cost = $0, remaining cost = $10,000 and earned value = $5,000.
I have tried to change the % Complete Type to units and fill it, then physical and fill it. I have also tried to uncheck auto compute actuals for the resources. On a project level, under the calculations tab, both "Recalculate Actual Units and Cost when duration % complete changes" and "Link actual to date and actual this period units and costs" have been ticked. I have also tried to change the duration type from "Fixed Duration & Units" to the other types. It seems that the actual cost can only be updated manually if the "Calculate costs from units" is not checked, and this is not an option in my project as the cost needs to be fixed. I did not work on a unit rate basis because one resource often reflects many BOQ items.
I'm running out of options and could really use a hand here.
edit: I found out that the material cost % complete is set to zero on all activities. My initial idea was to go through a gobal change to make material cost % complete = duration % complete. However, I can't find anything related to material cost % complete in the global change.
Replies