Lootnhood · Business Services

Inventory Health Report

Prepared for Maple Street Pet Supply — a single-location independent pet store.

Sample report — fictional store
How to read this page: Maple Street Pet Supply doesn't exist, and every number below is made up. What's real is the format — this is the exact structure, depth and plain language of the report your store gets. A real report is built from your sales and inventory data, and every figure in it is yours.
Store: Maple Street Pet Supply Data reviewed: 12 months of sales + current stock Report date: Sample Prepared by: Loot, Lootnhood
2,438
active products reviewed
87
out of stock — and still selling
$11,240
tied up in dead stock (retail value)
$6,930
reorder plan, 5 suppliers

1 · Empty shelves that are still selling

These products are at zero stock but sold within the last 90 days — every day they stay empty is a sale that walks to a competitor or a big-box store. Top of the list, by how fast they move:

ProductSold / 90 daysDays outEst. sales lost
Acana Wild Prairie Recipe dog food, 25 lb1412≈ $150
Orijen Cat & Kitten, 12 lb119≈ $130
Stella & Chewy's Freeze-Dried Dinner Patties, 25 oz196≈ $170
Greenies Dental Treats, Large 36 ct2315≈ $210
KONG Classic, Large1721≈ $95
Fromm Gold Adult dog food, 30 lb918≈ $160
Vital Essentials Freeze-Dried Minnows, 1 oz264≈ $60
Earth Animal No-Hide Chews, Medium 2 pk1511≈ $110
Top 8 of 87 items≈ $1,085

The full report lists all 87, each with the quantity to reorder (Section 3). Estimates use each product's own sell-through rate × days out of stock.

2 · Dead stock — your cash, sitting on shelves

296 products haven't sold a single unit in 180+ days. At retail they're worth $11,240 — at cost, roughly $5,900 of this store's cash is parked in them. The biggest offenders:

ProductOn handLast sold$ tied up (retail)
Discontinued-brand kibble, assorted (brand exited the market)18 bags214 days ago$612
Halloween pet costumes, assorted17312 days ago$289
Aquarium castle ornaments22196 days ago$264
Holiday bandana assortment (seasonal)34288 days ago$238
Small-animal yogurt treats — check expiry dates41231 days ago$184
Fish medication, slow-moving lines13187 days ago$156
All 296 dead-stock products$11,240

The full report lists every one, flagged: clearance candidate, return-to-vendor candidate, or write-off. Seasonal items are flagged to hold or clear by season, not lumped in with true dead stock.

3 · The reorder plan — supplier by supplier

Every out-of-stock seller and every fast mover running low, grouped into order-ready lists per supplier. Quantities are sized by each product's own sell-through rate — fast movers get 60 days of cover, steady sellers 45, slow movers 30 — so the order fixes the shelves without over-buying.

SupplierLinesEst. cost
Phillips Pet Food & Supplies46$2,940
Pet Food Experts31$1,865
Animal Supply Company18$940
Stella & Chewy's (direct)9$600
Fromm Family Foods (direct)6$585
Total refill110$6,930

Costs are estimated at standard wholesale where an invoice-verified cost isn't on file — the report says which is which, line by line. Nothing is ordered for you; these lists are yours to send, edit or ignore.

4 · Data problems worth fixing

Found while building this report — each one quietly distorts reorders, margins or both:

ProblemCountWhy it matters
Duplicate listings (same product, two records)18Stock and sales split across two records — both look wrong
Products with no cost entered12Margin on these is invisible — you can't tell if they make money
Products priced below cost7Every sale loses money until the price or the cost is corrected
Products with no supplier assigned23They never make it onto any order, however well they sell

Fixing these is a separate service (Dead Stock & Duplicate Purge, Price-Book Cleanup) — this report just shows you they're there.

5 · If it were my store, I'd fix these first

How this report is built: your inventory and sales data, reviewed product by product — year-to-date sell-through for every active item, cover sized by how fast each product actually moves (60 / 45 / 30 days), dead stock measured at 180+ days without a sale. Supplier costs are invoice-verified where invoices exist; estimates are labeled as estimates. Plain language, no dashboard to learn, nothing ordered or sent anywhere without your approval.

Get this report for your store — $199

One-time, no subscription. Delivered within 7 days of receiving your data.
Your dead stock in real dollars, your stockouts named, your reorder plan ready to send.

Purchase the Inventory Health Report — $199 Questions first? Email loot@muse.ai · All services: lootnhood.com/business