POWER BI FEATURES

Dashboards

Parameters to be monitored:

Financials:

1. Aging report/Overdue report, with exceptional delays as compared to policy, with reasons and the responsible distributor’s name.
   1. It will highlight the delays and their trends by distributor, city, etc.
   1. This in turn will help expedite the recovery of outstanding amounts, thus improving the cash flows and ROI, and the cost of doing business.
   1. If delays are due to any disputes, it will highlight the root causes of those disputes and their trends.
   1. It will highlight the speed with which these disputes are resolved or at which stage the disputes are stuck in the resolution process.
   1. It will also help in setting and monitoring the KPIs of the people responsible for recoveries, resolving disputes, and reducing bad debts.

• Cash flow analysis – projections.
  • This will help improve the decision-making process for investments and dividends and can also reduce the financing costs while dealing with the banks, etc.

• The cost of each product based on …
  • Current prices of Raw materials.
  • FIFO/LIFO options (interchangeable).
• Balance Sheet comparisons and trends analysis, in multiple currencies.
  • Trends of Capital over a time period.
  • Trends of various Assets, including Raw Materials, Plant and Machinery, Vehicles, Accounts Receivables,
  • Trends of various Liabilities, including Accounts payables, Bank loans,
  • Trends of Owners Equity / Capital.
• All financial ratios at a glance. These will include the Current ratio, Liquidity, Turnover times, ROI, Gross and Net margins, etc. with graphs to show the trends they are moving through or highlight the cyclical or seasonal trends, etc.

Stocks:

1. Stock in hand (Inventory) – both usable and unusable (defective)
2. Purchases in transit with durations
3. Standard preparation time, including documentation preparation time, approval time, banking, and transit times. Planned versus Actual analysis, along with reasons for deviations.
4. Quality rejection rates with supplier details, rework in process on defects by suppliers, etc.
5. Finished goods inventory, along with till when it covers the projected sales.
6. Product Aging report, to show if FIFO is being used or not, to safeguard against quality degradation due to limited shelf life, if any.

Operations:

1. Production plan, based on Sales plan and finished goods inventory in hand.
2. Projections of inputs needed/available in hand (less wastage) against the planned production schedule.
3. Status of inputs available, issued, and utilized on a daily basis, along with daily production targets for monitoring the production process and teams, and to be able to change the production plan if any input is in short supply.
4. Alerts of inputs to be ordered based on current stocks in hand, purchases in transit, planned utilization (production plan), lead times for new orders, minimum order quantities, etc.
5. Propose consolidation of the orders from each supplier and even recommend changes in purchase quantity to avail volume discounts or container/minimum value considerations.
6. Suggest the possibility of buying from a different supplier due to consolidation of other materials for meeting container or value minimums advantages.
7. Wastage product and supplier-wise.

Sales Management:

1. View # of SKUs purchased by each shop. (% of SKUs from the whole list).
2. Filtering of shops reducing or increasing purchases of specific items or total purchase quantities by distributor.
3. Filtering of shops by frequency of orders, average order size, etc.
4. Filtering of shops that are delaying payments beyond a threshold.