Material Requirements Report

This report can be used for the following purposes:

  1. To determine which materials need to be ordered to satisfy current material requirements.
  2. To determine which Materials are expected late and may cause jobs to be late or interfere with the current schedule.
  3. To communicate to a material planner when materials should be expedited or de-expedited to synchronize with the schedule

Note that the Need By date is calculated as the earlier of the Operation's JIT Start date and its Scheduled Start date.  This is so that when operations are scheduled sooner than their JIT date (due to capacity or setup reasons) the material plan will strive to meet the schedule (i.e. get the materials earlier than the JIT date).  Operations that are scheduled late will still have early enough material Need By dates to allow for the operation to be scheduled sooner should capacity allow.

No Supply - (Critical) Tab

This lists all of the Material Requirements that may need to have an order placed immediately.  They are requirements that are to be satisfied from stock (not Buy Direct) and are not covered by On Hand inventory or any scheduled Job or Purchase To Stock.  They also have Need By dates that are within the Lead Time and therefore may not be able to be ordered and received in time.

No Supply - (OK) Tab

This lists all of the Material Requirements that may need to have an order placed in the future.  They are requirements that are to be satisfied from stock (not Buy Direct) and are not covered by On Hand inventory or any scheduled Job or Purchase To Stock.  They also have Need By dates that are outside of the Lead Time and therefore should still be able to be ordered and received on time.  Note that the Order By column suggests the latest time that the material can be ordered and still be expected in by the Need By date (according to the Lead Time).

Late Materials Tab

This lists all of the Material Requirements that will not be available until after either the Need By date and therefore may be the cause of Jobs being late.

Early Materials Tab

This lists all of the Material Requirements that will available more than one day before the consuming Operation's Need By date.  This can be used to de-expedite materials to reduce inventory carrying costs.