—
Agent Call-Outs (goals)
What the agent will surface once the pending segments (Projections, Ratios, Days of Stock) are populated. This card will be redesigned.
Rank SKU by Class
Every classification in the brand. Shows the rank SKU(s) set for each class — or flags classes that don't have one assigned yet.
Filter:
Rank SKUs are today's featured SKU per portfolio. Sales/Day now populated from SPD (L7) — the default period across the app. Plan & Pace columns (Projections / Ratios / DoS) populate once those segments are built.
NB = Hoffman (New Brunswick).
Still in Production = ordered − received − inbound expected (at factory). On Water = inbound expected qty.
📦 FBA Shipment
Decide what goes in the next shipment. Suggested = action-ready candidates. Queued = locked-in items pending shipment creation.
No items selected.
SPD = sales per day (units ÷ days in period). At rollup levels, SPD = sum of SKU SPDs — answers "how fast is this classification/portfolio moving inventory."
Default period = L7 (labeled everywhere). Hover column headers for exact date ranges.
📌 What these numbers mean: Projection quantity shown per month represents the projected sales units per day at the class level.
Example: If May shows 50 units for a single class, and May is a 31-day month, then the projected sales units for that class for May is a total of 1,550 units (50 × 31 = 1,550).
Edit inline (click any month cell) OR bulk upload via Excel. Both paths write to Hub's
tbl_projections via new-batch merge. Current month column is highlighted.
▶ 📌 What these numbers mean — ratios distribute class-level projections to SKUs · click to expand
Step 1 — class projection: Projection cells per month represent units per day at the class level.
If May shows 50 units for a single class and May is a 31-day month, the projected sales for that class in May = 1,550 units (50 × 31 = 1,550).
Step 2 — ratios distribute the class total to SKU level: Each SKU has a ratio (a fraction of its class) so we can project each SKU's expected demand.
Worked example (SKU level):
Say the class above has a SKU with a ratio of 0.10 (= 10%) — meaning this SKU is projected to capture 10% of the class's sales.
• Projected monthly units for this SKU = 1,550 × 0.10 = 155 units
• Projected daily SPD for this SKU = 50 × 0.10 = 5 units/day
• Sanity check: 155 ÷ 31 = 5/day ✓
Within a single class, all SKU ratios should sum to 1.00 (= 100%). The classification rollup view on this tab flags any class where the sum drifts away from that.
Say the class above has a SKU with a ratio of 0.10 (= 10%) — meaning this SKU is projected to capture 10% of the class's sales.
• Projected monthly units for this SKU = 1,550 × 0.10 = 155 units
• Projected daily SPD for this SKU = 50 × 0.10 = 5 units/day
• Sanity check: 155 ÷ 31 = 5/day ✓
Within a single class, all SKU ratios should sum to 1.00 (= 100%). The classification rollup view on this tab flags any class where the sum drifts away from that.
Read-only mirror of Inventory Hub's active
tbl_ratios batch. Each SKU's ratio = its share of its classification. Rollup shows ratio sum — should be ~1.0 when fully loaded.
Target cover = 60 days (fulfillable + inbound combined). Units to send = how many to ship to FBA to hit 60d. Excess = how many above 60d (candidates to slow down / hold).
Rows color-coded by health bucket. Default period = L7 — swap above to re-score.
Segments
Each inventory segment is built end-to-end before moving to the next. Order is flexible.
Agent Call-Outs (goals)
What the agent should surface once the segments above are populated.
Ground Rules
- Target stock at FBA: 60 days cover (fulfillable + inbound combined).
- Production orders are placed at the classification level.
- NB = Hoffman (New Brunswick).
- Default SPD period = L7. Labeled everywhere — change the one constant in the backend to swap to L14/L30.
- Rollup SPD at classification/portfolio = sum of SKU SPDs.
- Phase 1 = Reebok only, via
vw_netsuite_portfolio_or_class_contains_brand_name_custom_mapping. - Sales source:
eddie_v2_sales.vw_sales_spd_by_child_asin_all_periods. - Production source:
eddie_v2_inventory.vw_inbound_shipments_production_data_merged_kelsey_erika. - Rank SKU source:
eddie_v2_x_custom_mcp_read_only_rank_sku.vw_g_sheet_amazon_ads_reporting_portfolio_hlink_rank_sku_parsed. - Inventory source:
eddie_v2_inventory.vw_netsuite_and_fba_inventory_by_child_asin. - Season is user-maintained in Firestore (
agent_inventory_seasons). - Images via
/api/image?asin=…, cached in Firestore (agent_inventory_asin_images). Click any image/ASIN to open Amazon.