huajun.wang

English

简体中文

English

简体中文

Rolling 8-Week PSI Production-Sales Balance Sheet ​

Monitor the dynamic production-sales-inventory balance and flag inventory-level risk.

📊 Rolling 8-Week PSI Supply-Demand Balance

Strictly follows the 03.05 launch ramp example: beginning stock + inbound − sales = ending stock, recomputable week by week.

units
WeekBeginning stockInboundSalesClosing stockDOSStatus
W1 Current120095027 daysLow
W2 95068018 daysCritically low
W3 Warning68059014 daysCritically low
W4 Inbound590128029 daysLow
W5 128096021 daysLow
W6 96062013 daysCritically low
W7 Stockout6202605 daysCritically low
W8 Bulk inbound260118022 daysLow
💡 Metric notes:DOS = Closing inventory ÷ Weekly sales × 7 (days of supply)• ● Healthy 45 ≤ DOS ≤ 75 days• ● Warning 20 ≤ DOS < 45 or 75 < DOS ≤ 110 days• ● Danger DOS < 20 (Stockout) or DOS > 110 days (Overstock)
During launch ramp, stock has just arrived and sales are climbing, so DOS naturally runs below the steady-state healthy band; all 8 weeks sitting in the tight/stockout zone is expected.

← Swipe horizontally to see the full table →

User Guide ​

  1. Planned production — Expected production quantity for the week
  2. Actual production — Actual production quantity for the week
  3. Planned sales — Expected sales quantity for the week
  4. Actual sales — Actual sales quantity for the week
  5. Ending inventory — Automatically calculated (prior-period inventory + actual production - actual sales)
  6. DOS — Days of supply (ending inventory ÷ weekly sales × 7)

Status Definitions ​

StatusDOS RangeDescription
🟢 Healthy≤ 45 daysInventory level is normal
🟡 Elevated45-60 daysNeeds attention; production may need adjusting or promotion
🔴 Too high> 60 daysInventory overhang risk; immediate action required

Reference Documents ​

huajun.wang Smart Hardware GTM Playbook · Methodology

© 2026 huajun.wang