| 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 |
unit of measurement |
quantity of packages |
|
How many packages of item x did customer y purchase this month? |
| Value |
currency |
value |
|
What was the value of items from category x sold to customer y this year? |
| Purchase Value |
currency |
purchase value |
|
What was the purchase value of items from category x sold to all customers in last year? |
| Price |
currency |
price |
Value / Quantity |
What is the average price of items from category x? |
| Purchase Price |
currency |
purchase price |
Purchase Value / Quantity |
What is the average purchase price of items from category x in this year? |
| 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 / value) * 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 / number of invoices |
Which customers purchase the greatest value of goods at once? |