Hatch
Hatch supplies engineering, project and construction management services, process and business consulting and operational services to the mining, metallurgical, energy and infrastructure industries.
Loading
Mining & Metals Power Oil & Gas Infrastructure Services Technologies
 
Business System Projects
 
Forecasting and Capacity Utilization

Forecasting and Capacity UtilizationUnion Gas conducted an initiative to better utilize its physical and contractual assets. A solution that provided one view of the information that would allow it to make the best decisions on how to maximize utilization and profits.  A solution was delivered for storage assets but in the future it will be expanded to include transportation assets.  The solution has the following major components:

  • Historical daily data for analysis and regression engine to look for historical usage patterns
  • Forecast engine to create daily forecasts of each contract’s activity
  • Scenario management to allow generation of forecast based on “what if” conditions
  • Proposal management to allow entry of proposed deals
  • Model of physical constraints to ensure all forecasted activity is possible
  • Business Intelligence reporting architecture to allow users to analyse information and drill into all the data

Users can review historical data to look for regression patterns and understand how their customers use their assets and when the best opportunities are available to sign deals. A forecasting system allows them to reliably predict their future positions. With this information they can assess what future opportunities are available and when best to take advantage of them. System combines real-time data for weather, commodity and foreign exchange futures market pricing and order transactions from the gas management system.

Scope of Services
Hatch provided the following services to Union Gas:

  • Analysis to define and document functional system requirements in functional specification
  • Design of complete solution documented in design specifications
  • Development of system testing and implementation of multi-tier application architecture using Microsoft .NET architecture, Oracle database and Oracle Business Intelligence Suite
  • Selection, definition and implementation of a business intelligence tool to provide pre-defined and ad-hoc reports
  • Project management

Project Highlights

  • Client was able to identify opportunities within months of implementation that helped to reduce the project payback time
  • Provides one central point of for decision making and analysis where all data is available to the users. They can review pre-defined reports or develop their own queries to help with the decision process
  • Scenarios allow for many “what if” conditions to be assessed in order to understand the risks if those conditions arose.  Risk can quickly be assessed and mitigated to address management concerns and speed up the decision process
  • Project delivered as a phased solution to allow costs to be spread over multiple years and users to be able to accept system on a modular basis
  • Continuous user feedback was designed into the project through the use of prototypes and an “Agile” development philosophy
  • Project delivered within budget and on schedule


Project Stats

Client:
Union Gas Limited

Location:
Chatham, Ontario, Canada

Start:
July 2007

Completion:
October 2009

See more Business System
projects
>

Your Careers Starts Here
Articles

See conference papers for our Management Consulting services.


More Information

Request more information on our Business System services.
Our Band of Principles