Case Studies

Grocery retailer uses machine learning to adjust daily prices to maximize revenue and profits

Posted by | Shashank Kulshrestha


A US-based Grocery and Fresh retailer was grappling with retail giants like Walmart and national grocery chains, and wanted to leverage Machine Learning to optimize pricing.


  • The company wanted to leverage Machine Learning (ML) pricing optimization to model price-demand to maximize profit or revenue, based on the objectives of store owners.
  • They also wanted to execute price optimizations on a weekly basis, while ensuring adherence to the rules and guardrails defined at the enterprise, category, and location levels.


  • Fuld’s team of analysts designed jobs to integrate the weekly sales, product and sales hierarchy, competitor pricing, and other SKU metadata into the SAP database for both the SKUs and individual stores
  • Using Python and Alteryx we created ML jobs to model a demand-price response and calculate predicted sales, volume, and gross profit for each SKU and price-point
  • Once the jobs were in place, we designed the system to select optimal prices based on:
    • Pre-defined price rules and guardrails
    • Targets of balancing the revenue and profit goals
  • As part of the verification stage of the project, we triggered and executed optimization jobs daily to recalculate optimal pricing which we then shared with our client’s pricing team to evaluate and approve
  • We completed the project by creating dashboards in Power BI to help the client visually monitor revenue, profitability, opportunity curve, and the cost of rules


  • The prices were successfully optimized for each store location, product category and SKU family on a daily basis
  • The retailer was able to meet and/or maintain the revenue and gross profit targets for 80% of its stores within the first 3-months of deployment of the new system.

Tools Used




Tags: , , , ,

Related Resources

Read More

Global medical equipment company discovers a new competitor…and a new market

A leading medical equipment manufacturer was concerned about a new entrant that had moved into one of its high-value, diagnostic […]

Read More

Identifying Drug Repurposing Collaboration Partners

A top pharma company actively working in the drug repurposing sector wanted to expand its portfolio by adding new indications […]

Read More

Identifying the most effective prophylactic/therapeutic oral anti-inflammatory agents

A global FMCG leader sought to expand their current oral care product range with a line of products that had […]

Subscribe to our mailing list for our latest updates: