Field Definitions: Mo/Mo Sales By Item Report (05-36)
Overview
Below are descriptions of each column on the Month by Month Sales by Item screen.
Fields
Brand
This is the item’s Brand.
Dept
This is the item’s Department.
Item#
This is the item number being reported on.
Description
This is the description for the item.
OnOrder
This is the quantity currently on open purchase orders.
Floor
This is the quantity of the item designated as Floor Model.
Damaged
This is the quantity of the item designated as Damaged.
Commit
This is the item’s committed amount. Remember that the committed amount is the quantity of items that are on Delayed Delivery or Special Order transactions, which have a delivery date other than a “?”, and that are not linked to a purchase order.
InBound
This is the item’s inbound transfer quantity.
Outbound
This is the item’s outbound transfer quantity.
% of Change
This is the percentage of change between the quantity sold in the current month and the quantity sold in the same month of last year.
It is calculated using the following formula:
For example, if the current month is September, the percentage of change between last September and this September is calculated as follows:
Using actual values, if the quantity sold this month is 4, and the quantity sold in September of last year was 6, the percentage of change (-33.3) is calculated as:
LY Current Month (e.g. LY Sep)
This is quantity sold of the item in the same month (as the current month) of last year.
Current Month (e.g. Sep)
This is the quantity sold for the current month.
Remaining Months
Quantities sold for the remaining months of the year appear in these columns.
Total
The total quantity sold for the last 13 months appears in this column.