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.
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
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.
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 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.
PERFORMANCE BY PROMOTION TYPE
| Promotion type | Weeks | Avg units | Avg lift | Extra 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.
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.
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.
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.
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.
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.
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.
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