Home > Reports > Screen Shots/Explanations > Item Performance Report

Item Performance Report

What Is It?

This report displays performance details for selected items. It displays cost and sell details for the item as well as sales (quantity and dollars) for the previous week. It is an ideal report for head office to track the performance of items at the location. The Location Range Report is similar but it’s designed for location usage. The items are printed in department, category, group, family group, description sequence.

Column Notes

The Landed Cost is the normal landed cost.

The Terms % is not currently calculated.

The Nett Unit Cost is the Landed Cost/Carton Size less the Deal Amt.

The GM% is the margin on the Nett Unit Cost and the Current Sell.

Stock Cover is the stock on hand divided by the rate of sale. If the item has linked items, the rate of sale will include the rate of sale of all the linked items.

The Rate Of Sale is the sales over the last thirteen weeks divided by thirteen. Whereas the rate of sale used to calculate the Stock Cover above included linked items, this one is only for the item itself.

The Quantity Sold, Sales and GP are the values from last week as this will be the first full week of statistics available.

The % of Grp is the item value divided by the group value.

Command

Client - REQUESTREPORTITEMS2.EXE ITEMPERFORMANCEREP

Server - REPORTITEMS2.EXE

What Are The Report Parameters?

Location

The location for which performance details are required. If a location group is entered, a separate report is generated for each location within the group. This must be entered.

Department/Category/ Group/SubGroup

All items in the nominated department, category group and subgroup will be selected. You can enter just a department and you will get all items in that department.

Family Group

Only items in this family group will be printed. This does not have to be entered.

Season/Year

Only items with this season/year will be selected.

Classification

Only items which are the same classification as this field will be printed. This does not have to be entered.

Brand Name

Only items from this brand will be selected.

Grade

Items which are of this grade will be printed. This does not have to be entered.

Qty Sold

Only items with a quantity sold less than this value will be printed. It defaults to 999999 so all items will pass this requirements.

Show Items With Zero Sales

If checked on, items that have zero sales will be reported.

Promotions Only

If checked on, only items on promotion will be printed.

Show Stock Items Only

If checked on, only items that are marked as stocked will be reported.

Sort Order

Indicates the order by which the data will be reported. The data sorts by department, category, group and then by the selected sort order -either Description, GP$ or GP%.

Paper Requirements

This report prints on A4 paper in Landscape mode.

Sample Report

Figure: Example Item Performance Report

Converted from CHM to HTML with chm2web Pro 2.85 (unicode)