下载PDF
SunOpta increases margins and reduces inventory exposure with QlikView
技术
- 分析与建模 - 实时分析
适用行业
- 消费品
适用功能
- 商业运营
- 销售与市场营销
用例
- 库存管理
- 供应链可见性(SCV)
服务
- 数据科学服务
挑战
SunOpta, a leader in the natural and organic foods and natural health products markets, faced challenges in reporting and data analysis due to rapid growth and acquisitions. The company lacked overall visibility into companywide sales, finance, and operations. It also struggled to quickly integrate data from newly acquired or existing business units with differing enterprise software systems for shareholder reporting and strategic planning purposes. SunOpta needed to upgrade its existing disparate BI and reporting solutions, including Oracle BIEE, to maximize profitability with a daily view of gross profit performance and reduce inventory exposure and related costs.
关于客户
SunOpta Inc. is a leading processor and distributor of natural and organic food products. The company operates in three business units: the SunOpta Food Group, which specializes in sourcing, processing, and distribution of natural and organic food products; Opta Minerals Inc., a producer, distributor, and recycler of environmentally friendly industrial materials; and SunOpta BioProcess Inc., which engineers and markets proprietary steam explosion technology systems for the bio-fuel, pulp, and food processing industries. Through a combination of internal growth and acquisitions, SunOpta quickly grew to become a leader in sourcing, processing, and distributing food products.
解决方案
SunOpta deployed its initial QlikView application – division sales analysis – in only one week. With QlikView, 120 SunOpta employees can now analyze customer profitability, inventory exposure, and manufacturing costs, for the answers they need to drive corporate profitability. SunOpta immediately leveraged the invaluable data that was locked in Oracle and five other enterprise systems. The company developed its first QlikView application – sales analysis – in only one week. Beginning with basic analysis of sales by division, SunOpta continued to expand the application to include in-depth sales and revenue analysis, including actual-to-budget, year-over-year, month-to-month, and top 25 customers by product and item. SunOpta division managers use QlikView on a daily basis for instant visibility of overall sales and contribution margins, as well as contribution margin by customer.
运营影响
数量效益
相关案例.
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.