The Power of Simplicity Consumer Products Retail

The Power of Simplicity Consumer Products, Retail / Wholesale and Distribution – January 2009 Representative Customer Case Studies Next Generation Business Intelligence

Representative Client Examples Ahlers Group Consumer Products Retail & Wholesale Distribution Customer Solution § During 80 years of its existence, the § Demand Planning and Inventory Management second largest manufacturer of § Manages its sales & supply chain to adapt to men’s clothing in Europe has proved ever changing consumer buying patterns. that it after implementing Qlik. View it § Analyzed large volumes of data with response can always react flexibly and quickly times of under one second. to the requirements of the time and of § Provided platform for fast, flexible analyses the market. that allows for and adapts to any ad-hoc inquiries to meet the unique information requirements of each department. § Consolidated data from wide array of sources. § AFC is one of the largest farmer- Alabama Farmers Cooperative Consumer Products Retail & Wholesale Distribution owned, regionally based supply and marketing agricultural cooperatives in the Southeastern United States. § Organized in 1936, AFC operates for the benefit of its 47 member associations, which include approximately 90 retail locations. § Improved margins and profitability in a wildly variable, seasonal business model: Deployed 12 Qlik. View applications, to 20 users, across six functional areas, in a span of only 16 weeks. § Chief Financial Officer now monitors an easy -to-view dashboard of 12+ KPI ratios, all updated daily for real-time information and swift adjustment to seasonal fluctuations. § Configured Qlik. View Server and Publisher. §

Representative Client Examples Customer § Leading international fine art Art in Motion publisher Art In Motion was able to optimize inventory levels to improve profitability and eliminate the cost of raw material obsolescence. Solution § Inventory and Supply Chain Management: § Enabled improved visibility into the supply chain which led to fact-based decision making § Resulted in a 50% reduction in inventory. § Application delivered in 3 weeks. § § Global manufacturer and retail wholesaler Bernard Chaus, has reduced inventory turns and increased sell through using Qlik. View. Bernard Chaus Reduced merchandise orders from $14 million to $7 million in 14 months without incurring any shortages. § Inventory and Markdown Management: Track slow selling items daily resulting in competitive price and markdown planning and execution. § Enable near-real time replenishment of high turn items to fast selling stores and channels. §

Representative Client Examples Customer § Leading consumer products business, Solution § Deployed Qlik. View to 200 super-users across four § 98% reduction in inventory carrying costs. § Global manufacturer and marketer of Blythe Home Scents Consumer Products primarily focused on fragranced products and related accessories. Strong relationship with Wal-Mart among other food, drug and mass retailers § Division of Blyth, Inc. prior to being sold to MVP Group International (Charleston, SC) in May 2007. § Optimized demand forecasting & inventory high quality simple meals, including soup, baked snacks, vegetable-based beverages, and premium chocolate products. § Headquartered in Camden, NJ, company has achieved revenue in excess of $5 billion with 17, 000 employees in NA. management models to support significant increases in new products and SKUs. Campbell Soup Consumer Products functional areas (sales, marketing, supply chain, and finance). Incorporated dashboards, scorecards, analysis and reports into departmental toolkits. § Implemented sales application in 3 -week period. § Leveraged Qlik. View Server and Publisher (64 - bit) to consolidate data from IBM System i (AS/400) based Movex, BPCS ERP and Excel. § Deployed Qlik. View to ~ 50 users across sales, supply chain and operations functions in NA. • Leveraged Qlik. View Server to access and analyze 4, 500 SKUs & data sets previously maintained in the MM/SCM systems and Excel. • Improved inventory forecasting accuracy by >50% .

Client Examples Customer Dean Foods Grocery • Based on the need for essential • Using Qlik. View. Server (64 -bit) & Publisher to business data across all of its brands, support approximately 20 Million data records Dean Foods deployed Qlik. View to used to report accurate Sales & A/R. 40 users as an Executive Dashboard • Increased A/R reporting frequency for Customer KPIs and A/R reporting. from monthly to weekly, resulting in significant interest savings to company. • Reduced time to access customer data from 2. 5 days to real-time. • Tracking key metrics and profitability with functional and customer KPI dashboard. § Food retailer EDEKA analyzes its EDEKA Grocery Solution cash register details against predefined business criteria, including cancellations, empty packages and personnel purchases, to identify potential loss prevention / fraud activity and existing areas of risk. § Minimize fraud losses through proactive reporting and what-if analysis and increased focus on risk management: Store. Mate loss prevention application, was deployed in just 4 weeks to reduce fraud and drive actions to minimize losses. § Rollout has led to the company having the statistical facts necessary to support corrective action up to an including legal action. §

Representative Client Examples Customer § French sportswear brand retailer Eden Park uses Qlik. View to analyze its store inventory in near real-time, allowing for stock balancing and merchandise transfers between stores where required. Solution § Optimize store-level stock turnover and overall inventory management. Resulted in a near immediate ROI. § 1 week to develop application. § Retail & Wholesale Distribution Apparel § Leading electronic components distributor in the pan-Asia region spanning 10 countries with more than 45 regional offices. • Headquartered in Singapore. FE Global • Achieved ~ $1 billion in revenue with Electronics 750 employees. Retail & Wholesale Distribution § Increased visibility to current cash flow. Results include: 20% reduction in aged receivables § 15% decrease in inventory carrying costs, improving overall cash flow. § Currently analyzes inventory and accounts receivable data using Qlik. View application. § CEO stated that “using Qlik. View has put our company in a stronger cash position”. §

Representative Client Examples Customer Solution § Multinational company specializing FILA § Deployed to 250 users across 4 functions in Italy. in athletic footwear and accessories, sporting goods and apparel. § Founded in 1911 by the brothers Fila in Biella, Italy. § Gained the ability to create in-depth reports and multi-dimensional data queries. § Introduced data quality standards to enable user- friendly, intuitive reports and analyses. • Through Qlik. View Server, Fila Europe now has one common dashboard to ensure consistent cross- enterprise and supplier communications. Manufacturer Consumer Products § Manufactures and distributes Gas line Increase Sales Revenue and Profitability: Grotto Gas Manufacturer Retail & Wholesale Distribution of jeans and clothing. § Manufactures > 6 M pieces annually. § Established in 1982 with a brand focus on young, hip consumers. § Headquartered in Chiuppano, Italy with over 1, 800 global employees. § 3, 000 points of sale across 56 countries. § Analyzed market reaction—including clothing wearability and hot / slow seller trends. § Monitored sales and in-stock turnover at each store. § Enabled documents to be shared between on-site and off-site users. § Gained the ability to track, analyze and “drill into” sales records without dimensional or hierarchical restrictions.

Representative Client Examples Customer Lifetime Brands Consumer Products Solution • Lifetime Brands is North America’s leading designer, developer and marketer of kitchenware, home decor and accessories. • The Company markets its products under more than a dozen of the industry’s best-known brands, including Farberware, Cuisinart, Calvin Klein, Casa. Moda and Hoffritz. • Lifetime’s products are distributed through almost every major retailer in the United States. • Facilitated consolidated reporting for all company brands based on data from disparate enterprise software systems. • Enabled visibility into supply chain management and sales analysis. • Deployed to 145 employees in less than 8 weeks. • Garnered time and cost savings from elimination of wait time for reports and forecasting. • Achieved single point of entry to disparate systems – collapsing 100 individual reports into a single instance of Qlik. View. • “With Qlik. View, we have the ability to aggregate historical data from various enterprise software systems with data from SAP systems. This has made company information accessible to everyone and enabled our users to develop consolidated reports more efficiently. ” Clifford Siegel, SVP, Global Supply Chain

