This section tracks the physical presence of stock and how long it has been occupying warehouse space. Use these metrics to identify "slow-movers" before they become obsolete.
SKU | Days in Stock | Quantity | Unit Cost | Current Inventory Value | Write-off Risk | ||
|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | ||
1 | Example: 101-A | 45 | 100 | $10.00 | $1,000.00 | $1,000.00 | |
2 | Example: 202-B | 200 | 50 | $20.00 | $1,000.00 | $500.00 | |
3 | Example: 303-C | 400 | 20 | $50.00 | $1,000.00 | $0.00 | |
4 | $0.00 | $0.00 | |||||
5 | $0.00 | $0.00 | |||||
6 | $0.00 | $0.00 | |||||
7 | $0.00 | $0.00 | |||||
8 | $0.00 | $0.00 | |||||
9 | $0.00 | $0.00 | |||||
10 | $0.00 | $0.00 |
Tracking where the aged stock is located helps determine if environmental factors (like humidity or heat) are accelerating the depreciation of the items.
Primary Warehouse Zone (e.g., Cold Storage, Aisle 4, Bulk Overstock):
Storage Environment Status:
Controlled
Ambient
High-Risk
Last Physical Audit Date:
Just because an item is old doesn't mean it's useless—but it often means the market has moved on. Use this section to justify the "Write-off Risk" calculated above.
Demand Trend:
Stable
Declining
Obsolete (No demand)
Replacement Product Available?
Reason for Stagnation (e.g., Seasonal overstock, Order cancellation, Technical obsolescence):
For items flagged with a 50% or 100% risk, an action plan is required to recover as much "Healthy Stock Value" as possible.
Recommended Action:
Markdown: Discount by 25% to 50% for immediate sale
Bundle: Pair with high-velocity SKUs
Return to Vendor: Check for buy-back agreements
Donation / Scrap: Formalise write-off for tax purposes
Assigned Stakeholder:
Gross Inventory Value (Book Value):
Total Potential Write-off Amount:
Healthy Stock Value (Net Realisable):
Form Template Insights
Please remove this form template insights section before publishing.
The form is structured to move from raw data (SKUs and counts) to derived financial values (risk-adjusted amounts) and finally to aggregate metrics (totals). This flow ensures that the summary figures at the end of the document are traceable back to individual line items. The use of a standardized table format facilitates the comparison of stock age across different product categories.
The "Days in Stock" field serves as the primary driver for the document’s logic. Because this value changes daily, the form is designed as a "snapshot in time." The formulas for "Write-off Risk" are time-dependent, meaning the form reflects the financial health of the warehouse specifically for the date the data was extracted or the audit was conducted.
The "Write-off Risk" column is a calculated field that serves as a Net Realizable Value (NRV) indicator. Its data type is numeric/currency because it represents the recoverable portion of the initial investment. The logic within this column creates a staggered depreciation model, transitioning the inventory from a "Current Asset" to a "Potential Loss" based on the 180-day and 365-day thresholds.
Beyond the numerical table, the form includes descriptive sections for warehouse locations and market relevancy. These sections provide qualitative context to the quantitative data. For example, knowing the storage conditions or the reason for stagnation explains why certain items are reaching the 365-day threshold, complementing the mathematical risk assessment with operational reality.
The summary metrics—Total Potential Write-off Amount and Healthy Stock Value—are the final outputs of the form.
To configure an element, select it on the form.