Merchbees Help Center
  • 🏘️Merchbees Homepage
  • Bee Forecast & Replenishment
    • 🏑Homepage
      • πŸ™‹β€β™€οΈFrequently Asked Questions
      • πŸ‘©β€πŸ«Forecast & Replenishment Calculations
        • πŸ§™β€β™‚οΈForecast Algorithm
        • πŸ–οΈOutlier Sales
        • πŸ“¦Replenishment Calculation
      • πŸ“ŠReports
      • πŸ“–Glossary of Terms
      • πŸ› οΈChangelog
  • Bee Low Stock Alert & Forecast
    • 🏑Homepage
      • πŸ™‹β€β™€οΈFrequently Asked Questions
      • πŸ“½οΈ Video Tutorials
      • πŸ“™Guide
      • πŸ•΅οΈβ€β™€οΈForecast and Reporting Module
        • πŸ“¦Replenishment with the Stock Cover Days
        • πŸ“¦Replenishment with the Dynamic Threshold (Old Version)
        • πŸ§™β€β™‚οΈForecast Algorithm
        • πŸ“ŠReports
        • πŸ“–Glossary of Terms
      • πŸ“§Setting up SMTP
      • πŸ”§Changelog
  • Push Down & Hide Out of Stock
    • 🏑Homepage
      • πŸ“˜Guide
      • πŸ™‹β€β™‚οΈFrequently Asked Questions
      • πŸ› οΈ Changelog
  • Merchbees Inventory Value
    • 🏑Homepage
      • πŸ™‹β€β™‚οΈFrequently Asked Questions
      • πŸ”¨Changelog
  • Others
    • πŸ™ŠPrivacy Policies
      • πŸ™‰Privacy Policy for Forecasting Apps
      • πŸ™ˆPrivacy Policy
    • πŸ’ŒContact Us
Powered by GitBook
On this page

Was this helpful?

  1. Bee Forecast & Replenishment
  2. Homepage
  3. Forecast & Replenishment Calculations

Forecast Algorithm

Forecast algorithm for the Bee Forecast & Replenishment.

PreviousForecast & Replenishment CalculationsNextOutlier Sales

Last updated 1 year ago

Was this helpful?

Merchbees look at recent sales and stockout information when generating a forecast.

By default, we use the last 30 days when the product had available inventory to calculate the sales velocity.

  1. We look at sales and stock over the last 30 days.

  2. If the product went out of stock during the last 30 days, we would look at the nearest 30 days when the stock was available in 90 days to calculate the sales velocity.

  3. If the product had less than 30 in-stock days, the forecast is calculated as total sales/ number of in-stock days. Note: if the number of in-stock days is <= 7, we divide total sales over 7 days by default.

Parameters

- Compute forecast using orders in the last

- Use stockout information

By default, when calculating the forecast, we do not include the days the product was out of stock since the product cannot make sales on those days.

By excluding stockout days, we base the forecast on the sales performance of the product during in-stock days. Not including stockout days in the forecast algorithm significantly improves and affects forecast accuracy. However, if you do not want to use stockout information and want to include all days in the forecast algorithm, you can uncheck the "Use stockout information" checkbox.

Exclusion There is one exceptional case in which we do not use stockout information; 'continue selling when out-of-stock products'. Since these products can be sold independently of inventory on hand, Merchbees do not use stockout information for these types of products.

New Accounts

Merchbees starts to keep inventory history during the free trial period and continues to do so if you subscribe to any Bee Forecast & Replenishment plan. Since we cannot see past inventory data, we assume that all products had positive inventory before you installed the application.

- Eliminate outlier sales

In the forecast algorithm, outlier adjustment is done if the "Eliminate outlier sales" checkbox is selected. If you want to include outlier sales in the forecast, you can uncheck this checkbox.

If you want to include more than 30 days in the forecast calculation, you can choose the 60 or 90 days options on the page.

If you have a different need for a forecast, please don't hesitate to contact us! We are always here to help! You can say hello with live chat on or send an email to .

🏑
πŸ‘©β€πŸ«
πŸ§™β€β™‚οΈ
Settings
What are outlier sales and how do they affect the forecast algorithm?
πŸ‘‹
merchbees.com
support@merchbees.com