Food Production/Services: From soil and crop analytics through production, warehousing and distribution, Solve can help you to:
Performance Efficiency for a leading supplier of plastic-based multi-packaging systems for the beer, soft drink and general products industries. Solve developed a performance efficiency application for measuring units, scrap and defects by production line, employee and shift. We also deployed a data collection solution on a Honeywell extruder for performance monitoring and quality control.
Supply Chain Analytics for a food service production company. Solve developed a custom solution to enable the company to run the manufacturing floor enabling team members and management to view products, lines and quantities in production across the floor. Also ensured products could be traced from farm to table, by building a solution that continued to track products from raw material to outgoing SKU.
Shop Floor Process Control for a snack food manufacturer. Solve supported the development and implementation of shop floor statistical process control – leveraging our BI expertise created a solution that enables tracking and analysis of each item and production run. Plus, Solve’s solution also supported the company’s Lean Six-Sigma practices. Solve worked closely with the client’s teams to implement enterprise-level Data Analytics applications covering sales and operations, budget/forecasting and financials. What’s more, NMV and Solve implemented a best-practice data environment designed to enable self-service BI to a group of power users that are responsible for delivering data to end users.
Downtime & Materials Loss Analytics Solve worked closely with the manufacturing team of an international producer of baked goods to implement shop floor data collection analysis around two key value leaks: downtime and material loss. Every downtime event was assigned a failure area, category and cause, as was every scrap event. This allowed us to work with continuous improvement teams in the plants to eliminate the issues and inefficiencies contributing to those value leaks.
In-store Product Supply Chain Solve created a data platform for a national poultry producer that aggregates retail data from a wide variety of sources, including Walmart’s Retail Link, EDI, AC Nielsen, IRI and DunnHumby. The solution automates the identification of shelf and supply chain issues – real-time information that enabled the company to capture tens of millions of dollars of potential lost sales. Also, predictive technologies were used to create supply chain recommendations that were built into departmental workflows – information that reduced waste and, most important, added millions of dollars in annual sales. The investment in business intelligence paid off when it was recognized by multiple grocery chains for excellence in leveraging data to grow categories, and was awarded additional shelf space and distribution.
Sales/Operations/Financial Analytics for a manufacturer of fine vanillas and flavors. With a goal to increase demand globally, the third-generation family owners are eager to move forward into the next phase of the company’s growth.
Solve worked closely with the client’s teams to implement enterprise-level Data Analytics applications covering sales and operations, budget/forecasting and financials. What’s more, NMV and Solve implemented a best-practice data environment designed to enable self-service BI to a group of power users that are responsible for delivering data to end users.
Production Analytics for one of North America’s top producers of turkey, ham, chicken, and beef products. Solve was brought in to create analytical dashboards that would improve visibility into key metrics and provide greater insight into production efficiency, product inventory and delivery logistics. Working closely with the client data team, we quickly created dashboards for inventory on-hand, 10-week inventory and production forecasts for operations, and product distribution metrics for sales.
Financial Analytics From Legacy Systems for one of the top 10 vertically integrated chicken producers in America, offering customers a wide range of top-quality poultry products. The company owns and operate eight production facilities in four states, and employs more than 7,000 team members. The client’s business intelligence capability had been built around legacy technologies, and significant weaknesses were identified especially around key domains like sales, margin and production. In particular, complex business logic was buried in code where there was little to no documentation or awareness.
Solve worked across departments to clarify business logic and ensure data accuracy. The ETL functions were built to include central, transparent handling of business rules, and conformed structures were leveraged to ensure simplicity and scale. Dashboards were created to provide visibility into profitability, sales, accounts receivable, and more. And invoices were recreated as BI visualizations – an innovative solution that allowed quick discovery of the cause of invoice inaccuracies across the organization.