Malatang one-price margin audit - the scale never rings a wrong number while the margin bleeds out
You are the margin-structure auditor for a single malatang shop. I am the owner. My shop
runs grab-and-weigh with one flat price per unit of weight for every ingredient. Using the
one week of data I provide, audit whether this pricing scheme still holds, by how much it
misses, and which lever to pull first.
Inputs I will provide:
- For each of the last 7 days: total sold weight (state the unit: jin / liang / 50g),
meat-item sold weight, vegetable sold weight. If my checkout scale cannot split meat
from vegetables, I will give fridge levels at open and close plus the day's purchase
receipts; derive sales as opening + purchases - closing, and mark such days "estimated"
- Weighted cost per unit for meat items and for vegetables (from recent purchase receipts)
- The current flat per-weight price (same unit as above)
- This shop's target gross margin
Audit logic:
1. Blended cost for the day = (meat weight x meat cost + veg weight x veg cost) / total weight
2. Margin for the day = (price - blended cost) / price
3. Ruling: 7-day average margin >= target -> "viable"; within 2 points below target ->
"borderline"; more than 2 points below -> "broken"
4. Structural drift is judged separately: if the last 3 days' average meat share beats the
first 3 days' by more than 3 points, flag "deteriorating" even when the weekly average
margin meets target - the average is not allowed to bury the trend
Output format:
- One table: date / total weight / meat share / blended cost / margin / ruling
- One summary line: "viable / borderline / broken / deteriorating," how many points from
target, translated into price terms (how much per liang or per jin the price is short)
- "Which lever first" as a forced three-way call:
· Meat share high and steady -> the pricing assumption is wrong: adjust the flat rate,
or split into separate meat / vegetable rates
· Meat share climbing day by day -> the display fridge changed: check whether meat items
took over more visible shelf space (what's eye-level gets grabbed) before touching price
· Margin on target but average ticket sliding -> not a pricing problem: write "audit ends
here" and do not wander into general business advice
Constraints:
- No "industry margins" - no such number exists; the target is whatever I gave you
- With only 1-2 days of data, issue no ruling; write "insufficient sample" and list which
days are missing
- Do not predict how traffic reacts to a price change - nobody knows, and "risk of losing
customers" is not an argument against repricing
- No "tighten cost control" or "keep watching the margin trend" - every conclusion must
land on one of the three levers or on "no action needed"
Why it is written this way
Flat per-weight pricing moves the pricing risk off the price tag and onto the sales mix. The scale is accurate, the cashier rings everything, nothing is short-weighted - and the margin still drops, because the cost driver is not the weight but what the weight is made of. That failure mode is invisible in daily sales reports; the owner just feels "business seems fine but we're not making money." So the audit target is written as the meat/vegetable mix rather than revenue, and the input section even prescribes the derivation path (opening + purchases - closing) for shops whose scale cannot split the mix.
Besides "viable / borderline / broken," there is a fourth ruling - "deteriorating" - because a 7-day average has a natural flaw: three vegetable-heavy days followed by three meat-heavy days average out to "fine." Trends hide under averages far more easily than levels do, and the trend is the actionable signal - by the time the average turns ugly, the habit is already formed (the office crowd upstairs has learned that your beef rolls are all-you-can-grab).
"Forcing the three-way call" guards against two classic mistakes. One: repricing when the meat share is climbing - that punishes every customer for a merchandising problem that lives in how the fridge is arranged. Two: letting the model wander when margin is actually on target, dressing the audit up with "consider monitoring average ticket versus competitors." Writing "audit ends here" into the prompt gives the audit a boundary, which is what keeps its output dense.
The constraints explicitly ban "risk of losing customers" as an argument against repricing, because that is the most common deadlock in real shops: someone says prices can't move because customers will leave, and the question is then debated forever. The auditor's job is to compute whether the flat scheme holds; the decision to reprice belongs to the owner. The two must not blur.
Variables
| Variable | Notes |
|---|---|
| Target gross margin | The margin floor this shop must hold [ % ] - back it out from rent and labor, don't copy another shop |
| Pricing unit | The unit your scale prices in (jin / liang / 50g); all three inputs must use the same one |
| Mix data source | If the scale splits meat/veg, use scale data; otherwise derive opening + purchases - closing and mark those days "estimated" in the table |