## Product Performance Report

This report analyses how your products are performing from a sales and also stock control point of view(e.g how fast are products moving off the shelves).

The report is designed to be run on a weekly/bi-weekly basis and will help you manage your stock so that you have less cash tied up in badly performing products.

To run this report go to **Manager**>**Reports**

Then Click on **Products** (1.) and highlight the **Product Performance** Report (as shown in point 2. below), then choose your report options or leave them blank to show all details (as shown in point 3. below) and finally click the **Generate Now** button (4.)

The report will then run, here is an example:

**Product Name**This is the product name.

**Unit Cost**

This is the cost price as displayed in the Stock panel(VAT included).**Unit Price**

This is the sale price as displayed in the Stock panel(VAT included).**Arriv**

This is the number of product items delivered in the given period of time.**Sold Qt**

This is the number of product items sold in the given period of time.**Stock**

This is the number of product items currently in store, Stock On Hand.**Last Wk Qt**

This is the number of product items sold 7 days back from today (included).**Last 2 Wks Qt**

This is the number of product items sold 14 days back from today (included).**Trans in**

This is the number of product items transferred from different branches in the given period of time.**Trans out**

This is the number of product items transferred to different branches in the given period of time.**Order**

This is the number of product items currently on order.**Gross Profit**

This amount is given by the total gross amount sold in the given period of time minus the total cost of items sold in the same period.

The total cost of items is given by the quantity of items sold in the period multiplied by the cost of every items.

Suppose we have a product A that we sell at price AP and cost AC, and a product B that we sell at price BP and cost BC. Assume that in the given period of time we sold 10 of product A and 5 of product B.

The gross profit in the period is 10 * (AP - AC) + 5 * (BP - BC)**GP%**

This is the gross profit percentage and it is obtained dividing the Gross Profit by the total cost of items sold in the same period.

From the example above the GP% is [10 * (AP - AC) + 5 * (BP - BC)] / (AC + BC)

**Sell thru**

This is the quantity of product items delivered in the given period of time divided by the quantity of product items sold in the same period of time.**Days Stock**

This is the number of days since the last order.