What every Replenishment Analyst should know (4 sessions)
Retail Link Intro
- "Canned" Queries
- Ad Hoc Queries
- Time Frames
- Customized Lists: Store groups, column groups,
- Calculations / Helpful Formulas
- Scheduling Queries; watchouts
- Sharing queries (with your Replenishment Manager!)
- Activity Research Tool (ARTS a.k.a. Where's My Stuff)
- SWAS
- Store Item Order Detail Report
- Download formats
Replenishment of the Community
- Traits - Select Store Trait & Select Store Trait Description
- Future Traiting
- Maps
Managing the Shelf
- Analyzing missed opportunity: Out of Stocks
- Max Shelf Qty / Minimum DD's
- Modular update impact to forecast / replenishment system
- Item / Store Outs combinations
- Lead Time analysis & MABD compliance
Building Forecasts
- Using POS to drive the forecast
- Incrementality / Cannibalization
Managing Monday Morning
- Begin with the end in mind: Assess current responsibilities
- Schedule "Master" queries
- Establish the "dumping ground"
- Automatically Update Charts & Templates
- Disable Links / Macros
- Create Smart Text to drive your email
- Maintain reference tables (dates, store lists, item segmentations)
Communication of Results
- Less is best: Say it succinctly & use "smart text" where possible
- A picture is worth 1,000 words; a chart is worth 1,000 numbers
- Show me the money; put a dollar on everything!
- Always remember the "elevator speech"; make your boss look good
|
