Skip to content

Sales Forecast Report

Action: RP_SALEFOR

This report will project your stock inventory sales for a selected time period, and compare that with your quantities on hand and outstanding stock purchase orders to show which weeks or months you may be short of inventory. ​ First, you select a time period, which can be weeks or months. You can select 1-12 week or month periods. You can also select on which date the projection should start. Then, you select the classification of inventory you want to analyze. You can select by inventory category, vendor, or style code. ProfitSystem will then perform the following analysis to create the report.

Assume you have selected to forecast the next 12 months of sales.

First, ProfitSystem will total your stock sales for each inventory item month by month for the last 12 months. These totals will be used as the forecasted sales for the next 12 months.

Then, ProfitSystem will total your stock PO's for each inventory item month by month for the next 12 months. The confirmation date on the stock PO indicates the month in which it is to be received.

Finally, for each month, ProfitSystem takes your current quantity on hand for each inventory item, subtracts the forecasted sales, adds the confirmed stock PO items, and uses the result as the ending balance for the month. It then repeats the process for each month. ​ On the report itself, each inventory item (style, size, color, width) is listed, along with the MTD sales, YTD sale, Total sales, current quantity on hand, quantity on stock order, and date last received. Next, a grid appears that shows 3 numbers for each time period (weeks or months) The first number is the previous sales (which is the forecast), followed by stock orders to be received, and finally, the ending balance.

Criteria

Forecast the next...The report will project your sales for an upcoming time period. You can select 1-12 weeks or months, starting on any selected date. ProfitSystem will analyze your sales for the last 1-12 weeks or months (depending on which you selected) and project them out for the next 1-12 weeks or months.

Limit to vendor...You can limit the report to a specific vendor, if you like.

Limit to category/sub-category...You can limit the report to a specific category and sub-category.

Limit to style code...You can limit the report to a specific style code, if you like.

Limit to stores...This option is available with the optional multi-store module. It will limit data to the entered stores. Multiple store IDs may be entered separated by a comma.