Forecast Variance and Percent - need help with hours forecast

Hi, I'm new to the forum but have used it many time to find solutions.

Here's a new one I can't seem to find an answer that fist my situation.

In my spreadsheet I have effort hours forecast for 1 month (no rolling history), Forecast hours, Actuals hours reported.

Where I'm stuck is - what's the best Variance calculation when Actual is greater than or less than Forecast?

And would it make the Accuarcy Percent results more useful if I limit it to 0%-100%?

I need a meaningful method to show the variance and accuracy percent. I've read many opinions and theories but none address this specifically so I'm hoping for a good solution here.

Sample attached. BTW, I'm using Excel 2010.
Forecast HoursAccuracyPct.xlsx

Wow, my quest for help still goes unanswered after a month now. Lots of views, not a single reply.

I truely thought this was the best place to ask.

Is my request unclear, not enough info, or is there no one here with Forecast advise to offer?

Maybee like this: