Product Supply/Demand

Product Supply/Demand reports global supply and demand quantities based on the selected profile. The data is sourced at the module level. When the demand transactions are posted at the module level, the records are available at the global level for reporting. The supply and demand calculation process will calculate the variables used to determine the net position and provide data for reporting.

Calculate Supply/Demand
View Supply/Demand
Generate Supply/Demand Reports

Calculate Supply/Demand

The Calculate option determines the supply and demand data based on the parameters established in the selected profile. This step must be completed before the reports can be generated to view the supply and demand data.

In the Product Supply/Demand index, select the required profile and right-click to select Calculate or select the icon.
The Select MRP Profile will be displayed with the parameters defined. The user can modify the data as required to generate the data.
Click OK to generate the data.

Depending on the amount of data, the profile may take several minutes to calculate.
When the process is complete, the task status will appear as 'Ready' and the Creation Date field in the index will be populated.

View Product/Supply Details

When the calculation process is complete, click on the required profile.
Right-click and select Edit.

Cost Center No displays the cost center for the supply and demand.
Cost Center Name is derived from the Cost No.
Product No indicates the product for the supply and demand analysis.
Product Name is derived from the Product No.
Ingredient Type is displayed if the product is an ingredient. Options will be Macro, Micro, Pre-Mix or Processed Ingredient.
Date Range name indicates either the Gregorian or Fiscal period for the supply and demand data.
Begin Date is the first date of the Date Range.
End Date is the last date of the Date Range.
Opening Period is checked if the Date Range is used to determine the beginning balances

Details related to all of the calculations in the Product Supply and Demand are outlined below:

Column Name	Calculation	Comments
Projected Supply
Beginning Inventory		Beginning Inventory for the period. This is either the balance from the previous period or calculated using the specified expression on the profile.
Purchase Order Inv		Purchase Orders available at the beginning of the period
Purchase Orders		Purchase Orders becoming available during the period. This is established by the Begin Receive Date defined on the purchase order.
Projected Demand
Product Order Demand		Demand coming from product sales orders.
Order Demand		Projected demand coming from feed sales order.
Sales Contract Demand		Projected demand coming from sales contracts.
Average Production Demand		Projected demand coming from average production based on historical usage.
Projected Demand		Projected demand coming from FDSA projections.
Manual Demand		Projected demand from manual data entry.
Calculated Projected Values
Opening Product Inventory	Beginning Product Inv	Only for first period
Forward Balance	Beginning Product Inv	For any period other than the first period.
Purchase Order Total	Purchase Order Inv + Purchase Order Recv + Planned Receiving
Total Supply	Beginning Product Inv + Purchase Order Total
Total Product Demand	Product Order Demand	Added if in the event that any other demand fields were added, the additional fields could be included in this total.
Total Planned Demand	Sales Order Demand + Sales Contract Demand + Average Production Demand + Projected Demand + Manual Demand
Actual Transactions
Product Beginning Inventory Transactions		Actual inventory from beginning inventory transactions during the period.
Product Purchases		Actual inventory from purchase transactions during the period.
Product Produced		Actual inventory from premix transactions during the period. (feed mill only)
Product Adjustments		Actual inventory from adjustment transactions during the period.
Product Transfer-In		Actual inventory from transfer-in transactions during the period.
Product Transfer-Out		Actual inventory from transfer-out transactions during the period.
Product Physical Adjustment		Actual inventory from physical inventory transactions during the period.
Product Production Usage		Actual inventory from production usage (feed production) transactions during the period.
Product Sales		Actual inventory from sales transactions during the period.
Product Disposal		Actual inventory from disposal transactions during the period.
Product Consignment Usage		Actual inventory from consignment transfer transactions during the period.
Calculated Actual Transaction Values
Product Receiving	Product BegInv Trans + Product Produced + Product Purchase
Product Total Receiving	Product Recv + Product Adjustments + Product Transfer In - Product Transfer Out
Product Total Usage	Product Usage + Product Sales + Product Disposal + Product Consignment Usage
Unutilized Demand
Unutilized Demand	Total Product Demand - Product Total Usage
Summary Values Based ONLY on Projections
Projected Monthly Product Balance	Opening Product Inv + Purchase Order Total - Total Product Demand
Projected Balance	Total Supply - Total Demand
Projected Monthly Position	Opening Product Inv + Purchase Order Total - Total Demand
Projected Monthly Cover	(Opening Product Inv + Purchase Order Total) / Total Demand
Projected Cumulative Position	Foward Balance + Projected Monthly Position
Projected Cumulative Cover	(Foward Balance + Opening Product Inv + Purchase Order Total) / Total Demand
Summary Values Including Projections and Actual
Monthly Product Balance	Projected Monthly Product Balance - Product Purchase - Product Sales
Balance	Projected Balance - (Product Total Recv - Product Total Usage + Product Phys Adjustments)
Monthly Position	Projected Monthly Position - Product Phys Adjustments
Monthly Cover	(Opening Product Inv + Purchase Order Total + Product Phys Adjustments) / Total Demand
Cumulative Position	Foward Balance + Monthly Position
Cumulative Cover	(Foward Balance + Opening Product Inv + Purchase Order Total + Product Phys Adjustments) / Total Demand

Generating MRP Reports

Currently, there are system reports defined for feed mill net position reporting.

FMIM Ingredients Net Position>Ingredient Net Position - report is generated from a profile displays the Net Position for each month and product based on the criteria. The graph displays a comparison of total supply to total demand for all products. The user is prompted for a Profile with an option to select Ingredient Type.
Ingredients Supply Demand>Ingredient Supply Demand - report is generated for a single month and displays the supply and demand for one or more ingredient. The graph displays a comparison of total supply to total demand for all products in the report. The user is prompted for Date Range Name, Product Type (required) and Product No.
Ingredients Supply Demand>Ingredient Supply Demand Monthly Ingredient - report displays the supply and demand for one or more ingredient for a defined period of months. The graph displays a comparison of monthly ingredient balance. The user is prompted for Date Range Name, Product Type (required) and Product No.

Ingredients Supply Demand>Ingredient Supply Demand Product Supply - report displays the supply and demand for one ingredient for a single period. The graph displays a comparison of total supply to total demand for the product. The user is prompted for Date Range Name, Product Type (required) and Product No.