Logistics & Distribution
Global
Multi site
The client
Real-time stock levels for a global logistics & distribution company
Our new client is a global leader in mobile accessories and technologies. They manufacture and distribute a range of products related to screen protection, power management, mobile keyboards, cases and personal audio equipment.
The company uses third-party logistic providers to manage and deliver products globally and the management team required daily visibility of stock levels and the value of stock across the business.
The challenge
Manually extracting data from 15 excel sheets, every month
The client had a system in place that heavily relied on extracting data from at least 15 excel sheets, CSV files and web applications. This was a manual process and extremely time-consuming.
Reports, KPIs and business insights were challenging to produce due to:
- Multiple source data points
- Multiple varied formats
- Independent source data points that were not connected
For the client’s monthly reports, it took employees days to gather, extract and verify information, before collating this a in a presentable format. What was then circulated, was a snapshot of a point in time that was outdated by several days or weeks.
This system was very administration intensive and resulted in reports that were provided key business data but were outdated and lacked a deeper level of analytics and insights. Due to this, plans to implement a new ERP system were put on hold.
The solution
Accessing data securely from the cloud
WrxFlo created a new application where all data is stored on WrxFlo’s Microsoft Azure cloud servers, providing the client with access to reports from the via secure https weblink.
The WrxFlo system revolutionised the clients reporting, going from monthly reports that were already out of data to always on, real-time reports that required no administration.
The WrxFlo solutions:
- Real-time KPIs and insights
- Tiered levels of user access
- Customer support module
- Easy to use data capture form builder
- No administration requirement: the system is fully automated
The result
All data available from one source
The logistics and distribution client now has an entire suite of data and insights into its stock valuations through one application. The WrxFlo platform has removed all manual steps from data collation, and the client can now analyse data and trends week on week and month on month. The client now has real-time reports, that are accessible from one system, removing any variance in data collection or presentation.
For this client, reporting that was only available retrospectively once a month is now available daily with up-to-date information.
Business outcomes:
- Real-time inventory valuation.
- One source of truth for data
- 90% reduction in administration
- 20% inventory reduction
- 25% part cost reduction
- 15% improvement in 3PL performance
