Viewing Product Demand Information

Use the Primary Inventory Maintenance dialog box to view product information related to inventory management.

The system continually updates the product's projected inventory level (PIL) and order/transfer point (OP/XP) in real time.

The system updates the remaining fields in the window each time you run the Update Product Demand Forecast program for the product.

When you assign a product the product status of Stock, the Primary Inventory Maintenance window displays a summary of the product's current demand information.

When you assign a product the status of NonStock, the system does not calculate the order point, line point, Economic Order Quantity (EOQ), and monthly demand.

To view product demand information:

From the Maintenance menu, select Product to display the Product Maintenance window.

Display a product record.

From the Inventory menu, select Primary Inventory Maintenance to display the Primary Inventory Maintenance dialog box.

In the Br column, review the branch numbers and types.

Branch or warehouse identifiers with letter suffixes indicate the warehousing scheme used for replenishing that product. These lines display calculated information for all branches combined under the defined warehouse scheme.

Suffix

Defines a...

Which...

Central purchasing branch

Purchases for other branches.

Central distribution branch

Warehouses for other branches.

Central warehousing branch

Purchases and warehouses for other branches.

In the Stock column, review whether the item is a known stock (Yes) or nonstock (No) item, or whether the system calculates (Auto) the stock or nonstock status based on the number of hits the product receives in a branch warehouse network.

The product's stock or nonstock status can be set in the Additional Inventory Parameters dialog box.

In the Buy Pkg <unit of measure> column, review the quantity multiple in which stock is purchased or transferred. For example, if set to 6, stock is purchased or transferred in quantities of 6, 12, 18, 24, and so forth.

In the Div column, review whether the buy package can be divided either by the vendor when purchasing or by the warehousing branch before transfers occur.

Note: Both the Buy Pkg and Div columns remains blank if no territory is selected.

Review the fields, as needed, for each parent branch and child branch:

When you have finished reviewing the information, exit the dialog box.

More Options in the Primary Inventory Maintenance Dialog Box

The Primary Inventory Maintenance dialog box also offers these options:

To...

Select this menu option...

view product demand calculation information

Edit > Audit

The Demand Calculation Audit dialog box displays.

view product order point and line point calculation information

Edit > Order Points

The Product Order Points/Line Points dialog box displays.

change the safety factor and projected gross margin for an individual branch

Edit > Order Points

The Product Order Points/Line Points dialog box displays.

set the parameters used to forecast product demand

Edit > Forecast Parameters

The Product Forecast Parameters dialog box displays.

enter specialized product-level user inventory control parameters

Edit > User Controls

The Product User Controls Parameters dialog box displays.

view inventory details for the product in all branches

Edit > Inventory Inquiry

The Inventory Inquiry dialog box displays.

define whether the item is stock and nonstock determination, by branch, and determine the buy package and divisibility overrides for branches and territories or to indicate how to calculate PIL when handling remnants

Edit > Additional Parameters

The Additional Inventory Parameters dialog box displays.

flag the product as vendor-managed inventory for EDI

Edit > EDI/VMI Maintenance

The Product EDI/VMI Maintenance dialog box displays.

Field	For a parent branch, shows the...	For a child branch, shows the...
PIL	projected inventory level.	projected inventory level.
OP/XP	order point. If a minimum-only is set for the product, the system uses that minimum as the order point until the calculated order point exceeds the minimum-only setting. The system then uses the calculated order point. Minimum-only is in effect when a lower case "m" displays after the EOQ value. If there is a min/max order point set for the product, the min is always the order point and an upper case "M" displays after the EOQ value. Note: The order point displays as a whole number.	system-calculated transfer point if there is no min/max order point set for the product. If the Respect Item Min/Max For Suggested Transfers control maintenance record is set to No, the system checks the Max setting for the product. If there is a min/max set for the product, the transfer point is the max and an uppercase "M" displays next to the EOQ value. If there is no min/max set for the product, the system uses the system-calculated transfer point. If there is a minimum-only set for the product the system uses the minimum-only is in effect when a lowercase "m" displays after the EOQ calculation.
OP/XP		If the Respect Item Min/Max For Suggested Transfers control maintenance record is set to Yes, the system checks the min setting for the product. If there is a min/max set for the product, the transfer point is the min and an uppercase "M" displays next to the EOQ value. If there is no min/max set for the product, the system uses the system-calculated transfer point. If there is a minimum-only set for the product, the system uses the minimum-only as the transfer point until the calculated transfer point exceeds the minimum-only setting, the system uses the system-calculated demand. A minimum-only is in effect when a lower case "m" displays after the EOQ value. Note: The transfer point displays as a whole number.
Low Sale <unit of measure>	lowest sale in the branch within the forecast period.	lowest sale in the branch within the forecast period.
EOQ	Economic Order Quantity, based on the combined demand of the multi-branch network. When the low sale quantity exceeds the calculated EOQ, the system uses the low sale quantity in place of the EOQ in associated calculations. In this case, the field displays with an asterisk to indicate the exception. An uppercase "M" in this field indicates that the system is using the min/max setting as the transfer point. A lowercase "m" in this field indicates that the system is using the minimum-only setting as the transfer point.	Economic Order Quantity for the item in the branch. An uppercase "M" in this field indicates that the system is using the min/max setting as the transfer point. A lowercase "m" in this field indicates that the system is using the minimum-only setting as the transfer point. An EOQ with no letter indicates that the system is using the system-calculated transfer point.
EOQ	An EOQ with no letter indicates that the system is using the system-calculated transfer point. An uppercase "M" in this field indicates that the system is using the min/max setting as the transfer point. A lowercase "m" in this field indicates that the system is using the minimum-only setting as the transfer point. An EOQ with no letter indicates that the system is using the system-calculated transfer point.
Monthly Demand	monthly demand for the item in the branch.	monthly demand for the item in the branch.
Monthly Hits	monthly hits for the item in the branch.	monthly hits for the item in the branch.
Leadtime XF Cycle	product's lead time for a purchasing branch.	transfer cycle days for selling (child) branches.
Safety LT Day	number of lead time safety days for the item in the branch.	number of lead time safety days for the item in the branch.