Some ways we've utilized Adaptive Planning that might be unexpected have been for Corporate Overhead Allocation planning. Prior to using Adaptive, we allocated shared service (HR, IT, Finance, Legal, Office Space, etc) expenses based on a number of factors including headcount, revenue, time spent, etc, but had no way to project out future allocations to our 8 subsidiaries that were allocated these expenses. This was a problem as one of our subsidiaries was growing revenues and headcount at a much faster rate than the others. With Adaptive we were able to utilize new accounts for future drivers that tied into our personnel planning and revenue plans, as well as others, to forecast future overhead allocations in real time, as users made changes to their plans. This is not only a great benefit for P&L projections, but also a time saver for finance when doing quarterly reforecasts, where we no longer have to spend a few days updating projections for the year.
We've added the Discovery Visual Display tool from Adaptive Planning and have been able to display key metrics, that we couldn't easily track and display in real time before, including some alternative asset based fee metrics. Also, we've been able to add some capabilities using Discovery including scorecards and metrics that we utilize across all of our subsidiaries, including some variance and year over year displays. Discovery allows us to easily filter these metrics by company to easily change views and keep the same metric display.
Adaptive allows us to create sub-departments that roll up to reporting departments, which allows us to grant access to users who might only plan sales-related expenses for a single department, even though we don't specifically report sales data separately. This has been a time savings for managers who can know focus on more value-added activities and decentralizes the planning process for that department.
We've been able to create multiple reports that have allowed us to conduct more accurate accounting reviews during the month-end close process. Some of these reports include account averages for the prior 3-months, while reporting variances from that average as well as variances from plan data. This allows us to more easily identify entries that need review.
For two of our subsidiaries, we've been able to create sheets where we can plan revenue on customer level by month. This is something we hadn't plan to do after purchasing the application. However, the ease of planning, updating data through excel imports, and linking the output to specific plans and accounts, allows us to have a much more accurate forecast of revenues for both of these subsidiaries.