15 Review Performance Information

This chapter contains these topics:

Section 15.1, "Reviewing Inventory Quantities"
Section 15.2, "Reviewing Sales History"
Section 15.3, "Reviewing Open Purchase Orders"

When you review performance information for an item, you can review the current quantities for items in your inventory, previous sales activity, and open purchase orders. This information is useful in helping you to plan for your inventory needs.

15.1 Reviewing Inventory Quantities

From Inventory Management (G41), choose Inventory Inquiries

From Inventory Inquiries (G41112), choose Buyer's Information

You can also access Buyer's Information from the Inventory Master/Transactions menu (G4111). Choose Inventory Inquiries, followed by Buyer's Information from the Inventory Inquiries menu (G41112).

You can review item and quantity information to plan for your current and future inventory needs.

To review inventory quantities

On Buyer's Information

Figure 15-1 Buyer's Information screen

Description of "Figure 15-1 Buyer's Information screen"

Complete the following fields:
- Item Number
- Brn/Plt
- Input U/M
Press Enter.
Review the following fields:
- Day/Avail
- On Hand
- Comm
- Avail
- Avail/Rec (Available on Receipt)
- On PO Reor Pt
- EOQ (Quantity-Economic Order)
- Cumulative Sales-This Yr

Field	Explanation
Input U/M	A user-defined code (system 00/type UM) that identifies the unit of measure in which you usually purchase the item. Form-specific information If you leave this field blank, the system uses the purchasing unit of measure.
Day/Avail	A number that indicates how many days of inventory are available. This number of days is calculated by dividing the total number of units sold during the previous two months by the number of working days in a two-month period (43.5). The system divides the number of days by the current quantity available. Example: Current Period is 11 Period 9 (150 sales) + Period 10 (140 sales) = 290 cumulative sales for two periods Divide by 43.5 Average working days within two months = 6.6666667 Quantity Available = 610 Divide by 6.6666667 Days Available = 91.5
On Hand	The number of units that are physically in stock. The quantity on-hand displays in the primary unit of measure. Form-specific information The total number of items (counted in the primary unit of measure) that are stored in both the primary and secondary locations of a particular cost center. This information is stored in the Item Location Information table (F41021). The total number of items (counted in the primary unit of measure) that are stored in both the primary and secondary locations of a particular cost center. This information is stored in the Item Location Information table (F41021).
On PO	The number of units specified on the purchase order, in primary units of measure. Form-specific information The system retrieves this number from the Item Location table (F41021) for the primary and all secondary locations of the item in the specified branch/plant.
Avail/Rec	The number of units that are currently available (in the primary unit of measure) plus the quantity on purchase or work orders.
Reor Pt	A quantity for an item that specifies when replenishment occurs. Typically, this occurs when the total quantity on-hand plus the quantity on order equal or do not meet a specified quantity. You can enter this quantity or the system can calculate it if there is sufficient sales history. If there is no safety stock quantity defined, the system first calculates the safety stock by multiplying the square root of the average leadtime quantity. Then, the system adds the calculated safety stock quantity to the average leadtime quantity to determine the reorder point.
EOQ	A fixed order quantity for an item that the system calculates to minimize the combined costs of acquiring and carrying inventory. The system calculates this number based on an economic analysis of the cost of placing an order and carrying the inventory.

15.2 Reviewing Sales History

From Inventory Management (G41), choose Inventory Inquiries

From Inventory Inquiries (G41112), choose Buyer's Information

You can also access Buyer's Information from the Inventory Master/Transactions menu (G4111). Choose Inventory Inquiries, followed by Buyer's Information from the Inventory Inquiries menu (G41112).

You can use sales history information to determine previous and projected sales. For example, you can review the cumulative sales to date and the projected sales for the remainder of the year. You can also compare item sales for different fiscal periods.

To review sales history

On Buyer's Information

Complete the following fields:
- Item Number
- Brn/Plt
- Input U/M
Press Enter.
Review the following fields:
- ABC RK (ABC Ranking)
- Per End
- Cumulative Sales-This Yr
- Cumulative Sales-Last Yr
- 12 PD (Quantity Projected-Total)
- Trd (Trend Percent)
- Reor Pt
- Lst Cst
- Avg Cst
- Lst Rec

Field	Explanation
ABC Rk	A grade that indicates the level of sales activity for a customer or inventory item. This code documents the 80/20 principle (80% of the significant results is attributable to 20% of the business effort). The possible grades are A (best) to F (worst).
Cumulative Sales	The number of units, in primary units of measure, that you sold during a prior month. The system maintains the units history for a period of twenty-five months.
12PD>	The total projected sales quantity for the next 12 months, i.e., the current month and the next 11 months. Note: The Buyer's Inquiry (V41150) itemizes projections for only the current month and the next nine months. Projections are designated by the symbol > next to the name of the month. The total projected sales quantity for the current month and the next 11 months, for a total of 12 months.

Field

Explanation

ABC Rk

A grade that indicates the level of sales activity for a customer or inventory item. This code documents the 80/20 principle (80% of the significant results is attributable to 20% of the business effort). The possible grades are A (best) to F (worst).

Cumulative Sales

The number of units, in primary units of measure, that you sold during a prior month. The system maintains the units history for a period of twenty-five months.

12PD>

The total projected sales quantity for the next 12 months, i.e., the current month and the next 11 months.

Note: The Buyer's Inquiry (V41150) itemizes projections for only the current month and the next nine months. Projections are designated by the symbol > next to the name of the month.

The total projected sales quantity for the current month and the next 11 months, for a total of 12 months.

15.3 Reviewing Open Purchase Orders

From Inventory Management (G41), choose Inventory Inquiries

From Inventory Inquiries (G41112), choose Buyer's Information

You can also access Buyer's Information from the Inventory Master/Transactions menu (G4111). Select Inventory Inquiries, followed by Buyer's Information from the Inventory Inquiries menu (G41112).

If your Inventory Management system is set up to work in conjunction with the Procurement system, you can review all of the open purchase orders that meet the following criteria:

Do not have an open quantity that is equal to zero
Do not have a next status that is below 900

To review open purchase orders

On Buyer's Information

Complete the following fields:
- Item Number
- Brn/Plt
- Input U/M
Press Enter.
Review the following fields:
- Type
- Number
- Line
- Supplier Name
- Quantity
- Date

15.3.1 Processing Options

See Section 58.8, "Buyer's Inquiry (P4115)"