Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Resources and Expenses: Time-scaled by Cost Account in Primavera P6

No replies
Rajesh Khanna Sake
User offline. Last seen 2 years 1 week ago. Offline
Joined: 14 Sep 2006
Posts: 14
Groups: None

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