Case Study - Data Warehousing with Contract Manufacturer and Supplier

"Vizion saved us over 80 hours of manual reporting and the solution immediately exposed us to data that allowed us to make quick decisions that positively affected our bottom line."

 

- CFO



Company Background

Industry - Food Services

Technology - Data Warehouse

 

Our client is a leading contract manufacturer and private label supplier for the food industry in North America, whose primary focus is “snacks”. The organization has eleven GFSI compliant state-of-the-art, geographically diverse production facilities operating in 10 cities throughout the United Sates and Canada. 

 

Business Issue

This organization was having trouble with data collection to accurately monitor and calculate commission reporting and payments. The commission structure in place was not universal and composed of multiple deals and multiple structures. The only method for analysis and ultimate payment was the use of multiple spreadsheets being mashed together to produce the data.

 

In total, the work to generate these reports took over 80 hours every week. Furthermore, the accuracy of the data was always an issue and the business had no definitive process in place to verify the results.

 




Vizion's Solution for Client Success

Our solution to help the client solve this lingering and costly issue was the creation of a Data Warehouse to consolidate their information into a single set of tables, allowing for a structure and analytic solution that made sense for their reporting and analytic needs. Our methods provided a platform to organize the company’s data and transform it into accurate performance statistics.

In addition, we utilized our custom Data Mart Manager (DMM) application  to create custom brokerage calculations that can be deployed easily, quickly and accurately for weekly, monthly and quarterly reporting purposes.

 

Results
 
  • Eliminated the over 80 hours of work each week freeing up employees to focus on other areas of the business—not report writing.
  • Identified reports that should have been calculated on Net Sales were erroneously using Gross Sales. Correcting this issue created significant improvement to the bottom line.
  • Exposed data that had been lost in their ERP system that could now be analyzed.
  • “No More Questions” - reports are all validated and data supported.
  • Identified deductions and refunds that were not being accounted for.
  • Simplified the Journal Entry Process and led to other accounting best practices.
  • Solution was so effective that it provided a platform to leverage the data warehouse solution for other areas of the business, including, sales and manufacturing analytics.

 

As your partner, we can help!

We turn your company-wide data into actionable insights that can take your organization from good to industry leading!

Vizion's Solutions will...
 

  • Grow the Top Line
  • Improve Profitability
  • Increase Productivity
  • Manage Risk

 

Vizion Solutions is not just a vendor, we are your full-service BI solutions partner, assisting through all stages of the BI process from exploration to development, deployment, training, ongoing support and ultimately your continued success.

Contact Us

 
Categories
Case Studies (11)
Testimonials (5)
Solution Sheets (5)
Distribution Industry (3)
Manufacturing Industry (3)
Services Industry (2)
Medical Industry (1)
Food Service Industry (1)
Sports Industry (1)
Manufacturing (1)
Wholsale (1)
ERP Systems (1)
+ Show More
Most Recent

Ohio Travel Bag: A Case Study

By Vizion Solutions
August 09, 2018 Category: Case Studies, Manufacturing, Wholsale, ERP Systems

What I have since realized using Vizion360 is that it wasnt the ERP system, it was our ability to get information out of it I now love our ERP, and we have canceled our approved budget to replace it. - Brian B., VP of Finance Purchasing Vizion360 Extends the Life of Wholesalers ERP, Enables E-Commerce Capabilities and Provides Transformative Insights In 2017, Ohio Travel Bag (OTB) had a frustration not uncommon to most companies, they had an ERP system that fit their business well, but they could not get the data they needed from it. A common issue with most ERP software solutions is that they are built to be transactional and getting sufficient reporting out the ERP itself is limited at best. The Situation OTB provides hardware solutions in solid brass, zinc-diecast, steel, stainless steel and plastic for luggage, handbags, cases, leather jewelry and leather goods to customers all over the world. OTB stocks over 8,000 items with a diverse selection of goods to remain the

Case Study - Inventory Application

By Eric Litras
August 31, 2017 Category: Case Studies

Company Background Client is a leading provider of customized manufacturing solutions serving organizations in a variety of industries with technically sophisticated manufacturing and quality requirements. Their products can be utilized in many industries including industrial automation, medical, military and aerospace, instrumentation, computer communications and radio frequency-enabled products. Industry leading manufacturer and distributor of high-quality performance automobile and boating parts and accessories. Business Issue As a contract manufacturer, our client is constantly faced with the challenge of balancing efficient inventory levels while maintaining high levels of flexibility to remain agile to respond to dynamic patterns of customer demand. Their general inventory levels, and especially, their excess and obsolete stock levels were rising and the they needed to get better visibility into why. Vizions Solution for Client Success This projects success lay in the ability

Case Study - Customer/Product Profitability

By Eric Litras
August 29, 2017 Category: Case Studies, Manufacturing Industry, Distribution Industry

Company Background Industry - Manufacturing and Distribution A top North American snack food private label supplier that uses advanced technology with innovative packaging solutions. Business Issue To maintain their status as anindustry leader and to continue their growth trajectory, the Client desired to impact their bottom line by finding ways to improve their profitability. To do so, they realized they needed to look beyond traditional financial reporting if they were to truly realize the profitability of their customers and products and uncover those improvement opportunities. Vizions Solution for Client Sucess The Vizion360 Customer/Product Profitability App uses data obtained from sales and finance departments to provide access to precise profitability statistics. To do so, we worked with the client to develop and refine customer and product profitability calculations by understanding and allocating fixed, variable and semi-variable profitability factors. More accurate profitability

Contact Us

4500 Rockside Road Suite 120
Independence, OH 44131
Phone: 866-407-5541
Fax: 216-373-0047
Email: info@vizionsolutions.com

Contact Us

Share Our Posts


© , Vizion Solutions, LLC | Powered by Virteom LLC