Please enable JavaScript.
Coggle requires JavaScript to display documents.
GM Tool Quantrix Mapping, NAP Data (Price Type ASP History-2021), (MFP…
GM Tool Quantrix Mapping
NAP Data (Price Type ASP History-2021)
Price Type ASP Input (% Change to Ly @ Week/Month/Quarter)
Price Type Gross Sales U Calc
Net Sls U
Dmd Ttl U Calc
(MFP DATA) Wp Gross Sls % Dmd Ttl U
ASP Planning Canvas
(MFP DATA) Wp Rtn R
Total Rtn U Calc
Wp Rtn C Calc
MFP DATA (Net Sls TC U)
Net Sls TC C
Historical GM R/% Calc
Nap DATA ( Historical Net Sls R/C)
GM Review Canvas
Quantrix Development Loop
Business Understanding
What is the business problem or question we are trying to address
With the absence of MD and IMU planning how do we develop an approach to planning GM in Cost that allows the FP to represent a Clearance ASP/AUC's mixed with Regular and Promotional ASP/AUC's to hit GM Targets
In-Season: How do we reconcile the Price Teams MD actions with our GM plans?
Data Review
Identify the available Data and dimensions.
Sales Components @ Banner->Country->Channel->Dept
Inventory Components @ Banner->Country->Dept
Main Logic and Structure Formulation
Develop Main Logic and Structure
Test Main Logic and Structure with Sample Data Set
Refine Debug Logic and Structure
NAP Data (Price Type Gross Sales History-2021)
Historical DATA (Historical Penetration PT %)
Price Type Planning Input (Clear; % Penetration @ Week/Month/Quarter, Promo % Penetration @ Week)
Price Type Gross Sales R Calc
Net Sales R Calc
Price Type Planning Canvas
MFP DATA (Wp Gross Sales R)
NAP Data (Price Type Gross Sales C/Gross Sales U)
Historical DATA Calc (Historical Price Type AUC)
Price Type AUC Input (% Change to Ly Week/Month/Quarter)**
Price Type Gross Sales C Calc
Net Sls C Calc
Net Sls AUC
GM R Calc
GM % Calc
AUC Planning Canvas
MFP DATA (Wp Dmd Ttl R)
Ttl Dmd ASP
NAP Data ( Rtn R/U)
Historical DATA Calc (Rtn ASP-2021)
Return ASP Planner (% Change to Ly @ Week/Month/Quarter)
MFP Output
Return Planning Canvas
NAP Data (Rtn C/U)
Historical DATA Calc (Rtn AUC-2021)
Return AUC Planner (% Change to Ly @ Week/Month/Quarter)
Trunk Club Module
NAP DATA ( Net Sls C/U-2021)
MFP DATA (Wp Net Sls TC R)
Tool Dimensions
Banner
Country
Dept
Channel
Ownership Model
Owned
Drop Ship
Time
Week
Month
Quarter
Half
Year
Plan Version
Wp
Cp
Sp
Qp
Op
Ly
In Ssn Module Canvas
Logic Pending (Price Team Output Dependency)
PT Penetration Sls/BOP Trend
PT Penetration Re-Plan In Ssn
PT BOP C/U
Recalc in future
Need solution to plan Net Need/Shrink components @ Price Type
Price Type Penetration Sls/BOP
Price Type AUC/ASP Re-Plan In Ssn
Price Type Gross Sls AUC/ASP Trend
Price Type Rtn ASP Re-Plan In Ssn
Price Type Rtn ASP Trend
Matrix Type
Input Matrix
Canvas (UI)
Output Matrix
NAP DATA
MFP DATA (Wp)
In Ssn
In Ssn Module