Inventory Optimization and Management: Methods, Formulas and Setup in NetSuite

By Louis Balla, Chief Revenue Officer, Nuage. Updated October 2026.

Inventory optimization sets a stock target for each item from its demand and lead time, so you can fill orders without holding more than you need. The core tools are ABC classification, reorder points, safety stock and order quantities, which you review as demand and lead times change.

This guide works the formulas through with an example and shows how NetSuite’s Advanced Inventory Management uses them. Nuage is a NetSuite optimization partner, so the setup detail is about NetSuite. The methods apply to any system or spreadsheet.

What is inventory optimization, and how does it differ from inventory management?

Inventory management is the daily work of recording, storing and ordering stock. Inventory optimization decides how much of each item to hold and when to reorder, using the demand and lead time those records show. The two use the same data, so errors in on-hand quantities, costs or lead times carry straight into the optimization settings.

The terms you will meet:

• Lead time: days between placing an order and receiving it.
• Safety stock: extra stock held to cover demand or lead time running above average.
• Reorder point: the stock level that triggers a new order.
• Preferred stock level: NetSuite’s term for the quantity you want on hand after replenishment.
• Cycle service level: the probability of getting through a replenishment cycle without a stockout. A 95% cycle service level means about one cycle in twenty runs out.
• Fill rate: the share of demand filled from stock. It is a different measure from cycle service level, since a stockout that is short or small barely moves fill rate.
• Inventory turnover: cost of goods sold divided by average inventory value.
• Days of inventory on hand: the days it takes to sell the average inventory, or 365 divided by turnover.
• Dead stock: stock on hand with no sales in a set window, such as 12 months.

Which inventory optimization methods should you use?

Method	Question it answers	Rule or formula	Watch for
ABC analysis	Which items deserve the most attention?	Rank items by annual usage value (units sold times cost). Common cutoffs put the top 80% of value in A, the next 15% in B and the rest in C	Cutoffs are conventions; revisit them when the assortment changes
Reorder point	When do I reorder?	Average daily demand times lead time in days, plus safety stock	Use lead times taken from actual receipts
Safety stock, days of cover	How much buffer do I hold?	Average daily demand times the buffer in days	Ignores how variable demand is; A items usually justify more days than C items
Safety stock, variability method	How much buffer for a target service level?	z times the standard deviation of daily demand times the square root of lead time in days, where z comes from the cycle service level (about 1.65 for 95%)	Needs a demand history long enough to measure variability. When lead time also varies, use z times the square root of (lead time times demand variance, plus average demand squared times lead time variance)
Economic order quantity	How much should I order each time?	The square root of (2 times annual demand times cost per order, divided by holding cost per unit per year)	Assumes steady demand and ignores vendor minimums and price breaks
Preferred stock level	What do I order up to?	Average daily demand times the days of stock you want	Must be larger than lead time in days, or it collapses into the reorder point
Dead stock review	What should leave inventory?	Quantity on hand with no sales order or invoice in the last 12 months	Check for seasonal items and new items first

An example with illustrative numbers: an item sells 40 a day, the lead time is 10 days and you want a 3-day buffer. By days of cover, safety stock is 40 times 3, or 120, and the reorder point is 40 times 10 plus 120, or 520. By the variability method, if daily demand has a standard deviation of 8 units and you want a 95% cycle service level, safety stock is 1.65 times 8 times the square root of 10, which is about 42, and the reorder point is 400 plus 42, or 442. The variability method gives a smaller buffer here because demand is steady, and a larger one for an item whose demand swings. For order quantity, annual demand is 14,600 (40 a day for a year). If each order costs $50 to place and holding a unit for a year costs $2, the economic order quantity is the square root of (2 times 14,600 times 50, divided by 2), which is about 854 units.

How do you classify items with ABC analysis?

1. Export a year of sales by item and multiply units by unit cost.
2. Sort the items from highest to lowest annual usage value and add a running percentage.
3. Mark the items up to about 80% of total value as A, the next 15% as B and the rest as C. Adjust the cutoffs to your assortment.
4. Set the review rhythm and the service level for each class. A items get the most attention and the most careful settings. C items can run on simple rules.

How do you set reorder points and safety stock in NetSuite?

Oracle describes Advanced Inventory Management as a feature that automates demand-based replenishment. You use item records to track lead time, safety stock and seasonal demand, and NetSuite uses past purchases and sales to calculate reorder points and preferred stock levels. Oracle’s documented settings and formulas are:

