Viewing Product Demand and Procurement Information

Use the Primary Inventory Maintenance screen to view product demand and procurement information for each branch in which the product exists. The system displays the demand and procurement information for each branch's warehousing scheme, such as central purchasing or central distribution.

The system continually updates the product's projected inventory level and order/transfer point in real time. The system updates the remaining information on the screen each time you run the Update Product Demand Forecast program for the product.

For stock products, the Primary Inventory Maintenance screen displays a summary of the product's current demand information. For nonstock products, the system does not calculate the order point, line point, Economic Order Quantity (EOQ), and monthly demand.

To view a product's demand information:

  1. From the Files menu, select Product to display the Product Maintenance screen.

  2. Display the product record for which to view demand information.

  3. Use the Inven hot key to display the Primary Inventory Maintenance screen.

  4. Review the following information for the displayed product record:

Column

Description

Brch

Branch to which the demand information applies.

Branch's with the following 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.

  • P – Central purchasing branch that purchases for other branches.

  • W –Central distribution branch that warehouses for other branches.

  • C – Central warehousing branch that both purchases and warehouses for other branches.

Stk

Product's stock status:

Buy Pkg (unit of measure)

Buy package quantity integral in which the product 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.

Div

Whether the product's buy package quantity integral can be divided when one of the following occurs:

  • Vendor purchases the product.

  • Warehousing branch transfers the product.

  1. Review the following demand information for the displayed product record:

Note: The following columns display different information depending on whether the branch is a parent or child branch.

Column

Parent Branch Description

Chile Branch Description

PIL

Projected inventory level.

Projected inventory level.

OP/XP

Order point.

Transfer point and surplus point.

Low Sale (unit of measure)

Lowest quantity sold in the branch within the forecast period.

Lowest quantity sold in the branch within the forecast period.

EOQ

Economic Order Quantity (EOQ), 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. If this is the case, the field displays with an asterisk (*) to indicate the exception.

EOQ for the product in the branch.

Monthly Demand

Monthly demand for the product in the branch.

Monthly demand for the product in the branch.

Monthly Hits

Monthly hits for the product in the branch.

Monthly hits for the product in the branch.

Leadtime XF Cyc

Lead time for a purchasing branch.

Transfer cycle days for a selling branch.

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.

  1. Press Esc to exit the screen.

More Options on the Primary Inventory Maintenance Screen

The Primary Inventory Maintenance screen also offers these options:

Hot Key

Function

Audit

Displays the Demand Calculation Audit screen. Use this screen to view product demand calculation information.

Order Points

Displays the Product Order Points/Line Points screen. Use this screen to do one of the following:

  • View product order point and line point calculation information.

  • Change the safety factor and projected gross margin for an individual branch.

Forecast Params

Displays the Forecast Parameters Maintenance screen. Use this screen to set the parameters used to forecast product demand.

User Controls

Displays the Product User Controls Parameters screen. Use this screen to enter specialized product-level user inventory control parameters.

Inv Inq

Display the Inventory Inquiry screen. Use this screen to view inventory details for the product in all branches.

EDI

Displays the EDI/VMI screen. Use this screen to flag the product as vendor-managed inventory for EDI.

Addl

Displays the Additional Inventory Parameters screen. Use this screen to do the following:

See Also:

Enabling Stock/Nonstock Determination for Products

Setting Product Buy Package Quantity and Divisibility

Product Demand and Procurement Determination Overview

Updating Product Demand Overview

Forecasting Overview