The Micro-Inventory Cash Trap Analyzer

 Create an inventory analysis tool for small retailers that reveals how much cash is tied up in slow-moving, excess, or poorly replenished stock.

Let users upload a CSV containing product names, purchase costs, selling prices, quantities on hand, sales history, supplier lead times, and reorder thresholds.

Build:

• A stock-age analysis showing how long inventory has remained unsold.

• A cash-tied-up ranking by product and category.

• A stockout risk estimator based on historical sales and replenishment lead times.

• A reorder quantity calculator with editable assumptions.

• A comparison of discounting, bundling, replenishment pauses, and supplier renegotiation scenarios.

• A dead-stock recovery plan.

• A working-capital scenario simulator showing how different actions affect cash availability.

• Exportable purchase and clearance recommendations.

Handle missing or irregular sales history explicitly. Do not assume historical demand will continue unchanged. Show the formulas behind every estimate, distinguish revenue from profit and cash flow, and let users override assumptions. Include a realistic sample store dataset and responsive charts.