forecasting essentials for spi buyer direct
TRANSCRIPT
Forecasting EssentialsLINDA SZYMANSKI
Forecasting• Understand Forecast Accuracy• Forecast Versioning• Mix Management• Product Variance• Managing Product Level Forecasting
Forecast Accuracy
• Fillrate – Initial / Final• Variance / MAPE• Backorder
Metrics to Measure
• Year or Season• Offer• Points in Time – Plan / X Weeks Out / Mail Date
When / Frequency
• Category, Key Items, Responsibility/Ownership• Key Items, Front / Back Covers• Key Inventory Investments / Strategy Changes
What
Reports - SnapshotsDynamic Reports• Offer Product• Offer Product
SKU• Select Version
Reports
Version Variance Reports
Reports
Fillrate
Product Variance
• The variance between the forecast and the projection is beyond what is set in the Variance Percentage
Why on the list?
• Quick Read – Flyers / Dyers• Prioritize
Benefits
• Daily• while offers are within the percentage done range set
Frequency to Review
Product Variance• Listing of
Products which met job criteria
• Forecast demand versus Projected demand
Product Variance - Submit Job• Run Daily Script• Manual Submit Job
Click Submit
Job
1) How soon do you want to review exceptions?
2) How late into the offer do you want to review exceptions?
3) What is not acceptable as an incorrect forecast?
Product Variance – Details
• Right click or double-click to access Product Level Forecasting
• Right click to assign projections as forecasts (may multi-select)
Direct Links to PLF
• Product Variance• Single and Multi-Offer Forecast• MAPS Planning Grid• Materials Planning• DRS Reports• Dashboard Quick Launch• Previous and Next Buttons
Product Level Forecasting (PLF)
View every offer in which a product is assorted
Customize the screen view/Filter offers shown
Like Products
View a graph of various metrics
Search capability of the screen
Grid and Toolbar Components
Product Level Forecasting (PLF)
Product Level Forecasting (PLF)
Active Offers Grid
History Grid
Sort Columns
Review Active Offer Forecasts to Historical Sales
PLF - Screen Components
• Offer Type• Seasonal• Catalog• Internet
• Offer Versions
• Summary Rows
PLF - Screen Components
• Customize Screen• Hide/Show• Add/Remove Columns• Set Column Display
Order• Save the Screen View
PLF - Screen Components
• Offer criteria• Examples - Filter by Year /
Channel / Seasonal Offers• Save Criteria• Set as Default Filter
PLF - Like Products
PLF - Like Products
PLF - Like Products
Offers listed
Select one of
19 Metrics
to display
PLF - Graphing
PLF - Search Options
• Product • Offer• SKU
PLF - Search ResultsEnter Search criteria
Results list returned
Double-click on Product
Work Through the List
Print the Search results List
PLF - Previous and Next ButtonsUse the Next Button to review products from a linked list.
Allows you to review products in sequence.
PLF - Grid ComponentsCurve Analysis
Product Image
Offer Comments
Offer-Product Comments
Change History
Mix Percentage
Select/Deselect All
PLF - Mix Percentages
Product Wizard
Materials Planning
Demand by Week
History/Forecast Graph
Real Time Publish
PLF – Toolbar Components
Demand By Week
View Forecast and Inventory Levels
History/Forecast Graph
View Sales Trends
History/Forecast Graph
Real Time Publish
Questions
