Sales Forecast Report

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

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

Was this article helpful?

Have more questions? Submit a request