Grid

The Grid is the primary part of the application where the planner can directly change the value of supplies and demands and can simulate the consequences of the applied changes.

The grid shows the projected on-hand balance or proj-OHB over a number of buckets. The balance for a specific date and time are displayed at the top of each proj-OHB columns. All demands and supplies for the specific dates and times are displayed between the proj-OHB columns. Each displayed cell in the grid has a tool tip that shows detailed information to calculate the value in the cell.

You can select which columns to display in the grid in Settings > Display. You also have the option to add more columns per bucket or, alternatively, not display supplies, demands, or proj-OHBs.

These information are displayed in the demand, supply, and proj-OHB sections. Use the tooltip on each cell to view detailed information for that specific cell.

Demand

This is calculated as the sum of IPW Forecast, MO/MOP - material issue, DOP issue, Released DOs - issue, and other demands.

The IPW Forecast is displayed as a sub-total in the tooltip. The forecast depends on these parameter settings:

  • If Manual Forecast is enabled and the value of Manual Forecast is greater than zero, and if Manual Forecast is not equal to forecast type, the forecast for IPW is calculated as:
    Change + Max (Manual forecast - shipped CO, open CO)

    You can set Manual Forecast in Settings > Miscellaneous.

  • If Forecast Method is set as Remaining Forecast, the forecast for IPW is calculated as:
    Remaining Forecast + open CO

    You can set Forecast Method in Settings > Data Retrieval 1.

  • If Forecast Method is set as Forecast, the forecast for IPW is calculated as:
    Max(forecast - shipped CO, open CO)
  • If Forecast Method is set as None, the forecast for Inventory Planning Workbench is Open CO.
    Note: The fields that are not used in calculating the FFP forecast are disabled in the tool-tip.

Supply

This displays contributions from orders. The acquisition code controls which order is displayed in the supply cell:

  • 1: Manufactured considers supplies from manufacturing orders
  • 2: Purchased considers from purchase orders
  • 3: Distribution considers supplies from distribution orders

Projected on-hand balance

This displays projected on-hand balance and calculates coverage time for the projected on-hand balance. The projected on-hand balance is calculated from the previous three cells, which include the previous projected on-hand balance, demand, and supply.

For the first bucket, the projected on-hand balance is different. It is based on the approved on-hand balance and is adjusted for any outstanding demands and supplies.