Industries >Oil & Gas
Operational Forecasting, Capacity Planning
IBM Cognos TM1
This oil and gas company is in the mid-stream energy infrastructure business. Essentially, they gather various petroleum products, move them from the source,through the pipeline and to the destination of their customers—oil and gas providers. They handle all of the logistical services for managing, moving and storing the oil and gas.
With hundreds of pipelines throughout North America, the company needed to accurately project the flow of oil and gas. In the industry, this is referred to as movement. This information would support better customer analytics and revenue forecasting. Specifically, the company wanted to track two key metrics—volume by barrels per day and revenue dollars by pipeline (by type/grade of product, by customer and by month). For example, the company wanted to be able to forecast how many thousand barrels per day move from a port in Louisiana to a terminal in Sacramento. They also wanted to track, analyze and understand other operational data associated with the movement of petroleum products. These include contracted tariff rates and aggregate movement volumes. Lastly, they wanted the ability to adjust for inflation, overrides and other variables in order to fine-tune the forecast.
Separately, the company also wanted to be able to use operational performance management for capacity planning for terminal storage of oil and gas. The company’s customers have storage contracts for the petroleum products that are being transported. It is vital that the company understands how much spare capacity it has to store oil and gas products. They also wanted to be able to analyze tank utilization in order to be more efficient, and potentially, drive more revenue.
Revelwood turned to IBM Cognos TM1 and built cube models by pipeline. It models the type/grade of oil, the customer, the month, the product’s origin and destination, and other factors. The TM1-based solution now gives the company the ability to accurately forecast volumes of product transported, as well as revenue associated with that movement. The finance team has the ability to analyze their operations by pipeline, by movement and by customer, enabling the line of business managers and executives to make more strategic decisions around how, when, where from and where to, they transport the petroleum products. They also now have the ability to do capacity monitoring on their pipelines in order to prevent projected volumes that would exceed a pipeline’s capacity.
For the terminal storage capacity planning application, Revelwood built a three-tiered cube model which contains information on the maximum number of barrels each tank can store, contract information by tank number, customer contract type, leased volume and the rate the customer is paying to store the product.
Now, the company has much better visibility into its operations and can ask questions such as:
- Are my tanks fully utilized?
- When are customer contracts expiring?
- What contracts are up for renewal?
- Who are my biggest customers?
- What seasonal trends and fluctuations impact the storage of petroleum products?
Lastly, this TM1-based capacity planning model then feeds the relevant data to the financial model, which in turn provides vital operational information to support capital decision making around terminal expansion and other strategic initiatives.
With the IBM predictive analytics-based sales and marketing application, this insurance company is able to prioritize lead lists, resulting in an average 45% success rate for sales. Read More
Using IBM PCI, this B2B retailer can increase incremental sales by optimizing the advertisements it serves up to specific customers in its predictive digital marketing platform Read More
Travel & Transportation (Airline)
With an operational analytics solution in TM1, the airline is better able to identify problem areas in its operations and can understand, react to and plan for trends based on a number of variables. Read More
Media & Entertainment
Using an "ultimates" module in TM1, this entertainment company can capture the expected revenue and costs of film and TV titles and project the overall lifetime value. Read More
Real Estate Investment Trust
A TM1-based capacity planning and lease analysis solution enables this real estate company to analyze granular information by tenant, by lease and by building. Read More
Oil & Gas
Using an operational forecasting and capacity planning solution in TM1, this oil and gas company has much better visibility into its operations by pipeline, by movement and by customer. Read More
As a result of a TM1-based volume planning, demand planning and capacity planning solution, this roofer knows which plants are under-performing or over-performing and how to optimize production. Read More
Food & Beverage
With a TM1-based demand and sales planning system, this brewer can now make strategic decisions on where to invest marketing and sales support by wholesaler. Read More
With a TM1-based volume planning solution, this beverage manufacturer can now anticipate demand based on previous sales volume in many different ways. Read More
With IBM Cognos TM1, this financial services firm can more easily keep track of its clients and its assets under management to better understand how different aspects of its services are performing. Read More
Using IBM Cognos TM1, this global publisher relies on a technical planning model to perform granular, top-down planning, such as by individual subject categories and product types. Read More
With a TM1-based demand planning application, this professional services firm can analyze demand by role, project, geography and status. Read More
Since deploying an incentive compensation solution in TM1, the hotel has seen significant process efficiencies, a reduction in calculation and payout errors and improved visibility for advanced analytics. Read More
With Revelwood Lightspeed and IBM Cognos TM1 on Cloud, this investment bank extended its key financial planning and reporting information to more decision makers throughout its organization. Read More