Deepdive
Item-level portfolio breakdown: evaluate matrix positioning, menu priority, trend movement, and operational performance metrics across categories.
💡 How to choose a subpage
Use this guide to select the layer of menu analysis according to your operational needs.
🏠
Macro
Overview
View the overall health of the restaurant menu.
🏪
Meso
Deep Dive
View the menu distribution map along with the conclusions for action.
📈
Micro & Historical
Report Card
View the list of skyrocketing/plummeting menus, then dissect their individual performance in depth.
📂
Raw Data
Data Directory
Explore raw data of menu performance per branch.
🏪 LOCATION FILTER
Portfolio Analysis by Branch
Select 'All Branches' for consolidated business aggregates, or select a specific location to isolate branch-level menu performance.
📖 Menu Matrix Classification Methodology
Categorizes menu items relative to active period sales volume and revenue medians.
⭐
High Volume & High Revenue
Star
Sales volume and gross revenue both equal to or exceeding period medians.
🧩
Low Volume & High Revenue
Puzzle
Gross revenue at or above period median, with sales volume falling below period median.
💪
High Volume & Low Revenue
Workhorse
Sales volume at or above period median, with gross revenue falling below period median.
🔻
Low Volume & Low Revenue
Underperformer
Sales volume and gross revenue both falling below period medians.
⭐
7
Star
High volume and high revenue contribution.
🧩
1
Puzzle
High revenue contribution with below-median sales volume.
💪
1
Workhorse
High sales volume with below-median revenue contribution.
🔻
7
Underperformer
Below-median sales volume and revenue contribution.
📌 Chart Interpretation: Horizontal axis represents sales volume; vertical axis represents total revenue. Tooltips provide item-level menu name, category, matrix classification, sales volume, and gross revenue metrics.
🎯 Cross-Item Promotional Analysis & Bundling Framework
🤝
Menu Engineering Cross-Category Dynamics
Evaluates structural opportunities for high-volume Workhorse items (high order velocity) paired with high-revenue Puzzle items (lower order velocity).
💡 Margin Impact Simulation
Item Pairing Scenario
Net Margin Contribution
Standalone: Single Item Baseline
+Rp 3,000
Bundled: Dual Item Pairing (Rp 5,000 Discount)
+Rp 8,000
🛠️ Promotional Bundling Execution Methodology
💎 High-Margin Puzzle Items
| Menu Item | Price (Rp) | Margin Contribution (Rp) |
|---|
| Pudding | 12,000 | 7,500 |
| Milkshake | 15,000 | 10,000 |
| Juice | 20,000 | 12,000 |
🐴 High-Volume Workhorse Items
| Menu Item | Price (Rp) | Margin Contribution (Rp) |
|---|
| Pizza | 22,000 | 2,500 |
| Hamburger | 25,000 | 3,000 |
| Hotdog | 20,000 | 2,000 |
1. Identify High-Volume Anchor Item (Workhorse Table): Select a primary high-velocity item from the Workhorse category (e.g., Hamburger).
2. Pair High-Margin Secondary Item (Puzzle Table): Select a high-margin item from the Puzzle category to complement the anchor item (e.g., Milkshake).
3. Calculate Total Combined Margin Threshold: Sum the individual item margins (Rp 3,000 + Rp 10,000 = Rp 13,000). This value represents the maximum theoretical discount ceiling before unit contribution loss.
4. Simulate Promotional Pricing Structure: Combine standalone prices (Rp 40,000 total) and apply a Rp 5,000 promo discount (promotional price becomes Rp 35,000). Net contribution margin stabilizes at Rp 8,000 per unit transaction.
5. POS Configuration & Mapping: Configure the promo item pairing within the POS database to track order velocity and aggregate margin realization.
🧩 High-Margin Puzzle Items
High Margin Contribution, Lower Order Volume
Items exhibiting gross revenue or margin contribution above median with sales volume below median.
📌 Financial Structure: High unit contribution margin provides substantial clearance for promotional discount structures without breaching unit profitability.
🐴 High-Volume Workhorse Items
High Order Volume, Lower Margin Contribution
Items exhibiting sales volume at or above median with gross revenue or margin contribution below median.
📌 Financial Structure: High transaction frequency makes these items suitable anchor candidates for volume velocity analytics and cross-category item pairing.
💡 Puzzle & Workhorse Calculation Methodology
Calculated using the Menu Engineering Framework (Kasavana & Smith Matrix). The system automatically plots each menu item across two axes by comparing individual item metrics against overall menu portfolio Median baselines:
🧩
Volume < Median | Margin > Median
Puzzle
Items exhibiting above-median unit contribution margin with below-median order volume velocity.
🐴
Volume > Median | Margin < Median
Workhorse
High-velocity anchor items exhibiting above-median order volume with below-median unit contribution margin.
⚠️
Statistical Boundary Consideration (Threshold Proximity)
Due to absolute mathematical median thresholding, items positioned near baseline boundaries may shift matrix quadrants based on minor unit volume fluctuations. Review trailing multi-period trend lines to distinguish structural category shifts from minor volume variance.
Classification metrics update daily using a trailing 30-day performance window.
