Planning & forecasting

items shown · sample of full item list Activate forecast demand ⓘ

25 … 41

Item	Existing stock

No rows of this type in the 14-row sample — the captured viewport listed packaging materials first (A–Z by variant config).

Showing 14 of 29 items in the captured viewport — Katana virtual-scrolls the full item list Horizon: weeks 16–24 of 26-week capture · projections recompute per location

Project Gaia — static mockup in Filament v3 table idiom. No backend. Sample data: Katana tenant snapshot 2026-04-12, location 11, Balakong Jaya.

Planning — field manifest

Build honesty note: this screen is NOT a standard Filament Resource table. It needs a custom Livewire page (custom Blade grid): pinned Item column, week columns generated dynamically from the horizon picker, per-cell stockout styling, and per-column "Show stockouts" controls are all outside the Table Builder API.

Field	Filament component	Type	Source	FK target
Item	custom Blade cell (pinned left) — TextColumn-equivalent with url()	string	stored: display '[variant config or SKU] product name / variant string'	variants.id
Existing stock	custom cell, red when negative	qty + variant UoM	derived: current on-hand at selected location (negative on-hand allowed, e.g. -3500 pcs)	stock_movements
Present week	custom cell + stockout marker	number	derived: existing stock − forecast demand for remainder of current week	—
Week 17–24 (shown)	custom cells, generated per horizon week	number	derived: cell = previous week − weekly forecast demand + scheduled inbound supply (open MO/PO due that week)	forecasts / mos / po_lines
Week 25–41	— (dropped: horizon truncated to 8 week columns in mockup; captured to W41)	number	derived: same projection formula	—
Stockout marker	conditional cell class (red text + red bottom border)	state	derived: projected value < 0; amber border = zero-stock warning tier (all-zero row)	—
Show stockouts	per-week-column control (custom header slot)	action	highlights/jumps to stockout cells in that week column	—
Activate forecast demand	Toggle (Livewire property)	bool	switches forward projection on/off — rows with no forecast hold flat	—
A / B / C	ToggleButtons filter — class assignments not captured in snapshot	enum filter	stored: variant ABC classification	—
Category	SelectFilter — per-row values not captured on this screen	string lookup	stored: items.category_id	categories.id
Location	Select (page-level scope)	FK	all quantities scoped to one location (11, Balakong Jaya)	locations.id
Weekly / Monthly + week chips	ToggleButtons + custom chip row — Monthly view not captured	enum + int[]	granularity + horizon selection (chips 16–41 in capture); rebuckets same projection	—
All / Products / Materials	Tabs (item type filter)	enum filter	planning list mixes finished products and materials (capsules, holograms, boxes)	—

Engine notes

Projection formula: week cell = previous week − weekly forecast demand + scheduled inbound supply. Rows decline linearly, confirming a flat forecast-demand rate per item (67.2/wk Gad Candy, 84/wk Gad Pouch, 460.6/wk STC30 New, 483.7/wk Double Root, 374.5/wk Taurus, 455/wk OLZZ, 69.3/wk Thor's Hammer, 119.7/wk AlphaMax, 3.5/wk Yes Global Sunset).
Present week = existing stock − forecast demand for the remainder of the current week (Gad Candy: 0 → −134.4, ~2× the steady 67.2 weekly rate — the present-week bucket can span more than one week's demand).
Scheduled supply is netted in: STC30 (New) jumps −5342.4 (W18) → +4197 (W19), an inbound of ~+10,000 units (open MO or PO due W19); same row has existing stock −3500 pcs, so negative on-hand is permitted.
Stockout detection is per-cell: the red underline begins exactly at the first negative week; every week column header offers "Show stockouts".
Forecast demand only applies while the toggle is on; items with no forecast hold flat (300 / 1300 / 20 / 5 rows never change). The mockup toggle demonstrates this: switching it off flattens all rows to existing stock.
Horizon = selected week chips (16–41, ~6 months); Weekly/Monthly rebuckets the same projection. Mockup truncates to Present week + Weeks 17–24.
Grid is per-location — every quantity scoped to the toolbar location (11, Balakong Jaya). No totals/footer row.
Filament build: custom Livewire page with its own Blade grid (pinned first column + horizontal scroll + dynamic week columns) — a standard Resource table cannot express this screen.