Inventory Turns reports allow users to compare the inventory turnover ratio by sales category for each month over a thirteen-month period.
Reports are available in summary format for both parent and child profit centers.
When you select Inventory Turns reports, the system displays the following report criteria screen:
The following selection criteria allow you to specify the period for which you want to view turnover data and the way the report is viewed.
Enter the ending date for the period for which you want to view turnover data. You must make an entry in this field and it must be in mm/dd/yy format. For example:
01/10/99
Note: You do not need to know the exact Period End Date. The system will find the actual End date for any date you enter.
You may specify how you want to view and/or print the report by choosing from the following selections:
· View Report Directly
· Condense Print
· Print Directly to LPN
· Display/Print Selection Page
Note: Inventory Turns Reports print in landscape format.
The following information is listed on Inventory Turns reports:
Period Ending Date
Profit Center
Merch Category
Total
Note: Table RS_CAT_DET is used to retrieve inventory data.
The report columns are as follows:
Period Ending Date
The Period Ending Date columns display the inventory data for the specified date. The first Period Ending Date is the date entered as selection criteria. Each subsequent Ending date is a prior period.
Note: Thirteen periods are shown on the Inventory Turns report. Prior periods are chosen by subtracting one period from the selected Period Ending date, and then subtracting one period from each subsequent Period Ending Date.
The following sections are listed on the report:
Profit Center
The report displays the name and number of the profit center represented by the corresponding report data.
If a profit center has a child profit center, it appears as a hyperlink. Clicking on the hyperlink allows you to view Inventory Turns reports for child profit centers.
Merchandise Category
The Merchandise Category rows describe the inventory reported for the corresponding period at the profit center.
Each turnover value is calculated by using the following formula:
X / Y
X = the period sales for the category.
Y = the corresponding beginning retail value for the category.
Values are rounded to two (2) places after the decimal.
Totals
The Totals column displays the sum of inventory turns for the category.
If a profit center has child profit centers, you may click on the parent profit center’s hyperlink to view report information for its child profit centers.
The Inventory Turns child report is based on the same selection criteria you entered for the parent profit center.
Information for child profit centers is calculated in the same manner as it is for parent profit centers. See the Inventory Turns report section for more information.
You may notice a slight rounding difference between totals on detail and summary reports. Click here to see why.