Reviewing Performance Information

Access the Work With Buyer's Item Information form.

When you review performance information for an item, you can review buyer information that is related to the item, previous sales activity, and open purchase orders. This information, when used in conjunction with item availability information, helps you to plan for the inventory needs.

Buyer Number

Enter the address number of the person who is responsible for setting up and maintaining the correct stocking levels for the item.

ABC 1 Sls (ABC code 1– Sales)

Enter a code that specifies this item's ABC ranking by sales amount. Values are:

A: Assign this item to the first (largest) amount ranking.

B: Assign this item to the second (intermediate) amount ranking.

C: Assign this item to the third (smallest) amount ranking.

D: Do not include this item when you run ABC analysis.

Three types of ABC analysis are available: sales, margin, and on-hand value. Within each type of analysis, you can have three groups: A, B, and C.

The ABC Code fields contain a percentage that tells the system how to define the A, B, and C groups for categorizing items during ABC analysis. Each group measures a total within the type of analysis.

For all groups, the system compares the appropriate sales, margin, or on-hand value totals of a single item to the appropriate total for all items and calculates the value of each item. An item's value is its percentage of the appropriate total. The system then arranges the values of all items from highest to lowest value and accumulates the percentages. What happens next depends on the group:

A group: If an item's value causes the accumulated total to exceed the A accumulated percentage, the system assigns the item to the B group.

B group: When the accumulated total reaches the percentage that you entered for items in the A group, it continues adding values until it reaches the percentage that you entered for items in the B group. The system assigns all items for which the value falls between the A and B percentages to the B group.

C group: The C group consists of items for which the accumulated value exceeds the B percentage. The percentage that you usually enter for the C group is .999.

Reorder Point

Enter a quantity for an item that specifies when replenishment occurs. Typically, this occurs when the total quantity on hand plus the quantity on order fall to or lower than a specified quantity. You can enter this quantity, or the system can calculate it if a sufficient sales history is available.

Economic Order Qty (economic order quantity)

Enter the estimated reorder quantity for an item. You can enter this quantity if not enough sales history is available for the system to accurately calculate a reorder quantity.

Safety Stock

Enter the quantity of stock that is kept on hand to cover high-side variations in demand.

Leadtime Level

Enter a value that represents the leadtime for an item at its assigned level in the production process, as defined on Plant Manufacturing Data. The system uses this value to calculate the start dates for work orders using fixed leadtimes.

Level leadtime is different for purchased and manufactured items:

Purchased: The number of calendar days that are required for the item to arrive at the branch/plant after the supplier receives the purchase order.

Manufactured: The number of workdays that are required to complete the fabrication or assembly of an item after all the components are available.

You can enter level leadtime manually on Manufacturing Values Entry, or you can use the Leadtime Roll up program to calculate it. To calculate level leadtime using the Leadtime Roll up program, you must first enter a manufacturing leadtime quantity in the F4102 table.

Branch/Plant and Item Number

Enter the branch/plant and item numbers.