Re: Nonlinear distribution of cost for one activity


Steve House [Project MVP] wrote:
IMHO, you're working backwards. Until you have explicitly defined the tasks
and the resources performing them, you don't know, CAN'T know, that the
project budget is $350k and will take 3 years. You have not set a budget or
timeline, you have set some parameters within which you hope you can
accomplish some business objective. The budget and timeline is an estimate
of what will really be required to achieve those objectives. So far, you
have set some goals based on the anticipated availability of assets, in
other words, a distribution of projected revenues. The actual budget may be
under or may exceed those desired parameters.

Don't define an arbitrary cost and then expect the work to expand or
contract to fit.

The cost assigned may not be arbitrary, Steve. I've used Comparitive
Sizing methods many times myself. If I've built 5 compressor stations
already, and I have, when I build the sixth I can make a pretty
accurate estimate of the cost if it is pretty similar. And I can factor
in some differences. Detailed estimating is not the only way to get a
reasonable project estimate. More accurate? Yes. But if there isn't
enough data yet to get one, I've started many projects on a Sizing
estimate based on experience or on published numbers. And they've
worked out quite well.


A task creates a specific, concrete, deliverable. The
task will take how ever long it takes to complete exactly that deliverable,
nothing more and nothing less. You can't stop when the defined deliverable
is 90% complete and it's pointless to continue work beyond the point it is
100% complete. Thus each task has a specific, concrete, exactly measurable
amount of work associated with it. Work costs X dollars per unit - you have
to pay resources to do work or they don't show up and nothing happens. You
pay them a specifc rate or salary. So the cost of doing the work on a task
is defined by the amount of work required to create the deliverable which in
turn is defined by the nature of the deliverable itself. As a result, you
cannot define the budget until you have explicitly defined the tasks,
analysed how much work will be involved in each one, and identified the
human and material assets that will be doing that work and their associated
costs.

If the projected cost is greater than the assets on hand, you cannot
arbitrarily shrink durations to fit - instead you must redefine the
project's objectives to encompass reduced deliverables. As an example, if
my painter paints 10 square feet per hour and we have 1000 square feet of
wall to paint, it will take him 100 hours. If we can't afford to pay for
100 hours, we can't just pull out of thin air that he will do it in 75
hours. The only way we can really get the budget down to within the
resources we have available is erect fewer walls so he only has to paint 750
square feet.

HTH

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


"nitsa" <nitsa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6AA493DD-2BA7-4E37-AF8B-B1F9B7818136@xxxxxxxxxxxxxxxx
I tried what you suggested as a sample on one task:
I defined a resource called "cost" in the resource *** and gave it a
standard rate of $1/hr.

I assigned this resource to the task of which duration was 10 and in the
"assignment information" I defined a bell shape work contour. The outcome
cost was $40.

If I wanted the cost to be a 100, the duration would increase to 25. And
since my planned duration and planned budgets are both given to me as an
input from "outside", all I could do is to change the rate. Am I working
with
the right program?



I entered an activity, gave it a start date and a duration of 10 days. I
--
dani


"Jan De Messemaeker" wrote:

Hi,

Good.
My advice should work for you.
HTH

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"nitsa" <nitsa@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in bericht
news:FFB1C062-D254-4748-8C19-1A4594B988E2@xxxxxxxxxxxxxxxx
Thank you.
Let me clarify my goal so you might be able to help me better:

I am trying to use MS Project in one or two levels above what it is
normaly
used for. I have to monitor a project that is has a budget of $350K and
a
duration of 3 years. The project is divided to roughly 60 tasks (ehch
has
a
duration and budget). I would like to build a plan for "cash flow" and
then
to be able to track it using earned value method. Since I am providing
the
funds, I would like to make sure that the project is on schedule and
budget.

--
dani


"davegb" wrote:


Jan De Messemaeker wrote:
Hi Nitsa,

First, apart from the cost issue, you may get unexpected results
when
entering bith start and finish dates - normally you have both
calculated by
Project (from durations and dependencies between tasks) oer at
least
only
enter satart a,d duration and have finish calculated.

This being said, no, Fixed cost (which is what you enter when you
type
in
cost without having resources) cannot be contoured.
I suggest you create a resource "cost" which you assign to the task
to
create an assignment and then contour the work.

Hope this helps,

--
Jan De Messemaeker
Microsoft Project MVP
+32 495 300 620

I agree with the replies above. I'd also ask, what is the duration of
this variable cost rate task? If it's more than 2 weeks, that is a
problem. A good guideline for task durations is between 0.5 days and
10
days. Tasks shorter than this are micro-planning. Tasks longer than
10
days are very dangerous because you may not know how you're doing on
this task until it's 10 days late. That can be a problem in most any
schedule.

If the task's duration is longer than 10 days, I'd consider breaking
it
down into multiple tasks. If you do that, you might use the "burn
rate", the rate the money is being spend, as a criteria for breaking
it
down. Make a few tasks out of the one, each with a linear (or nearly
linear) burn rate. You've solved 2 problems at once.

I should also mention that if at some time you want to use Earned
Value
Analysis, you will want every task to have a constant burn rate, or
EVA
won't work.

Hope this helps in your world.

http://users.online.be/prom-ade
"nitsa" <nitsa@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9295A12E-86C8-46D4-A14D-11873A809FF5@xxxxxxxxxxxxxxxx
In other words you mean that if I have a task for which I entered
three
values: start, finish and cost and no resource, then there is no
way to
distribute the cost in a nonlinear way?

--
dani


"Jan De Messemaeker" wrote:

Hi Dani,

As long as cost is calculated from resoruce's work, yes, because
you can
contour the work of an assignment (double-click an assignment
line
in a
Usage view to get assignment information, you can select the
contours)
HTH

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"nitsa" <nitsa@xxxxxxxxxxxxxxxxxxxxxxxxx> schreef in bericht
news:13E39BB6-CA05-495D-91B3-CB80EC857405@xxxxxxxxxxxxxxxx
In cases wher the cost of an activity is not uniform, is this
possible,
using
MS Project, to distribute cost in a nonlinear manner such as a
bell
shape
or
a triangular curve distribution?
--
dani









.

Quantcast