Supply and Demand and Ending Available Charts
The system aggregates the adjusted primary units for customer demand and forecast records in the F34X200W table by date, and then evaluates which records to mark for exclusion based on the planning fence rule for the item/branch. If you are using the forecast consumption by customer functionality, the system uses the customer address relationship to determine the demand based on the greater of sales (retrieved from the F4211 table) or forecast (retrieved from the F3460 table). The system creates a record with the aggregated quantity for unconsumed forecast by date for the new forecast type in the F34X200W table. The total of customer demand and the aggregated unconsumed forecast drive the demand for the Supply and Demand and Ending Available charts.
Customer demand records marked for exclusion from the charts still display in the Supply/Demand Details grid. The system highlights records in the Supply/Demand Details grid in gray colored font to indicate that the record is excluded from the Supply and Demand and Ending Available charts. The system highlights records in black colored font to indicate that the record is included in the charts.
On the Supply and Demand chart, each planning horizon bucket displays raw values for supply and demand in that period. The values are not cumulative across the time periods.
The Supply and Demand chart is a double bar chart that plots the quantity on the y-axis versus the date on the x-axis. For each time period, the chart displays one blue bar for supply and one red bar for demand.
The system accumulates unadjusted or adjusted values for the period. Supply includes all records in the F34X200W table within the period of adjusted or unadjusted dates where the Supply or Demand Code is equal to S.
The Supply and Demand and Ending Available charts include the following supply:
Inventory on-hand
Lots expiring today
Purchase orders
Work orders
Rate schedules
The system charts rate schedules for only the dates included within the planning horizon specified in the Planning Horizon Periods processing options of the Planning Console program.
Demand includes all records in the F34X200W table within the period of adjusted or unadjusted dates where the Supply or Demand Code (34XSDDS) is equal to D.
The Supply and Demand and Ending Available charts include the following demand:
Sales orders
Interplant demand
Configured components
Forecasts
Work order project demand
Parts list
Pegging orders
If the value of the Interplant Demand processing option is 1, the system considers firm and planned transfer orders as customer demand. If you use forecast consumption, the system uses interplant demand to consume forecast when the Interplant Demand processing option is set to 1.
The Supply and Demand chart also includes messages for planned orders and transfer orders.
The system does not include bulk items in supply and demand.
The system displays the Freeze Fence Date and Planning Fence Date fields above the Supply and Demand chart.
The system takes the first character from the Freeze Fence Date and Planning Fence Date control fields to display in the chart after the date on the x axis of the Supply and Demand chart. If the date falls within the daily buckets, then the system displays the first character on the corresponding date. If the date falls in the weekly or monthly buckets, then the system displays the first character on the first bucket that the date corresponds to.