The Budgeting Process at Big West Oil: Spreadsheet Complexity to Streamlined Efficiency with Vena
Big West Oil’s Challanges Before Vena
Big West Oil is a family-owned petroleum refining company that operates the North Salt Lake Refinery in Utah, a facility that has been part of the state’s energy infrastructure since 1948. The company focuses on producing refined petroleum products while emphasizing safe, reliable, and environmentally responsible operations across the Intermountain West.
Fragmented Budgeting System
The budgeting process was managed through 42 separate Excel spreadsheets, leading to a fragmented and cumbersome financial planning framework. The reliance on Excel templates introduced significant limitations, making the budgeting process prone to errors and inconsistencies.
Version Control Issues
The inefficient version control led to confusion over changes and updates to budgeting documents, coupled with a high risk of template disruption. Unintended inputs by users could easily corrupt the data structure, further complicating the budgeting process.
Data Integration Complications
The process involved an upload mechanism using hidden tabs to simplify data for integration into a SQL table for reporting, which was vulnerable to version control issues, requiring manual communication for any data changes. A manual and complex data load process created inefficiencies in consolidating and reporting financial data.
Operational Inefficiencies
Annually creating and updating templates was labor-intensive. This limited additional analysis and creation of additional budgeting scenarios was limiting financial processes.
”We had hands on help from Delbridge to train two individuals in creating and manipulating templates. The templates also provided views into historical budget and actual data for reference.”
Jon Dahlin, Controller
Delbridge’s Approach
Delbridge played a pivotal role in addressing Big West Oil’s budgeting and financial management challenges through a comprehensive and hands-on implementation process. Our approach was characterized by close collaboration, tailored solutions, and strategic planning to ensure a seamless transition to the Vena system.
Hands-On Training and Template Development
Delbridge provided personalized training for Big West Oil’s team, focusing on the creation and manipulation of budgeting templates. This ensured that the team could effectively utilize the new system from the outset. Our consultants worked alongside Big West Oil’s IT department to facilitate the daily upload of accounting data from the company’s ERP system into Vena, enhancing the accuracy and timeliness of financial data.
Customized Financial Templates
Delbridge collaborated with Big West Oil to develop specialized templates for operating and administrative expense cost centers. These templates were designed to include only active General Ledger (GL) accounts relevant to each cost center, streamlining the budgeting process. The templates also incorporated views into historical budget figures and actual financial data, providing a comprehensive reference for more informed budget planning and analysis.
Enhanced Reporting for Executive Review
A key component of Delbridge’s approach was improving the reporting capabilities for Big West Oil. The team focused on creating reports that summarized budget data efficiently, enabling executive leadership to review financial performance and make strategic decisions with greater insight.
Continuous Improvement and Feedback
Post-implementation, Delbridge maintained an ongoing relationship with Big West Oil to gather feedback, provide updates, and make continuous improvements to the system. This approach ensured that the Vena solution remained aligned with Big West Oil’s evolving needs.
”Template generation is much faster and kicking off a new budget workflow is very efficient.”
Jon Dahlin, Controller
Results
Following the implementation of Vena by Delbridge, Big West Oil witnessed significant improvements in its budgeting and financial management processes. The transition to Vena not only streamlined operations but also introduced a level of efficiency and control previously unattainable. The benefits realized from this transformation are evident in several key areas of the company’s operations.
How we deliver impact
Implementation & Deployment
1- Phased rollout strategy to accelerate time to value
- Data integration and security setup
Planning & Reporting Enablement
2- Design reporting and analytics frameworks
- Align Vena to your operating model
Optimization & Continuous Improvement
3- Process refinement and automation
- Data migrations and governance support
Training & Adoption
3- Customized enablement workshops
- Change management support
Managed Services
3- Production support as an extension of your team
- Long-term roadmap and feature adoption
Our featured solutions
Purpose-built data, AI, and industry solutions designed to solve real problems and accelerate your business.
Budgeting for Senior Living
Improve profitability, optimize census, and gain visibility into your data with a pre-configured solution designed for senior living and integrated with the Microsoft 365 apps you already know.
Budgeting for Real Estate
Project Details
Our Vena Expertise
See Vena FP&A in Action
In a live demo, explore how Vena combines the flexibility of Excel with enterprise-grade governance, automation, and real-time visibility, enabling clearer insights and more confident decision-making.
Your FP&A Evolution Starts With Vena
Discover how Vena empowers your organization to plan with confidence, adapt with agility, and turn financial data into strategic insight.
Not sure what you need?
We help organizations evaluate leading solutions, compare the right options, and make confident decisions based on their business needs, technical requirements, and long-term goals.