Produce Shrink & Rotation Calculator

Operational vs Financial Shrink

This is the operational rotation tool — it works at the lot and case level, asks today’s question (mark down which strawberries, donate which kale, discard which raspberries), and outputs a printable action list a produce manager can walk the case with. The Shrink & Waste Calculator is the financial sibling — it works at the department and period level in dollars, computes COGS, gross profit, and shrink percent of sales, and answers the CFO’s question (how much was lost this quarter and where). Use both: this one to decide what to touch today, that one to measure how the program is doing over the period.

Category Shelf Life and the Markdown Window

Every perishable category has two days that matter: total shelf life (the day after which the product is no longer saleable) and the markdown day (the day at which managers typically discount to clear remaining stock before discard). The USDA Agricultural Handbook 66 — Commercial Storage of Fruits, Vegetables, and Florist and Nursery Stocks, a public reference — documents typical post-harvest holding windows by commodity under good handling, and is the conceptual basis for the starter values this tool ships with. Your operation’s real numbers will be tighter than the handbook’s lab figures because of supply-chain age before receiving, display conditions, and case turnover. Edit the starter category values against your own quality logs before trusting the recommendations.

When Markdown Beats Hold

Holding a lot at full price preserves margin per unit but risks ending the shelf-life window with units left over — and those units become 100% loss. Marking the lot down lifts the daily sell-through (the tool’s model assumes the lift roughly doubles velocity, capped at 60% of remaining stock per day) and trades per-unit margin for lower unsold-unit risk. The crossover point is where projected revenue at the marked-down price plus residual cost beats projected revenue at full price plus residual cost. The tool walks through 10%, 20%, 30%, 40%, and 50% discount candidates and returns the shallowest one that wins — so the price doesn’t get over-discounted.

Markdown vs Donate vs Discard

Past the markdown day, if no markdown candidate beats holding, the tool compares donation versus discard. The Bill Emerson Good Samaritan Food Donation Act provides federal liability protection for food donors acting in good faith, and donations to qualifying organizations can carry an enhanced tax deduction — the tool deliberately models donate recovery as zero revenue (it doesn’t claim a tax outcome it can’t verify) but ranks donate above discard whenever the lot is still wholesome. Past shelf life, the lot is discarded with a full cost loss recorded.

Automating Rotation

This calculator runs in the browser against numbers you type. The next step — and the one that actually moves the loss number — is wiring the receiving feed and POS movement into a nightly process that produces this list automatically for every store. I build perishables analytics for grocery and fresh-food operations. See grocery and retail services. Companion tools: Shrink & Waste Calculator, Cycle Count Planner, Reorder Point Dashboard, and ABC Analysis Tool.