BusinessQlik Supply Chain Analisys

BusinessQlik Supply Chain Analisys is the complete solution of supply chain management on the system of the business analysis based on QlikView/Qlik Sense for production companies in the field of production supply.

BusinessQlik Supply Chain Analisys (2016)

The main objective of the application - the analysis of indicators of the company in the field of warehouse and production logistics, for ensuring planned and rhythmical production, control and improvement of indicators of regulation, improvement of indicators of inventory turnover, optimization of accounts payable.

Tasks

• Ensuring purchases (work of purchasing managers, orders, deliveries);
• accounts payable management;
• management of inbound logistics (requests, delivery);
• inventory managements of the company;
• regulation;
• ensuring rhythm, uninterrupted operation of supply of production;
• the analysis of bottlenecks in a supply chain.

Possibilities of Business-Qlik for SCM:

• Analysis of commodity balance and overstocking of warehouses, detection of deficits and illiquid assets;
• The analysis of a commodity remaining balance in pieces, cost, volume units and the number of days of sales by warehouses;
• Out-of-stock is the analysis of lack of goods in warehouses and in shops and the missed sale;
• Support of operating control of level of goods in a warehouse at the level of day;
• Turnover analysis, an average trade inventory (including in dynamics) taking into account lack of goods in shops;
• The analysis of the actual covering of a matrix of shops (security) according to the format o Implementation of the Autoorder System taking into account turnover and safety stocks
• Analysis of the movement of goods for the period;
• Implementation of interactive model of merchandising in cuts taking into account the analysis of a goods lifecycle, planning of markdowns and discounts
• The analysis of GMROI in cuts (on collections to brands, etc.)
• Analysis of cross-sellings and structure of "consumer basket";
• The analysis of passability of outlets on hours and days of the week, the analysis of conversion and its interrelation with marketing activity;
• The detailed analysis of checks; the average amount, structure of the check on days and hours
• Support of planning of strategy of promotion and sale;
• Analysis of seasonality of sales;
• efficiency of discount programs and programs of loyalty of o the Analysis of elasticity of demand on promotion actions;
• Segmentation of base of buyers;
• Efficiency evaluation of advertizing and media activity and actions;
• Identification of consumer patterns of behavior;

Control panel of the head (dashboard);

• Analysis of the KPI company, including analysis of profitability of business, market share, costs, plan fact for turnover and profit;
• The analysis of KPI of sales by sales channels, regions, key clients, brands and activities;
• The analysis of a KPI warehouse concerning regulations of overstocking and turnover.
• The tree of KPI/card BSC (balanced scorecard) for managerial supervision is more whole than all levels;

Specific Features

1. The analysis of out of stock in different cuts, a possibility of the forecast of balance of warehouse stocks.

2. Control of indicators of turnover, ukhodimost, dynamics of a ratio of the request stocks, timeliness of the order.

3. Automatic forecasting of stocks taking into account production schedules and their adjustments.

4. Forecast calculation by different techniques using statistical calculation procedures, use of forecasting methods on mean value.

5. Drawing up versions of plans of ensuring production, choice of an optimal solution. Maintaining different versions of plans, division of plans on basic and operational for improvement of forecast calculations.

6. Viewing the nomenclature of purchases and stocks in different cuts (suppliers, warehouses, managers, etc.) with detailing to SKU, with calculation in monetary and quantitative measurement (kg, piece, a pallet, batches, etc.)

7. Maintaining history of purchases on each supplier, the manager, the direction, payments. Online monitoring of terms of the contract and deliveries, taking into account discounts, bonuses, penalties. Drawing up a pool of suppliers, the choice of the optimal supplier, the rating of suppliers by the selected criteria.

8. Job evaluation of cost centers on normative coefficients.

9. Assessment of indicators of value creation at each stage of a logistics chain.

10. Calculation of capacity at different plans of loading.

11. Monitoring of storage lives for stocks with an expiration date.

12. The analysis combined by ABC-XYZ, to SKU.