Inventory & Demand Forecasting
No forecast on screen yet
Click Load Recent Data for a quick sync, or Full Data Load for a full 12‑month rebuild. Forecasts, purchase recommendations, and P&L appear below after the first successful run.
If the sales cache is already built, this page tries to restore the last forecast from cache automatically—if you still see only this message, use Load Recent Data.
-
-
-
-
| SKU | Avail | On hand | Alloc | Forecast | Flag | SKU Detail |
|---|
Stock column: Available (used for flags & PO) · on hand / allocated. Flag and View stay visible when scrolling.
| TYPE | SKU | Supplier | Stock | SOO | Avg Cost | Sell | Marg. | Fcst | PO | Order | Total | Flag | View |
|---|
Figures use the same forecast, Cin7 costs/prices, and reorder logic as Purchase Recommendations. Load forecast data first.
| Revenue | — |
|---|---|
| Forecasted sales for next ~30 days: median monthly units × sell price (Held SKUs only). When Available is known, volume is the lesser of that median and Available (not physical on-hand). SKUs with Available ≤ 0 are excluded; missing inventory uses the median only. | |
| Margin | — |
| Forecasted margin for next ~30 days: same volume basis as revenue (median capped by Available when known); out-of-stock SKUs excluded. | |
| Stock on order (value) | — |
| Stock on order from suppliers × average cost (all SKUs with on-order qty). | |
| Operating expenditure | |
| Total operating expenses | $0.00 |
| Sum of the operating lines above: fixed dollar amounts plus Bank fees and Courier as % of P&L revenue (Revenue row). Saved on this server when you change a value. | |
| Projected expenditure | — |
| All items flagged Reorder: order quantity × average cost (uses your Order column overrides). | |
| Cashflow | — |
| Margin − total operating expenses. | |
| Bank or liquid balance you enter (saved on this server). Remaining cash adds the cashflow line when forecast data is loaded. | |
| Remaining cash | $0.00 |
| Cash at hand plus cashflow (if no forecast yet, cashflow is treated as $0). | |
| Total working capital | — |
| On-hand stock × average cost (all SKUs). | |
Create a virtual parent SKU assembled from existing Cin7 SKUs. Add each component with the quantity needed to build one parent unit. Manual forecasts for these parents (next tab) add demand to the child components in Purchase Recommendations.
| Child SKU | Qty per parent |
|---|
| Parent SKU | Name | Components |
|---|
Enter expected build quantities per parent for the next six months. These flow through the BOM to add component demand in Purchase Recommendations. Saved on this server as you type.
| Parent SKU |
|---|
Totals below are added to each child SKU's forecast (rebuild forecast to apply to Purchase Recommendations).
| Child SKU | 6‑mo total |
|---|