September 27, 2023
Dasco Engineering is a manufacturing, trading and distribution company dealing in multiple product segments in Nigeria. It primarily engaged in manufacture of barbed wire, wire mesh and other similar products. They were using Tally primarily as an accounting package and wanted to expand the usage and automate their reporting function.
Business Problems
- Tracking landed cost of imported components. This was manually done in excel
- Production and raw material planning
- Debtors payment performance and outstanding analysis
- Tracking actual sales against previous periods and targets
- Tracking inventories and slow moving inventory
- Management dashboards for overall company reporting
Solution Provided
- Customizing tally and providing excel uploads to capture additional data for production, import module, sales targets, etc.
- Capturing data for imports including vessel, port, ETA, import documentation and additional costs of import
- Setting min / max inventory levels for inventory and production planning
- Production planning and raw material planning dashboard
- Outstanding variance, debtors payment performance
- Management, inventory and sales dashboards
Benefits
- Reduced the disparate data silos and data maintenance, manual effort and errors in excel based reporting
- Helped improve the production and raw material procurement planning leading to better cost of production
- On demand production analysis and production cost reports based on actual landed costs
- Dashboards for top management for interactive and ready reports
- Integration of exported reports with Google Sheets