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.

Budgeted Cost Calculation

6 replies [Last post]
Kannan CP
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 12 Jun 2008
Posts: 290
Groups: None

Hi,

I am stuck with an issue related to the budgeted cost calculation, where the normal procedure is (Budgeted Units x Price/Unit= Budgeted Cost).

My setting for unit of time is hour and the price/unit is 1. The problem is in the calculation process of BC, which always consider a value of 0.125  to multiply with the BU in order to get the BC.

For eg: BU=100 and price/unit=1, but the BC is calculated as 100x0.125 =12.5

If the setting for unit of time is changed to day, the calulation will be 100x1 =100, which I think is wrong.

All other resources are working perfectly except one (with above issue).

Am I missing any setting for this resource?

Thanks and Regards

Kannan

Replies

Zoltan Palffy
User offline. Last seen 4 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

I assume that your planning unit is days 

go to edit users preference

click on the Time Units tab

look under Units format the unit of time should be hours

look under duration format unit of time should be day

go to the resource directory 

click on the details tab 

on the right the Defaut Units/ Time this should be 8.00/d

 

 

Kannan CP
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 12 Jun 2008
Posts: 290
Groups: None

Hi Zoltan,

Thanks for the reply.

How to change the units of the resource from days to hours?

 

Rergards

Kannan

Kannan CP
User offline. Last seen 4 weeks 2 days ago. Offline
Joined: 12 Jun 2008
Posts: 290
Groups: None

Hi Zoltan,

Thanks for the reply.

How to change the units of the resource from days to hours?

 

Rergards

Kannan

Zoltan Palffy
User offline. Last seen 4 weeks 3 days ago. Offline
Joined: 13 Jul 2009
Posts: 3089
Groups: None

your resource calendar must be in days and 

that is because your default units/time f0r that resource is set to 8 so 1/8= 0.125

this says your are working 8 hours in 1 hours so the unit per hour is 0.125

if you are using hours then 

so 100x0.125=12.5

if you are using days then 

the default units/time is 8 and 8 hours per day so 8/8=1

and 100 units x 1 = 100 which is correct

F A
User offline. Last seen 6 years 34 weeks ago. Offline
Joined: 8 Sep 2012
Posts: 8
Groups: GPC Qatar

Hello Kannan

Try running Re Calculate assignment cost in Tools . It might help to solve this.

Cheers

 

F A
User offline. Last seen 6 years 34 weeks ago. Offline
Joined: 8 Sep 2012
Posts: 8
Groups: GPC Qatar

Hello Kannan

Try running Re Calculate assignment cost in Tools . It might help to solve this.

Cheers