L
Laura
Hi, I would like to find a way of more easily doing the following:-
To put it simply, say project X is made up of 10 cost items, lets say
the total forecast value of the project is £100, and each of the line
items represents a forecast of £10. The project is set to run for 10
months, and line item 1 has forecast costs of £10 in month one, line
item 2 has forecasts costs of £10 in month two... and so on, down to
line item 10 which has forecast costs of £10 in month 10.
Another way of stating the above would be to say that line item 1 has
forecast costs falling into the period 0-10% of the total project time
frame, and line item 10 has forecast costs falling into the period
90-100% of the total project time frame.
What I want to know is, that if I then have another project of a very
similar nature (say project Y), that has the same total forecast value
of £100, but it being run over a period of 20 months, what way can I
use excel to adapt my forecast from 10 mths to 20 mths (clearly here I
have just multiplied my project period by 2, but it could just as
easily be by 3, 1.5, 1.7 etc etc)
In the scenario of project Y, line item 1 representing £10 of forecast
costs would still fall into the first 10% of the project, but now,
instead of the total cost falling into month one, it would have to be
split over the first two months - 50% in each
Of course this is a very simplistic version of the forecasts we really
do, but I thought if I should start simple!!!
What I really want to do is build a model where I can plug in my new
forecast value and tell it the total time period the project is running
over, and it will then indicate to me in what months (or weeks) that
cost will fall (assuming that the project conforms to the usual
"model").
Any help would be very much appreciated.
Thanks in advance
Laura
To put it simply, say project X is made up of 10 cost items, lets say
the total forecast value of the project is £100, and each of the line
items represents a forecast of £10. The project is set to run for 10
months, and line item 1 has forecast costs of £10 in month one, line
item 2 has forecasts costs of £10 in month two... and so on, down to
line item 10 which has forecast costs of £10 in month 10.
Another way of stating the above would be to say that line item 1 has
forecast costs falling into the period 0-10% of the total project time
frame, and line item 10 has forecast costs falling into the period
90-100% of the total project time frame.
What I want to know is, that if I then have another project of a very
similar nature (say project Y), that has the same total forecast value
of £100, but it being run over a period of 20 months, what way can I
use excel to adapt my forecast from 10 mths to 20 mths (clearly here I
have just multiplied my project period by 2, but it could just as
easily be by 3, 1.5, 1.7 etc etc)
In the scenario of project Y, line item 1 representing £10 of forecast
costs would still fall into the first 10% of the project, but now,
instead of the total cost falling into month one, it would have to be
split over the first two months - 50% in each
Of course this is a very simplistic version of the forecasts we really
do, but I thought if I should start simple!!!
What I really want to do is build a model where I can plug in my new
forecast value and tell it the total time period the project is running
over, and it will then indicate to me in what months (or weeks) that
cost will fall (assuming that the project conforms to the usual
"model").
Any help would be very much appreciated.
Thanks in advance
Laura