Cincinnati CPG Edge is independent Kroger news and analysis for CPG brands.
No spin. No agenda. Just the insight to sell smarter and make all of us better vendors.

PLANNING TOOLS  |  FREE TO USE

Supplier Calculators

Quick math for the numbers that come up in every Kroger conversation. Type in your own figures and the results update as you go. Nothing you enter is saved or sent anywhere.

New: Why does a 23% gross margin leave a grocer about two cents on the dollar? Read Gross vs. Net Margin and try the gross to net waterfall calculator.

CALCULATOR 1

Margin: yours and Kroger's

Your margin and Kroger's margin are two different numbers. See both, and the shelf price a target margin needs.

$
$
$
%
Cost per unit to Kroger-
Kroger margin-at the shelf price
Your gross margin-on what Kroger pays you
Shelf price for target margin-

Kroger margin = (shelf price minus unit cost) divided by shelf price. Your gross margin = (unit cost to Kroger minus your cost) divided by unit cost to Kroger. Kroger sets the retail price, so treat the shelf price as an estimate.

CALCULATOR 2

Margin-neutral promotion funding

Retailers generally expect promotions to be margin neutral, and margin accretive is better. Enter your case cost and casepack, any everyday EDLC allowance, your SRP and the sale price you want, and see the overlay allowance it takes to stay margin neutral.

YOUR EVERYDAY SETUP

$
$
$

YOUR PROMOTION

$
pts
$
Unit cost to Kroger-list cost per unit
Everyday net unit cost-after EDLC
Everyday Kroger margin-at your SRP
Overlay needed per case-to stay margin neutral
Overlay for your target-neutral plus the extra points
Total overlay funding-for the expected units
Lowest neutral sale price-with your budgeted overlay
Kroger margin with your budget-at the target sale price

Unit cost = case cost divided by casepack. Everyday net cost = unit cost minus the EDLC per unit. Everyday margin = (SRP minus everyday net cost) divided by SRP. Overlay needed per unit = everyday net cost minus sale price times (1 minus everyday margin); a case allowance is that amount times the casepack. A case allowance is paid off invoice on cases Kroger buys, while a scan allowance is paid on units actually sold, so total case funding can run higher if cases are bought ahead of the event.

CALCULATOR 3

Promotion planner: lift and return

Estimate what a temporary price reduction costs you and what it buys in extra units.

$
$
$
$
%
Shopper discount-off the regular price
Promoted units-total for the event
Extra units-above base
Your trade spend-allowance times all promoted units
Cost per extra unit-trade spend divided by extra units
Kroger margin on promotion-after your allowance

Trade spend is paid on every promoted unit, including the ones that would have sold anyway, which is why cost per extra unit matters more than the lift alone. Lift is your own estimate; use past results where you have them.

CALCULATOR 4

Promotion results: lift and ROI

After the event, measure what the promotion really did. Lift compares your average promoted week with your average non-promoted week, in units sold.

YOUR UNITS

YOUR COSTS AND SPEND

$
$
$
$
Lift-average promoted week vs. average week
Extra units per week-
Total extra units-for the event
Total trade spend-allowance on all promoted units plus fees
Extra gross profit-extra units times your profit per unit
Promotion ROI-(extra profit minus spend) divided by spend
Cost per extra unit-
Break-even lift-lift needed for profit to cover spend

Lift = (average promoted week minus average non-promoted week) divided by average non-promoted week. Trade spend = allowance times every promoted unit sold, plus fixed fees, since the allowance is paid on the base units too. Extra gross profit = extra units times (your price to Kroger minus your cost). ROI above 0% means the extra profit paid for the promotion. Pick non-promoted weeks close to the event and leave out holiday or out-of-stock weeks for a fair baseline.

CALCULATOR 5

Promotion history: what worked best

Paste up to 52 weeks of unit sales and see which promotion types and weeks drove the biggest lift, and which fell flat. Lift is each promoted week compared with your average non-promoted week.

NAME YOUR ANALYSIS

PASTE YOUR WEEKS

