Restaurant Menu & Cost Planner
An Airtable base for a Nigerian restaurant to manage recipes, track changing market prices, and calculate daily meal preparation costs.
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.
- I set up a main ingredient list to track the current market price for every single item.
- I built detailed recipes and linked them directly to those specific ingredients.
- I added a daily planner to schedule exactly what the kitchen needs to cook each day.
- 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.
- A custom calculator instantly adds up the total grocery expenses for the planned menu.
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.
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.