The schedules I am currently working on have both resources and expenses assigned to activities. In order to be able to track approved cost modifications to the project, I assigned cost accounts to both resources and expenses. I was expecting, it would help me print a time-scaled summary by cost- account. Unfortunately, when I run a report to summarize by cost accounts, it summarizes only the resource costs and ignores all expenses.
Example: To explain the problem in more detail –
Activity-A (4 weeks duration)
Resources –
Resource-1……… Cost Account-1 (Modification-1)….$100
Resource-2……….Cost Account-2 (Modification-2)….$200
Expenses –
Expense-1………...Cost Account-1 (Modification-1)….$20
Expense-2…………Cost Account-2 (Modification-2)….$40
Total activity cost …………………………………………………………. $360
When I look at a time-scaled report, it looks similar to this – (considering a linear distribution)
Activity Name …………………………… Week1 Week2 Week3 Week4
Activity-A $90 $90 $90 $90
Is there any way I can get a report similar to the one below?
Cost account ……………………………. Week1 Week2 Week3 Week4
Cost Account-1(Modification-1) $30 $30 $30 $30
Cost Account-2(Modification-2) $60 $60 $60 $60
-------------------------------------------------------------------------------------------------------
Total $90 $90 $90 $90
I could think of only cost accounts to relate resources and expenses. Please suggest any other way in which I can generate such reports.
I appreciate any help in this regard.
Many Thanks,
Rajesh