Program Description
This program can be found on the Inventory Reports Inventory Control menu (INV-4-3-2). This program sorts vendor number and then item number (ITEMXVEN). The Item Warehouse file (ITEMWHD) for on hand information on all warehouses is also found. The Sales History (SAHIST.DT) file is searched to print the last six months of units for the item number. The program does not process item numbers that do not have an item type of P or if the calculated ROQ is zero. When the option to update is selected, the report will print and the calculation of the new minimum and maximums will be written into the ITEM files minimum on hand and maximum on hand.
Rev 15 Changes
Three additional prompt have been added to the report.
The first new prompt is “Round Avg. And Max U’p, D’own, Or O’ff”. When the program calculates the Average Usage Per Month, and the new Max, the operator is given the opportunity to round the result off to the nearest whole number, to always round down to the nearest whole number, or to always round up to the nearest whole number. If you would like to have the program work the same manner as prior to Revision 15, enter a “U” to round the result up to nearest whole number. For example:
|
Result |
Round Off |
Round Down |
Round Up |
|
45.6 |
46 |
45 |
46 |
|
45.2 |
45 |
45 |
46 |
The second new prompt is “Skip Items With LIFO Quantity=99 (Y’es/N’o)”. The LIFO Quantity is used for the Rank Number in the reports on the Inventory Control menu. A 99 indicates that the item is new and a min and max should not be calculated on the item. Answer this question with an N for no to have the program work the same manner as it did prior to Revision 15. Enter Y at this prompt to have the program to skip items or item warehouse records were the LIFO Quantity in the Item file is set to 99.
The third new prompt is “Do You Wish The QOS Figure To Be Wh O’ne Only Or A’ll Warehouses”. The QOS figure is the on hand figure. Prior to Revision 15, it was the on hand from warehouse one only. The operator can now choose to use all warehouses to calculate this figure.
Screen 2 sample:
Rev 14 Changes
An option was added to the report to print the report for a range of product classes. The product class from the Item file (ITEM) is used to determine if an item is within the range of product classes entered.
Also, the operator is given the opportunity to enter Item Types For Parts. The Item Type from the Item file (ITEM) is used to determine if the item should be printed. Prior to Revision 14, only items with an Item Type of P were included on the report.
Example:
Results:
Rev 13 Changes
The following prompts are described below:
Do You Wish To U'pdate The File, R'eport Only Or E'nd
Enter U to set the new minimum and maximum levels in the ITEM file and print the report. Enter R to print the Parts Minimum and Maximum report. Enter E to end and return to the menu.
Beginning Vendor Or A'll
Ending Vendor
Enter a specific vendor number, range of vendor numbers, or A for all vendor numbers. If the ending vendor number is less than the beginning vendor number entered, the message Beginning Vendor Number Is Greater Than Ending will display and the cursor will return to the ending vendor number for re-entry. The Vendor number can be up to 8 numeric.
Continue (Y'es N'o)
Enter Y for yes to continue with the program or N for no to end the program and return to the menu.
Results
The following screen display shows the results for report only and all vendors:
PART#
This is the item number from the ITEM file.
RANK
This is the lifo quantity field from the ITEM file. See the Ranking of Service Parts program for information on how item numbers are ranked.
DESCRIPTION
This is the item numbers description from the ITEM file.
BIN
This is the bin location for warehouse one from the ITEM file.
COST
This is the last cost from the ITEM file.
MAX
This is the days max usage from the ITEM file divided by 30 and rounded to one decimal position
15 / 30 = .5
TOT
This is the total unit sales month to date from the ITEM and ITEMWHD files.
MONTHS AGO (6 MO.) 1 - 6
This is the unit sales for the last 6 months in a calculation format.
RD = (Units for Month X 10 / Pak Multiple) - (Units for Month / Pak Multiple X 10)
If RD is greater than 4 than RD is equal to 1. If RD is less than or equal to 4 than RD is equal to
zero. MONTH # = (Units for Month / Pak Multiple) + RD + Units for Month
TOTAL
This is the total of months 1 - 6.
MONTH 1 + MONTH 2 + MONTH 3 + MONTH 4 + MONTH 5 + MONTH 6
AVG
This is the total of the TOTAL from up above of the 6 months divided by 6 and rounded up to the
nearest whole number.
MAX
This is a calculation of the new minimum and maximums. It is the AVG calculation from above
multiplied by the MAX from above and rounded to the nearest whole number. In the report sample, PART 2 is 5.00 X 1.3 = 6.5 and therefore MAX is 7.
QOS
This is the amount on hand divided by the pak multiple from the ITEM file.
QAL
This is the total for each warehouse of the individual calculation of maximum on hand minus on hand.
This is taken from the ITEMWHD file.
QOO
This is the amount on order divided by the pak multiple from the ITEM file.
ROQ
This is a calculation of the following values that were already explained above.
ROQ = MAX - QOS - QOO + QAL
Note: if this calculation comes out 0 than the item number is skipped from printing.
Notes
On SuperDOS, the program needs to be compiled with BCOMP.60. This report is from MT Business Technologies, Inc. Their version of the program is called MANSMIN.