“Previously, we couldn’t provide true driver-based planning, and it was a challenge just to create one version of a plan. Now, businesses are modeling all types of scenarios, even within a single forecast cycle, and because they now own it, they have a much clearer understanding of how the data is behaving in the model and how to change it to create another scenario.”
John Gooch, Business Warehouse Manager
4,500 Dallas, TX
Hunt Consolidated, Inc. is one of the largest, privately held firms with business units focused on oil and gas exploration and production, refining, LNG, power, real estate, investments, ranching and infrastructure.
Challenges and Benefits
- Multiple subsidiaries with diverse and highly complex forecasting models
- Historical bottom-up approach to financial planning
- Lack of centralized budgeting or forecasting processes
- Disparate practices across units required enterprise-wide process reengineering
- Top-down, rate-driven system
- Granular views via integrated reporting across subsidiaries
- Greatly reduced query times
About the Project
While one subsidiary, Hunt Oil Company (HOC), operates a capital expense-based business with multiple simultaneous projects spanning years, others would rely on cash flow analysis or waterfall structure calculations. Because of these variations, budgeting and forecasting had always been the responsibility of the independent business units, with minimal centralized planning.
HOC formed a capital planning and forecasting team, supported by changing reporting requirements from its existing SAP Business Warehouse (SAP BW) system. With more insight into capital expense transactions out of SAP ERP, the team began to consider long-term forecasting in the context of defined processes to drive actuals.
With the goal of implementing the solution for each business, HOC couldn’t configure the new system for the standalone business without factoring in others’ needs. To design the landscape, the team incorporated as many similarities as possible into a harmonizing layer.
While planning models might differ considerably between units, they’d share basic entries within the general ledger view. A sub-layer would contain the models proprietary for a specific business unit, so each would have its own dimensions and calculations specific to its operational planning needs. This approach made it easier to consolidate every plan into a singular finance plan for the organization at the top.