(Supply Chain) Demand vs. Replenishment Graphical Report (MRP and Supply Chain Planning Help)


	Previous	Next		Contents	Index	Navigation	Glossary	Library

(Supply Chain) Demand vs. Replenishment Graphical Report

The (Supply Chain) Demand vs. Replenishment Graphical Report is a graphical, summary report of material availability for a DRP, MRP, or MRP plan. This report is printed in line chart format. Cumulative replenishments plus the quantity on hand and cumulative demand in buckets of one week are included. You can use this report to gauge trends in projected on-hand quantities over long periods of time, such as analyzing repetitively planned items or discrete items that are components of repetitively planned items.

Note: If your plan was run with the Memory-based Planning Engine, by-products (negative usage) are included in the calculation of demand, current projected on hand, and current projected available.

Report Submission

In the Submit Requests window, enter Demand vs. Replenishment Graphical Report in the Name field. Supply Chain Planning users should enter Supply Chain Demand vs. Replenishment Graphical Report in the Name field.

Report Parameters

Plan Name

Select a plan name.

Organization Selection SUPPLY CHAIN PLANNING

Select the planned organization (all or current) if this is a supply chain report. You can select All Organizations for a multi-org plan if you are working in the organization that owns the plan; otherwise, you can select only the current organization and report material availability pertaining to the current organization.

First Sort

Select one of the following options. The report sorts items first in this order, then in the order you specify for Second Sort and Third Sort.

ABC class Sort items first by ABC class.

Buyer Sort first by buyer.

Category Sort first by material category.

Inventory item Sort first by inventory item.

Organization Sort first by organization.

No sort Do not employ a first sort for the report.

Planner Sort first by planner.

Second Sort

Select the second sort type for the item. Oracle Master Scheduling/MRP and Supply Chain Planning sorts the items by the first sort type and then by this sort type within the first type.

If you choose No sort, the report is sorted by using just the First Sort type.

Third Sort

Select the third sort type for the item. Oracle Master Scheduling/MRP and Supply Chain Planning sorts the items by the first sort type, then by the second sort type within the first type, and finally by this sort type within the second type.

For example, if you choose Planner as the first sort type, Category as the second sort type, and Inventory item as the third sort type, the report is sorted by planner, then by material category within planner, and finally by Inventory item within material category.

If you choose No sort, the report is sorted by using just the first and second sort types.

Exception Type

Choose one of the following exception types:

Item has a shortage Report all items whose quantity on hand is less than the sum of the requirements plus safety stock within the exception time fence.

Item has excess inventory Report all items whose quantity on hand exceeds the total requirements against the item within the exception time fence.

Item has no activity Report all items that have no demand or supply in the current plan.

Item has orders to be cancelled Report all items that the planning process recommends be cancelled.

Item has orders to be rescheduled in Report all items that the planning process recommends be rescheduled in.

Item has orders to be rescheduled out Report all items that the planning process recommends be rescheduled out.

Item has orders with compression days Report all items that have planned orders, discrete jobs and purchase orders that have compression days.

Item has a repetitive variance Report all repetitive items that have a variance in the amount that you actually manufacture and the amount that the planning process suggests you manufacture up to the exception date.

Item has past due orders Report all items that have past due orders.

Item is overcommitted Report all items for which ATP is negative or below safety stock within the exception time fence.

Planner

Select a planner to sort the items by.

Buyer

Select a buyer to sort the items by.

Items From/To

To restrict the report to a range of items, enter the beginning and ending item numbers.

Category Set

Enter a category set. Oracle Master Scheduling/MRP and Supply Chain Planning reports items associated with this category set.

Categories From/To

To restrict the report to a range of categories, enter the beginning and ending category names.

ABC Assignment Group

Select an ABC assignment group. Oracle Master Scheduling/MRP and Supply Chain Planning reports items associated with this ABC assignment group.

ABC Class

Select an ABC class associated with the ABC assignment group.

ABC class	Sort items first by ABC class.
Buyer	Sort first by buyer.
Category	Sort first by material category.
Inventory item	Sort first by inventory item.
Organization	Sort first by organization.
No sort	Do not employ a first sort for the report.
Planner	Sort first by planner.

Item has a shortage	Report all items whose quantity on hand is less than the sum of the requirements plus safety stock within the exception time fence.
Item has excess inventory	Report all items whose quantity on hand exceeds the total requirements against the item within the exception time fence.
Item has no activity	Report all items that have no demand or supply in the current plan.
Item has orders to be cancelled	Report all items that the planning process recommends be cancelled.
Item has orders to be rescheduled in	Report all items that the planning process recommends be rescheduled in.
Item has orders to be rescheduled out	Report all items that the planning process recommends be rescheduled out.
Item has orders with compression days	Report all items that have planned orders, discrete jobs and purchase orders that have compression days.
Item has a repetitive variance	Report all repetitive items that have a variance in the amount that you actually manufacture and the amount that the planning process suggests you manufacture up to the exception date.
Item has past due orders	Report all items that have past due orders.
Item is overcommitted	Report all items for which ATP is negative or below safety stock within the exception time fence.