Skip to main content

Inventory Management - AI Calculate Minimum Quantity

A
Written by Angela Mazon
Updated yesterday

Overview

Inventory - AI Calculate Minimum Quantity automatically keeps your minimum stock levels up to date so you don't have to. Enable it once and Redlist recalculates the minimum quantity for each part every night based on the last 90 days of usage — adjusting as consumption patterns change so your stockrooms stay stocked without the manual upkeep.

Accessing AI Calculate Minimum Quantity

From the navigation, click Settings, then click Inventory Management. Select the Forecasting tab.

The AI Automation section is at the top of the Forecasting page and contains the AI Calculate Minimum Quantity checkbox.

How to Enable or Disable AI Calculate Minimum Quantity

  1. Navigate to the Forecasting tab (Settings > Inventory Management > Forecasting)

  2. Check or uncheck the AI Calculate Minimum Quantity checkbox under the AI Automation section

  3. The setting saves automatically — no additional confirmation is required

Note: Changes take effect starting with the next nightly calculation. Minimum quantities on existing stockroom parts will not update immediately after toggling the setting.

How This Affects Stockroom Parts

When AI Calculate Minimum Quantity is enabled, the Minimum Qty and Consumption Rate Per Day fields on individual stockroom parts become read-only. These values are maintained automatically by the system and cannot be manually overridden while the setting is on.

When AI Calculate Minimum Quantity is disabled, both fields become editable again and you can set minimum quantities manually on each stockroom part.

Understanding How Minimum Quantities Are Calculated

The system uses the past 90 days of part consumption to establish a baseline usage rate per day for each stockroom part. Each night, it applies that rate to calculate the minimum quantity needed to cover expected demand.

If you have configured Demand Multipliers for any stockrooms, those multipliers are factored in during the event window. For example, if a stockroom has a 50% demand multiplier active for a peak period, the system will calculate a minimum quantity that is 50% higher than the baseline for that stockroom's parts during that period.

Note: See the Demand Multipliers User Guide for instructions on setting up peak-period adjustments.

Best Practices

Enable the Setting Before a Need Arises: Turn on AI Calculate Minimum Quantity early so the system has time to establish accurate baselines before a busy period begins. The first nightly calculation after enabling will set initial values from existing 90-day history.

Use Demand Multipliers for Predictable Peaks: If you know demand will spike during a specific period, configure a Demand Multiplier event before it starts so the system can prepare minimum quantities in advance.

Monitor After Enabling: Check minimum quantities on key stockroom parts the day after enabling to confirm the system is calculating values that align with your team's expectations.

Avoid Toggling Frequently: Switching the setting on and off frequently can cause inconsistency in minimum quantity values. Enable it when you are ready to rely on automated calculations long-term.

Troubleshooting

Issue: The Minimum Qty field is greyed out on a stockroom part and cannot be edited

Solution: This is expected when AI Calculate Minimum Quantity is enabled — the field is controlled by the system.

  1. This is expected behavior when AI Calculate Minimum Quantity is enabled — the field is controlled by the system

  2. If you need to override the value manually, go to Settings > Inventory Management > Forecasting and uncheck AI Calculate Minimum Quantity

  3. Be aware that disabling the setting means all minimum quantities will need to be maintained manually going forward

Issue: Minimum quantities have not updated after enabling the setting

Solution: The system updates minimum quantities overnight — check again the following morning.

  1. The system updates minimum quantities overnight — check again the following morning

  2. Confirm the setting is still enabled by returning to Settings > Inventory Management > Forecasting

  3. If quantities have still not updated after 24 hours, contact Redlist support

Issue: Calculated minimum quantities seem too low or too high

Solution: Review the past 90 days of consumption for that part — unusual activity in that window may be skewing the result.

  1. Review the past 90 days of consumption for that part — if usage during that period was unusually low or high, the calculated minimum may not reflect typical demand

  2. If a peak period is approaching, add a Demand Multiplier event to increase expected consumption for the relevant stockrooms

  3. If the calculated values are consistently inaccurate, consider disabling the setting and managing minimum quantities manually until consumption patterns stabilize

Summary

AI Calculate Minimum Quantity removes the manual work of keeping reorder points up to date by automatically computing minimum stock quantities each night from 90 days of usage data. When paired with Demand Multipliers, the system can also account for seasonal or event-driven spikes, giving your team accurate stock targets without ongoing manual effort.

Did this answer your question?