Restaurant BOM & COGS Calculator (MySQL)

Dashboard

Manage recipes, ingredient prices, and instantly see margins.

Customer:

Calc Method:

Customers

Manage customer accounts for customer-specific COGS and pricing

Name	Business ID	Type	Address	Phone	Actions

Total Dishes

Avg Margin %

Top Dish (by margin)

—

Dishes

All dishes and quick actions

🔍

Dish	SP	COGS	Margin

Ingredients Quick

Add or update ingredient costs

BOM Tools

Create recipe or map ingredients

Dishes

🔍

Dish	Category	SP	COGS	Margin %	Actions

Ingredients

🔍

Item Code	Ingredient	UOM	Cost/Unit	Last Updated	Actions

BOM (Recipes)

🔍

Dish	# Ingredients	COGS	SP	Margin	Actions

Reports

Customer-specific COGS analysis and reports

⚠ Customer Selection Required

Please select a customer from the dropdown above to view customer-specific reports.

Select Dish:

Margin Comparison

Compare margins at different selling prices for the selected dish

Select a dish above to enable margin comparison

Export Reports

Download various reports in Excel format (.xlsx)

Dishes Report

Export all dishes with prices, COGS, and margins

Ingredients Report

Export all ingredients with costs and units

BOM (Recipes) Report

Export all recipes with ingredient details

COGS Analysis Report

Export detailed COGS breakdown for all dishes

Complete Report

Export everything in one Excel file with multiple sheets

Margin Analysis Report

Export margin analysis with profit calculations

Export Options

Include Headers Format Numbers Auto-size Columns

💡 Tips:

• All exports are in Excel (.xlsx) format

• Files are automatically downloaded to your Downloads folder

• Complete Report includes all data in separate sheets