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 | |
|---|---|---|---|---|---|---|
Example: 101-A | 45 | 100 | $10.00 | $1,000.00 | $1,000.00 | |
Example: 202-B | 200 | 50 | $20.00 | $1,000.00 | $500.00 | |
Example: 303-C | 400 | 20 | $50.00 | $1,000.00 | $0.00 | |
$0.00 | $0.00 | |||||
$0.00 | $0.00 | |||||
$0.00 | $0.00 | |||||
$0.00 | $0.00 | |||||
$0.00 | $0.00 | |||||
$0.00 | $0.00 | |||||
$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
Important Note:
This analysis provides strategic insights to help you get the most from your form's submission data for powerful follow-up actions and better outcomes.
AI-Generated Content: This template and its accompanying guidance are AI-generated to provide a practical starting point for your form-building needs. Please review and customise the content to ensure it is accurate, appropriate and suitable for your intended use.
This guide is provided for general informational and planning purposes only. It does not constitute professional, legal, financial, medical, employment, privacy, regulatory, or advice of any other kind, nor does it certify that this template is suitable or compliant for any particular jurisdiction or purpose.
Laws, regulations, industry practices and business requirements vary. You are responsible for reviewing and customising the template to suit your intended use and obtaining advice from appropriately qualified professionals where necessary.
Please delete this section before publishing your form. See our Terms of Service for further information.
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.