★ MONEY · INVENTORY · SALES

Inventory to Sales Ratio Calculator: Is Stock Too High?

On the defaults — $200,000 of average inventory against $1,000,000 of net sales — the inventory to sales ratio is 0.20 (20.00%), so the business holds 20 cents of inventory for every dollar of net sales. Put in your own average inventory, net sales and target ratio, and the calculator works out the inventory to sales ratio and the average inventory or net sales any target needs. No inventory-to-sales page of any kind exists on the site — the inventory-turnover page measures how many times the stock sells through in a year, the days-inventory-outstanding page measures how many days the stock sits before it sells, the current-ratio page measures all current assets against current liabilities, the quick-ratio page measures the assets that turn to cash fast against current liabilities, the debt-to-equity page measures debt against owners’ money, and the cash-flow-to-debt page (run 452) measures operating cash flow against total debt. This one is INVENTORY TO SALES ONLY — average inventory divided by net sales — how much stock the business holds for every dollar it sells.

1232

Inventory to sales ratio calculator

Inventory to sales ratio = average inventory ÷ net sales. Average inventory needed at the target = target ratio × net sales. Net sales allowed at the target = average inventory ÷ target ratio. The inventory to sales ratio is average inventory divided by net sales — it measures how much stock the business holds for every dollar it sells. Average inventory is the stock on hand averaged across the year — (opening stock + closing stock) ÷ 2 — not the stock on the last day of the year, because a single day’s stock can be flattered by a delivery or emptied by a sale. Net sales are the sales after returns, discounts and allowances — the money the business actually kept, not the gross till total. A ratio of 0.20 means 20 cents of inventory for every dollar of net sales — at that pace the business sells five dollars for every dollar of stock on its shelves, if sales stay steady, which they rarely do, so the ratio is read alongside turnover and days of inventory, not alone. A lower ratio is usually better: below 0.10 (10%) the shelves are lean, above 0.30 the shelves are heavy, and above 1.00 the business holds more stock than a whole year of sales. Retailers and wholesalers use it to judge whether cash is trapped on shelves — a high ratio means money sits in boxes instead of the bank, gathering dust and going out of date. The ratio differs from inventory turnover: turnover divides cost of goods sold by average inventory, so it counts how many times the stock sells through, while inventory to sales divides the stock by the sales, so it says how much stock backs each dollar sold — the two are related but they answer different questions. The ratio differs from days inventory outstanding: days outstanding turns the same stock into a count of days, while this ratio keeps it as cents per dollar. A negative ratio means net sales went negative — returns outran sales — and the ratio says nothing about stock levels at all, whatever the inventory figure. The ratio is read year over year and within one industry: a car dealer holds far more stock per dollar of sales than a software firm, so the same 0.20 is a different story in each. A ratio that climbs year after year while sales stay flat is the classic early warning — the business is buying stock faster than it sells it.

The average inventory — (opening stock + closing stock) ÷ 2 — the default is $200,000.

The net sales — sales after returns, discounts and allowances — the default is $1,000,000.

The inventory to sales ratio you want to reach — the default is 0.25.