• Reorder point: demand divided by time, multiplied by lead time.
• Lead time: a default number of days applies when none is set on the item, and the default is 14 days. If you check the autocalculate box, lead time comes from your last three purchases, and you can override it.
• Preferred stock level in days: daily demand multiplied by the number of days you enter. Oracle’s example is five a day and seven days, which gives 35.
• Safety stock in days: daily demand multiplied by the days you enter, kept on top of the preferred stock level. With five a day and three days, the buffer is 15. This is the days-of-cover approach from the table above.
• Seasonal demand: the Seasonal Analysis Interval preference defaults to 1 month and applies only to items where you use seasonal demand.
• Overrides: you can override or turn off the calculations, including for a single item.

Two edge cases matter. When demand is zero and the preferred stock level is auto-calculated, the preferred stock level is zero, because there is not enough history to work out demand per day. And when the preferred stock level in days is less than the vendor’s lead time, the preferred stock level equals the reorder point. Check both when you review new items and new products with short histories.

Start with your A items. Run the NetSuite calculation next to the buyer’s own spreadsheet for a few weeks, find the differences and decide which one is right before you turn the calculation on for the rest. Our NetSuite inventory control guide covers the surrounding setup, and our demand planning guide covers forecasts and supply plans.

What does an inventory optimization review look like?

• Purchasing: owns lead times, vendor minimums and the reorder parameters for the items it buys.
• Planner or operations lead: reviews the ABC classes, safety stock days and shortage reports on a set schedule.
• Warehouse lead: owns counts and bin accuracy, since the calculations read on-hand quantity.
• Controller: reviews inventory valuation, slow movers and dead stock.
• Sales: tells purchasing about promotions and large orders before they hit demand history.

An operations leader at a manufacturer described the report he wanted 12 to 16 weeks out: “I’d like to get a report that says, hey, if we’re looking at this, here’s all my shortfalls for each one of these over time.” His team would then use it to decide which purchase orders to pull forward or add. A shortage list by week gives a buyer something to act on. Our production planning software guide covers the planning side for manufacturers.

What goes wrong in practice?

The data the calculations read is often the problem. ABC classification multiplies units by unit cost, so an item with no recorded cost lands in class C whatever it sells, and a negative on-hand quantity makes stock look lower than it is, which can trigger a reorder nobody needs. Between July and September 2026 our team logged assessment findings for 15 client accounts. At an industrial technology company, 88% of 9,956 inventory and assembly items carried no recorded cost, which affects margin and cost-of-goods reporting. Our guide to inventory counts and audits covers what else those assessments found.

How Nuage approaches inventory optimization

In recent inventory assessments and projects, our team has taken or recommended these steps. The order changes with each account.

1. Check the data the calculations read. We look for negative on-hand quantities, items with no recorded cost and lot tracking that is switched off where shelf life matters.
2. Classify the items by annual usage value so the settings go to the A items first.
3. Set the method and parameters for the A items, and compare the result with the buyer’s own spreadsheet.
4. Build the view the buyer asks for, such as a shortage report by week.
5. Set a review schedule by class, monthly for A items and quarterly for the rest, with a named owner for each setting.

Nuage’s NetSuite experts also do this work as part of ongoing NetSuite optimization and managed services.

Inventory optimization FAQ

What is inventory optimization?

Inventory optimization is the practice of setting the quantity of each item to hold, and when to reorder it, from its demand and lead time. The aim is to fill orders from stock without tying up cash in items that sell slowly. The usual tools are ABC classification, reorder points, safety stock and order quantities.

What are the first steps to optimize inventory?

Pull a year of sales by item and rank the items by annual usage value. Check that on-hand quantities and costs are right for the A items, then set lead times, safety stock days and reorder points for them. Run the new settings next to the current ones for a few weeks, then widen to B and C items.

How is enterprise inventory optimization different?

The formulas are the same. Scale changes the work: more locations, suppliers and sales channels mean more lead times and more demand histories to keep accurate, and more people who own a setting. Most of the enterprise work is assigning an owner to each location’s lead times and reorder settings and reviewing them on one schedule across locations.

How often should you review inventory settings?

Review A items on a fixed schedule, such as monthly, and the rest quarterly. Review any item sooner when its lead time, vendor or demand changes materially, and after new products launch. Oracle notes that you can override or turn off the NetSuite calculation for a single item when demand is unusual.

What do inventory optimization services include?

At Nuage, the work starts with a check of the inventory data. We then classify the items, set and compare reorder parameters for the A items, build the views buyers ask for and name an owner for each setting. It runs inside your NetSuite account, so settings, reports and ownership stay with your team.

About the author

Louis Balla is Chief Revenue Officer at Nuage, a NetSuite optimization partner that has served 250+ clients since 2011 and holds a 4.9 out of 5 rating on Clutch. The client work in this article is our team’s.