PF OHL Reporting Demo
PF / GL / Vendor drill-down • GMS + NPPM eşit KPI • CtC + Forecast + Inventory/Turn notları
Excel
Upload
Load default (server)
Reset
Executive Summary
PF seçiliyse GL’ler; GL seçiliyse Vendor’lar gösterilir. Satıra tıkla → drill-down.
GMS
PF
-
Target:
-
Gap: -
Forecast:
-
NPPM
PF
-
Target:
-
Gap: -
Forecast:
-
Scenario
Forecast
Baseline
+10%
+20%
+30%
Boss bucket
None
Worst 10 ASIN (NPPM)
Worst 20 ASIN (NPPM)
Boss %
0%
Δ GMS:
-
Δ NPPM:
-
Δ Net PPP:
-
Top Negative CtC
GL
Top Positive CtC
GL
GMS • Actual vs Target-to-date
PF
NPPM • Actual vs Target-to-date
PF
Level
GMS Gap
NPPM Gap
CtC (TL)
WoC
Turn
Trend
Explain-why
Sor
Pricing & Inventory Diagnostics
External Match / Markdown / Deal etkisi • Inventory constraint ve cash tied-up sinyali
Demo: PricingBreakdown sheet varsa çalışır
Pricing mix share
PF
Pricing impact (Net PPP drag)
PF