Newton’s Apple Nursery

 
 

The Problem

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.

The Solution

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.

 
 
 
 

Wins

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.

Deliverables

  • 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