Re: Does resource overallocation, past and present, affect the EVM fig
- From: "Steve House [Project MVP]" <sjhouse.remove.this@xxxxxxxxxxxxxxxxxxx>
- Date: Sat, 30 Jul 2005 07:14:49 -0400
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.
.
- Follow-Ups:
- Prev by Date: Re: Changing language, i e days, duration, start, end, etc
- Next by Date: Re: Earned value and project management deliverables
- Previous by thread: Re: Changing language, i e days, duration, start, end, etc
- Next by thread: Re: Does resource overallocation, past and present, affect the EVM
- Index(es):
Relevant Pages
|