Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Nov 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Per diem Cost (project 2000)

    I need to budget per diem costs as daily allowances and
    hotel costs - for the moment I calculate it with excel and
    add it in the fixed costs which is added then to the Total
    Cost.
    *) How can I refine this method? Add other cost colums and
    use a formula?
    *) When using other colums, will these costs automatically
    be added to the total cost?

    Dries

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Per diem Cost (project 2000)

    If your perdiem cost is 100 per day, Go to the Resource Sheet, Add a new Resource and set the Standard Rate to $100/D.

    Then assign the resource to the task. If the task is 10 days, the total cost would be $1,000. Suggest naming the resource PerDiem.

    HTH
    Regards,

    Gary
    (It's been a while!)

  3. #3
    New Lounger
    Join Date
    Nov 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Per diem Cost (project 2000)

    Hi Gary,

    the problem is more complex:
    * the resource is working on hourly basis
    * there are different per day costs/resource - depending on the calendar days the resource is incountry: hotel/car/daily allowance/....

    that's the reason I want to make customised fields and add them to the total cost colum - I want to add them to the total cost colum, because then, all predefined fields as ACWP/BCWP/... are working based on this colum.

    Br,
    Dries.

  4. #4
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Per diem Cost (project 2000)

    Can we clarify what it is you are doing a bit more.

    Are your per diem costs based on labor or non-labor costs? If I read your response correctly, then the resource has an hourly rate and then also receives a per-diem based on where they are working.

    What do you mean there are different per day costs/ resource depending on the calendar days the resource is incountry? Are you saying the resource would have different billing rates based on where they are working or the job function they are doing? The Per Diem (assuming Non-Labor) would also change on the location of where they are working??

    You could set up customized fields and do a calculation against them, however, I need to better understand what it is you are trying to do.
    Regards,

    Gary
    (It's been a while!)

  5. #5
    New Lounger
    Join Date
    Nov 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Per diem Cost (project 2000)

    Hi Gary,

    thx for your reply: the thing I try to do is the following.

    I have an installer and this guy needs to go out and do a job in another country:
    1. he is paid an hourly rate (100) and overtime rate (120) - he works 8h/day incountry ; 10h/day (8 normal and 2 overtime) abroad
    2. if this guy is abroad - he gets additional fees based on calendar days (and not on working days) like
    * car: 50/day
    * daily allowance: 50/day
    * local logistic eg telephone: 20/day

    Now, the point is that inserting these customised fields etc, is no problem. The only thing is that a lot of precalculated fields are present in msp like acwp, bcwp, remaining cost etc... But these predefined fields are not taking into account the customised cost fields, so for exemple, cost1 is not added to the msp-total cost field.

    Another thing is that I can not use the analyse timescaled button, to export the data to excel and have a nice graphic: you can not select the customised cost-fields!!!


    So what I want to do is:
    1. insert customise fields (ok)
    2. have the "total cost" field takethese customised fields into account, so I can use
    * other pre-defined fields that are working based on this "total cost " field
    * the "total cost" field to excel with the magic "timescale analysis button" as it is impossible to select other fields to export to excel than the pre-defined msp-fields.

    Best regards,
    Dries.

  6. #6
    New Lounger
    Join Date
    Nov 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Per diem Cost (project 2000)

    Gary,

    The workaround that I now do is:
    1. create all my customised cost fields and a subtotal cost field
    2. copy the subtotal cost field manually to the Fixed Cost field

    that is ofcourse not a neat solution.

    Best regards,
    Dries.

  7. #7
    Star Lounger
    Join Date
    Oct 2001
    Location
    Ellettsville, Indiana, USA
    Posts
    76
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Per diem Cost (project 2000)

    I am not sure if this is what you are loooking for but...
    There are different cost rate tables that you can set up for each resource. Cost Table A is the default...the one you see on the resource sheet. However, if you double click on the resource in the resource sheet and click the cost tab you will find the different tables. Click on the B tab and enter the different cost information...
    Once you have set the different rates you can go to the task usage view and find those task that the resource is assigned to that incure these costs. Double click on the resource and the assignment information box comes up.
    At the bottom right you can select the correct cost rate table.
    Good Luck

  8. #8
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Per diem Cost (project 2000)

    Dries,

    Have you figured out how to make this work yet?
    Upon further review, I suggest the following:

    You Said: << I have an installer and this guy needs to go out and do a job in another country:
    1. he is paid an hourly rate (100) and overtime rate (120) - he works 8h/day incountry ; 10h/day (8 normal and 2 overtime) abroad
    2. if this guy is abroad - he gets additional fees based on calendar days (and not on working days) like
    * car: 50/day
    * daily allowance: 50/day
    * local logistic eg telephone: 20/day >>

    Response:
    - To get the above to work such that your ACWP, BCWS, etc fields work, I would still suggest that you set up your resources with an hourly rate. (In this case, you would need two rates, one for incountry and one or out of country) Then add another resource for per diem which in your case is 120 / Day. The task would then have two resources assigned, one for the resource and one for the per diem. The hourly resource is on a 5 day calendar. The per diem resource is on a seven day calendar. The Cost field will then calculate for the task as the hourly cost (Hourly resource) plus the daily cost (Per diem). I would also suggest that you assign the Resource and their associated Per Diem within the same group, Code, or with similar Resource Names (i.e., Res1 and Res1PerDiem) to allow you filter on like fields or for your excel analysis.

    Unforturnately if you want the Total Cost field add the customized fields, you will need to do this in code. I would try the other alternative which should work as well.

    Don't know if this helps. Good Luck.
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •