SQL / PYTHON / SYNTHETIC DATA
Inventory Insight
A public demonstration of sales-and-return reconciliation and inventory review logic. Every record in this report is fictional.
NET SALES
$51,850
ON-HAND UNITS
160
REVIEW CANDIDATES
1
Reconciliation: PASS — source net amount equals SQL summary output.
| Product | Name | Net units | Net sales | Returns | On hand | Signal |
|---|---|---|---|---|---|---|
| DEMO-A100 | Atlas Valve | 28 | $33,600 | 0 | 90 | Review inventory level |
| DEMO-B200 | Beacon Mixer | 9 | $14,400 | 0 | 18 | Monitor |
| DEMO-C300 | Cobalt Panel | 11 | $3,850 | 2 | 12 | Monitor |
| DEMO-D400 | Drift Kit | 0 | $0 | 0 | 40 | No demand in period |