IC150 - Movement Analysis - Cost
Run this program to print the Movement Analysis - Cost report. This report
lists items in descending order by total cost and suggests movement classes
based on total cost percentages. By default the total issue and sales cost is
used, but you can optionally include transfer and adjustment costs.
You define what percentage of total costs must be met by movement class 1, 2,
and 3. For example, if you assign 70, 20, and 10 to movement class 1, 2 and 3
this program assigns class 1 to items that make up 70 percent of total issue
costs, class 2 to items that make up the next 20 percent of the total and
class 3 to items that make up the last 10 percent of total issue costs. You do
not have to assign a percentage to each movement class. However, the total
percentage assigned must equal 100 percent. Examples include 50/50, 80/15/5,
and 60/40.
This program requires you to enter a period and year range for which to
analyze inventory movement. For example, enter
1 1993 - 4 1993
to analyze inventory movement for the first four periods in 1993. This form
also provides an update option which lets you update suggested movement
classes to the Item Location records in IC12.1 (Item Location).
You select the items affected by this form by location, report group, and/or
inventory class. You can also specify a cost cutoff amount and/or include
items set up as inactive in the Item Master file (IC11.1) or Item Location
file (IC12.1). If you specify a cost cutoff amount, this program excludes
items with issues costs that fall below the cost specified.
Note: Summarized inventory history does not include sales prices for
make-to-order kit components. This report is invalid for these items.
Updated Files
CKPOINT - Used in backout or restart circumstances.
ITEMLOC - Used to update the movement class and rank if the update
option is selected.
Referenced Files
GLADDRESS - Used in a General Ledger common routine.
GLCHART - This file contains chart and system account information in the
General Ledger system.
GLCODES - Used in a General Ledger common routine.
GLSYSTEM - Used in a General Ledger common routine.
ICBIN - Used to validate bin number and extract bin information.
ICCOMPANY - Used to validate the existence of the company number.
ICHISTORY - Used to accumulate total sales cost for an item location.
ICLOCATION - Used to print the location description.
ICRPTGRP - Used to validate the report group.
ITEMMAST - Used to print the item description.
MAJORCL - Used to validate the major class.
MINORCL - Used to validate the major-minor class.
INVOKED Programs
IFSG
|
