Material Availability Report

This report calculates a rough estimate of how much time is required to manufacture an item, based on current material availability. The report is based solely on a given item and quantity, or on an existing job or estimate job.

Use this report only for rough estimating purposes. To provide relatively quick processing times, the system makes these assumptions:

  • All jobs of higher priority are currently released, thus their requirements are either allocated or issued.
  • Shrinkage rates are not considered.
  • Alternate items in the current routing/BOM are not considered.
  • If released jobs and POs are to be included in estimating the availability of materials, those jobs and POs with end/due dates that are less than or equal to the earliest requirement date are included. If both the top and bottom levels of an indented BOM need an item, the availability of the item is based on the earliest potential job that requires the item.
Note:  When you run the Material Availability Report for a job, the component quantity issued, but not yet used, counts toward the quantity of the material available.

This report uses the MDAY calendar. See the topic Defining the Work Week for a description of how the MDAY calendar is used

If a shortage of an item exists, this report shows only components of the item. If enough quantity of an item exists, only one line displays.

The availability status displays as the quantity required, quantity available, and date required. If availability for the date required is different than availability for the current date, the system considers the date required to be incorrect. The required date is replaced with the following message:

    ASAP Date: Not Available...Rerun Report with Required Date = Today

The current quantity on hand minus any allocations determines the quantity availability (with an option to include released jobs and/or POs). If a shortage exists, the amount of the shortage and an order date display.

The order date is based on the date required less the lead time, dock-to-stock time, and paperwork lead-time. In addition, the system accumulates the longest series of dependent lead times and prints the result as the critical path lead time in manufacturing days.

Note:  This report will not show reserved quantities as available, regardless of the options you select.