Inventory Health Report
Prepared for Maple Street Pet Supply — a single-location independent pet store.
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:
| Product | Sold / 90 days | Days out | Est. sales lost |
|---|---|---|---|
| Acana Wild Prairie Recipe dog food, 25 lb | 14 | 12 | ≈ $150 |
| Orijen Cat & Kitten, 12 lb | 11 | 9 | ≈ $130 |
| Stella & Chewy's Freeze-Dried Dinner Patties, 25 oz | 19 | 6 | ≈ $170 |
| Greenies Dental Treats, Large 36 ct | 23 | 15 | ≈ $210 |
| KONG Classic, Large | 17 | 21 | ≈ $95 |
| Fromm Gold Adult dog food, 30 lb | 9 | 18 | ≈ $160 |
| Vital Essentials Freeze-Dried Minnows, 1 oz | 26 | 4 | ≈ $60 |
| Earth Animal No-Hide Chews, Medium 2 pk | 15 | 11 | ≈ $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:
| Product | On hand | Last sold | $ tied up (retail) |
|---|---|---|---|
| Discontinued-brand kibble, assorted (brand exited the market) | 18 bags | 214 days ago | $612 |
| Halloween pet costumes, assorted | 17 | 312 days ago | $289 |
| Aquarium castle ornaments | 22 | 196 days ago | $264 |
| Holiday bandana assortment (seasonal) | 34 | 288 days ago | $238 |
| Small-animal yogurt treats — check expiry dates | 41 | 231 days ago | $184 |
| Fish medication, slow-moving lines | 13 | 187 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.
| Supplier | Lines | Est. cost |
|---|---|---|
| Phillips Pet Food & Supplies | 46 | $2,940 |
| Pet Food Experts | 31 | $1,865 |
| Animal Supply Company | 18 | $940 |
| Stella & Chewy's (direct) | 9 | $600 |
| Fromm Family Foods (direct) | 6 | $585 |
| Total refill | 110 | $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:
| Problem | Count | Why it matters |
|---|---|---|
| Duplicate listings (same product, two records) | 18 | Stock and sales split across two records — both look wrong |
| Products with no cost entered | 12 | Margin on these is invisible — you can't tell if they make money |
| Products priced below cost | 7 | Every sale loses money until the price or the cost is corrected |
| Products with no supplier assigned | 23 | They 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
- 1Send the Phillips and Pet Food Experts orders today. They cover 61 of the 87 stockouts, including the four fastest movers — that's most of the ≈ $1,085/month leak closed with two emails.
- 2Clear the discontinued-brand kibble this week. The brand is gone from the market; the $612 on the shelf only gets older. A 40%-off bin recovers most of the cost — waiting recovers none of it.
- 3Merge the 18 duplicates before the next order. Until they're merged, every reorder quantity for those products is a guess split across two records.
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.