Performance Management - Multi-Dimensional Forecasting and Reporting

You sell 60 products across 25 countries. In one country you have 5 salespeople. Fairly modest numbers – there could be thousands of products and many more salespeople.

Now you want to forecast sales, cost of sales and gross profit by month. You may have significantly different sales prices, purchase costs or shipment costs in different countries. What about currency and management of currency exposures?

You’ll also want to report actual information against budgets and re-forecasts.

There are just too many dimensions for Excel to handle comfortably. So you have three choices:

• Somehow set up all the spreadsheets and consolidate them
• Simplify the situation into groups of products, groups of countries, and ignore salesperson
• Use a multi-dimensional software tool which lets you look at each dimension, and adds everything up for you automatically

Which will you choose?

If you would like to discuss your options in more detail do contact me by email or ring me on 01628 632914.

.