🏭 Case Study: Procurement Automation in Food Manufacturing with Odoo ERP

πŸš€ Project Overview🧩 The ChallengeπŸ’‘ Our Solution🧠 Key Considerationsβœ… Results AchievedπŸ“… What’s Next?

πŸš€ Project Overview


What you see is what you get


 As part of a digital transformation initiative, we implemented a custom procurement automation system using Odoo ERP for a fast-growing food manufacturing company. The goal was to improve efficiency, eliminate overstock, and enhance procurement planning accuracy across hundreds of components.

🧩 The Challenge


Although Odoo’s standard Purchase module allows for creating RFQs and ordering components, it lacked predictive logic for planning future procurement based on:

  • Confirmed production orders
  • Ingredient expiration dates
  • Supplier variability (lead time, pricing, volume)
  • Inventory turnover goals

Without this, the company faced:

  • Overstocking or understocking critical ingredients
  • Locked working capital
  • Manual and reactive procurement decisions


πŸ’‘ Our Solution


We developed a dynamic procurement formula embedded into Odoo workflows that evaluates daily demand fluctuations, lead times, and stock availability. The system now automatically generates RFQs only when necessary, based on future production requirements.


πŸ“ The Formula Logic

plaintextCopyEdit((Avg. Consumption Last 3 Months * 2) + (Avg. Daily Consumption)) * Supplier Lead Time
- Free Stock - Confirmed Purchase Orders = Ξ”
  • If Ξ” > 0 β†’ Create RFQ
  • If Ξ” ≀ 0 β†’ No Action Required

This ensures components are ordered just in time, without overstocking.


🧠 Key Considerations


Rolling average usage of components

Lead times from each supplier

Real-time stock visibility

Reserved stock prioritization based on expiration dates

Production manager priorities


βœ… Results Achieved


βš™οΈ Automated RFQ generation based on real-time demand

πŸ“¦ Reduced warehouse overstock and improved inventory turnover

πŸ“‰ Lower working capital freeze

πŸ”„ Dynamic vendor selection based on lead time and pricing

πŸ“ˆ Increased production planning accuracy



πŸ“… What’s Next?


We’re extending this system to support:

  • Multi-supplier RFQ optimization
  • Intelligent procurement acceleration
  • Dynamic prioritization of urgent ingredients for high-volume orders


πŸ”— Ready to transform your manufacturing operations?

Leverage the power of Odoo ERP with tailored automation β€” from procurement to delivery.


πŸ‘‰ Contact us to learn more or schedule a live demo.