Representative Client Examples Customer § Leading Swedish distributor of Optimera DIY / Home Improvement Retail & Wholesale Distributor CPG, Retail & Wholesale Distributor § Inventory Management and Call Center building materials to professional and Operational Excellence private consumers. § 33% reduction in customer call center queues. § Home improvement store Optimera, § € 1. 3 million reduction in inventory stock analyzes customer satisfaction, sales levels. trends, inventory levels, and account § Generate rich insight into all the various factors receivables with Qlik. View. that impact sales performance and profitability. § Manufacturer of laminate flooring, Pergo Solution based in North Carolina, with estimated sales revenue of $400 M. § Goal: To implement business intelligence software enabling the ability to pull data from various sources. Retail data and sales analysis was then given to sales staff so they could identify and react to changes in consumer demand. § Demand Planning and Business Analysis: § Qlik. View pulls data from various sources including a data warehouse from Cognos, which houses statistics from the Company’s Movex ERP and EDI from its distributors. Pergo recognized the ROI value of the sales analysis information and quickly expanded across functions (i. e. inventory, planning, logistics, finance, customer care & credit). § Created /deployed Executive Dashboard tools. §

Representative Client Examples Customer Robinsons Group Upscale / Luxury Department Store Solution • Robinsons Group is a leading retailer § Faster access to business critical information: operating 18 upscale department § Analysts spend 50% less time aggregating stores in Singapore and Malaysia. and accessing data § The content of dashboard views and reports • Since the introduction of Qlik. View, yield up to 80% more detailed information Robinsons Group’s decision makers than the prior paper-based reporting. have faster access to more actionable § Supply Chain Agility - quickly able to respond to data leading to smarter, timelier market condition and buyer preference business decisions. fluctuations: § Increased gross margin %, inventory turn, and profitability. § Merchandise allocation and pricing, by market geography, down to the store-level. Track selling performance by category/item; enabling shelf replenishment for strong sellers & execution of exit strategies for slow movers. § Accurate and timely reporting has allowed for proactive forecasting and replenishment to minimize “out of stock” scenarios. §

Representative Client Examples Customer Solution § The Roxcel Group is one of the Roxcel Retail § Order Management, Forecasting and Allocation leading global retailers and wholesalers of paper products and cartons. § Sales volume of 1 million tons. § 15 -minute modification requests. Modification requests for dashboards, analysis and reports are mostly completed within 15 minutes § Cash Flow Optimization essential to managing the international transit trade. & Wholesale Distributor § Quickly deployed Qlik. View to roughly 40 users. § Aggregate and free the large data volume previously locked in its internal ERP application. § SIBA AB is one of the Nordic SIBA Electronics Retailer § Increased store efficiency & reduced labor spend. countries leading home electronics retailers, operating department stores in Sweden, Norway and Denmark; departments for industrial trade in Stockholm, Gothenburg and Copenhagen; and in 1998, launched its web operations @ www. siba. se. § The company has 650 co-workers with revenues around € 350 million. § Reduced required training investment due to product ease of use: § “A brief introduction is all it takes to start to work in Qlik. View. Easy to use and user friendly – two of the main reasons we selected. Qlik. View. Every store manager across >50 stores had just a 5 -minute tutorial over the phone to learn how to analyze their own data in Qlik. View. ” Hans Broström, Backoffice Manager, SIBA

Representative Client Examples Customer § WH Smith is one of the UK’s leading WH Smith Specialty Retail retail groups, incorporating marketleading companies in retail and news distribution. § Its online division, WH Smith Direct, is the UK’s leading multi-channel retailer, offering a range of over 2. 1 million products online including every British book in print, plus 250, 000 entertainment products. Solution § Better manage SLAs: § Achieved an 18% improvement in “delivery- to-promise (i. e. parcels delivered within the time stated to customers) rates; Improved from 79% to >93%. § The ‘now – current state’ is used as a key measure for managing service level agreements with their drop-ship suppliers. § Leading specialty home goods retailer § Minimize profit erosion from returns. Williams. Sonoma Specialty Retail Williams-Sonoma was able to enforce a new 30 -day return policy by bringing together purchase date and product data from online and in store sales in a dashboard to analyze return requests and approve them. § Recently stated in the annual report that “results associated with our catalog optimization and returns, replacement and damages initiatives drove better than expected savings for the quarter. ” § Delivery in shocking time. Implemented catalog / call center operations analysis application in 9 days - customer initially projected 120 days based on traditional project rollouts.