Business Intelligence as a management tool

Challenge

  • No system to track profit on each order
  • Cash flow issues resulting in strain on working capital

Recommended Solution

  • Designed a robust model to monitor all key parameters of customer orders including:
    • Profit of the order providing details of invoice, costs, indirect expenses
    • AR and AP outstanding against the order
    • Life cycle of the project – overall time to complete, time to place PO, GN, delivery and receipt of collection
  • Completely automated reporting to capture all the information from ERP in one place, compute the critical parameters and distribute to mailing list at pre-set frequency

Benefits

  • Detailed report designed and implemented
  • complete automation of reporting delivered
  • Report lead to key management decision to control working capital issues