Estimate days of cover
- Inputs
- OnHand 90, SoldInWindow 30, window 90 days.
- Output
- Daily sales are 30 / 90; cover is 270 days.
This uses the supplied period sales, not a forecast.
Slow-moving inventory
Analyze stock, costs, period sales and last-sale dates from Excel or CSV. Identify idle items, unknown sales dates and estimated days of cover; export results.
Free to useNo signupMade for daily work
Slow-moving inventory
Analyze supplied sales history. Last-sale recency is not the physical age of stock.
Synthetic example. XLSX: first worksheet only. Up to 2,000 rows, 64 columns and 5 MB; data stays local.
Headers: SKU, OnHand, UnitCost, SoldInWindow, LastSaleDate (YYYY-MM-DD)
SoldInWindow is total sales in the N days ending on the as-of date. Blank last-sale dates remain Unknown. Zero sales has no finite days-of-cover estimate.
Current results
Swipe the table sideways to see all columns.
Useful? Share this tool.
Share the tool address. Your entered values are not included.
How this tool works
Cover = on hand ÷ (sales in window ÷ window days). Review flags include stock with no period sales, old last-sale dates or missing dates. These are candidates to investigate, not automatic write-offs or future-demand predictions.
Files and privacy
Where is my data processed?
On this device. The tool does not upload your data or synchronize inventory. Exports contain values only. Scan lists and results are not stored after you leave.
What if I edit an input?
Calculated outputs, printing and exports become unavailable until you rebuild the result, so a stale result is not exported.
Worked example
Illustrative inputs and outputs to help you check your own task.
Treat missing dates honestly
- Inputs
- An item has stock and its LastSaleDate is blank.
- Output
- It is marked Last sale unknown for review.
A last-sale date does not reveal the physical age of stock.
Start with reliable stock records
Try the free Excel sample for product setup, stock balances and pack-rounded reorder suggestions. The full AUD29 kit adds the overview and stocktake, with 200 product rows and 2,000 movement rows.
No email required. The sample is a working file with synthetic data. The full kit is a blank template; applicable taxes are included in AUD29.
Your work stays yours.
These tools run in your browser. They do not upload your entries or store them after you leave. Downloads are created on your device. Hosting providers may process standard access logs.