Inventory Turnover by Issues (IC135)
Run Inventory Turnover by Issues (IC135) to print a report of inventory turnover based on item issues. Run this program if you do not use the Order Entry application. If you use the Order Entry application, run IC134 (Inventory Turnover) to calculate turnover rates based on item sales.
Processing Effect
This program calculates inventory turnover rates based on issue quantities, average stock-on-hand quantities, and, optionally, on transfer and adjustment quantities. In order to calculate accurate turnover rates, you must run this program immediately after you close an inventory period in IC190 (Closing). The closing form (IC190) captures period end balances and calculates average stock-on-hand quantities.
Calculations used by this form are listed below.
Average Inventory is the sum of period end item stock-on-hand quantities divided by the number of periods for which balances exist.
Turnover Rate is the sum of inventory issue quantities for the last 12 months divided by average inventory quantities.
This program requires you to enter the period and year range for which to calculate turnover rates. For example, enter
1 1993 - 4 1993
to calculate turnover rates for the first four periods in 1993. This form also provides an update option which lets you update inventory turnover rates to Item Location records in IC12.1 (Item Location). You can select the items affected by this program by location, report group, and/or inventory class.