Restaurant Menu & Cost Planner

An Airtable base for a Nigerian restaurant to manage recipes, track changing market prices, and calculate daily meal preparation costs.

Airtable
Problem

Changing local market prices made it difficult to know the exact cost of each dish. Calculating costs in spreadsheets led to budgeting mistakes, and planning purchases for the daily market trip took time.

Process
  1. I set up a main ingredient list to track the current market price for every single item.
  2. I built detailed recipes and linked them directly to those specific ingredients.
  3. I added a daily planner to schedule exactly what the kitchen needs to cook each day.
  4. When the price of an ingredient changes in the main list, the system automatically does the math and updates the total cost of any dish that uses it.
  5. A custom calculator instantly adds up the total grocery expenses for the planned menu.
Result

When the restaurant plans its menu, the base provides an up to date cost breakdown. Kitchen staff can see the daily cooking schedule, and managers can estimate market expenses without calculating each dish by hand.

Business Impact

The updated cost calculations give managers a clearer basis for budgeting and reduce time spent checking figures by hand. The team can focus more on running the restaurant and less on spreadsheet calculations.

A look inside

Screenshots

Current ingredient prices and suppliers
Recipes linked to ingredients and costs
Daily meal planning schedule
Visual ingredient gallery
Recipes grouped by difficulty
Market run cost calculator
Ingredients grouped by category
Recipes with cooking instructions
Next Project
WhatsApp Ordering AI Agent