Sales Forecast Report
Use this report to forecast sales for up to the next 12 months based on your previous sales history. View expected quantities sold and revenue for each product and location.
Prerequisites
This is a Cin7 ForesightAI feature and requires an add-on to your subscription.
ForesightAI reports require at least 3 months of sales history in Cin7 Core.
Report options
Reporting period |
Select the reporting period from a list of options or set a custom date range. |
Layout |
Set to the default layout or select from a saved layout. |
Save layout as |
Save a layout for potential future use. |
Reset layout |
Resets layout to the default layout or selected saved layout. |
Select Apply filter to set filter fields for the report and Update to refresh the output with any new changes. See Managing Cin7 Core Reports - Filtering Reports for more detailed information about using filters.
Export report data to Excel, PDF, or RTF.
Report fields
The following fields are available for this report. Open the Configure Layout menu to view all available fields.
Fields | |
SKU |
Product SKU |
Product |
The name of the product |
Brand |
Product brand |
Category |
Product category |
Family |
Product family name |
Product tags |
Comma-separated product tags |
Location |
Location name |
Unit |
Product unit of measure |
Supplier |
Supplier associated with this product |
Barcode |
SKU barcode |
Demand segment |
Winners are top sellers which generate the most revenue, chasers are still in demand products, losers are products that are rarely sold. |
Data Headers | |
Month |
Forecasted month |
Sale qty |
Quantity sold in preceding 12 month period |
Forecast qty |
Quantity to be sold in upcoming reporting period, according to sales forecast |
Stock price | Total stock price |
Sale price | Average sale price |
Forecast revenue | Predicted revenue from this SKU over the forecast period |
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip20 KB
- Publish to everyone.4.log-2010416261.zip30 KB
- Publish to everyone.4.log-2010416261.zip30 KB