The default formula for computing actual cost is (actual units)*(price/unit). Is there a way to change/tweak the formula of actual cost so that it should be (actual units)*(price/unit2)?
In my project, the budgetary unit cost is different from the actual unit cost of a particular item. For example, the unit price of concrete rises from $70.00/cu.m. to $80.00/cu.m. I want this to reflect on my programme, in which i input (price/unit)=$70.00, and (price/unit2)=$80.00 for concrete. In budgeted cost, I use $70.00 (price/unit) as its unit cost and as for the actual cost, its unit cost should be $80.00 (price/unit2).
Thanks in advance.
Yes but the procedure shall be similar, the concept of cost periods is universal, we just need someone who can give us the details on how P6 does it if you cannot figure it out.
If you want to keep it simple, instead of using a second set of cost periods using a second set of cost codes just keep the original in the Baseline and new values on the updates. I was showing the two sets on the same file as you suggested a second value on the same file.
Regards,
Rafael
@Rafael Davila:
your using a different software, right?
Unfortunately, we only use P6 in our firm.
Cost shall be computed based not exclusively on a single fixed cost but on cost that vary with time, inflation is kind of universal. Only in short duration jobs unit prices will not vary. Most software provide some table where you will be able to relate unit prices with time. A table most probably similar to the one used to define variable resource availability with time.
Use separate cost accounts (or cost components in Spider) for initial budgeting using estimated unit costs that can vary with time. Similarly you can use separate cost accounts for reporting actual cost and revised budget based on actual unit prices using a cost periods table that reflect actual changes in unit costs.
In summary for every budget unit cost you will need two cost accounts to track initial budget versus revised budget and actual forecast.