Average inventory $200,000.00; net sales $1,000,000.00; inventory to sales ratio 0.20 (20.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $800,000.00Average inventory $200,000.00; net sales $1,000,000.00; inventory to sales ratio 0.20 (20.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $800,000.00Average inventory $200,000.00; net sales $1,000,000.00; inventory to sales ratio 0.20 (20.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $800,000.00. On $200,000.00 of average inventory and $1,000,000.00 of net sales the inventory to sales ratio is 0.20 (20.00%) — the business holds 20 cents of inventory for every dollar of net sales.

Average inventory: $200,000.00

Net sales: $1,000,000.00

Target ratio: 0.25

Inventory to sales ratio: 0.20 (20.00%)

Average inventory needed for the 0.25 target: $250,000.00

Net sales allowed for the 0.25 target: $800,000.00

Verdict: the business holds 20 cents of inventory for every dollar of net sales

Branch: Average inventory $250,000: Average inventory $250,000.00; net sales $1,000,000.00; inventory to sales ratio 0.25 (25.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $1,000,000.00

Branch: Net sales $800,000: Average inventory $200,000.00; net sales $800,000.00; inventory to sales ratio 0.25 (25.00%); average inventory needed for the 0.25 target $200,000.00; net sales allowed for the 0.25 target $800,000.00

Branch: Net sales $1,250,000: Average inventory $200,000.00; net sales $1,250,000.00; inventory to sales ratio 0.16 (16.00%); average inventory needed for the 0.25 target $312,500.00; net sales allowed for the 0.25 target $800,000.00

Branch: Average inventory $150,000: Average inventory $150,000.00; net sales $1,000,000.00; inventory to sales ratio 0.15 (15.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $600,000.00

Branch: Average inventory $1,000,000: Average inventory $1,000,000.00; net sales $1,000,000.00; inventory to sales ratio 1.00 (100.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $4,000,000.00

Branch: Net sales $2,000,000: Average inventory $200,000.00; net sales $2,000,000.00; inventory to sales ratio 0.10 (10.00%); average inventory needed for the 0.25 target $500,000.00; net sales allowed for the 0.25 target $800,000.00

Branch: Ratio bars — average inventory $300,000, net sales $500,000, average inventory $100,000: average inventory $300,000: inventory to sales ratio 0.30 (30.00%); net sales $500,000: inventory to sales ratio 0.40 (40.00%); average inventory $100,000: inventory to sales ratio 0.20 (20.00%)

Reverse: Smallest whole-dollar average inventory for the ratio to reach 0.25: $250,000

Reverse: Smallest whole-dollar average inventory for the ratio to reach 0.25 (rounded): $250,000

At $250,000 the figures are: Average inventory $250,000.00; net sales $1,000,000.00; inventory to sales ratio 0.25 (25.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $1,000,000.00

At the lower neighbor the figures are: Average inventory $249,999.00; net sales $1,000,000.00; inventory to sales ratio 0.249999 (24.9999%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $999,996.00

At the upper neighbor the figures are: Average inventory $250,001.00; net sales $1,000,000.00; inventory to sales ratio 0.250001 (25.0001%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $1,000,004.00

Reverse verdict: STEP

Reverse: Largest whole-dollar net sales for the ratio to STAY at or above 0.25: $800,000

Reverse: Largest whole-dollar net sales for the ratio to STAY at or above 0.25 (rounded): $800,000

At $800,000 the figures are: Average inventory $200,000.00; net sales $800,000.00; inventory to sales ratio 0.25 (25.00%); average inventory needed for the 0.25 target $200,000.00; net sales allowed for the 0.25 target $800,000.00

At the lower neighbor the figures are: Average inventory $200,000.00; net sales $799,999.00; inventory to sales ratio 0.250000313 (25.0000313%); average inventory needed for the 0.25 target $199,999.75; net sales allowed for the 0.25 target $800,000.00

At the upper neighbor the figures are: Average inventory $200,000.00; net sales $800,001.00; inventory to sales ratio 0.249999688 (24.9999688%); average inventory needed for the 0.25 target $200,000.25; net sales allowed for the 0.25 target $800,000.00

Reverse verdict: STEP

Reverse: Smallest whole-dollar average inventory for the ratio to reach 0.30: $300,000

Reverse: Smallest whole-dollar average inventory for the ratio to reach 0.30 (rounded): $300,000

At $300,000 the figures are: Average inventory $300,000.00; net sales $1,000,000.00; inventory to sales ratio 0.30 (30.00%); average inventory needed for the 0.30 target $300,000.00; net sales allowed for the 0.30 target $1,000,000.00

At the lower neighbor the figures are: Average inventory $299,999.00; net sales $1,000,000.00; inventory to sales ratio 0.299999 (29.9999%); average inventory needed for the 0.30 target $300,000.00; net sales allowed for the 0.30 target $999,996.67

At the upper neighbor the figures are: Average inventory $300,001.00; net sales $1,000,000.00; inventory to sales ratio 0.300001 (30.0001%); average inventory needed for the 0.30 target $300,000.00; net sales allowed for the 0.30 target $1,000,003.33

Reverse verdict: STEP

Reverse: Largest whole-dollar net sales for the ratio to STAY at or above 0.20: $1,000,000

Reverse: Largest whole-dollar net sales for the ratio to STAY at or above 0.20 (rounded): $1,000,000

At $1,000,000 the figures are: Average inventory $200,000.00; net sales $1,000,000.00; inventory to sales ratio 0.20 (20.00%); average inventory needed for the 0.20 target $200,000.00; net sales allowed for the 0.20 target $1,000,000.00

At the lower neighbor the figures are: Average inventory $200,000.00; net sales $999,999.00; inventory to sales ratio 0.2000002 (20.00002%); average inventory needed for the 0.20 target $199,999.80; net sales allowed for the 0.20 target $1,000,000.00

At the upper neighbor the figures are: Average inventory $200,000.00; net sales $1,000,001.00; inventory to sales ratio 0.1999998 (19.99998%); average inventory needed for the 0.20 target $200,000.20; net sales allowed for the 0.20 target $1,000,000.00

Reverse verdict: STEP

Reverse: Smallest whole-dollar average inventory for the ratio to reach 0.15: $150,000

Reverse: Smallest whole-dollar average inventory for the ratio to reach 0.15 (rounded): $150,000

At $150,000 the figures are: Average inventory $150,000.00; net sales $1,000,000.00; inventory to sales ratio 0.15 (15.00%); average inventory needed for the 0.15 target $150,000.00; net sales allowed for the 0.15 target $1,000,000.00

At the lower neighbor the figures are: Average inventory $149,999.00; net sales $1,000,000.00; inventory to sales ratio 0.149999 (14.9999%); average inventory needed for the 0.15 target $150,000.00; net sales allowed for the 0.15 target $999,993.33

At the upper neighbor the figures are: Average inventory $150,001.00; net sales $1,000,000.00; inventory to sales ratio 0.150001 (15.0001%); average inventory needed for the 0.15 target $150,000.00; net sales allowed for the 0.15 target $1,000,006.67

Reverse verdict: STEP

Reverse: Largest whole-dollar net sales for the ratio to STAY at or above 0.10: $2,000,000

Reverse: Largest whole-dollar net sales for the ratio to STAY at or above 0.10 (rounded): $2,000,000

At $2,000,000 the figures are: Average inventory $200,000.00; net sales $2,000,000.00; inventory to sales ratio 0.10 (10.00%); average inventory needed for the 0.10 target $200,000.00; net sales allowed for the 0.10 target $2,000,000.00

At the lower neighbor the figures are: Average inventory $200,000.00; net sales $1,999,999.00; inventory to sales ratio 0.10000005 (10.000005%); average inventory needed for the 0.10 target $199,999.90; net sales allowed for the 0.10 target $2,000,000.00

At the upper neighbor the figures are: Average inventory $200,000.00; net sales $2,000,001.00; inventory to sales ratio 0.09999995 (9.999995%); average inventory needed for the 0.10 target $200,000.10; net sales allowed for the 0.10 target $2,000,000.00

Reverse verdict: STEP

Edge: Average inventory $0: Average inventory $0.00; net sales $1,000,000.00; inventory to sales ratio 0.00 (0.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $0.00

Edge: Net sales $0: Average inventory $200,000.00; net sales $0.00; inventory to sales ratio undefined — the business holds no stock against no sales, so there is nothing to compare against

Edge: Average inventory $250,001: Average inventory $250,001.00; net sales $1,000,000.00; inventory to sales ratio 0.250001 (25.0001%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $1,000,004.00

Edge: Net sales $800,001: Average inventory $200,000.00; net sales $800,001.00; inventory to sales ratio 0.249999688 (24.9999688%); average inventory needed for the 0.25 target $200,000.25; net sales allowed for the 0.25 target $800,000.00

Edge: Average inventory $200,000: Average inventory $200,000.00; net sales $1,000,000.00; inventory to sales ratio 0.20 (20.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $800,000.00

Edge: Average inventory $1,000,000: Average inventory $1,000,000.00; net sales $1,000,000.00; inventory to sales ratio 1.00 (100.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $4,000,000.00

Edge: Ratio bars: average inventory $300,000: inventory to sales ratio 0.30 (30.00%); net sales $500,000: inventory to sales ratio 0.40 (40.00%); average inventory $100,000: inventory to sales ratio 0.20 (20.00%)

Edge: Average inventory $12,500 against net sales −$50,000: Average inventory $12,500.00; net sales −$50,000.00; inventory to sales ratio −0.25 (−25.00%); average inventory needed for the 0.25 target −$12,500.00; net sales allowed for the 0.25 target $50,000.00

Average inventory $200,000.00; net sales $1,000,000.00; inventory to sales ratio 0.20 (20.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $800,000.00. On the defaults $200,000 of average inventory and $1,000,000 of net sales give an inventory to sales ratio of 0.20 (20.00%) — the business holds 20 cents of inventory for every dollar of net sales. If the average inventory rose to $250,000, the ratio would reach 0.25 — and at $249,999 it is 0.249999 (24.9999%), which displays as 25.00% but is below the 0.25 target.

Average inventory $250,000: Average inventory $250,000.00; net sales $1,000,000.00; inventory to sales ratio 0.25 (25.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $1,000,000.00.

Net sales $800,000: Average inventory $200,000.00; net sales $800,000.00; inventory to sales ratio 0.25 (25.00%); average inventory needed for the 0.25 target $200,000.00; net sales allowed for the 0.25 target $800,000.00.

Net sales $1,250,000: Average inventory $200,000.00; net sales $1,250,000.00; inventory to sales ratio 0.16 (16.00%); average inventory needed for the 0.25 target $312,500.00; net sales allowed for the 0.25 target $800,000.00.

Average inventory $150,000: Average inventory $150,000.00; net sales $1,000,000.00; inventory to sales ratio 0.15 (15.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $600,000.00.

Average inventory $1,000,000: Average inventory $1,000,000.00; net sales $1,000,000.00; inventory to sales ratio 1.00 (100.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $4,000,000.00.

Net sales $2,000,000: Average inventory $200,000.00; net sales $2,000,000.00; inventory to sales ratio 0.10 (10.00%); average inventory needed for the 0.25 target $500,000.00; net sales allowed for the 0.25 target $800,000.00.

Ratio bars — average inventory $300,000, net sales $500,000, average inventory $100,000: average inventory $300,000: inventory to sales ratio 0.30 (30.00%); net sales $500,000: inventory to sales ratio 0.40 (40.00%); average inventory $100,000: inventory to sales ratio 0.20 (20.00%).

Reverse: The smallest whole-dollar average inventory for the ratio to reach 0.25 is $250,000; at $250,000 the figures are Average inventory $250,000.00; net sales $1,000,000.00; inventory to sales ratio 0.25 (25.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $1,000,000.00; at the lower neighbor the figures are Average inventory $249,999.00; net sales $1,000,000.00; inventory to sales ratio 0.249999 (24.9999%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $999,996.00 — verdict: STEP. Reverse: The largest whole-dollar net sales for the ratio to STAY at or above 0.25 is $800,000; at $800,000 the figures are Average inventory $200,000.00; net sales $800,000.00; inventory to sales ratio 0.25 (25.00%); average inventory needed for the 0.25 target $200,000.00; net sales allowed for the 0.25 target $800,000.00; at the upper neighbor the figures are Average inventory $200,000.00; net sales $800,001.00; inventory to sales ratio 0.249999688 (24.9999688%); average inventory needed for the 0.25 target $200,000.25; net sales allowed for the 0.25 target $800,000.00 — verdict: STEP. Reverse: The smallest whole-dollar average inventory for the ratio to reach 0.30 is $300,000; at $300,000 the figures are Average inventory $300,000.00; net sales $1,000,000.00; inventory to sales ratio 0.30 (30.00%); average inventory needed for the 0.30 target $300,000.00; net sales allowed for the 0.30 target $1,000,000.00; at the lower neighbor the figures are Average inventory $299,999.00; net sales $1,000,000.00; inventory to sales ratio 0.299999 (29.9999%); average inventory needed for the 0.30 target $300,000.00; net sales allowed for the 0.30 target $999,996.67 — verdict: STEP. Reverse: The largest whole-dollar net sales for the ratio to STAY at or above 0.20 is $1,000,000; at $1,000,000 the figures are Average inventory $200,000.00; net sales $1,000,000.00; inventory to sales ratio 0.20 (20.00%); average inventory needed for the 0.20 target $200,000.00; net sales allowed for the 0.20 target $1,000,000.00; at the upper neighbor the figures are Average inventory $200,000.00; net sales $1,000,001.00; inventory to sales ratio 0.1999998 (19.99998%); average inventory needed for the 0.20 target $200,000.20; net sales allowed for the 0.20 target $1,000,000.00 — verdict: STEP. Reverse: The smallest whole-dollar average inventory for the ratio to reach 0.15 is $150,000; at $150,000 the figures are Average inventory $150,000.00; net sales $1,000,000.00; inventory to sales ratio 0.15 (15.00%); average inventory needed for the 0.15 target $150,000.00; net sales allowed for the 0.15 target $1,000,000.00; at the lower neighbor the figures are Average inventory $149,999.00; net sales $1,000,000.00; inventory to sales ratio 0.149999 (14.9999%); average inventory needed for the 0.15 target $150,000.00; net sales allowed for the 0.15 target $999,993.33 — verdict: STEP. Reverse: The largest whole-dollar net sales for the ratio to STAY at or above 0.10 is $2,000,000; at $2,000,000 the figures are Average inventory $200,000.00; net sales $2,000,000.00; inventory to sales ratio 0.10 (10.00%); average inventory needed for the 0.10 target $200,000.00; net sales allowed for the 0.10 target $2,000,000.00; at the upper neighbor the figures are Average inventory $200,000.00; net sales $2,000,001.00; inventory to sales ratio 0.09999995 (9.999995%); average inventory needed for the 0.10 target $200,000.10; net sales allowed for the 0.10 target $2,000,000.00 — verdict: STEP.

Edges: Average inventory $0 gives Average inventory $0.00; net sales $1,000,000.00; inventory to sales ratio 0.00 (0.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $0.00. Net sales $0 gives Average inventory $200,000.00; net sales $0.00; inventory to sales ratio undefined — the business holds no stock against no sales, so there is nothing to compare against. Average inventory $250,001 gives Average inventory $250,001.00; net sales $1,000,000.00; inventory to sales ratio 0.250001 (25.0001%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $1,000,004.00. Net sales $800,001 gives Average inventory $200,000.00; net sales $800,001.00; inventory to sales ratio 0.249999688 (24.9999688%); average inventory needed for the 0.25 target $200,000.25; net sales allowed for the 0.25 target $800,000.00. Average inventory $200,000 gives Average inventory $200,000.00; net sales $1,000,000.00; inventory to sales ratio 0.20 (20.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $800,000.00. Average inventory $1,000,000 gives Average inventory $1,000,000.00; net sales $1,000,000.00; inventory to sales ratio 1.00 (100.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $4,000,000.00. Ratio bars — average inventory $300,000, net sales $500,000, average inventory $100,000 gives average inventory $300,000: inventory to sales ratio 0.30 (30.00%); net sales $500,000: inventory to sales ratio 0.40 (40.00%); average inventory $100,000: inventory to sales ratio 0.20 (20.00%). Average inventory $12,500 against net sales −$50,000 gives Average inventory $12,500.00; net sales −$50,000.00; inventory to sales ratio −0.25 (−25.00%); average inventory needed for the 0.25 target −$12,500.00; net sales allowed for the 0.25 target $50,000.00.

Is a 0.20 inventory to sales ratio high or low?

On the defaults — $200,000 of average inventory and $1,000,000 of net sales — the inventory to sales ratio is 0.20 (20.00%). A 0.20 ratio is neither high nor low on its own: it means 20 cents of inventory for every dollar of net sales — the business sells five dollars for every dollar of stock on its shelves. Below 0.10 (10%) the shelves are lean, above 0.30 the shelves are heavy, and above 1.00 the business holds more stock than a whole year of sales. A ratio that climbs year after year while sales stay flat is the classic early warning — the business is buying stock faster than it sells it. The ratio is read year over year and within one industry: a car dealer holds far more stock per dollar of sales than a software firm, so the same 0.20 is a different story in each.

Three things about the model are worth stating plainly.

First, the inventory to sales ratio is $200,000 ÷ $1,000,000 = 0.20 (20.00%). Second, the average inventory needed for a 0.25 ratio is 0.25 × $1,000,000 = $250,000.00. And third, the net sales allowed for a 0.25 ratio is $200,000 ÷ 0.25 = $800,000.00; all listed in Accuracy & limitations.

The worked example, line by line

Setup: $200,000 average inventory, $1,000,000 net sales, target ratio 0.25.

Line 1 — the inventory to sales ratio. The ratio is $200,000 ÷ $1,000,000 = 0.20 (20.00%).

Line 2 — the average inventory needed. The average inventory needed for a 0.25 ratio is 0.25 × $1,000,000 = $250,000.00.

Line 3 — the net sales allowed. The net sales allowed for a 0.25 ratio is $200,000 ÷ 0.25 = $800,000.00.

Line 4 — the check. $250,000.00 ÷ $1,000,000.00 = 0.25 (25.00%), the target ratio; and $200,000.00 ÷ $800,000.00 = 0.25 (25.00%), the target ratio.

Every branch, checked

Average inventory $250,000: Average inventory $250,000.00; net sales $1,000,000.00; inventory to sales ratio 0.25 (25.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $1,000,000.00 — With average inventory of $250,000 the ratio rises to 0.25 (25.00%) — the target ratio itself

Net sales $800,000: Average inventory $200,000.00; net sales $800,000.00; inventory to sales ratio 0.25 (25.00%); average inventory needed for the 0.25 target $200,000.00; net sales allowed for the 0.25 target $800,000.00 — With net sales of $800,000 the ratio rises to 0.25 (25.00%) — the most sales the stock can carry at the target

Net sales $1,250,000: Average inventory $200,000.00; net sales $1,250,000.00; inventory to sales ratio 0.16 (16.00%); average inventory needed for the 0.25 target $312,500.00; net sales allowed for the 0.25 target $800,000.00 — With net sales of $1,250,000 the ratio falls to 0.16 (16.00%)

Average inventory $150,000: Average inventory $150,000.00; net sales $1,000,000.00; inventory to sales ratio 0.15 (15.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $600,000.00 — With average inventory of $150,000 the ratio falls to 0.15 (15.00%)

Average inventory $1,000,000: Average inventory $1,000,000.00; net sales $1,000,000.00; inventory to sales ratio 1.00 (100.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $4,000,000.00 — With average inventory of $1,000,000 the ratio is 1.00 (100.00%) — the business holds a full year of sales on its shelves

Net sales $2,000,000: Average inventory $200,000.00; net sales $2,000,000.00; inventory to sales ratio 0.10 (10.00%); average inventory needed for the 0.25 target $500,000.00; net sales allowed for the 0.25 target $800,000.00 — With net sales of $2,000,000 the ratio falls to 0.10 (10.00%)

Ratio bars — average inventory $300,000, net sales $500,000, average inventory $100,000: average inventory $300,000: inventory to sales ratio 0.30 (30.00%); net sales $500,000: inventory to sales ratio 0.40 (40.00%); average inventory $100,000: inventory to sales ratio 0.20 (20.00%) — An average inventory of $300,000 gives a ratio of 0.30 (30.00%); net sales of $500,000 give a ratio of 0.40 (40.00%); an average inventory of $100,000 gives a ratio of 0.20 (20.00%)

The reverses, worked backwards

Smallest average inventory for the ratio to reach 0.25: At the displayed $250,000 the figures are Average inventory $250,000.00; net sales $1,000,000.00; inventory to sales ratio 0.25 (25.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $1,000,000.00. At the displayed $250,000 the ratio is 0.25 (25.00%) (exactly 0.25). At $249,999 the ratio is 0.249999 (24.9999%) — it displays as 25.00% but is below the 0.25 target — so $250,000 is the smallest whole-dollar average inventory for the ratio to reach 0.25.

Largest net sales for the ratio to STAY at or above 0.25: At the displayed $800,000 the figures are Average inventory $200,000.00; net sales $800,000.00; inventory to sales ratio 0.25 (25.00%); average inventory needed for the 0.25 target $200,000.00; net sales allowed for the 0.25 target $800,000.00. At the displayed $800,000 the ratio is 0.25 (25.00%) (exactly 0.25). At $800,001 the ratio is 0.249999688 (24.9999688%) — it displays as 25.00% but is below the 0.25 target — so $800,000 is the largest whole-dollar net sales for the ratio to stay at or above 0.25.

Smallest average inventory for the ratio to reach 0.30: At the displayed $300,000 the figures are Average inventory $300,000.00; net sales $1,000,000.00; inventory to sales ratio 0.30 (30.00%); average inventory needed for the 0.30 target $300,000.00; net sales allowed for the 0.30 target $1,000,000.00. At the displayed $300,000 the ratio is 0.30 (30.00%) (exactly 0.30). At $299,999 the ratio is 0.299999 (29.9999%) — it displays as 30.00% but is below the 0.30 target — so $300,000 is the smallest whole-dollar average inventory for the ratio to reach 0.30.

Largest net sales for the ratio to STAY at or above 0.20: At the displayed $1,000,000 the figures are Average inventory $200,000.00; net sales $1,000,000.00; inventory to sales ratio 0.20 (20.00%); average inventory needed for the 0.20 target $200,000.00; net sales allowed for the 0.20 target $1,000,000.00. At the displayed $1,000,000 the ratio is 0.20 (20.00%) (exactly 0.20). At $1,000,001 the ratio is 0.1999998 (19.99998%) — it displays as 20.00% but is below the 0.20 target — so $1,000,000 is the largest whole-dollar net sales for the ratio to stay at or above 0.20.

Smallest average inventory for the ratio to reach 0.15: At the displayed $150,000 the figures are Average inventory $150,000.00; net sales $1,000,000.00; inventory to sales ratio 0.15 (15.00%); average inventory needed for the 0.15 target $150,000.00; net sales allowed for the 0.15 target $1,000,000.00. At the displayed $150,000 the ratio is 0.15 (15.00%) (exactly 0.15). At $149,999 the ratio is 0.149999 (14.9999%) — it displays as 15.00% but is below the 0.15 target — so $150,000 is the smallest whole-dollar average inventory for the ratio to reach 0.15.

Largest net sales for the ratio to STAY at or above 0.10: At the displayed $2,000,000 the figures are Average inventory $200,000.00; net sales $2,000,000.00; inventory to sales ratio 0.10 (10.00%); average inventory needed for the 0.10 target $200,000.00; net sales allowed for the 0.10 target $2,000,000.00. At the displayed $2,000,000 the ratio is 0.10 (10.00%) (exactly 0.10). At $2,000,001 the ratio is 0.09999995 (9.999995%) — it displays as 10.00% but is below the 0.10 target — so $2,000,000 is the largest whole-dollar net sales for the ratio to stay at or above 0.10.

A warning about the neighbours: every neighbour above sits one dollar from the star — $1 of average inventory or $1 of net sales — and every neighbour displays as the target when rounded to two decimals, yet sits below it. The ratio is linear in whole dollars, so the reverses have exact closed forms: the average inventory needed is the target times the net sales, and the net sales allowed is the average inventory divided by the target. The page prints the unrounded percents in full so the rounding does not mislead you: 24.9999%, 24.9999688%, 29.9999%, 19.99998%, 14.9999% and 9.999995%.

What the defaults assume

The defaults are $200,000 of average inventory, $1,000,000 of net sales and a target ratio of 0.25 — Average inventory $200,000.00; net sales $1,000,000.00; inventory to sales ratio 0.20 (20.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $800,000.00. With Average inventory $250,000, Average inventory $250,000.00; net sales $1,000,000.00; inventory to sales ratio 0.25 (25.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $1,000,000.00. With Net sales $800,000, Average inventory $200,000.00; net sales $800,000.00; inventory to sales ratio 0.25 (25.00%); average inventory needed for the 0.25 target $200,000.00; net sales allowed for the 0.25 target $800,000.00. With Net sales $1,250,000, Average inventory $200,000.00; net sales $1,250,000.00; inventory to sales ratio 0.16 (16.00%); average inventory needed for the 0.25 target $312,500.00; net sales allowed for the 0.25 target $800,000.00. With Average inventory $150,000, Average inventory $150,000.00; net sales $1,000,000.00; inventory to sales ratio 0.15 (15.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $600,000.00. With Average inventory $1,000,000, Average inventory $1,000,000.00; net sales $1,000,000.00; inventory to sales ratio 1.00 (100.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $4,000,000.00. With Net sales $2,000,000, Average inventory $200,000.00; net sales $2,000,000.00; inventory to sales ratio 0.10 (10.00%); average inventory needed for the 0.25 target $500,000.00; net sales allowed for the 0.25 target $800,000.00. With Ratio bars, average inventory $300,000: inventory to sales ratio 0.30 (30.00%); net sales $500,000: inventory to sales ratio 0.40 (40.00%); average inventory $100,000: inventory to sales ratio 0.20 (20.00%). With Average inventory $0, Average inventory $0.00; net sales $1,000,000.00; inventory to sales ratio 0.00 (0.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $0.00. With Net sales $0, Average inventory $200,000.00; net sales $0.00; inventory to sales ratio undefined — the business holds no stock against no sales, so there is nothing to compare against — the ratio is undefined, shown as undefined with that note, never a crash and never a made-up number. With Average inventory $250,001, Average inventory $250,001.00; net sales $1,000,000.00; inventory to sales ratio 0.250001 (25.0001%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $1,000,004.00 (unrounded 25.0001% — displays 25.00% but is above the 0.25 target). With Net sales $800,001, Average inventory $200,000.00; net sales $800,001.00; inventory to sales ratio 0.249999688 (24.9999688%); average inventory needed for the 0.25 target $200,000.25; net sales allowed for the 0.25 target $800,000.00 (unrounded 24.9999688% — displays 25.00% but is below the 0.25 target). With Average inventory $200,000, Average inventory $200,000.00; net sales $1,000,000.00; inventory to sales ratio 0.20 (20.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $800,000.00 (exactly 0.20). With Average inventory $1,000,000, Average inventory $1,000,000.00; net sales $1,000,000.00; inventory to sales ratio 1.00 (100.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $4,000,000.00. With Ratio bars, average inventory $300,000: inventory to sales ratio 0.30 (30.00%); net sales $500,000: inventory to sales ratio 0.40 (40.00%); average inventory $100,000: inventory to sales ratio 0.20 (20.00%). With Average inventory $12,500 against net sales −$50,000, Average inventory $12,500.00; net sales −$50,000.00; inventory to sales ratio −0.25 (−25.00%); average inventory needed for the 0.25 target −$12,500.00; net sales allowed for the 0.25 target $50,000.00 (negative net sales from returns — the ratio is −0.25, shown with a note, never hidden).

A note on the rounding: the percent is displayed to two decimals, half-up. At $249,999 of average inventory the unrounded percent is 24.9999% — it displays as 25.00% but is below the 0.25 target. At $800,001 of net sales the unrounded percent is 24.9999688% — it displays as 25.00% but is below the 0.25 target. At $250,001 of average inventory the unrounded percent is 25.0001% — it displays as 25.00% but is above the 0.25 target. At $399,999 of average inventory against $2,000,000 of net sales the unrounded percent is 19.99995% — it displays as 20.00% but is below the 0.20 line. The page prints the unrounded percents so the rounding does not mislead you.

Output · formula · meaning

OutputFormulaWhat it means
Average inventoryinput$200,000.00.
Net salesinput$1,000,000.00.
Target ratioinput0.25.
Inventory to sales ratioaverage inventory ÷ net sales0.20 (20.00%).
Average inventory needed for the 0.25 targettarget ratio × net sales$250,000.00.
Net sales allowed for the 0.25 targetaverage inventory ÷ target ratio$800,000.00.
Verdictwhat the stock on the shelves backsthe business holds 20 cents of inventory for every dollar of net sales.
Reverse: Smallest whole-dollar average inventory for the ratio to reach 0.25step$250,000 → $250,000.
Below the revr1 starneighborAverage inventory $249,999.00; net sales $1,000,000.00; inventory to sales ratio 0.249999 (24.9999%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $999,996.00.
Above the revr1 starneighborAverage inventory $250,001.00; net sales $1,000,000.00; inventory to sales ratio 0.250001 (25.0001%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $1,000,004.00.
Reverse: Largest whole-dollar net sales for the ratio to STAY at or above 0.25step$800,000 → $800,000.
Below the revr2 starneighborAverage inventory $200,000.00; net sales $799,999.00; inventory to sales ratio 0.250000313 (25.0000313%); average inventory needed for the 0.25 target $199,999.75; net sales allowed for the 0.25 target $800,000.00.
Above the revr2 starneighborAverage inventory $200,000.00; net sales $800,001.00; inventory to sales ratio 0.249999688 (24.9999688%); average inventory needed for the 0.25 target $200,000.25; net sales allowed for the 0.25 target $800,000.00.
Reverse: Smallest whole-dollar average inventory for the ratio to reach 0.30step$300,000 → $300,000.
Below the revr3 starneighborAverage inventory $299,999.00; net sales $1,000,000.00; inventory to sales ratio 0.299999 (29.9999%); average inventory needed for the 0.30 target $300,000.00; net sales allowed for the 0.30 target $999,996.67.
Above the revr3 starneighborAverage inventory $300,001.00; net sales $1,000,000.00; inventory to sales ratio 0.300001 (30.0001%); average inventory needed for the 0.30 target $300,000.00; net sales allowed for the 0.30 target $1,000,003.33.
Reverse: Largest whole-dollar net sales for the ratio to STAY at or above 0.20step$1,000,000 → $1,000,000.
Below the revr4 starneighborAverage inventory $200,000.00; net sales $999,999.00; inventory to sales ratio 0.2000002 (20.00002%); average inventory needed for the 0.20 target $199,999.80; net sales allowed for the 0.20 target $1,000,000.00.
Above the revr4 starneighborAverage inventory $200,000.00; net sales $1,000,001.00; inventory to sales ratio 0.1999998 (19.99998%); average inventory needed for the 0.20 target $200,000.20; net sales allowed for the 0.20 target $1,000,000.00.
Reverse: Smallest whole-dollar average inventory for the ratio to reach 0.15step$150,000 → $150,000.
Below the revr5 starneighborAverage inventory $149,999.00; net sales $1,000,000.00; inventory to sales ratio 0.149999 (14.9999%); average inventory needed for the 0.15 target $150,000.00; net sales allowed for the 0.15 target $999,993.33.
Above the revr5 starneighborAverage inventory $150,001.00; net sales $1,000,000.00; inventory to sales ratio 0.150001 (15.0001%); average inventory needed for the 0.15 target $150,000.00; net sales allowed for the 0.15 target $1,000,006.67.
Reverse: Largest whole-dollar net sales for the ratio to STAY at or above 0.10step$2,000,000 → $2,000,000.
Below the revr6 starneighborAverage inventory $200,000.00; net sales $1,999,999.00; inventory to sales ratio 0.10000005 (10.000005%); average inventory needed for the 0.10 target $199,999.90; net sales allowed for the 0.10 target $2,000,000.00.
Above the revr6 starneighborAverage inventory $200,000.00; net sales $2,000,001.00; inventory to sales ratio 0.09999995 (9.999995%); average inventory needed for the 0.10 target $200,000.10; net sales allowed for the 0.10 target $2,000,000.00.
Average inventory $250,000same modelAverage inventory $250,000.00; net sales $1,000,000.00; inventory to sales ratio 0.25 (25.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $1,000,000.00.
Net sales $800,000same modelAverage inventory $200,000.00; net sales $800,000.00; inventory to sales ratio 0.25 (25.00%); average inventory needed for the 0.25 target $200,000.00; net sales allowed for the 0.25 target $800,000.00.
Net sales $1,250,000same modelAverage inventory $200,000.00; net sales $1,250,000.00; inventory to sales ratio 0.16 (16.00%); average inventory needed for the 0.25 target $312,500.00; net sales allowed for the 0.25 target $800,000.00.
Average inventory $150,000same modelAverage inventory $150,000.00; net sales $1,000,000.00; inventory to sales ratio 0.15 (15.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $600,000.00.
Average inventory $1,000,000same modelAverage inventory $1,000,000.00; net sales $1,000,000.00; inventory to sales ratio 1.00 (100.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $4,000,000.00.
Net sales $2,000,000same modelAverage inventory $200,000.00; net sales $2,000,000.00; inventory to sales ratio 0.10 (10.00%); average inventory needed for the 0.25 target $500,000.00; net sales allowed for the 0.25 target $800,000.00.
Ratio bars — average inventory $300,000, net sales $500,000, average inventory $100,000same modelaverage inventory $300,000: inventory to sales ratio 0.30 (30.00%); net sales $500,000: inventory to sales ratio 0.40 (40.00%); average inventory $100,000: inventory to sales ratio 0.20 (20.00%).

Who uses this

  • The shop owner checking the shelves before ordering: they learn $200,000 of average inventory against $1,000,000 of net sales is a ratio of 0.20 (20.00%) — and they check the $250,000 reverse to see the inventory a 0.25 ratio needs.
  • The buyer planning next season’s stock: they learn $800,000 of net sales is the most the stock can carry and still hold a 0.25 ratio — and they check the $1,000,000 reverse to see the sales a 0.20 ratio allows.
  • The analyst comparing two retailers in one industry: they learn the same 0.20 is a different story in a car dealer and a software firm — and they check the $300,000 reverse to see the inventory a 0.30 ratio needs.
  • The student learning stock measures: they learn the inventory to sales ratio is average inventory divided by net sales — and they check the $150,000 reverse to see the inventory a 0.15 ratio needs.

Accuracy & limitations

The math is first-principles: the inventory to sales ratio is average inventory divided by net sales; the average inventory needed for the target is the target ratio times net sales; the net sales allowed for the target is average inventory divided by the target ratio — all in whole dollars, the percent displayed to two decimals half-up. This page uses AVERAGE inventory — (opening stock + closing stock) ÷ 2 — not ending inventory: a single day’s closing stock can be flattered by a delivery that landed that morning or emptied by a big sale that afternoon, so the average across the year is the honest figure for a ratio that is read year over year. If you only have the closing stock, use it and say so — the ratio will be close, but a stock-take taken the day after a delivery will read high and a stock-take taken the day before one will read low. At $0 of net sales the ratio is UNDEFINED — the business holds stock against no sales, so there is nothing to compare against — the page shows the ratio as undefined with that note, never a crash and never a made-up number. A negative ratio means net sales went negative — at $12,500 of average inventory against −$50,000 of net sales the ratio is −0.25 (−25.00%) — returns outran sales, so the ratio says nothing about stock levels — and a negative ratio is not a bargain signal, it is a warning sign — so the ratio is negative and the calculator shows the negative figure with a note, never hides it and never shows “—” for it. What the model cannot do is judge the stock: the ratio says nothing about which lines sell, how old the stock is, or whether the shelves hold the right goods — a low ratio can hide empty shelves and lost sales, and a high ratio can hide slow lines that never move. The ratio differs from inventory turnover: turnover divides cost of goods sold by average inventory, so it counts how many times the stock sells through. The ratio differs from days inventory outstanding: days outstanding turns the same stock into a count of days. Use it to see how much stock backs each dollar sold — then walk the shelves.

Cite this calculatorBright Side Kit. “Inventory to Sales Ratio Calculator: Is Stock Too High?” brightoolbox.com, 2026. Method: Inventory to sales ratio = average inventory ÷ net sales; average inventory needed at the target = target ratio × net sales; net sales allowed at the target = average inventory ÷ target ratio. This page uses AVERAGE inventory — (opening stock + closing stock) ÷ 2 — not ending inventory. Reverses: smallest whole-dollar average inventory for the ratio to reach 0.25 is $250,000 (at $250,000 the ratio is 0.25 (25.00%), exactly 0.25; at $249,999 the ratio is 0.249999 (24.9999%) — displays 25.00% but is below the 0.25 target); largest whole-dollar net sales for the ratio to STAY at or above 0.25 is $800,000 (at $800,000 the ratio is 0.25 (25.00%), exactly 0.25; at $800,001 the ratio is 0.249999688 (24.9999688%) — displays 25.00% but is below the 0.25 target); smallest whole-dollar average inventory for the ratio to reach 0.30 is $300,000 (at $300,000 the ratio is 0.30 (30.00%), exactly 0.30; at $299,999 the ratio is 0.299999 (29.9999%) — displays 30.00% but is below the 0.30 target); largest whole-dollar net sales for the ratio to STAY at or above 0.20 is $1,000,000 (at $1,000,000 the ratio is 0.20 (20.00%), exactly 0.20; at $1,000,001 the ratio is 0.1999998 (19.99998%) — displays 20.00% but is below the 0.20 target); smallest whole-dollar average inventory for the ratio to reach 0.15 is $150,000 (at $150,000 the ratio is 0.15 (15.00%), exactly 0.15; at $149,999 the ratio is 0.149999 (14.9999%) — displays 15.00% but is below the 0.15 target); largest whole-dollar net sales for the ratio to STAY at or above 0.10 is $2,000,000 (at $2,000,000 the ratio is 0.10 (10.00%), exactly 0.10; at $2,000,001 the ratio is 0.09999995 (9.999995%) — displays 10.00% but is below the 0.10 target). Defaults: Average inventory $200,000.00; net sales $1,000,000.00; inventory to sales ratio 0.20 (20.00%); average inventory needed for the 0.25 target $250,000.00; net sales allowed for the 0.25 target $800,000.00 Bright Side Kit. "Inventory to Sales Ratio Calculator: Is Stock Too High?" https://brightoolbox.com/inventory-to-sales-ratio-calculator/ Accessed October 27, 2026.
Embed this calculator

Frequently asked questions

What is the inventory to sales ratio?

Average inventory divided by net sales. On $200,000 of average inventory and $1,000,000 of net sales the ratio is 0.20 (20.00%) — the business holds 20 cents of inventory for every dollar of net sales.

How do I calculate the inventory to sales ratio?

Divide the average inventory by the net sales. $200,000 ÷ $1,000,000 = 0.20 (20.00%).

What does a 0.20 inventory to sales ratio mean?

The business holds 20 cents of inventory for every dollar of net sales. The business sells five dollars for every dollar of stock on its shelves.

How much inventory do I need for a 0.25 ratio?

$250,000 with $1,000,000 of net sales. The smallest whole-dollar average inventory for the ratio to reach 0.25 is $250,000. At $250,000 the ratio is 0.25 (25.00%), exactly 0.25.

How much can I sell and still hold a 0.25 ratio?

$800,000 with $200,000 of average inventory. The largest whole-dollar net sales for the ratio to stay at or above 0.25 is $800,000. At $800,000 the ratio is 0.25 (25.00%), exactly 0.25.

What does a negative inventory to sales ratio mean?

Net sales went negative. At $12,500 of average inventory against −$50,000 of net sales the ratio is −0.25 (−25.00%) — returns outran sales — and a negative ratio is not a bargain signal, it is a warning sign — and the calculator shows the negative figure with a note, never hides it and never shows “—” for it.

What if net sales are zero?

The ratio is undefined. At $0 of net sales the ratio is undefined — the business holds stock against no sales, so there is nothing to compare against — shown as undefined with that note, never a crash and never a made-up number.

Why does $249,999 of average inventory miss the 0.25 target?

Because $249,999 ÷ $1,000,000 = 0.249999 (24.9999%). The ratio displays as 25.00% but is below the 0.25 target — the smallest whole-dollar average inventory for the ratio to reach 0.25 is $250,000.