UK Stumped!!! Please help

[magicone99]

Hi all

Any help would be greatly appreciated - this is messing with my head!

I am in the middle of a massive cost reforecast and I have managed to reconcile a figure but have no idea how or why it reconciles.

I have 2 forecast figures - one the old forecast , one of the new forecast.

Old Forecast 1,051,962
New Forecast 1,255,085
Variance 203,123

I am currently reforecasting from April 2014 - Dec 2014 - so for that period I have forecasted

Old Forecast 369,750
New Forecast 352,800
Variance (16,950)

When I subtract 203,123 - (16,950) = 220,073

220,073 is the end of March costs variance to the old forecast

I cannot understand why they reconcile?

 

[Counterofbeans]

The first thing I'd take a look at is how you are generating your forecast figures.

 

[kirby]

No mystery.
Difference for first 3 months is 220,073
Difference for last 9 months is (16,950)
Sum of those two equals difference for all 12 months equals 203,123