Challenge
•  No system to track profit on each order
• Cash flow issues resulting in strain on working capital Recommended Solution
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
