Metrics
The following metrics are used in ZEUS Sales pivot tables:
| LABEL |
UNIT |
MEANING |
FORMULA |
EXAMPLE OF USE |
| Quantity |
unit of measurement |
Quantity |
|
How many items from category x did customer y purchase this year? |
| Packages |
|
|
|
|
| Value |
currency |
value |
quantity x price |
What was the value of items from category x purchased by customer y this year? |
| Purchase Value |
|
|
|
|
| Price |
|
|
|
|
| Purchase Price |
|
|
|
|
| Gross profit (GP) |
currency |
difference in value |
price difference x quantity sold |
Which items achieved the largest gross profit last year? |
| Gross margin (GM) |
currency |
difference in price |
sale price - purchase price** |
How did the gross margin from the sale of item x fluctuate over the last 5 years? |
| Gross profit/value (GP/value) |
% |
difference in value as percentage |
DIFFERENCE IN VALUE divided by VALUE multiplied by 100 |
How did the per unit gross profit (%) on the value of the sale of item x fluctuate over the last 5 years? |
| Gross profit/cost (GP/cost) |
|
|
|
|
| Number of purchases |
|
number of customer's (or consignee's***) purchases |
number of invoices |
How did the number of orders placed by customer xy fluctuate by month in 2005% |
| Average number of items/invoice |
|
Average number of items in invoices |
|
What was the average number of items in customer xy's invoices in 2005?
|
| Average number of categories/invoice |
|
average number of categories in invoices |
|
What was the average number of categories in customer xy's invoices in 2005? |
| Average value/invoice |
currency |
the average value of a customer's (or consignee's***) purchases |
VALUE (IN CURRENCY) divided by NUMBER OF INVOICES |
Which customers purchase the greatest value of goods at once? |
* - sale value
** - purchase value plus costs; own price
*** - depends on option selected in the By box in preferences and tools.
Instructions for Use
Related Topics: