Analyze Supply and Demand Information

Explanation

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

Prerequisites

N/A

System Effects

N/A

Window

Inventory Part Availability Planning

Related Window Descriptions

Inventory Part Availability Planning

Related Visualization Chart Descriptions

Inventory Part Availability Planning

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 window.

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:

  1. Open a visualizer enabled window and query for the data to be analyzed.
  2. If the Data View is displayed, click Visualization View on the title bar.
  3. Click the Configure Visualizations icon on the topmost right hand corner. The Visualization Settings dialog box is opened.
  4. Double-click Inventory Part Availability Planning.
  5. Click OK. The chart is displayed and can be analyzed as required. Supply records are displayed as positive bars and demand records as negative bars. The projected on-hand and plannable quantity development is represented with lines. If a safety stock, or order point has been defined for the part these will be represented with lines in the chart as well.