Display an Item's Demand and Availability

Use the Planning Profile Inquiry (MRD) program to display an item's demand and availability, peg demand, and peg supply. See Road Map for work flow.

Enter an item number or click the Lookup icon and use the standard lookup options to select the item from a list.

The program displays these fields:

Field Name

Displays

Item no

The item number followed by its description

Item type

The item type that you assigned in the Enterprise Item Maintenance (IM) program; see Item Types

Prod class

The product class for this item; entered in the Product class field in the Enterprise Item Maintenance (IM) program

Planner

The code of the planner for this item; entered in the Planner field in the Branch Item Maintenance (IMB) program

Consignment

N: Item is not on consignment
Y: Item is on consignment

RRL

The Routing Revision Level entered in the Routing rev lvl field in the item's record in the Branch Item Maintenance (IMB) program

Stock UOM

The item's stocking unit of measure entered in the Stocking UOM field in the Enterprise Item Maintenance (IM) program

Auto plan

Y:	The Auto planning? field is selected in this item's record in the Branch Item Maintenance (IMB) program
N:	The field is not selected

Planning period

The planning period code either from the Branch Item Maintenance (IMB) program or from this program

Scrap %

The percent of this item that you normally scrap during the manufacturing process, which is entered in the Scrap % field in the Branch Item Maintenance (IMB) program

Max days

The total number of days of sales orders for each planned order; entered in the Max plan period field in the Branch Item Maintenance (IMB) program

The Finished Goods Planning (MFP) and Material Requirements Planning (MRP) programs use this value to schedule planned orders.

Lead time

The total number of days to procure or manufacture this item

For purchased items (Make/Buy/Kit = B): Order prep LT + Intransit LT + Put-away LT

For manufactured or kitted Items (Make/Buy/Kit = M or K): Order prep LT + Mfg LT + Put-away LT

Accm lead

The item's accumulated lead time

Safety stock

The minimum quantity of this item that should be kept in the stockroom at all times; entered in the Safety stock field in the Branch Item Maintenance (IMB) program

Min order

The minimum quantity for a planned order; entered in the Min order qty field in the Branch Item Maintenance (IMB) program

The Finished Goods Planning (MFP) and Material Requirements Planning (MRP) programs use this value to calculate planned order quantities. For example, if demand is 40 and Min order is 100, the planned order will be for 100.

Lot size

The standard quantity of the item manufactured at a time; entered in the Lot size field in the Branch Item Maintenance (IMB) program

The Finished Goods Planning (MFP) and Material Requirements Planning (MRP) programs use lot size when creating planned orders.

OH + Flr stk

The quantity of this item in on hand and floor stock inventory in branches in your inventory group

In MRB

The quantity tagged as rejected material

The program displays these fields for each period:

Field Name	Displays
Date	The start date of each period; period 1 has no start date; period 2 is your login date or if that date is not on the shop calendar, the preceding work date The Planning period field in the item's record in the Branch Item Maintenance (IMB) program determines the period length. *: End of the demand time fence: Login date + Order prep lead time + Mfg lead time
Sales	The quantity of this item committed for sales orders that have not been shipped in this period
Forecast	The quantity forecast for this period; 0 for some periods if you did not select the Spread forecast field in the item's record in the Branch Item Maintenance (IMB) program
Other req	Other requirements, which may be generated from a parent item, outgoing transfers, planned orders, or safety stock
Other sup	Other supply, which includes the quantity on hand, purchase orders, requisitions, incoming transfers, and released manufacturing orders
Planned	Quantity on orders planned by the system for the period
Proj on hand	Based on all sources of demand and supply for the period, the projected on hand quantity at the end of the period Period 1 is calculated: Other sup - Other req - Sales - Forecast Subsequent periods are calculated: Previous Proj OH - Sales - Forecast - Other req + Other sup + Planned
ATP	Available To Promise, which is a calculation of the "for sale" quantity of an item by planning period The Finished Goods Planning (MFP) and Material Requirements Planning (MRP) programs calculate ATP for each finished good and selected configured product components. If you add, change, or delete planned orders for an item, the Planning Profile Maintenance (MPM) program recalculates ATP. When an operator enters a sales order line, ATP can determine whether there is sufficient supply to promise the customer delivery by the date wanted.
Days	The number of shop days in the period
Per	The period number: 1 to 50; period 1 is past due and period 50 is future

(Optional) Click Prog opts to review your options. To change them:

Click the Runtime tab to set runtime options. See Set Options for Reports and Inquiries for more information.
Click the Program tab to set this program specific option:

Field Name	Type / Max Length	Action / Description
Enter planning period	Optional	Select to display a specific planning period or a planning period set up in the Branch Item Maintenance (IMB) program.

Click Save to save this option for future use.
Click Refresh to redisplay current options.
Click OK to apply this option or click Cancel to exit without applying it.

Choose the appropriate options:

To	Do This
Review your options for this program	Click Prog opts. See step 2.
Print the planning profile	Click Print. See Print an Inquiry.
Display all sources of demand for this item	Click Peg demand. See Display Demand Sources. Click OK to return to this program.
Display all sources of supply of this item	Click Peg supply. See Display Supply Sources. Click OK to return to this program.
Specify a different item	Click OK.
Exit the program	Click Exit.