Easy Insight Logo
Call 1-(720)-316-8174

Inventory Forecasting in Easy Insight

Easy Insight provides a variety of settings and reports to help you forecast your inventory demands:

  • Using the forecast reports
  • Choosing history ranges for determining velocity
  • Defining whether a product is forecast per location or across all locations
  • Configuring reorder points and reorder quantities
  • Including returned quantities in the forecast
  • Configuring supplier lead times
  • Configuring seasonality
  • Excluding certain orders from the forecast
  • Excluding certain days from the forecast
  • Creating purchase orders from the forecast

Using the Forecast Reports

Each inventory connection in Easy Insight comes with four forecasting report sections: The first shows inventory and demand across all locations in your business, while the second allows you to filter inventory by location.

  • Forecasting Across Locations provides a table of products with their stock and consumption velocity across all locations
  • Forecasting By Location provides a table of products with their stock and consmption velocity per location
  • Forecast by Supplier provides views by supplier to help you quickly identify which particular suppliers require reorders
  • Forecast by Supplier and Location provides views by supplier and location to help you quickly identify which particular suppliers require reorders
Quantity Sold in Forecast

With the report on inventory across all locations, you'll see two values. The labeling will vary a bit depending on your inventory, but in general, these values will be Sales Quantity and Total Quantity. Sales Quantity represents the number of units sold of that SKU, while Total Quantity represents the number of units included in bundles, assemblies, BOMs, or other manufacturing/assembly/kits. You can click on the cells for Sales Quantity and Total Quantity to pull up the underlying orders. You can choose to exclude particular orders--for example, you might have a large B2B order skewing your totals. You can choose to exclude that order from your demand calculations:

Exclude Order

With the report on inventory location, you'll just see the Sales Quantity. You can also click in here to exclude certain orders in the same way as the inventory across all locations report.

Daily Demand and Monthly Demand are based on the time period you configure under Inventory Settings on the data source. You can choose up to three different ranges, so for example, you could calculate the average of your 365 day demand, 90 day demand, and 30 day demand. You could also simply look at the last 90 days.

Configure Reorder Values

You can click on the Reorder Point value to customize the reorder point and reorder quantity for each SKU:

Configure Reorder Values

Forecast Velocity Date Ranges

You can customize the date range used for calculating historical product velocity under the Configure Inventory page for your data source, found under the Configuration section:

Inventory Configuration

Including Returned Quantities

You can choose whether or not to include returns in the forecast calculations--if included, Easy Insight will subtract the returned quantities from its calculations of sales velocity.

Include Returns

Forecasting Across Locations vs By Location

You can define a filter under the Configure Inventory page to determine whether a product's forecasting is tracked per location or across all locations. If the filter condition evaluates to true, the product will be tracked by location.

Configuring Locations for Products

Reorder Point Strategies

Easy Insight provides a couple of different approaches for managing reorder points. You can use a safety stock strategy or you can specify explicit lead time/target days of stock to keep/minimum days of stock to keep. If you choose explicit lead time/days of stock, you can set blanket values for all products here on the configuration page:

Configuring Locations for Products

You can customize these days of keep and lead time values per product through the reorder configuration. You can also choose to set an explicit reorder point and reorder quantity for the product through the reorder configuration.

Supplier Lead Times

You can define an explicit lead time per supplier under the Supplier lead times page found under Configuration:

Configuring Supplier Lead Times

Excluding Days from Forecasts

You can choose to exclude certain days from your forecasting--for example, if you want to exclude the week around Black Friday, you can choose to exclude those days from your historical velocity. To exclude days, go to the 'Exclusion Days' report on your dashboard in the same section as the forecast reports and click on Add Exclusion to add a day to exclude:

Excluding Days from Forecast

Seasonality

The forecast reports also take into account seasonality if configured. You can configure your monthly seasonality values under Account Settings -> Seasonality:

Configuring Seasonality

Specify the weight for each month with a value of 1 representing 100% of normal. If you update a month to 1.2, it'll assume 120% of normal demand when calculating values for outofstockdate. You can click Load Historical Quantities to pull in your historical values for help with determining possible month weights.

Creating Purchase Orders

You can raise a purchase order directly in your inventory system by doing Export -> Generate Purchase Order from the Forecasting reports. You'll need to first select a supplier:

Creating a Purchase Order

From here, you can choose the products to reorder and the reorder quantities. Upon clicking Create, Easy Insight will generate a draft purchase order and redirect you to the source system to look at the purchase order.

Purchase Order Setup

You can customize system specific purchasing settings under the Configure Inventory page as well. Typical settings include default inventory location, purchase order template, and default tax rule.

Twitter Logo