Hunt Consolidated, Inc.

4,500             Dallas, TX
Employees      Headquarters

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.

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.