Forecasts
- 1 Analyze
- 2 How MySales Builds a Forecast
- 2.1 1. Forecasting Hierarchy
- 2.2 2. Data Used for Forecasting
- 2.3 3. Overall Forecasting Logic
- 2.3.1 3.1. Data Preparation and Processing
- 2.3.2 3.2. Sales Cleansing
- 2.3.3 3.3. Seasonality and Trend Calculation
- 2.3.4 3.4. Analysis of Influencing Factors
- 2.3.5 3.5. Forecast Model Generation
- 2.3.6 3.6. Incorporation of Future Factors
- 2.3.7 3.7. Short-Term Forecast Refinement
- 2.3.8 3.8. Safety Stock Calculation
- 2.3.9 3.9. Final Adjustments and Use of Results
- 2.4 4. Special Forecasting Algorithms
- 2.5 5. Configuration Flexibility
- 3 Parameters
- 3.1 Groups
- 3.2 SKU
- 3.3 Last Sales date
- 3.3.1 Data Selection
- 4 Settings
- 4.1.1 Stores
- 4.1.2 Promo Drafts
- 4.1.3 Profile
- 4.1.4 Supplier
- 4.1.5 Update
- 4.2 Starting the Forecast Run
- 5 Results
- 6 SKUs
- 6.1 SKUs Chart
- 6.1.1 Area chart on SKUs
- 6.2 SKUs Table
- 6.2.1 Summary table for SKUs
- 6.1 SKUs Chart
- 7 Stores
- 7.1 Stores Charts
- 7.1.1 Area chart on stores
- 7.2 Stores Table
- 7.1 Stores Charts
- 8 Components
- 9 Forecast
- 10 Predictors
- 11 Price
- 12 Trends
- 13 Models
- 14 Results Display Area
- 15 Forecast Analysis Components Guide
- 15.1 Forecast Evaluation
- 15.2 Correlation Coefficients
- 15.3 Detailed
- 16 Results Display Area
- 17 Forecast analysis components guide
- 18 Category 'Volume'
- 19 Category 'Value'
- 20 Category 'Original'
- 21 Category 'Regressed'
- 22 Category 'Economy'
- 23 Usage Scenarios
- 24 View
- 24.1.1 Overview & Use
- 24.1.2 Description and Usage
- 24.2 Forecast View
- 24.3 Template Creation
- 24.3.1 Metrics for display
- 24.4 Template Selection
- 24.5 Editing and Deletion
- 24.6 Filter
- 24.7 Usage Scenarios
- 24.8 Examples of Functionality Usage
- 25 Master
- 25.1 Description and Usage
- 25.2 User Guide
- 25.3 Working with the “Master” Page
- 25.4 Adding a Forecast
- 25.5 Editing a Forecast
- 25.6 Deleting a Forecast
- 25.7 Export and Import of Master Forecast
- 25.8 Uploading a Forecast from a File
- 25.9 File Format for Uploading a Forecast for a Specific Week
- 25.10 File Format for Uploading a Forecast for a Period
- 25.11 Working with Versions
- 25.12 Usage Scenarios
- 25.13 Other Use Cases for Master Forecast
- 26 New
- 26.1 SKU
- 26.1.1 Adding a New Item
- 26.1.2 Forecast Configuration
- 26.1.3 Editing and Deletion
- 26.1.4 File Upload
- 26.1.5 Usage Features
- 26.2 Groups
- 26.2.1 Adding a Group
- 26.3 Stores
- 26.3.1 Adding a New Store
- 26.3.2 Additional Features
- 26.1 SKU
- 27 Admin
- 27.1 Additional load
- 27.1.1 Operating manual
- 27.1.1.1 Working with page
- 27.1.2 Filters
- 27.1.3 Working with files
- 27.1.4 Use cases
- 27.1.5 Recommendations for Use
- 27.1.1 Operating manual
- 27.2 Enabled items
- 27.2.1 Filters
- 27.2.1.1 Search bar
- 27.2.1 Filters
- 27.3 Use Cases
- 27.4 Safety Stock Adjustments
- 27.4.1 Overview & Usage
- 27.4.2 Safety Stock Table
- 27.4.3 Interface Logic
- 27.4.4 Principle of Safety Stock Calculation
- 27.4.5 How to Apply the Safety Stock Coefficient
- 27.4.6 Criteria for Changing Safety Stock
- 27.4.7 Recommendations for Use
- 27.4.8 Coefficient Usage Instructions
- 27.4.9 Increasing Safety Stock
- 27.4.10 Decreasing Safety Stock
- 27.4.11 Coefficient Validity Period
- 27.4.12 Returning to the Default Value
- 27.5 Setting the coefficient at the “SKU — entire network” level
- 27.6 Setting coefficients at the Store level
- 27.7 Setting the coefficient at the SKU — Stores
- 27.7.1 Adding an SKU — Store pair
- 27.7.2 Uploading Coefficients from a File
- 27.7.3 Uploading at the SKU — Entire Network Level
- 27.7.4 Uploading at the Store Level
- 27.7.5 Uploading at the SKU — Store Level
- 27.7.6 Recommended Use Cases
- 27.7.7 Top-Selling Items
- 27.7.8 Margin-Generating Products
- 27.7.9 Fresh Category Products
- 27.8 Forecast Adjustment
- 27.9 Adding an Adjustment
- 27.9.1 Prorate on Sales
- 27.9.2 Coefficient
- 27.10 Uploading Adjustments from a File
- 27.11 File Requirements
- 27.11.1 Numeric Value Format
- 27.1 Additional load
- 28 Anomalies
- 28.2 User Guide
- 28.2.1 Working with the “Anomalies”
- 28.2.1.1 Search and Filtering
- 28.2.1 Working with the “Anomalies”
- 28.3 Filters of the “Anomalies” Tab
- 28.4 Working with the “Excluded” Tab
- 28.4.1 Conditions for Data Display
- 28.4.2 Use Cases
- 28.4.3 When to Use Anomalies
- 28.4.4 When to Use Exceptions
- 29 Models
- 29.1 Forecast Models Table
- 29.1.1 Main Table Elements
- 29.1.2 Model Parameters
- 29.1.3 Working with the Table
- 29.1 Forecast Models Table
- 30 Competitors Events
- 30.1 Main Page Features
- 30.1.1 Form Parameters
- 30.1.2 Completion of Creation
- 30.1.3 Purpose of the Functionality
- 30.1 Main Page Features
Analyze
Description & Overview
The “Analysis” page is intended for building predictive models and for conducting a detailed examination of the factors that influence the formation of demand forecasts.
The page interface consists of two main sections:
Parameters — used to select and configure the key forecasting settings.
Results — displays the outcomes of the generated forecast and provides the ability to analyze the factors that influenced its formation.
How MySales Builds a Forecast
MySales uses a high-performance mathematical forecasting engine, validated on hundreds of millions of “product–store” combinations.
The system automatically generates consistently high-quality forecasts for each item in every retail location, taking into account historical data and influencing factors.
1. Forecasting Hierarchy
The forecast is generated using a hierarchical approach — from more aggregated levels to more granular ones:
Product category — entire network
Product category — region
Product category — store
SKU — entire network
SKU — region
SKU — store
This approach makes it possible to leverage demand patterns at different scales and ensures forecast stability even when historical sales data is limited.
2. Data Used for Forecasting
With each recalculation, the system analyzes up to 3–4 years of historical data, including:
actual sales
prices and promotional activities
inventory levels
product hierarchy and reference data
geographical structure of the network
external factors (weather conditions, macroeconomic indicators, competitive environment)
Depending on the scale of the network, the volume of processed data can range from gigabytes to terabytes.
3. Overall Forecasting Logic
The forecast generation process is automatic, multi-step, and iterative.
The main stages include:
3.1. Data Preparation and Processing
The system loads historical data from databases and data warehouses, performs validation, and normalizes it.
For new products or new stores, data from similar items is used for periods where no own historical data is available.
3.2. Sales Cleansing
Historical sales are adjusted to account for factors that distort baseline demand:
promotional activities
price changes
seasonal peaks
lost sales due to stockouts
This allows the system to determine the true level of demand.
3.3. Seasonality and Trend Calculation
The system determines:
the nature of seasonal fluctuations (additive or multiplicative)
long-term demand trends
average and median sales values
Seasonality of the average price at the product group level is also analyzed.
3.4. Analysis of Influencing Factors
The system evaluates the dependency of sales on key factors:
price levels
promotions and discounts
weather conditions
macroeconomic indicators
cross-product interactions
If dependencies cannot be determined at a detailed level, data from more aggregated forecasting levels is used.
3.5. Forecast Model Generation
The system automatically:
calculates correlation coefficients
tests various forecasting models
selects the model that provides the highest accuracy based on historical data
A baseline sales forecast is then generated.
3.6. Incorporation of Future Factors
The forecast is adjusted to account for:
planned promotional activities
expected price changes
forecasted values of external factors