ARC Merchandise Analytics

ARC Merchandise Analytics equips you with a wide range of reports, dashboards and analyses, that help merchandisers in strategic, tactical as well as day-to-day decisions. Some of these decision making areas include optimizing merchandise and assortment performance, maximizing sell-through, controlling shrinkage, tracking new product performance, optimizing markdown and promotions, improving price realization, rationalizing products, and allocation optimization.

ARC provides analytics across roles in merchandising, including:

• Divisional merchandise managers
• Heads of Merchandising
• Category / Department Managers
• Merchandise Analysts and Planners
• Buyers and Allocators

Here are a few examples of the pre-built analyses ARC provides you:  

• Track store performance based on key metrics like target achievements, margin percentage, growth over last year, growth in average selling price and quantity per ticket against store clusters, regions and corporate
• Evaluate the impact of store size and employee strength on sales and resultant margins at various levels of merchandise categories
• Identify sales and margin growth, and contribution by sales channel (regular store, discount store, web, catalog)
  

• Track merchandise plan, OTB plan against actual, and drive assortment and allocation decisions
• Optimize merchandise mix based on a composite index of margin and sales value
• Track sell through and stock-to-sale ratios by brand, category or items, to formulate specific sales strategies
• Identify potential cross-sell and up-sell opportunities by means of Market Basket Analysis (MBA)
  
  

• Streamline retail distribution to minimize inventory carrying costs, stock-outs and markdowns
• Identify stock movement and liquidation opportunities by tracking stock ageing and non-moving stocks
• Identify negative margin items and stock holding trends
  
  

• Track promotion effectiveness with lift percentage, target achievement and ROI
• Track stock availability, buying needs based on rate of sale during promotion period
• Track plan against actual markdowns, analyze overall markdown impact on margin, and optimize markdowns by analysing sell through trends
  
  

• Identify potentially fraudulent transactions
• Evaluate various sources of inventory shrinkage, including employee theft, shoplifting and vendor fraud
• Track out-of-hour transactions, price overrides, employee discounts and store discounts Supplier Analysis
  
  

• Compare suppliers of similar products on performance metrics like sales contribution, margin percentage, stock contribution and rebates
• Provide access to vendors to track stock-on-hand positions by location, to reduce stock outs and improve delivery time
• Rank vendors based on scorecards that track supplier service metrics such as fill-rate, on-time and quality of delivery and performance metrics like sales, margin, stock and rebates