M3 Midstream LLC (“Momentum”) is an independent midstream energy company that provides oil and gas producers with flexible, responsive and reliable midstream services linking the wellhead to the market. One of their current projects, Utica East Ohio Midstream, LLC, will be building and operating the largest single location natural gas processing plant in the United States. This growth-oriented strategy has resulted in a history of consistent performance for their stakeholders, including producers, employees and investors.
In the past, M3 Midstream relied on spreadsheets to manage their budgeting and forecasting processes, but like many companies, as they grew and their processes became more complex, it became clear that the manual process was too inefficient and error prone. Momentum’s business model and revenue stream depend on them providing a turnkey natural gas production facility, not only planning for the physical capacity of over a billion dollars in property plant and equipment, but also the human capacity in terms of a trained and productive workforce. Being able to accurately forecast the resulting demand for cash over an 18-24 month pre-production cycle is paramount to our success, said Gina Aspromonte, M3 Midstream Controller. “For each of six operating companies on separate SAGE general ledgers, we need to provide an annual budget and series of quarterly forecast revisions including projecting cash flow requirements over the course of the year. We were spending far too much time chasing down broken links and double-checking formulas for errors.”
“When we started looking at solutions to help manage our process, we knew we needed one that had very detailed cash forecasting capabilities and that led us to Budget Maestro. We also liked the fact that Budget Maestro has user defined drivers to create and revise our budget and forecasts automatically as we adjust these key volume and rate metrics. This process helped us create our annual budget 50% faster than using spreadsheets in the first year. Now that our model is set up, we expect to save even more time creating next year’s budget. Managers from across the organization were able to gather together in virtual forecast planning sessions and watch how discussed strategy changes would impact their budgets. With each change to assumptions we could verify the projected effect in real time. We set up a series of drivers very specific to our business at a macro level, and were able to compare not only the financial impact but also compare these assumptions on versions and see differences between budget forecast and actuals.
Adjustments to forecasted volume by customer and changes in processing cost are the primary focus of our operations and maintenance budget. Seeing the immediate effect of these changes is crucial in managing our performance. After processing costs, our next largest expense is personnel, which is by far my favorite module in Budget Maestro. We are delighted with the granular payroll tax calculations and especially how easy it is to adjust for actual start date and the natural cascade of related expenses. If people aren’t hired or we staff up a facility more quickly than planned, these personnel expenses have a dramatic impact on cash flow.
Before Budget Maestro, it would take us two or three days in Excel to show the impact of adding a major new greenfield project or selling a part of an existing asset. Now we can model major changes in a matter of hours. Minor changes are done with management in a real time strategy session. Making on the fly adjustments and seeing the decision’s impact with confidence gives us better decision making information which will have a positive effect on our bottom line. Budget Maestro also gives us the capacity to communicate budgets to our employees at a more detailed level, empowering our employees to make a positive effect on our bottom line.”
Industry: Energy & Utilities
G/L System: Sage 500
“Budget Maestro also gives us the capacity to communicate budgets to our employees at a more detailed level, empowering our employees to make a positive effect on our bottom line.”
– Gina Aspromonte
M3 Midstream Momentum
“When we started looking at solutions to help manage our process we knew we needed one that had very detailed cash forecasting capabilities and that led us to Budget Maestro. We also liked the fact that Budget Maestro has user defined drivers to create and revise our budget and forecasts automatically as we adjust these key volume and rate metrics.”
– Gina Aspromonte
M3 Midstream Momentum