Simple Demand Forecast Workbook for Small Restaurants

Welcome

This interactive workbook helps small restaurant teams create lightweight demand forecasts and practical reorder suggestions using sales history, day-of-week patterns, and event overrides. Paste a CSV of daily sales or enter an average daily sales figure. Configure a moving-average window, add known events, set lead time and safety stock, then save your inputs. Formulas are provided so you can replicate or automate calculations later.

Key formulas

• Simple forecast (moving average): average of the prior N days (configurable).
• Day-of-week adjustment: scale the forecast by average ratios for that weekday when enabled.
• Event override: apply a multiplier for known events (e.g., 1.5 for a 50% increase).
• Reorder point (ROP): (Lead time days × Avg daily sales) + (Safety stock days × Avg daily sales).
• Suggested order quantity: max(0, (Avg daily sales × Order frequency days) + (Safety stock days × Avg daily sales) − On-hand), then round up to nearest pack size.

Example

If avg daily sales = 50 units, lead time = 2 days, safety stock = 2 days → ROP = (2 + 2) × 50 = 200 units. If you order every 2 days and have 60 on hand: suggested order = (50 × 2) + (2 × 50) − 60 = 200 − 60 = 140 units (then round to pack size).