Download PDF
National Frozen Foods Corporation enhances production analysis with QlikView
Technology Category
- Analytics & Modeling - Real Time Analytics
- Application Infrastructure & Middleware - Data Exchange & Integration
Applicable Industries
- Consumer Goods
Use Cases
- Predictive Maintenance
- Real-Time Location System (RTLS)
Services
- Data Science Services
- System Integration
The Challenge
National Frozen Foods Corporation, a leading private label packer of vegetables, faced challenges with poor visibility into production data. The company found it difficult to analyze data across disparate IT systems for ERP, warehouse management, HR, and other systems. There was no way to package company data to executives and other employees. The company recently upgraded its legacy ERP, Warehouse Management, and other systems to better accommodate the selection, quality, varieties of crops, seasonality, growing methods, and inventory management needs of customers. While those systems provided better access to the information management and operations professionals needed, the source was limited to exported data in Microsoft Excel. This proved difficult and time-consuming, particularly for those users with non-technical backgrounds.
About The Customer
Seattle-based National Frozen Foods Corporation is a $100 million+ privately-held company that processes, packs and freezes vegetables for a variety of customers including major grocery chains and consumer brands in the North American, Asian and Australian markets. Employing over 600 full-time and up to 1,400 seasonal personnel, the company produces over 300 million pounds of frozen corn, peas, beans and carrots per year. The company recently upgraded its legacy ERP, Warehouse Management and other systems to better accommodate the selection, quality, varieties of crops, seasonality, growing methods and inventory management needs of customers.
The Solution
National deployed QlikView to 200 employees. The first application was deployed in 1 week. With 64-bit QlikView, National is now able to aggregate and analyze 1-5 terabytes of data sourced from different systems across multiple departments. Real-time production analysis allows plant managers to spot anomalies and trends In output. Role-specific dashboards give all employees access to the data they need to perform their job on a daily basis. Since first deploying QlikView for production analytics, National’s IT team has used the platform to deploy over 100 applications across all departments. Meersman has also used QlikView to populate the company’s “My National” web portal, which provides personalized analysis via tabs and dashboards based on an employee’s job function and permissions.
Operational Impact
Quantitative Benefit
Related Case Studies.
.png)
Case Study
Improving Vending Machine Profitability with the Internet of Things (IoT)
The vending industry is undergoing a sea change, taking advantage of new technologies to go beyond just delivering snacks to creating a new retail location. Intelligent vending machines can be found in many public locations as well as company facilities, selling different types of goods and services, including even computer accessories, gold bars, tickets, and office supplies. With increasing sophistication, they may also provide time- and location-based data pertaining to sales, inventory, and customer preferences. But at the end of the day, vending machine operators know greater profitability is driven by higher sales and lower operating costs.
Case Study
Series Production with Lot-size-1 Flexibility
Nobilia manufactures customized fitted kitchens with a lot size of 1. They require maximum transparency of tracking design data and individual processing steps so that they can locate a particular piece of kitchen furniture in the sequence of processes.
Case Study
American Eagle Achieves LEED with GE LED Lighting Fixtures
American Eagle Outfitters (AEO) was in the process of building a new distribution center. The AEO facility management team decided to look at alternate options for lighting layout that could provide energy and maintenance savings. AEO would need a full-time maintenance employee just to replace burned-out fluorescent tubes.
Case Study
Revolutionizing Rodent Control
From pet- and child-safe traps, to touch-free and live-catch rodent control solutions, Victor continues to stay committed to producing superior products that meet the varying needs of today’s pest control professionals. And, with a long standing history supporting customers in the food processing, service, and retail settings, Victor knew that strict regulations were costing organizations thousands of dollars in excess overhead trying to manage their rodent-control solutions. Trap inspections in these environments are often difficult and time consuming, requiring personnel to manually check a trap’s status multiple times per day, amounting to over six hours of manual labor. Victor is looking for an innovative way to increase operational efficiencies with the use of technology.
