Download PDF
Central Data Repository and Audit Trail Cut Forecasting Time Down by Hours
Technology Category
- Analytics & Modeling - Predictive Analytics
- Application Infrastructure & Middleware - Data Exchange & Integration
- Platform as a Service (PaaS) - Data Management Platforms
Applicable Industries
- Mining
Applicable Functions
- Business Operation
- Quality Assurance
Services
- Software Design & Engineering Services
- System Integration
The Challenge
The finance team of a leading North American mining company faced significant challenges in managing their forecasting data. All forecasting data was stored in a single, complex workbook that was prone to being lost or damaged. The use of uncontrolled spreadsheets allowed unauthorized changes to data, formulas, and calculations, making it difficult to track the status of the forecast or determine which user made specific changes without exchanging emails or phone calls. Additionally, making real-time changes to the forecast was cumbersome because relevant information was scattered across disparate spreadsheets that required manual sorting and review.
About The Customer
The customer is one of North America's leading mining companies, responsible for forecasting the value of all their shipments. The finance team had to manage a 30-page linked workbook that contained numerous factors affecting the value of shipments before they reached customers. The need for real-time changes to the forecast was critical, given the dynamic nature of the mining industry. The company required a robust solution to streamline their forecasting process, enhance data security, and improve overall efficiency.
The Solution
Vena provided a comprehensive solution by integrating a secure, central database that seamlessly synced with the client's General Ledger (GL) and Ellips. This central repository automatically stored all the company's up-to-date spreadsheets, templates, assumptions, and drivers, eliminating the need for manual work. Vena's detailed audit trail feature date-, time-, and user-stamped all changes made to spreadsheets, enabling managers to easily roll back to previous versions and compare changes over specific time periods. The finance team could now create quarterly, weekly, monthly, and even daily forecasts, and perform what-if modeling by changing assumptions and visualizing their effects on forecast scenarios. This allowed for more informed decision-making and improved the overall forecasting process.
Operational Impact
Quantitative Benefit
Related Case Studies.
Case Study
Underground Mining Safety
The goal was to produce a safety system to monitor and support underground mining operations; existing systems were either too simple (i.e. phone line) or overly complex and expensive, inhibiting deployment, and providing little-to-no support in event of an accident. Given the dangerous nature of the mining work environment and the strict regulations placed on the industry, the solution would have to comply with Mine Safety and Health Administration (MSHA) regulations. Yet the product needed to allow for simple deployment to truly be a groundbreaking solution - increasing miner safety and changing daily operations for the better.
Case Study
Mining Firm Quadruples Production, with Internet of Everything
Dundee Precious Metal’s flagship mine, in Chelopech, Bulgaria, produces a gold, copper, and silver concentrate set a goal to increase production by 30%. Dundee wanted to increase production quality and output without increasing headcount and resources, improve miner safety, and minimize cost.
Case Study
Fastenal Builds the Future of Manufacturing with MachineMetrics
Fastenal's objective was to better understand their machine downtime, utilization, quality issues, and to embrace cutting-edge manufacturing technology/process improvement capabilities to bring their team to the next level. However, there was a lack of real-time data, visualization, and actionable insights made this transition impossible.
Case Study
Joy Mining Systems
Joy equipment faces many challenges. The first is machine integration and control. The business end of the machine has a rapidly-spinning cylinder with 6-inch diamond-studded cutting teeth. It chews through rock at rates measured in tens of tons per minute. The system grinds through the rock in front, creating a rectangular mine tunnel. Hydraulic lifters support the ceiling as the machine moves forward. Automated drills and screws drive 3-ft long screws into the ceiling to stabilize it. The rock and coal fall into a set of gathering "fingers" below the cutting cylinder. These fingers scoop up the rock and coal and deposit it onto a conveyor belt. The conveyor passes under the machine and out the back. A train of conveyor belt cars, up to a mile long, follows the cutter into the mine. The rock shoots along this train at over 400 feet per minute until it empties into rail cars at the end. Current systems place an operator cage next to the cutter. Choking dust (potentially explosive), the risk of collapse and the proximity of metal and rock mayhem make the operator cage a hazardous location.
Case Study
Improved Monitoring in Industrial Manufacturing Facility
When your crane is moving tons of magma-hot iron, you can’t afford an unexpected failure. McWane Ductile knew monitoring the crane motor metrics within their facility could help prevent a mechanical failure that would strand an enormous bucket of molten metal overhead. Unfortunately, their legacy wired monitoring system couldn’t work with moving objects in this extreme environment. If they could integrate wireless capabilities into their existing equipment they could extend their monitoring capabilities without starting over from scratch.