Broadcasting
| Function: | Products: |
| Budgeting | IBM Planning Analytics |
Challenge
A publicly traded television broadcasting company that owns and operates more than 175 stations across the U.S. has a very granular budgeting process and plans down to the individual employee. The calculations in the model include detailed benefits and taxes, combined with multiple bonus calculations that depend on results from the core financial model. Due to the size and complexity of the process, “top of the house” reports took more than 10 minutes to properly refresh.
Solution
Revelwood analyzed the existing calculations and the interaction of the various models to determine an efficient order of processing. Due to the need for an order of operations, many of the live rules were converted into on-demand TurboIntegrator scripts.
Results
This approach shrunk refresh time from one minute down to a few seconds, while also bringing the “top of the house” analysis down to under 20 seconds.