The Cost Price Analysis report offers valuable insights into purchasing costs associated with each product within a specified time frame. This report provides a detailed examination of the cost prices, empowering users to make informed decisions and strategic planning based on a comprehensive understanding of the product-specific expenditure over the selected period.

This report is available only to companies subscribed to the Inventory Management module.

For companies with multiple sites, this can be split per site or can be consolidated for all sites.

If required, this report can be created as a Saved Report and set up to send out periodically.

Report Filters

Access the Cost Price Analysis Report via: Reports & Analysis > Inventory Management > Cost Price Analysis.

Select the required report parameter options from:

Select Sites	Select which sites and/or site groups to include in the report.
Date Range	Select which date range to include data for.
Product Groups	Select which product groups to include. If left blank, all groups will be included.
View Type	Select whether to view the report as: Consolidated: To combine multiple sites into one consolidated output. Split By Site: To product a separate output per site if multiple sites are selected.
Suppliers	Select which suppliers to include costs for. If left blank, all suppliers will be included.

Report Output

The Cost Price Analysis report has several levels, depending on the selected View Type:

Level 1 - Cost Price Summary
Level 2 - Cost Prices By Supplier
Level 3a - Cost Prices by Supplier By Site
Level 3b / 4 - Cost Prices By Supplier Order

Level 1 - Cost Price Summary

The first level of the Cost Price Analysis report is a summary of costs per product, displaying:

Product Name	Displays the products description.
Min Price	Displays the minimum price paid within the date range, based on the pack size shown.
Max Price	Displays the maximum price paid within the date range, based on the pack size shown.
Orders	Displays the quantity of orders placed for each product.

Level 2 - Cost Prices By Supplier

The second level of the Cost Price Analysis report provides the same information as per Level 1, but broken down by supplier:

Level 3a - Cost Prices by Supplier By Site

The third level of the Cost Price Analysis when the View Type is Consolidated is a summary of information as per Level 2, but also broken down by site:

Level 3b / 4 - Cost Prices By Supplier Order

The fourth level of the Cost Price Analysis when the View Type is Consolidated (or the third level when the View Type is Split By Site) is a list of supplier orders where the product was purchased from the selected supplier, displaying:

Supplier Name	Displays the name of the supplier.
Order Date	Displays the date and time that the order is said to have been placed. This can be selected to open the order in a new tab.
Ordered Qty	Display the quantity ordered.
Delivered Date	Displays the date and time that the order is said to have been received in.
Delivered Qty	Displays the quantity received in.
Price	Displays the cost price paid in the selected order.