Excel Recipe & Inventory Manager with Cost-Per-Portion Logic
Thomas Biziouras
📦 Excel Recipe & Inventory Manager with Cost-Per-Portion Logic
Built for chefs, caterers, and food entrepreneurs, this Excel tool consolidates ingredients, suppliers, stock levels, and recipe costing into a single system — helping teams control cost, monitor usage, and optimize profits at the portion level.
🔹 Core Functionalities
Recipe-Based Costing Engine
Calculates per-portion cost based on ingredients, units, and prep time. Supports menu-level builds and bundled offers.
Stock & Price Tracking
Monitors current stock, logs all usage, and tracks price fluctuations per item. Alerts when ingredients fall below restock levels.
Operating Cost Allocation
Distributes general expenses (rent, staff, utilities) across recipes based on prep time and usage frequency.
Menu Builder Module
Combine multiple recipes to generate composite pricing for events or batch sales.
Loss & Consumption Logging
Capture waste, yield loss, or special consumption entries for full traceability and cost impact.
🧰 Tools & Techniques Used
Excel Structured Tables for inventory and recipe rows
Named Ranges for prep logic & auto-calculations
Price Adjustment Tracker with timestamped updates
Built-in logic for daily/weekly/monthly stock consumption
Backup Module for versioned saves
Cloud-compatible structure (OneDrive, Dropbox, etc.)
✅ No subscriptions, no platforms, no lock-in — just Excel, structured and scalable.
Gallery
Inventory control and material tracking with stock alerts, purchase logging, and price fluctuation analysis. Built-in backup system ensures data recovery, while the price trend chart helps monitor supplier inflation over time./im
Detailed material purchase ledger including quantities, suppliers, units of measure, and usage-based price breakdown. Enables precise tracking of inventory costs across varying purchase formats — fully linked to recipe costing.
Recipe builder with ingredient linking, quantity-based costing, and automatic profit margin calculation. Supports real-time updates when material prices change and offers a per-recipe view of prep time, costs, and retail price.
Real-time sales and stock usage tracking with recipe-based deduction logic. Every sold portion updates the inventory and logs material consumption per ingredient, creating a complete audit trail from purchase to portion.
Menu cost builder with support for portion grouping and unit conversion logic. Automatically calculates total menu cost and visualizes price trends over time. Built-in unit dictionary supports conversions like Kg ↔ Gr or Lt ↔ Ml.
Like this project
Posted Apr 29, 2025
Developed a complete Excel-based system for recipe costing, stock tracking, and profit analysis — tailored for chefs, restaurants and catering services.
