Thanks, but can you please write out a sample formula...assuming $10MM over
12 months...once I see the formula and use it I will be able to better
understand the interaction...Thanks!

"Mike Middleton" wrote:

RLind -

Since the normal distribution (bell curve) theoretically goes from minus
infinity to plus infinity, you have to make a choice about where to start
the twelve intervals on the X axis. Then you can use the NORMSDIST worksheet
function to get the cumulative probability for each of the twelve intervals,
subtract to get the probability in each interval, and then multiply each
probability by the total cost. The probabilities for months one thru six are
the same as the probabilities for months twelve thru seven.

If I start at Z = -2.5 and use steps of 0.5, the probabilities are
0.0062097
0.0165405
0.0440571
0.0918481
0.1498823
0.1914625

If I start at Z = -2.0833 = 25/12 and use steps of 0.4167 = 5/12, the
probabilities are
0.0186104
0.0291799
0.0578594
0.0966786
0.1361327
0.1615389

In general, to use this approach, the steps are one-fifth of the negative
starting value of Z.

- Mike
http://www.mikemiddleton.com

"RLind" wrote in message
...
Hello -
I have a project that will cost $10MM to build over 12 months. I would
like
to spread the costs out in a bell curve shape. For example, I would like
something similar to the following costs...
Month 1 - $100,000
Month 2 - $150,000
Month 3 - $225,000
....
Month 7 - $2,000,000
Month 8 - $3,000,000
...
Month 11 - $150,000
Month 12 - $100,000

Is there a formula I can use where I can input the total costs and the
time
period to allocate so that it will spread my costs out over that time
period
in a Bell Curve fashion?

Thanks for your help!