Report Information
The Cost Price Analysis report provides insights into product purchasing costs over a selected time frame. It offers a detailed breakdown of cost prices, helping users make informed decisions and plan strategically based on product-specific expenditure.
This report is available only to companies subscribed to the Inventory Management module.
Access the Cost Price Analysis Report via: Reports & Analysis > Inventory Management > Cost Price Analysis.
The output of the report can very depending on the selected report filter options.
If required, this report can be created as a Saved Report and set up to send out periodically.
Information on report filter options
The table below summarises report filter options available for this report.
| 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:
|
| Suppliers |
Select which suppliers to include costs for. If left blank, all suppliers will be included. |
Report Output
Level 1 - Cost Price Summary
The first level of the report is a summary of costs and order totals per product.
Additional information on this view
The table below summarises the data shown in each column of this report view.
| 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 report provides the same information per Level 1 broken down by supplier.
Additional information on this view
The table below summarises the data shown in each column of this report view.
|
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 3 (or 4) - Cost Prices By Supplier Order
The third level of the report (or fourth, if View Type filter option "Consolidated" is selected) is a list of supplier orders where the product was purchased from the selected supplier.
Additional information on this view
The table below summarises the data shown in each column of this report view.
| 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. |
Note that if View Type filter option "Consolidated" is selected, as this is the fourth level of the report, the third level shows the same information as Level 2, just broken down by site.
Comments
0 comments
Article is closed for comments.