Material Shortage Report (MSR)

The Inventory Shortage Report (or Allocation Shortage Report) is the primary source for material requirements planning for one or more builds in the allocation stage. It is composed of a part-by-part detail of quantity requirements to satisfy the builds in progress and is most often used to inform quoting and purchasing activities.

The Allocation Shortage List (ASR) is being replaced by the Material Shortage Report (MSR). It’s considerably faster and more flexible. Once all functionality is available in the MSR, the ASR will be permanently removed.

When you maintain component inventory levels within Aligni, you have the capability to compute a “material shortage report” (MSR) based on your production schedule (build allocations). The MSR is a list of individual material requirements to satisfy the demands of your production schedule.

Access to the MSR is provided from your Inventory Dashboard.

Build Allocations

Allocated builds generate demand for components. The MSR uses your production schedule (build allocations) as inputs to generate the report. The expected reservation date for each build is used to determine the production sequence.

Note that only allocated items on builds generate demand. Planned (or scheduled) builds do not contribute to component demand and reserved items are already factored in to the inventory counts available to satisfy this demand.

Navigating the Report

Consider a hypothetical production schedule consisting of the following builds:

BUILD #PART NUMBERQUANTITYRESERVATION
1ASSY-FPGABOARD1002019-01-01
2ASSY-POWERBOARD1002019-02-01
3ASSY-FPGABOARD1002019-03-01

Along the left column are all of the components required to complete the builds presently in allocation. The next column (Total Required) shows the number of each item required. You can click on the information icon here to get a brief material summary of this item.

The remaining columns can be read, from left to right, as a sort of simulation of time and how your inventory, builds, and purchases will play out:

  • Starting at the left is the Total on Hand column which indicates your present inventory available for builds.
  • Each build is then ordered chronologically left to right.
  • Builds consume inventory and indicate shortages by coloring the cell appropriately (see the legend below).
  • Purchases supply inventory and are indicated by the small encircled arrows.
  • Builds also supply inventory of the assembly being built.
  • Safety stock indicators (if selected) are shown as horizontal lines at the bottom and top of each cell to indicate if you are below or above your target inventory level in that period.
  • At the far right is the Still Short column indicating any unresolved material requirements at “infinity”.

Reading the Report

  1. The Overstock Indicator is shown in a period where the forecast inventory quantity is above the established inventory maximum for the item.
  2. The quantity of an item allocated to the build is shown as the Quantity Required.
  3. The Safety Stock Indicator is shown in a period where the forecast inventory quantity is below the established inventory minimum for the item.
  4. When a build only has partial material requirements, the buildable quantity is indicated by Nmax.
  5. The blue encircled arrow at the left of a cell indicates that there is arriving inventory on a purchase due before the build date.
  6. The red encircled arrow at the right of a cell indicates that there is inventory on order on a purchase due sometime after the build date.
  7. Notes are not presently supported.
  8. Incoming inventory that is due to arrive before the build reservation date is indicated in blue on the left side of the cell.
  9. An orange indicator appears on the right side of a cell if there is a shortage and inventory due within the next week.
  10. A red indicator appears on the right side of a cell if there is a shortage and inventory due more than one week in the future.

Production Management

Making the most of the MSR and the information it provides requires clean and dependable inputs. Regular review of builds and purchases is important to keep the MSR data fresh and usable.

Purchases and Promise Dates

Material requirements planning works best when there is a well-established timeline for the execution of events. This timeline relies on your build expected reserve dates to determine when a build will be initiated as well as the promise dates for items arriving on purchase orders from suppliers.

When a promise date is unavailable for an item, Aligni places the arrival of that inventory just before the Still Short column. This can help you find those purchases and update the promise dates manually or ask your suppliers to do so.

Builds and Completion Dates

Material requirements planning works best when there is a well-established timeline for the execution of events. This timeline relies on your build expected completion dates to determine when a build will be finalized to supply inventory of assemblies that may be consumed by other builds.

When a completion date is unavailable for an item, Aligni places the availability of that inventory just before the Still Short column. This can help you find those builds and set the completion dates appropriately.

Filtering and Options

With complex production schedules, the MSR can be noisy and difficult to read. Applying filters and other settings can help focus attention on key components, builds, or timelines.

Saved Reports

Save, update, and remove common or favorite report settings to quickly restore settings later for report generation. Note that new builds are not automatically added to existing reports, so these may need refreshing occasionally.

Settings

The basic settings pages offers the following options:

  • Location – The MSR is computed based on the builds specified at this location. Only inventory available at this location is available to these builds.
  • Time Period – You may optionally specify a start and end date for reporting. Only builds with expected reservation dates within this range are displayed but demand from all builds is still considered.
  • See All Items – By default, items without shortages over the MSR period are removed from the report to reduce noise. Check this to include these items in the report.
  • Ignore Parts on Order – Items on order resolve shortages if they are scheduled to arrive before their demand date. Check this to ignore inventory inbound on purchase orders.
  • Ignore Incoming Inventory Transfers – Items in transit resolve shortages if they are scheduled to arrive before their demand date. Check this to ignore inventory inbound on transfers.
  • Hide Safety Stock Indicators – Safety stock indicators are shown when an item’s forecast inventory is out of the target range specified for the item at this location.

Builds

Builds appear along the columns of the MSR. If you have a lot of builds or a long production timeline, this can generate a lot of data. By selecting a subset of builds, you can greatly reduce the number of columns to review and focus on specific assembly outputs, customers, or orders.

Manufacturer

Items appear as rows of the MSR. Select a subset of manufacturers to reduce the number of items displayed and focus on specific manufacturer concerns or vendor relationships.

Part Type

Similar to the manufacturer filter, you can focus on a subset of part types to reduce the number of items displayed.