Forecasting

Forecasting makes it easy to plan your production and your purchases in relation to your sales. You can plan days, weeks and months ahead.

The forecasting feature works like this: You enter your expected sales for a given SKU. Now you can see the consequences for your inventory and convert the sale directly to purchase and production orders. You can also make estimates for your expected sale based on sales in earlier periods.

Convert forecast to orders

  1. Click Warehouse in the top menu and select Forecasting in the drop-down menu.
  2. Indicate which SKU(s) you wish to estimate your sales for in the left sidebar.
  3. In the row Expected in the table, you fill in your expected sales for each SKU for a specific period of time.
  4. Click the button Supply in the upper right corner. Now you will see your inventory, expected supply and expected sales for the selected SKUs.
  5. Tick the small boxes for the SKUs you wish to create orders for. You can also click the button Select all.
  6. Select period From and To. Now click Create Order.
  7. Select Purchase Order or Production Order.
  8. Fill in the order details. You can read the tutorials for purchase orders and production orders. The order will be created with the selected SKUs.
    • The quantities ordered will be set so that the quantity will not go below the reorder point at any time within the selected period.
    • The order date has been determined by the SKU with the longest lead time and the delivery date is set to the beginning of the period. You can edit the lead time for the SKUs, read more here.
  9. Click Save.

Estimate forecast

  1. Click Warehouse in the top menu and select Forecasting in the drop-down menu. If you view the page for Supply, you can change the view by clicking Sales in the upper right corner.
  2. Indicate which SKU(s) you wish to estimate forecast for in the left sidebar.
  3. In the row Expected in the table, you fill in your expected sales for each SKU for a specific period of time.
  4. Tick the small boxes for the SKUs you wish to make estimates for. You can also click the button Select all.
  5. Select period From and To. Now click Estimate Forecast.
  6. In the dialogue, you can now apply a trend or a correction for the expected sales in percentage. You can indicate whether it should be calculated based on
    • Current forecast in the selected period.
    • Same period last year.
    • Period of same length before selected period.
  7. Click Calculate.

Guide for the rows in the tables

Sales

On Order The sales orders already entered in the application.
On Quote The sales quotes already entered in the application.
Expected Here you can enter your expected sales for the SKU. This is the only row you can enter data into. The other rows indicate sales quotes and sales orders already created.

Supply

Supply The supply added to your inventory from production orders and purchase orders in the period.
Expected supply You can enter your expected supply here.
- (Actual Sales/Quotes) The actual sales on sales orders and sales quotes already entered in the application.
- Expected sales Here you can enter the expected sales for the SKUThis is the only row you can enter data into. The other rows are calculations based on stock movement and the expected sales that you entered.

If you already entered expected sales in the sales forecasting table, it will appear here.

NB. The expected sales must include the actual sales/quotes.
- Consumed (production) Indicates what has been consumed in production of the SKU in the period.
- Estimated consumption for production The expected amount of raw material consumed in production.
- Adjustments Indicates any waste or loss in the period.
= Stock Movements Sums up the stock movements of the period, i.e. what went in or out of stock in total.
Initial Inventory Your inventory at the beginning of the period.
End Inventory Your inventory at the end of the period.

Outline