DEMO DASHBOARD · Example data for a fictional bar, “The Copper Tap.” Not real figures.

Weekly overview

Sample week · The Copper Tap Week of Example data

What this means this week

    Pour cost: actual vs. theoretical

    Gap between the lines = drinks poured but not rung in. Last 6 weeks.

    Pour cost by category vs. target

    Bars = this week. Target range is a common rule of thumb.

    Top sellers this week

    Where the beverage dollars go

    Cost of product used this week

    Sales by category

    POS sales this week

    Category scorecard

    Mixers have no direct POS sales, so their cost rolls into liquor. Targets: common industry rules of thumb, not standards.

    Biggest variances this week

    Actual usage (counts) minus theoretical usage (POS sales × pour size). Rule of thumb: under 2–3% is normal spillage.

    Where to look first

      Cash tied up in slow movers

      Items with more than 4 weeks of supply on hand, value at cost

      Weeks of supply = on hand ÷ this week's usage. Suggested action: run a special (see Drink specials), stop reordering, or return/swap with your distributor rep.

      Order to par

      Slow movers are held back on purpose. Order quantities round up to whole units.

      Beverage COGS reconciliation ·

      How inventory counts tie to the monthly P&L (example numbers)

      Where the cost went

      What you should have used vs. what you did

      Gross margin

      Why this matters

        Built from this week’s slow movers. Costs use the bar’s own unit costs; sales per week are estimates. Pour cost runs above the liquor target on purpose: the goal is turning dead stock into cash. Drink names are examples.

        Specials style

        Menu Pricing Review · sample

        This is example output for The Copper Tap, marked as sample data. A real review flags drinks priced below target pour cost, suggests a new price for each one, compares the list to similar local bars, and sorts every item into Stars, Plowhorses, Puzzles or Dogs.

        One-time add-on, about $199, or included in the Full Service tier.

        How the four categories work

        Classic menu engineering, using this week’s sales and pour cost vs. category targets.

        Stars High sales, healthy margin. Protect these.
        Plowhorses High sales, tight margin. Raise the price or tighten the pour.
        Puzzles Low sales, healthy margin. Feature them so they get ordered.
        Dogs Low sales, tight margin. Reprice, pour in a special, or drop them.

        Local comparison figures are illustrative sample ranges for similar independent bars, not a live market survey. Suggested prices assume volume holds; a real review would talk through the trade-offs. Targets: liquor 18–22%, draft 20–24%, package 24–28%, wine 28–35% (rules of thumb).

        Upload this week's inventory sheet

        Demo: your file is read in the browser only. Nothing is sent anywhere.

        📄
        Drop your count sheet here
        CSV in this demo · required columns listed below

        Templates: sample_inventory.csv · sample_inventory.xlsx
        Columns: item, category, subcategory, count_unit, unit_cost, par, begin_count, purchases, end_count, pour_size_oz, menu_price, pos_units_sold, container_oz