Newton’s Apple Nursery
Before partnering with Datalore, one of our clients received purchase orders from Walmart without any internal validation. As a result, supply chain shortages were creating incorrectly low forecasts, which led to lost sales. Our client needed a quick way to judge the orders from their buyer, make order adjustment suggestions, and correctly project inventory positions. With such a narrow time frame to assess and suggest orders; the solution had to deliver the data promptly and in an easy to understand format.
We created a Replenishment Model which combined data from the Client’s existing system and Walmart’s Decision Support System to allow for agile decision making. Information from these multiple data sources was organized in a star schema, utilizing the tabular modeling capabilities in Microsoft PowerBI.
Increased shipments by 14.5%
Increased Retail Sales by 24.4%
Not only did client improve their own top line sales, but they increased Retail Sales to a higher rate than inventory levels, resulting in a substantial margin improvement for Walmart.
A Power BI model to analyze retail data and to compare suggested orders against Walmart’s requested quantities
Training for sales team and analysts on how to add value to their buyer relationship by suggesting opportunities to increase sales leveraging data from the model and Retail Link