Analyse Sales YOY

The Analyse Sales YOY Workbook allows you to overview  your Sales Performace for the trailing 12 months and 3 months. 

The workbook analyses Sales Volumes and Margins across the following 4 tabs.

Headline Sales Tab

The Headline Sales tab presents KPI of Total Sales , COGS, Gross Profit  with a breakdown by State. The report utilises colour coded trend indicators and values present on a bar charted background to highlight their contribution. The Workbook can be customer with your logo.

YOY01.png

COGS and Margins are calculated from the Sales Invoice Cost Of Goods. If your business does not use Items Sales then the COGS will be zero. 

3M Dashboard Tab

This presenst the Trailing 3 Months in chart and tabular format. The report utilises colour coded trend indicators and values present on a bar charted background to highlight their contribution.

YOY02.png

Last 3 mths Compare Tab

Esentially a large format version of last 3 months sales. Defaults to Top 10 Customer by Sales volume.

YOY03.png

YOY Comparisons

Esentially a large format version of last Last 12 months sales .

YOY04.png

Pre-requisites.

This workbook include Cost of Goods and Margins and requires cost in the Sales Invoices. Typically thos will require the use of Inventory to provide average cost. 

 

Was this article helpful?
0 out of 0 found this helpful

Articles in this section

Ask the BI4 Community
Need help using this report or feature?