90 likes | 205 Views
estoque & giro. November, 2007. Estoque & Giro. Current Process Universe / Sample / Coverage Gathering Consolidation Expansion Reporting Issues & Opportunities 2007 baseline adjustment The Sell Out Project. P. SELL OUT Store. DC GKA. Store GKA. SELL OUT Trade. DC RSM. Store
E N D
estoque & giro November, 2007
Estoque & Giro • Current Process • Universe / Sample / Coverage • Gathering • Consolidation • Expansion • Reporting • Issues & Opportunities • 2007 baseline adjustment • The Sell Out Project P KFB Sales Development Team
SELL OUT Store DC GKA Store GKA SELL OUT Trade DC RSM Store RSM SELL IN KRAFT Consumer DC DIST SELL OUT Trade Store TT DC WHL Gathering Collected Information SELL OUT KFB Sales Development Team
IN TRANSIT STOCK CD GKA Store GKA INVENTORY STOCK CD SMR Store RSM KRAFT Consumer CD DIST Store TT CD WHL Gathering Collected Information INVENTORY KFB Sales Development Team
Estoque & Giro • Current Process • Universe / Sample / Coverage • Gathering • Consolidation • Expansion • Reporting • Issues & Opportunities • 2007 baseline adjustment • The Sell Out Project P P KFB Sales Development Team
Sales Field Sales Support (Branches) Sales Planning (HQT) Consolidation GKA RSM Wholesalers Distributors Customers Data Gathering Customers Data Gathering Customers Data Gathering Customers Systems Excel Files by Customer Excel Files by Customer Excel Files by Customer Excel Files by Customer Region Consolidation Region Consolidation Region Consolidation Excel Files by Region/Customer Excel Files by Region/Customer Channel Consolidation Excel Files by Region/Customer Other Customers Data Expansion Other Customers Data Expansion Reports Building Reports Building Reports Building Reports Building KFB Sales Development Team
Estoque & Giro • Current Process • Universe / Sample / Coverage • Gathering • Consolidation • Expansion • Reporting • Issues & Opportunities • 2007 baseline adjustment • The Sell Out Project P P P KFB Sales Development Team
Expansion Sell out information from Customers that doesn’t share data with KFB are estimated based on their sell in relevance for the Channel and Region where it belongs to, by Product Family. Note: The % used to estimate Other customers Sell out is revised each 6 months. KFB Sales Development Team
Expansion Case 1: Sample Sell out decreases 10% vs LY, while Other Custumers increases +34% due to new Customer Mix. Case 2: Sample Sell out in line with LY, while Other Custumers decreases 41% also due to new Customer Mix. w/o Expansion Expansion KFB Sales Development Team