I will build an excel inventory planning and optimization model
About this Gig
Are you struggling with excess inventory, stockouts, or unclear reorder decisions? I am an Industrial Engineer with nearly 10 years of hands-on experience in supply chain, production planning, and inventory optimization in manufacturing and food-industry environments. I will build a practical, tailored Excel inventory planning and optimization model based on your business data to help you streamline your replenishment decisions and protect your cash flow. Depending on the package you select, I can provide: Inventory health analysis (stock levels, slow-moving items, and stockout risks) Safety stock calculations based on lead-time variability and demand Dynamic Reorder Point (ROP) and Min/Max stock level settings Recommended purchase order quantities (EOQ / batch rules) Days/Weeks of inventory coverage indicators Clear, user-friendly Excel planning dashboard and summaries Why work with me? Industrial engineering background with deep knowledge of MPS/MRP logic Real-world experience with SAP, Canias, and Netsis ERP systems Practical, clean Excel tools designed for daily operationsnot overly complex formulas you cannot maintain Please send me a message with a brief des
FAQ
What information do I need to provide to get started?
You can share your current stock list in Excel or CSV, past sales/consumption data, and supplier lead times if available. If some data is missing, we can discuss practical assumptions.
Do I need advanced Excel knowledge to use your model?
Not at all. I design my models to be intuitive, clean, and easy to maintain with clear input and output sections.
Can you work with large product catalogs?
Yes. The standard packages cover up to 50 items/SKUs, but for larger catalogs or custom ERP exports, please message me for a tailored custom offer.
