Please enable JavaScript.
Coggle requires JavaScript to display documents.
52 Week Inventory, METRICS USING CHANNEL SPLIT ONLY, METRICS USING BOTH…
-
-
-
-
CHANNEL SPLITS
-
-
• RCTS ACTIVE C CHANNEL SPLIT % TTL BANNER* (CURRENTLY A FLAT FILE. WORKING ON PULLING UPDATED RECEIPT SPLITS FROM APT/CATEGORY)
-
-
-
-
-
-
-
BOP Active R C U
Channel / Price Type
Calculates for Reference:
• BOP Inventory AUC / AUR
• BOP Inventory PT Penetration
• BOP Inventory Channel Split
-
-
Receipts Active R U C
Channel / Price Type*
• MFP Plan at Total: Uses Channel Split Recommendations from Allocation/Catetory by Dept / Month (Ed Golay)
• Actualizes as is / Future assumes all Reg
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
BOP Active C
• Reg & Clear
• Uses If Statement < today
• Historical Actual from NAP data
• Future = Prev Week EOP Active Calculated
BOP Active C:Regular:Wp = if(Date:Regular:Wp < today(), sum(BOHEOH::BOH_REG_COST)+(BOHEOH::BOH_INTRANS_REG_COST), '52 Week'[~PREV]:'EOP Active C (Calculated):Regular:Wp
-
-
-
-
-
Rcpts Active C
• Uses If Statement < today
• Historical Actual from NAP data
• Future assumes Reg Only using Total from MFP data (which pulls from Banner Inventory NAP)
-
Inv Active In C
• Movement from Inactive to Active
• Rack: NQC / P&H Transfers In
• Pulls historical and actual from NAP (pulled into Total)
• Assumes all Reg
Reclass In C
• Uses an assumed split Reg / Clear
• Split determined using YTD actual Net Sales Penetration %
• Pulls from Banner Inventory (No Price Type)
Inv Rack In C
• Uses If Statement < today
• Pulls in actual Racking In Transfers (both Reg & Clear)
• Future uses assumed split Reg / Clear
• Split determined by using YTD actual created in historical summary
-
Inv Mvmt Drop Ship In C
• Pulls in at Total for Actualized weeks AND Plan? in Own as a Neg value?
• Assumes all Reg
• This metric must have started tracking in Jul Wk 3 2022, no data prior to that date
• When a dropship item is returned to a store or online WH, moves IN to Own inventory.
Inv Other In C
• Transfers between Banner / Country, Actual AND Plan
• Comes in from NAP on Banner Inventory table (no price type)
• Assumes all Reg
• This metric must have started tracking in Jul Wk 3 2022. no data prior to that date
Ttl Inv Mvmt In C
• Calculated: Rcpts Active C + Inv Active In C + Reclass In C + In Rack In C + Inv Mvmt Drop Ship In C + Inv Other In C
Net Sls C
• For Inventory Purposes combines Reg & Pro together
• Pulls from 52 Week Sales Matrix (which pulls from Weekly Output) so Actualized + Future Plans (includes user input changes)
-
MOS Active C
• Uses If Statement < today
• Actualized pulls from NAP (comes in as a negative value)
• Future uses assumed split Reg / Clear
• NOTE: Future comes in at Total, from Banner Inventory (no price type) ALSO: comes in as a positive value?) which should it be?
• Split determined by using YTD actual created in historical summary
-
Inv Active Out C
• Movement from Active to Inactive
• NORD: Units moving to NQC
• RACK: Units moving into P&H WH (rare)
• Uses If Statement < today
• Actual pulls in from Banner Inventory (not by price type)
• So uses assumed split Reg / Clear both Actualized & Future (should it?)
• Split determined by using Net Sales Penetration %
• DO WE HAVE THIS METRIC BY PRICE TYPE AT WEEK ON A DIFFERENT TABLE?
-
Inv Mvmt Drop Ship Out C
• Actualizes in Drop Ship Ownership as a negative value
• Pulls from NAP Banner Inventory table (no price type)
• Assumes all Reg
• NOTE: Drop ship neg value in DS Ownership is matching what is showing in Own Ownership also neg value, in actualized weeks?
• This metric must have started tracking in Jul Wk 3 2022, no data prior to that date
• DS Out should be in DropShip Ownership only.
Reclass Out C
• Uses an assumed split Reg / Clear
• Split determined using YTD actual
• Pulls from Banner Inventory (No Price Type)
Inv Rack Out C
• Uses If Statement today
• Pulls actuals from NAP by price type (shows both Reg & Clear Rack Out)
• Future pulls in at Total from Banner Inventory
• Future uses assumed split Reg / Clear
• Split determined by using TYD actual created in historical summary
RTV Active C
• Pulls in from Banner Inventory table (No Price Type)
• Assumes all Reg
• This metric must have started tracking in Jul Wk 3 2022, no data prior to that date
Inv Other Out C
• Transfers between Banner / Country
• This metric must have started tracking in Jul Wk 3 2022, no data prior to that date
• Pulls in from Banner Inventory table (no price type)
• Assumes all Reg
Shrink C
• Pulling data from MFP through NAP
• Comes in at the total
• Split determined using YTD actual Shrink Penetration %
Ttl Inv Mvmt Out C
• Calculated: Net Sls C + MOS Active C + Inv ACtive Out C + Reclass Out C + Inv Rack Out C + Inv Mvmt Drop Ship Out C + RTV ACtive C + Inv Other Out C + Shrink C
-
-
-
-
-
-
-
-
-
-
-
Rcpts Active R
• Uses If Statement < today
• Historical actuals from NAP
• Future uses Rcpts Active C * Gross Sls Markup % and assumes Reg only
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Inv Active Out R
• Total uses Inv Active Out C * Gross Sls MU %
• Uses same split Reg/Clear as C (Net Sales Penetration %)
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Regular
BOP Active C
First MD C
-
Rcpts Active C
Inv Active In C
Reclass In C
Inv Rack In C
Inv Mvmt Drop Ship In C
Inv Other In C
Ttl Inv Mvmt In C
- 1 more item...
-
-
-
-
Clearance
BOP Active C
First MD C
Remark MD C
Last Chance C
Reclass In C
Inv Rack In C
Ttl Inv Mvmt In C
Net Sls C
MOS Active C
- 1 more item...
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
Questions/Logic Validation
• Backing into Retail components using Cost components * Gross Sls MU % (which is just a calculation using Gross Sales ASP & AUC)
• Then, apply the same logic/calc/splits as we did to the Cost components for Reg & Clear
• Based on discussion with Directors, do we leave Inventory components at Banner/Country or still want to break it down by Channel?
• Answer: Yes. In order for inventory to possibly influence Sales (which is planned at Channel) we'd want to see Inventory at Channel.
-
-
-
-
-
-
-
-