- Customer Stories
- Ag Energy Co-operative

Answering questions you wouldn’t know to ask

SAS analyzes commodity market risks to improve trading decisions.

Balanced portfolio
right to the gigajoule
Ag Energy achieved this using • SAS® BookRunner®
Ag Energy gains deeper insights into commodity risk management with SAS® BookRunner®
During the financial crisis of 2008, the natural gas market experienced its own chaotic fall. The price of natural gas peaked at almost $14 per MMBtu before plummeting to just above $3 only nine months later. Those involved in the industry at that time still remember the lessons of that extreme volatility.
“It was absolute chaos. It wasn’t a rational time in the market,” recalls Bob Webb, Director of Portfolio and Risk Management for Ag Energy Co-operative. “You experience hard and fast the importance of risk management and the necessity of having an accurate handle on your positions.”
SAS BookRunner has been very helpful in terms of drill-down analytics. We now answer questions daily that we couldn’t have answered a few years ago.Bob Webb Director of Portfolio and Risk Management Ag Energy Co-operative
The dramatic rise and fall of natural gas prices confirmed Ag Energy’s decision to implement a software solution for managing its commodity portfolio. The Canadian natural gas and electricity co-op buys natural gas at wholesale prices and supplies it to 375 agribusinesses across Ontario. Its members range from small farms and greenhouses to large agricultural producers and agri-tech firms such as ethanol plants.
“I’ve used SAS BookRunner for more than 20 years,” says Webb, who turned to SAS while at a different energy company after a frustrating year trying to make a well-known energy trade risk management (ETRM) product generate the necessary results. “At that former company, I had said let’s go back to the drawing board and find software that will actually work. SAS BookRunner gave us what we wanted, so I felt comfortable recommending it to Ag Energy years later.”
Adding value through analytics
Using SAS BookRunner, Webb enabled Ag Energy to accurately reflect its commodity portfolio and trading positions, and expand to a deeper level of analytics. “SAS BookRunner has been very helpful in terms of drill-down analytics,” Webb says. “We now answer questions daily that we couldn’t have answered a few years ago. Not only that, we wouldn’t have even known to ask the questions at all.”
The ability to answer bigger questions has brought significant value to the co-op. In addition to offering energy to members at near-wholesale prices, Ag Energy shares the success of its profitable commodity portfolio. “When we have a good year, we return the profit as patronage shares and dividends back to our members,” Webb says. “We’ve been able to return both for several years.”
Ag Energy has multiple divisions that must be organized in SAS BookRunner while maintaining the discipline of segregating duties between groups in the front, middle and back offices. To balance its natural gas portfolio, each division enters its own transactions into SAS BookRunner. A risk analyst then blends them together to expose where the sales or supply portfolio is out of balance – enabling the company to address those areas.
Ag Energy Facts & Figures
375
Agribusinesses obtain natural gas from Ag Energy
10+
Years as a SAS BookRunner client
90%
Of revenue goes back into Ontario's economy
“I still remember popping champagne the day we were able to balance to the gigajoule using SAS BookRunner,” Webb says. “I’m proud to say we’ve been balanced ever since.”
The SAS platform also enables Ag Energy to move data easily between SAS BookRunner, its customer information system and its accounting software. This shared data is used to generate enterprise-level reports for the executive team as well as specialty reports for sales, portfolio, risk and finance, as well as the co-op’s members.
SAS BookRunner also enables the creation of risk models in a centralized environment. “Recently I asked my risk analyst to explain how unexpected changes in market pricing were impacting our portfolio. What are the moving parts that are causing this shift in mark-to-market and why? A few years ago, trying to answer this question would have been like throwing darts at a dartboard. Now she can slice and dice the data and provide a meaningful answer.”
Keys to success
When asked about the keys to implementing and running a successful commodity risk system, Webb highlights the importance of a pragmatic approach and quality vendor support. “One thing that can cause an ETRM package to crash and burn is if it’s so complex that end users can’t fully appreciate all that’s happening,” he says. “If you can’t get something to work right, and you can’t fix it, you’ll end up washing your hands of the software unless you can get help. Thankfully the SAS support team is second to none.”
Webb is excited to continue harnessing his team’s analytical skills to take full advantage of the platform. As Ag Energy expands into carbon credits, foreign exchange and other new markets, he believes the growing expertise of his young analysts will help generate ideas and solutions the veteran risk manager never thought possible.
With SAS BookRunner, Ag Energy is better positioned to weather the next round of drastic market fluctuations. “To stay on top of things, one of our philosophies is to stay current with technology,” Webb says. “Once you have analytical tools, it makes you want to analyze other things and ask questions you wouldn’t have asked before. It becomes addictive.”
Next steps
본 문서에 나오는 결과는 본 문서에 설명된 특정 상황, 비즈니스 모델, 데이터 입력 및 컴퓨팅 환경에 적합하게 되어 있습니다. 각 SAS 고객의 경험은 고유한 것으로, 비즈니스 및 기술적 변수에 따라 달라집니다. 따라서 모든 서술은 비전형적인 것이라는 점을 고려해야 합니다. 실제 절약, 결과 및 성능 특성은 개별 고객의 구성 및 조건에 따라 달라질 수 있습니다. SAS는 모든 고객이 비슷한 결과를 달성할 수 있다고 보증하거나 진술하지 않습니다. SAS 제품과 서비스에 대한 유일한 보증은 해당 제품 및 서비스에 대한 서면 계약의 보증서에 명시되어 있습니다. 본 문서의 어떠한 내용도 추가 보증을 구성하는 것으로 해석될 수 없습니다. 고객은 SAS 소프트웨어의 성공적인 구현에 따라 합의된 계약적 교환 또는 프로젝트 성공 요약의 일환으로 성공 사례를 SAS와 공유했습니다. 브랜드 및 제품 명칭은 각 기업의 상표입니다.