Prophix ad hoc reporting

Getting to grips more with the ad hoc reporting of the Prophix forecasting software.  With a bit of practice it is getting much easier to compare actuals, budgets and forecasts sliced and diced in different ways to give overviews or spot variances.  I remain really impressed by the way detailed (hidden until needed) lines can be added in the explain changes - invaluable in explaining changes.  The reporting of this detail is not good so far but a fix is on the way.  For the moment, budget managers continue to be wowed when I drill down and show them that the reason a number looks odd is that I have incorporated a change that they asked for a few weeks before but have since forgotten about.

Prophix Forecasting update

Had update training on Prophix P10 forecasting software, following replacement of P3 Personnel module with DPM (detailed planning manager).  Looks good having all the data in one module so that personnel changes feed through to the P&L more quickly.  Also allows improved reporting from the Ad Hoc Report Generator which feeds to Excel - so this should allow easier people cost variance analysis against future actuals.

Budgeting and forecasting

Budgeting and Forecasting – Best Practices | Striking an Enterprise Performance Management Balance

Must look into options other than Excel and Winforecast.