Formula to drive forecasts

[BRISBANEBOB]

I am trying to create a forecast.

Beyond the current date, the budget becomes the forecast for that and all following month's production. If the production falls below the budget, the shortfall is made up in the following year

Any budget shortfalls are made up in the next year using the average monthly budget numbers. The end result should be a chart where the Forecast and Budget lines meet.

I have attached an example.

Thanks for any assistance.

[FDibbins]

How is this thread different to your other thread here...
http://www.excelforum.com/excel-gene...forecasts.html

I am closing this 1 now, if you think this is not teh same as the other, PM me and I will re-open this