performance against forecast formula :(

[rini22]

Hi,

Please see attached...

the sheet shows the daily performance (KPIs in orange) against the forecasted orders

im having trouble coming up with a formula that incorporates the forecast, the variance of the forecast to the actual orders received against the performance...

i'd really appreciate any ideas.

Thanks alot!!!!

[snap101]

Can you be more specific? I sorta get what your trying to do but maby you could describe what it is exaclty your trying to do here.

[rini22]

basically, i have to produce a summary of our performance in relation to the forecast we work from.

we sell sports eqipment and we get a weekly forecast, from that we plan the labour we need to fulfill the orders. So what i have attached is for last week.

the grey column is the forcasted orders
the yellow is the actual orders we received
next to that i have calculated the variance to the forecast
the orange highlighted columns are our KPIs for the dyas of last week.

i'd like to figure out a formula that allows for the inaccuracy of our forecast for our daily performance.

hope i've made sense

Thanks alot!!