Analyze Supply and Demand Information

Explanation

The procedures described below are examples on how to interpret the information displayed on the Inventory Part Availability Planning page or visualizer chart.

Using Inventory Part Availability Planning (IPAP) page:

The usage of Inventory Part Availability Planning page to view the planning information for a part controlled by your company. Therefore, the customer owned and supplier loaned material is not included. General planning data for the part is displayed in the header area (Part, Site, Configuration ID and Project ID). Detailed planning data as well as supply and demand information, is found on the tabs.

The Inventory Part Availability Planning page is a client that has many complexities. Due to its nature, there had been many design decisions taken which had made this page to be developed not as a normal/usual page. Therefore, RnD recommends that a user performing search in this page should at least specify the part and site as search criteria. If the customer has project information, to view the supply and demand situation for a project, you can search for the project specific part with the relevant Project ID. You can also view the supply and demand situation of all the projects and standard inventory for the part by searching with the Hash (#) symbol in the Project ID field.

Note that if you search for a specific part number and site only, the system will return as many records as there are open projects for the given site, irrelevant of the part number. If an asterisk is displayed in the Project ID field, it indicates that the parts belong to standard inventory.

If you want to search for a part that has supplies, demands or onhand qty, then performing search in Inventory Parts Availability Planning overview page is preferred.

Prerequisites

N/A

System Effects

N/A

Procedure

To analyze supply and demand information using the data view:

Analyzing Date for Infinite Availability

The Lead Times/Unlimited Supply Date area in the header contains information about the lead times for the part, as well as a calculation of the date for which the availability is infinite. The date field adjacent to the Picking lead time field is a calculation of the date on which the part will be pick reported, if  pick-planned  today. The calculations are based on the Picking lead time value and is done according to the appropriate calendar. A calculation which involves non-working days will adjust the date to a working date. Also one day is always added to ensure that delivery can be met if the receipt is done late or the order is placed late.

Examples:

Analyzing Project Specific Supply and Demand

To view the supply and demand situation for a project, select the project specific part in question in the Part No field in the header part of the page.

Analyzing Total Supply and Demand

Query by entering the Hash symbol (#) in the Project ID field and you will be able to view the supply and demand situation, of all the projects and the standard inventory, for the particular part.

Analyzing the Projected and Plannable Columns
There are four pairs of Projected and Plannable columns available in all the tabs except the Planning Info tab. The calculation logic for all these columns are the same, as it is the input data that differs.

There are several reasons why a balanced supply/demand situation may deteriorate. A supply may be re-confirmed, a customer may ask for a change in delivery time, a customer order line may be reserved in advance, due dates for a pegged pair of supply and demand lines may differ, etc.
An out of balance supply/demand situation may be rectified by for instance adjusting the due dates on the supplies and demands, dissolving reservations, changing peggings, and creating new supplies.
The different Plannable column details will assist in finding out how to improve the availability.

Use the Projected and Plannable columns to view the ability to fulfill a new demand, disregarding any current reservations or peggings. They should display the most favorable situation, assuming you have full flexibility to adjust both reservations and peggings. The starting quantity for the calculation is the value in the Usable Quantity field in the header. In the Availability Check and Availability Check per Day tabs, however, the starting quantity for the calculation is the value in the Available Quantity field in the header.

Use the Projected Not Reserved and Plannable Not Reserved columns to view the ability to fulfill a new demand when reservations are considered, and peggings are not. Reserved quantities are excluded from these columns. If there is a difference between the Plannable and the Plannable Not Reserved column, the reason is that there are reservations affecting the availability. Pay attention to the reservations made in advance, i.e., outside the picking lead time date. These reservations may be dissolved to improve availability. The starting quantity for the calculation is the value in the Quantity Available field in the header as reservations are deducted from this figure.

Use the Projected Not Pegged and Plannable Not Pegged columns to view the ability to fulfill a new demand when peggings are considered, and reservations are not. Pegged quantities are excluded from this pair of columns. If there is a difference between the Plannable and the Plannable Not Pegged column, the reason is that there are peggings affecting the availability. Change the due date for the supply or demand, dissolve the pegging, or change the pegging target to improve the availability. The starting quantity for the calculation is the value in the Usable Quantity field in the header.

Use the Projected Not Reserved/Pegged and Plannable Not Reserved/Pegged columns to view the ability to fulfill a new demand considering both reservations and  peggings. If there is a difference between the Plannable and the Plannable Not Reserved/Pegged column, the reason is found among the reservations or peggings made. This means that the starting quantity for the calculation is the value in the Quantity Available field in the header.

Additionally the CO Plannable column is displayed. This column may present a different figure due to the differences between the expected lead time and the purchasing or manufacturing lead time, and on what kind of stock locations the parts are stored.

Notes:

To analyze supply and demand information using the visualization view:

Order Proposal and Order Proposal per Day tabs to view the selection of supply and demand information that is used by, e.g., the Order Proposal functionality. Certain supply and demand types and supply and demand details connected to projects are not available here and can be found on the All tab.

 Order Proposal per Daytab is to view the summarized details of the supplies and demands found on the Order Proposal tab. These are summarized per date, and therefore all the orders for a particular part on one particular date, are displayed on one line. References to individual supplies and demands are not available here.