Module 6 โ Recipe Costing & Analysis
Primary Purpose: Understand real-time costs and profit margins per recipe and menu item; identify when margins change and why with comprehensive financial analysis.
View all GP and cost reports across venues
View and adjust recipe costs per venue
See quantities and portion costs (limited)
Export COGS and variance data
Understand current costs and profit margins per recipe
Monitor GP% across all menu items and venues
Identify when margins change and understand why
Test price changes and forecast impact on profitability
Strong profit margin, healthy recipe
Moderate margin, monitor closely
Action required, review pricing or costs
GP% = ((Selling Price โ Cost) รท Selling Price) ร 100
Example: Dish sells for $25, costs $7.50 โ GP% = (($25 โ $7.50) รท $25) ร 100 = 70%
Open "Costing & Analysis"
Default Dashboard Shows:
Ingredient Cost = Quantity ร Unit Cost ร (1 + Wastage %)
Example: 500g butter @ $10/kg with 5% wastage = 0.5 ร $10 ร 1.05 = $5.25
Total Cost = ฮฃ (All Ingredient Costs + Component Costs)
Sum all ingredients and linked components
Cost Per Serve = Total Cost รท Batch Yield
Example: $45 total cost รท 6 portions = $7.50 per serve
GP% = ((Sell Price โ Cost Per Serve) รท Sell Price) ร 100
Example: ($25 โ $7.50) รท $25 ร 100 = 70%
Sortable columns: name, cost, GP%, selling price, last updated
Adjust prices with sliders, see instant GP% updates
Visual timeline of margin changes over days/weeks/months
PDF (formatted report) / CSV (data spreadsheet)
List of recipes below threshold with "View Recipe" button
Hover/tap ingredient to see cost history with +/โ % change
Toggle between recipe view and ingredient breakdown
"View Affected Recipes" button when ingredient price changes
Cost and GP values with clear visual indicators
Cost and GP values with clear green/amber/red indicators
Toggle between recipe and ingredient views seamlessly
Hover/tap ingredient shows historical costs with % changes
Simplified trend visualizations for mobile/tablet display
Quick access when ingredient price changes impact multiple dishes
GP% recalculates instantly as values change
One-tap export to PDF or CSV with date range selection
Critical GP alerts displayed prominently on dashboard
Clear before/after comparison in what-if scenarios