Back to Cookbook
OpenClaw recipe

Menu Engineering on Autopilot: From POS Sales to Profit Matrix

Stop guessing and start knowing which menu items actually make you money

Pulls daily POS sales data and ingredient costs to calculate food cost percentage and contribution margin per item, then auto-generates a menu engineering matrix that classifies every dish as Star, Plowhorse, Puzzle, or Dog.

CommunitySubmitted by codepm03Work15-20 minutes
Try in KiloClawFree 7-day trial

INTEGRATIONS NEEDED

PROMPT

I run a restaurant and want to automate menu engineering. Each day, pull my POS sales data and match it against my ingredient cost database to calculate food cost percentage and contribution margin per menu item. Classify each item as Star (high margin, high popularity), Plowhorse (high popularity, low margin), Puzzle (high margin, low popularity), or Dog (low margin, low popularity). Output a clean matrix report with one-line action recommendations per item (e.g. promote, reprice, remove).

How It Works

This automation recipe takes daily POS sales data, pulls ingredient costs from supplier invoices or a database, calculates food cost % and contribution margin per item, then auto-generates a menu engineering matrix. The owner gets a clean report: "Butter Chicken = Star (promote it), Naan = Plowhorse (raise price or reduce portion), Gobi Manchurian = Dog (consider removing)."

What Others Get

You stop guessing and start knowing. Instead of "I think this dish sells well," you get a data-backed matrix that tells you exactly which items make you money, which ones cost you money, and which ones need a price tweak.

Setup Steps

  1. Export daily sales data from your POS system (CSV or API)
  2. Prepare an ingredient cost sheet or connect to your supplier invoice database
  3. Point the automation at both data sources and run the recipe
  4. Review the generated matrix and act on the Star/Plowhorse/Puzzle/Dog classifications
Tags:#workflow#restaurant#menu-engineering#analytics#pos