Business Intelligence Blog from arcplan

Planning Visualizations: Forecasting Charts


My series on planning visualizations has so far explained how to use the right chart types to tell your plan’s story. Today I’ll wrap up with a focus on using visualizations to show how your plan will hold up as the fiscal year progresses. The charts below display forecasts that are based off of 12-24 months of historical data used to predict future results.

Plan vs. Actual Spend: Bullet Visualization with Linear Regression
Good planners know that a plan shouldn’t simply be created, approved and then left to rot on a shelf somewhere. Plans should be managed and updated throughout the year. Even the best plans require changes, especially when it looks like you might be getting off track.

Say you’re a marketing director for a retailer and your fiscal year begins in January. In March, you’re starting to wonder if there will be enough funds in the budget by September to do your holiday season advertising. There’s a way to predict this information, even if you’re only a few months into the fiscal year. A finance professional might run a linear regression and stick a table in Excel to show the progressions of the budget over time. But as a marketer, you’re a visual person and might better understand a bullet chart. Plotting the actual data (in yellow) against the plan data (in gray), it’s easy to see that marketing expenses were understated in the plan from the beginning, or you simply overspent early on and won’t recover without making adjustments to spending. The red bars show just how far off spending will be vs. the plan if you don’t take corrective action:


Continue reading this post >>