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.
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 NUMBER||QUANTITY||RESERVATION|
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
- The Overstock Indicator is shown in a period where the forecast inventory quantity is above the established inventory maximum for the item.
- The quantity of an item allocated to the build is shown as the Quantity Required.
- The Safety Stock Indicator is shown in a period where the forecast inventory quantity is below the established inventory minimum for the item.
- When a build only has partial material requirements, the buildable quantity is indicated by Nmax.
- The blue encircled arrow at the left of a cell indicates that there is arriving inventory on a purchase due before the build date.
- 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.
- Notes are not presently supported.
- Incoming inventory that is due to arrive before the build reservation date is indicated in blue on the left side of the cell.
- An orange indicator appears on the right side of a cell if there is a shortage and inventory due within the next week.
- 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.
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.
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.
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 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.
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.
Similar to the manufacturer filter, you can focus on a subset of part types to reduce the number of items displayed.
Clear-to-Build (Build-Specific MSR)
The Material Shortage Report tab on a build is designed to show the shortages for only the specific build under review.
Note that the results of the build-specific MSR are not exactly the same as showing the MSR and filtering only for the single build. When multiple builds occur on the same day, the MSR uses a default ordering of the builds and this cannot be specified. The build-specific MSR, however, always places the build under review at the end of the day. This is done under the assumption that all builds will need to be run.
A reduced subset of settings are available for the build-specific MSR. For the complete set of options, you will need to run the full MSR.
MSR TimeWarp allows you to create a Build-Specific Material Shortage Report with the build scheduled a different time in the production schedule. The rest of the production schedule remains intact, but the build’s expected reservation date is moved to some other date. The report then answers the question “if I move this build to another date, what would my shortages be?”.
Note that MSR TimeWarp does not provide any information about the impact of this rescheduling on other builds on your production schedule. For example, moving to build to occur before another build may create shortages on that other build. Determining the full impact is only possible by changing the expected reservation date and running the full MSR.