Challenge
With more than 16,000 different products, Applico wasn't able to get the reporting they needed with Chrystal Reports. Pre-defined paper printouts simply was not enough. Applico needed detailed information about sales and purchasing and stock control that could not be obtained with the existing system.
Solution
One QlikView main sales and purchasing application handles most of the reporting requirements for Applico. But since the introduction of QlikView in 2003 Applico has developed 14 different applications.
Benefits
· Detailed Target Followup on sales rep level
· Powerful performance analysis down to invoice level
· Instant information access and reporting for sales people
· Sales reps can analyse off line - on the road
Applico Group Ltd
is the leading importer of premium kitchen appliances into New Zealand sourced from throughout the world. Specifically, Smeg, Baumatic and Classique from Italy, St George from Australia and Viking from the USA.
Advanced Logistics Planning
The majority of Applico’s products are being imported from the other side of the world. Shipping times for most products are 5 weeks or more making re-stocking and stock optimisation a major concern. Warranty obligations also require Applico to always ensure that spare parts are readily available. The sheer number of different products and spare parts make this a highly complex task.
One of Applico’s QlikView applications takes care of this complex task combining input from the ERP system and various other sources, giving instant feedback to the logistics manager. This information is the base for purchase ordering keeping the stock on hand at an optimum level at all times.
Warranty Analysis
QlikView gathers data from a separate warranty database that logs all warranty claims and compares the data with current sales and purchase information enabling advanced Analysis that gives Applico early warnings if any products should have a higher than normal fault rate.
Terms of use