Re: Does resource overallocation, past and present, affect the EVM fig

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



You're probably up on the following but for the benefit of others ...

Project will easily calculate ACWPs greater than BCWP. Here's how. Resource Joe Fidmaker earns $10/hr and works 8hr/day. He's assigned to Task X, 5 days duration starting Monday, to make 100 fids. Work is 40 mh, cost is $400. We baseline and start work. BAC=$400. At the end of the 1st day we're on schedule, BCWS=$80, BCWP=$80, ACWP=$80. So far so good. But *WORK* is actually a measure of the effort required to achieve a given output, not the time it takes - this means the BCWS is really the estimated cost of 100 fids, the BWCP is the budgeted cost per fid times the number of fids we have done up to the status date, while ACWP is the actual amount we've spent for the time it took to produce however many fids we've made so far. Coming up at the end of the day Friday, we find we've only done 50 fids, original estimate for duration was low by half so we update progress by entering 5 days Actual Duration (time spent), 5 days Remaining Duration (estimated required to complete) and MSP calculates 50% complete. As of Friday 5pm, BCWS=$400, BCWP=$200, ACWP=$400 (because we still had to pay Joe for the full 40 hours he worked even though it only generated 50 fids). SPI=0.5, CPI=0.5, behind schedule and over budget. We work another week and Joe finishes the 100th fid the following Friday. Now the *work* required to make 100 fids is the same regardless of whether it takes 5 days or 10 and thus the BCWS and BCWP don't increase beyond the baseline when the task runs longer than the baseline estimate. At completion BCWS and BCWP are equal to each other and also equal to BAC regardless of how long it took to get there. But our ACWP *does* change since Joe doesn't put in those extra man-hours for free. When the last fid is added to the pile at the end of 10 days duration, BCWS=$400, BCWP=$400, ACWP=$800, SPI=1, CPI=0.5. Project happily calculates that for you IF you enter actual/remaining duration and don't simply mark the task 100% done without entering actual performance.

--
Steve House [MVP]
MS Project Trainer & Consultant
Visit http://www.mvps.org/project/faqs.htm for the FAQs



"RTucker" <RTucker@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:CA3AAD11-8C83-4FB9-8DFF-CC4EDC534210@xxxxxxxxxxxxxxxx

....
Allowing MS Project to calculate Actuals is not good practice. How could
you ever experience an ACWP greater than the BCWP? You wont, therefore,
you're fooling yourself and the customer. If you slip and need to catch up
by creating a corrective action plan to work OT, where will it be shown?


....
BOL,

RTucker, PMP


"Evan" wrote:

A client of mine had this question, and I had a halfway finished response,
but realized I needed cleverer minds that I to help me.


I have a master schedule that shows resources actuals overallocated in the
past. Since I let Project allocate the actual hours ( I enter them on a
weekly timescale) I will probably get numbers that have 10 hours one day, 2
hours the next and so on. As long as the weekly resource is not working over
40 hours a week, the EVM should not be affected I am guessing. Please let me
know if I am mistaken.


For future overallocations, I don't think the BCWP or BCWS is affected, but
the ETC might be. To me, that affect would be insignificant since the EAC
would stay the same if the total remaining work was correct, despite
overallocations at different intervals changing the slope of the ETC line
(graphed out in Excel).


I hope I am making sense, if I am please let me know if I am crazy in my
thought process.



.



Relevant Pages

  • Re: Does resource overallocation, past and present, affect the EVM
    ... Even though you've finished the hole in half the time, at completion BCWS and BCWP are both equal and you did *2* hours worth of work in *1* hour of time (ACWP) ... ... If you draw a parallel to electrical consumption, "units" is equivalent to a heater's wattage rating, "work" is the kilowatt-hours consumed to heat a space, and "duration" is the time during which you operate the device. ... X, 5 days duration starting Monday, to make 100 fids. ...
    (microsoft.public.project)
  • Re: % Completed vs BCWP
    ... The duration is 40 hours, ... The BCWP and the ACWP will be the same if the resource costs and duration ... Calculation page uncheck the box for "Updating task status updates resource ...
    (microsoft.public.project)
  • Re: The BCWP for delayed tasks?
    ... duration of your incomplete work to reflect a new finish date after 20 MAR ... I found something confused for the BCWP calculation. ... The calulation of ACWP is correct for the tasks which's finish later than ... current date as below.(BCWP = Baselined Cost * Physical % Complete, ...
    (microsoft.public.project)
  • Re: How is BCWP calculated
    ... Hover your mouse over the column title for BCWP and then click on the Help ... This takes you to the correct help page and a description of ... Do the same for ACWP. ... Also, if BCWP is calculated as % of duration complete, is ACWP calculated ...
    (microsoft.public.project)
  • Re: Problem with dates/durations on a plan containing imported dat
    ... duration, that you expect your resources will require to complete the work. ... and the resource assignment but NO dates at all (other than the single entry ... >> and I look at a task that says we must produce 80 fids. ... >>>> Project Calendar to see what the master hours of work are? ...
    (microsoft.public.project)