Three columns, copied straight from Excel or Google Sheets: Week, Units, Promo type (TPR, Ad, Display, BOGO or your own labels). Leave the promo type blank for non-promoted weeks. Your data stays in your browser and is never uploaded or saved.

PROMOTION HISTORY FORSample Brand
Baseline week-average non-promoted week
Promoted weeks-average lift
Extra units from promotions-above baseline, all promoted weeks
Best promotion type-
Worst promotion type-
Best week-
Worst week-

PERFORMANCE BY PROMOTION TYPE

Promotion typeWeeksAvg unitsAvg liftExtra units

52-WEEK VIEW Non-promoted Promoted Baseline

Tips: use weeks from the same stores and item set, and consider leaving out holiday or out-of-stock weeks from the non-promoted group so the baseline is fair. Lift does not count the dip some items see in the weeks right after a promotion.

CALCULATOR 6

Velocity: units per store per week

The number Category Managers look at first. Turn total movement into velocity, and see what it takes to hit a goal.

$
Units per store per week-
Dollars per store per week-
Change needed for goal-versus today
Weekly units needed-across all stores for the goal

Use the same store count and weeks your data covers. Comparing velocity across items only works when the time period and store base match.

CALCULATOR 7

New item revenue projector

Project year one units, sales and profit for a new item, including the ramp up, promotions, trade and slotting payback.

$
%
$
%
%
%
$
Year one units-
Year one retail sales-
Your gross revenue-
Your net revenue-after trade and slotting
Your profit after trade and slotting-
Slotting payback-
Survival check-
Price to retailer-per unit

The ramp grows evenly from the starting share to full velocity. Promotion lift is spread across the year as an average. Your price to the retailer is the SRP less the retail margin. Compare the survival check to the velocity your category typically needs.

CALCULATOR 8

Distribution expansion

What adding stores or divisions is worth, plus the cases it takes to fill the new shelves.

$
%
$
Added units per week-
Added units for the period-
Added retail sales-
Added revenue to you-
Added gross profit to you-
Store count growth-
Initial fill-
Initial fill value-at price to retailer

New stores often sell a little slower than your best stores at first. Use a conservative velocity, and check whether free fill is part of the deal.

CALCULATOR 9

Cost increase impact

See the new shelf price needed to hold the retailer's margin, and what a cost increase does to volume and profit.

$
%
$
%
$
New price to retailer-
SRP to hold retailer margin %-
Shelf price change-
Expected units after-
Change in your revenue-
Change in your gross profit-
Change in retailer margin dollars-
Pass through pennies only-SRP if retailer keeps the same cents

Volume sensitivity varies a lot by category. 1% lost per 1% price change is a common starting point; use your own history if you have it. Expect a Category Manager to look hard at the retailer margin dollars line.

CALCULATOR 10

Break even velocity

The minimum units per store per week an item needs to cover trade, slotting and its fixed costs.

$
$
%
$
$
Contribution per unit-after trade and COGS
Break even units-
Break even velocity-units per store per week
Cushion versus your velocity-

Other annual costs can include broker fees, demos, marketing and digital spend for this item. If contribution per unit is zero or negative, no velocity will break even.

CALCULATOR 11

Digital coupon ROI

Estimate what a digital coupon costs, including clip and redemption fees, how many units it really adds, and whether it pays back.

%
$
$
$
$
%
$
Redemptions-
Total cost-
Cost per redemption-
Incremental units-
Profit from incremental units-
ROI-
Break even incremental share-of redemptions

Not every redemption is a new sale: many go to shoppers who would have bought anyway. The incremental share and repeat purchases are the key assumptions, so test a few values. Repeat units count only for truly new buyers.

CALCULATOR 12

Order and inventory planner

Turn weekly movement into a reorder point, a suggested order and days of supply.

Units per day-
Reorder point-
Suggested order-
Days of supply-
Next step-

Reorder point = daily units x (lead time + safety stock). Suggested order covers the days between orders, rounded up to full cases.

These calculators are for planning estimates only and use the numbers you enter. Kroger's own margin, pricing and velocity measures may be calculated differently. Questions or an idea for another calculator? info@cincinnaticpgedge.com