none
MS Project 2016 - Remaining Cost is not calculating correctly RRS feed

  • Question

  • I have a task that has Work totaling 327.25 hours, at a rate of $56.38 per hour. Resource is allocated at 100%. Remaining Cost should equal $18,450.35. However, the total Remaining Cost is calculating as $10,250.20.

    The duration of this task is 180 days.  I did not that if I change the duration to 100 days or less (didn't go less than 40 days), that the Remaining Cost does calculate correctly.

    Cannot determine what the issue is.  Any thoughts?

    Monday, August 5, 2019 6:26 PM

Answers

  • Cost = actual cost + remaining cost.

    actual cost = % complete * cost

    % complete = actual duration/duration

    duration = actual duration + remaining duration

    File, options, schedule: 1 day = 8 hours (default)

    Task type: fixed duration, effort driven = off

    Work = 1440 hours, cost = $81187.20.

    If your total work is 327.25 hours instead of 1440, then 1 day = ? hours and/or resource assignment = ?%

    % complete = ?

    Tuesday, August 6, 2019 12:26 AM

All replies

  • What is the total cost value (not total Remaining cost).   

    Ben Howard [MVP] | web | blog | book | downloads | P2O

    Monday, August 5, 2019 9:50 PM
    Moderator
  • Cost = actual cost + remaining cost.

    actual cost = % complete * cost

    % complete = actual duration/duration

    duration = actual duration + remaining duration

    File, options, schedule: 1 day = 8 hours (default)

    Task type: fixed duration, effort driven = off

    Work = 1440 hours, cost = $81187.20.

    If your total work is 327.25 hours instead of 1440, then 1 day = ? hours and/or resource assignment = ?%

    % complete = ?

    Tuesday, August 6, 2019 12:26 AM