How to Calculate Minimum–Maximum Stock and the Reorder Point in Hotels

One of the most common mistakes in hotel stock management is this:

Ordering a product when it runs low.

At first glance, it seems logical.

If the coffee in the warehouse is running low, buy coffee.

If the shampoo is running low, buy shampoo.

If the toilet paper is running low, place an order.

In professional stock management, however, the question is not:

“Is the product running low?”

The real questions are these:

At what level should I order?

How many days does an ordered product take to arrive?

How much will I consume during that time?

What happens if I consume more than expected?

What happens if the supplier is late?

How much safety stock should I hold?

How much stock counts as excess stock?

This is where:

• minimum stock,
• maximum stock,
• safety stock,
• the reorder point,
• par stock

provide the answers to these questions.

When set up correctly, the purpose of the system is very simple:

The product should never be so low that it disrupts operations, nor so high that it ties up the business's money in the warehouse unnecessarily.

What Is Minimum Stock?

Minimum stock is:

the lower stock level set so that operations can continue safely.

For example, say that for toilet paper in a hotel:

Minimum stock = 20 cartons

has been set.

When the current stock falls to:

18 cartons

the product is now below the defined lower limit.

At this point, a purchasing action is needed.

But the minimum stock should not be guessed as:

“I want to see at least 20 cartons in the warehouse.”

It must be calculated.

Why Is Minimum Stock Necessary?

Because the product you order does not arrive in your warehouse instantly.

In between, there are:

• the purchase request,
• approval,
• quotation/order,
• the supplier's preparation,
• transport,
• goods receipt,
• warehouse entry.

The whole of this period is considered within the:

Lead Time — Procurement Period

For example, if procuring a product consumed at 10 units per day takes:

5 days

then between placing the order and the product arriving, you can consume approximately:

10 × 5 = 50 units

more.

If you place the order only when 20 units are left:

the stock may run out before the product arrives.

How Is Minimum Stock Calculated?

The basic approach:

Minimum Stock = Expected Consumption During Lead Time + Safety Stock

For example:

The calculation:

25 × 5 = 125

Then:

125 + 50 = 175 units

So the minimum stock is:

175 units

In this example, the purchasing process should start when stock approaches 175 units.

What Is Safety Stock?

Safety Stock

It is additional stock held against risks that may arise outside normal conditions.

Because in real life:

average consumption is not the same every day.

And:

the supplier may not deliver every order exactly on time.

For example, normal consumption may be:

20 units/day

But during a high-occupancy period, it may be:

30 units/day

The supplier may normally deliver in:

3 days

But during a holiday period, it may deliver in:

6 days

This is exactly where safety stock creates a buffer against these uncertainties.

Safety Stock and Minimum Stock Are Not the Same Thing

These two concepts are often confused.

For example:

Daily consumption:

10 cartons

Lead time:

3 days

Safety stock:

20 cartons

then:

Consumption during lead time:

10 × 3 = 30 cartons

Minimum stock:

30 + 20 = 50 cartons

Here:

20 cartons is the safety stock.

50 cartons is the minimum stock level.

How Should Safety Stock Be Determined?

There is no single figure that applies to every hotel and every product.

When determining safety stock, at least the following factors should be considered:

1. Consumption Variability

How much does consumption fluctuate?

2. Lead Time

How many days does the product take to arrive?

3. Lead Time Variability

Does the supplier always deliver in the same time?

4. Criticality of the Product

How much are operations affected if the product runs out?

5. Alternative Supplier

Can it be sourced quickly from somewhere else?

6. Season

Does supply risk increase in the busy season?

7. Storage Conditions

Is it possible to stock more of the product?

8. Shelf Life

Can the product spoil?

Therefore:

two products with the same daily consumption do not necessarily need the same safety stock.

Why May Critical Products Need More Safety?

Say the hotel runs out of decorative candles.

Operations will probably continue.

But when:

• a basic hygiene product,
• a critical cleaning consumable,
• a core breakfast item,
• an important technical spare part

runs out, operations can be seriously affected.

That is why, when setting stock levels, it is wrong to look only at the question:

“How many do we use per month?”

Ask this as well:

“What happens to the hotel if this product runs out?”

Classify Products by Criticality

A simple structure can be used:

For example:

Class A

• critical technical spare parts,
• basic hygiene products,
• some safety/technical consumables.

Class B

• housekeeping consumables,
• basic F&B consumables,
• room amenity items.

Class C

• some decorative items,
• promotional items,
• secondary office consumables.

This classification can influence the safety stock decision.

What Is the Reorder Point?

Reorder Point — ROP

For a product, it is the stock level at which you say:

“Now I must place a new order.”

The basic approach:

Reorder Point = Expected Consumption During Lead Time + Safety Stock

In many simple minimum–maximum systems, this value can be used as:

the same as the minimum stock level.

For example:

Daily consumption:

20 units

Lead time:

4 days

Safety stock:

40 units

Consumption during lead time:

20 × 4 = 80

Reorder Point:

80 + 40 = 120 units

When stock reaches:

120 units

the order should be placed.

Let's Picture the Reorder Point

At the start, the warehouse holds a high level of stock.

Every day, stock decreases because of consumption.

At a certain point, it reaches:

the Reorder Point

level.

The order is placed here.

But the product does not arrive the same day.

During the lead time, the current stock keeps being consumed.

When the new product arrives, the stock must not have run out completely.

That is why safety stock exists.

The simple logic:

Stock decreases → Reaches the Reorder Point → Order is placed → Consumption continues during the lead time → New stock arrives.

What Happens If Lead Time Is Calculated Wrongly?

This is one of the most critical inputs of stock calculations.

For example, the supplier may tell you:

“We deliver in 3 days.”

But the real data may look like this:

That is why it is healthier to track not only the time the supplier states but also:

the actual delivery history.

Average Lead Time Is Not Always Enough

Say the last five deliveries took:

3 days, 3 days, 4 days, 3 days, 9 days.

The average may be about:

4.4 days.

But for a critical product, relying on the average alone can be risky.

Because the system must also be able to manage:

a 9-day delay.

For this reason, especially for critical products, the following should be evaluated together:

• average lead time,
• maximum realistic lead time,
• delivery deviations.

What Is Maximum Stock?

Maximum stock is:

the upper level that limits unnecessary stock build-up.

Minimum stock protects you from:

the product running out.

Maximum stock protects you from:

buying more than necessary.

Because excess stock:

• ties up cash,
• takes up warehouse space,
• creates obsolescence risk,
• increases expiry-date risk,
• can increase attrition,
• increases the counting workload,
• can lead to unnecessary purchasing.

That is why:

Buying extra just because it is cheap does not always save money.

How Is Maximum Stock Calculated?

There is no single universal formula that applies to every business and every product for maximum stock.

One practical approach is:

Maximum Stock = Consumption During the Reorder Period + Consumption During Lead Time + Safety Stock

For example:

Weekly consumption:

10 cartons

Need until the next order period:

10 cartons

Consumption during lead time:

10 cartons

Safety stock:

5 cartons

Approximate maximum stock:

10 + 10 + 5 = 25 cartons

is possible.

But the calculation does not end here.

The following must also be checked:

• shelf life,
• warehouse capacity,
• product cost,
• order pack size,
• minimum order quantity,
• season,
• cash flow.

How Does a Minimum–Maximum System Work?

For example:

Minimum stock: 20 cartons

Maximum stock: 60 cartons

Current stock: 18 cartons

Stock has fallen below the minimum.

An order will be placed.

In a simple min-max system, the order quantity is:

Order Quantity = Maximum Stock − Current Stock

That is:

60 − 18 = 42 cartons

are ordered.

When the new stock arrives, the system again approaches the target upper level.

Reorder Point and Order Quantity Are Not the Same Thing

This distinction is important.

Reorder Point

When will I order?

is the answer to that question.

Order Quantity

How much will I order?

is the answer to that question.

For example:

Reorder Point:

20 cartons

Maximum:

60 cartons

Current:

18 cartons

then:

the order has been triggered.

The order quantity could be:

60 − 18 = 42 cartons

So:

ROP = When? Order Quantity = How much?

A Simple Example: Toilet Paper

In a hotel:

Consumption during lead time:

3 × 4 = 12 cartons

Reorder Point / Minimum can be set at:

12 + 8 = 20 cartons

The initial maximum level can be set, for example, in the range of:

40–50 cartons

But this value should be revised as real consumption data comes in.

Second Example: Coffee

Say a hotel's average daily coffee consumption is:

1.5 kg

Lead time:

3 days

Safety stock:

4 kg

Consumption during lead time:

1.5 × 3 = 4.5 kg

Minimum / ROP:

4.5 + 4 = 8.5 kg

But if coffee is sold in:

1 kg packs

the pack unit must be taken into account in the actual purchasing decision.

In other words, even if the math says:

8.5 kg

the operational stock:

can be rounded according to the pack structure.

Third Example: Shampoo

Say that:

Daily consumption:

25 units

Lead time:

5 days

Safety stock:

50 units

Minimum / ROP:

25 × 5 + 50 = 175 units

Let's say the maximum stock has been set at:

400 units

When current stock is:

160 units

the order is triggered.

According to the simple min-max system:

400 − 160 = 240 units

can be ordered.

But the actual order should be finalized after checking:

• units per carton,
• the supplier's MOQ,
• season,
• upcoming occupancy,
• existing open orders.

Fourth Example: Technical Spare Part

It is important here to see the limits of consumption-based formulas.

Consider an air-conditioning control board.

Say average consumption is:

0.1 units per month

If you look only at the math, you might say:

“There is no need to keep this in stock.”

But when the board fails:

• if the room cannot be used,
• if the product is a special order,
• if the delivery time is 20 days,

keeping 1 spare in stock may be economical.

Because the real question here is:

not the product's consumption rate but the cost of a stockout.

When setting minimum stock, look not only at how much the product is consumed but also at how much its absence would harm the business.

Why Does the Expiry Date Matter for Maximum Stock?

Especially in F&B:

excess stock = security

is not true.

For example, for:

• milk,
• yogurt,
• cheese,
• meat,
• fresh vegetables,
• fresh fruit

excess stock can directly create:

attrition risk.

That is why maximum stock:

should not exceed safe consumption capacity.

FIFO and FEFO Must Work Together with Maximum Stock

For products with an expiry date:

FEFO

First Expired, First Out

can be applied.

That is:

the product whose expiry date comes first is consumed first.

But if you buy more stock than necessary, even FEFO does not completely solve the problem.

Because you may not be able to:

consume the products before their expiry date.

That is why:

Right FEFO + Wrong Maximum Stock = Attrition Anyway

is possible.

Warehouse Capacity Limits Maximum Stock

The math may say:

Maximum stock = 100 cartons

But if your warehouse can safely store:

60 cartons

the theoretical maximum cannot be applied.

Therefore:

Theoretical Maximum ≠ Physical Maximum

is possible.

In this case:

• order frequency can be increased,
• delivery batches can be reduced,
• the supply model can be changed,
• warehouse capacity can be reassessed.

Cash Flow Also Limits Maximum Stock

For example, say a high-cost product has:

a monthly need of:

100,000 TL

If you buy six months of stock:

600,000 TL

of cash may be tied up in the warehouse.

Because the product became cheaper or there is a bulk-purchase discount:

buying unnecessary stock

is not always economical.

The advantage gained from the discount should be assessed together with:

• financing cost,
• storage,
• spoilage,
• attrition,
• obsolescence.

Is the “Let's Buy a Year's Worth and Protect Ourselves from Price Increases” Logic Always Right?

No.

It may make sense for some products.

For others, it may not.

When deciding, you need to compare:

the purchase discount

with

the cost and risk of carrying stock.

For example, bulk purchasing can be considered if the product:

• does not spoil,
• will not change in standard,
• will definitely be used,
• has low storage cost,
• offers a significant price advantage.

But if:

• shelf life is short,
• consumption is uncertain,
• the concept may change,
• the product standard may change,
• storage space is insufficient,

excess stock can create a serious cost.

Should Minimum–Maximum Stock Stay Fixed in Seasonal Hotels?

Generally not.

For example, in an Alaçatı hotel:

May consumption and

August consumption

may not be the same.

Therefore, using:

the same average daily consumption

all year round can be misleading.

In seasonal businesses, stock levels can be assessed separately for:

• low season,
• shoulder season,
• high season,
• special events/holiday periods.

Take the Occupancy Rate into Account

Especially for products tied to guest consumption:

there is a relationship between consumption and occupancy.

For example:

In a 30-room hotel:

the amount of shampoo used at 30% occupancy and

the amount used at 95% occupancy

are not the same.

So, rather than only:

total monthly consumption,

you can track:

Consumption per Occupied Room

The formula:

Consumption per Occupied Room = Total Product Consumption / Occupied Room Nights

For example:

1,200 bottles of water

600 occupied rooms

then:

1,200 / 600 = 2 units / occupied room

of consumption.

This ratio can be used in stock planning together with the future occupancy forecast.

Stock Can Be Forecast Based on Future Occupancy

For example, for the next 10 days you expect:

400 occupied rooms

If the average water consumption per room is:

2 units

then:

the expected consumption is:

400 × 2 = 800 units

By adding:

• current stock,
• open orders,
• safety stock

the purchasing requirement can be calculated.

This approach is especially useful for products such as:

• water,
• room amenities,
• coffee capsules,
• tea,
• room treats.

Using a Forecast Strengthens Stock Management

Past consumption tells you:

what happened.

A forecast helps you estimate:

what will happen.

For example, last week there was:

50% occupancy.

Next week:

95%

is expected.

If you order based only on last week's consumption:

stock may fall short.

That is why a good stock system uses:

Past Consumption + Future Operations Forecast

together.

Don't Forget Open Orders

In the stock system, you should see not only:

physical stock on hand

but also:

orders in transit.

For example:

Physical stock:

200 units

Open order:

500 units

New purchase request:

400 units

If you look only at physical stock, you might say:

“Stock is low.”

and order again.

The result:

1,100 units

of stock could pile up.

That is why a stock decision should consider together:

• current stock,
• open orders,
• reserved/allocated stock,
• expected consumption.

How Often Should Minimum–Maximum Values Be Updated?

It is not right to calculate them once and use them for years.

Because over time:

• consumption changes,
• the number of rooms may change,
• occupancy changes,
• the supplier changes,
• the lead time changes,
• the product changes,
• the pack size changes,
• the price changes,
• the concept changes.

That is why minimum–maximum levels should be seen as:

living operational data.

They should be reassessed especially:

• at the start of the season,
• before the high season,
• when the supplier changes,
• when consumption changes noticeably,
• when a stockout occurs,
• when overstock keeps recurring.

What Does It Mean If You Keep Having Stockouts?

If a product keeps running out, it is not right to immediately say:

“Let's hold more stock.”

First find the cause.

The problem may be:

• the minimum level being too low,
• insufficient safety stock,
• lead time being calculated wrongly,
• supplier delays,
• increased consumption,
• stock issues being recorded wrongly,
• a counting error,
• delays in purchase approval.

In other words:

A stockout can be a stock-level problem as well as a process problem.

What Does It Mean If You Keep Having Overstock?

If excess stock keeps building up in the warehouse:

• the maximum may be too high,
• the consumption forecast may be wrong,
• the purchase quantity may be too large,
• the MOQ may be managed wrongly,
• department requests may not reflect real consumption,
• the same product may be ordered repeatedly.

In this case, the solution is not:

“Let's build a bigger warehouse.”

but first:

finding out why excess stock builds up.

The Difference Between Par Stock and Minimum–Maximum Stock

It is important to separate these concepts.

Par Stock

The target standard stock level of the operation.

Minimum Stock

The lower safety/action level.

Maximum Stock

The upper control level.

Reorder Point

The level at which a new purchase order is triggered.

Safety Stock

The buffer stock held against unexpected demand or delays.

For example:

If current stock is:

55

the product is below both the par level and the minimum level.

Therefore, priority replenishment is needed.

Par Stock is the target; maximum stock is the control limit.

How Is the Replenishment Quantity Calculated?

Especially in an in-department par stock system:

Replenishment Quantity = Par Stock − Current Stock

For example:

Par:

100

Current:

65

Replenishment:

100 − 65 = 35 units

This calculation can be used especially in daily operational areas such as:

• housekeeping,
• floor pantry,
• F&B,
• minibar.

Don't Confuse the Purchase Quantity with the Replenishment Quantity

Transferring:

35 units

from the main warehouse to the housekeeping store is a different transaction from buying:

200 units

of the product from the supplier.

The first:

internal replenishment

and the second:

procurement replenishment

can be thought of separately.

A good stock system keeps these two movements apart.

Minimum–Maximum Stock Worksheet

A master table like the one below can be created for each product:

When this table is kept accurately, an important part of the purchasing department's question:

“What should we buy?”

starts to be answered from data.

A Simple Hotel Stock Dashboard

At the management level, instead of examining every SKU one by one, KPIs can be tracked.

Number of Stockouts

How many products ran out completely?

Number of Items Below Minimum

How many products fell below the safe level?

Overstock

For how many products was the maximum level exceeded?

Average Stock Value

How much capital is tied up in the warehouse on average?

Inventory Turnover

How quickly does stock turn over?

Attrition

How much product is lost?

Expiry Loss

How much loss is incurred because of expiry dates?

Emergency Purchase

How many times were emergency purchases made?

Average Lead Time

How long do suppliers actually take to deliver?

Stock Accuracy

How closely do system stock and physical stock match?

Why Is Inventory Turnover Important?

The formula:

Inventory Turnover = Cost of Stock Used During the Period / Average Stock Value

For example:

Annual usage cost:

6,000,000 TL

Average stock:

1,000,000 TL

then:

6,000,000 / 1,000,000 = 6

inventory turnover results.

In theory, stock turns over about:

6 times

a year.

How Is Average Stock Value Calculated?

A simple approach:

Average Stock Value = (Opening Stock + Closing Stock) / 2

For example:

Opening:

800,000 TL

Closing:

1,200,000 TL

The average:

(800,000 + 1,200,000) / 2 = 1,000,000 TL

Average Time in Stock

From inventory turnover, the approximate:

Average Time in Stock = 365 / Inventory Turnover

can be calculated.

For example, if turnover is:

6

then:

365 / 6 ≈ 61 days

But this value should not be interpreted the same way for all products.

For fresh food and a critical technical spare part:

the ideal turnover is not the same.

“The Lowest Stock” Is Not Always the Best Stock

The purpose of stock optimization is not:

to hold as little stock as possible.

Very low stock can create:

• stockouts,
• emergency purchases,
• higher prices,
• operational interruptions,
• guest dissatisfaction.

Very high stock, on the other hand:

• ties up capital,
• creates storage costs,
• increases attrition,
• creates obsolescence.

So the goal should be:

Optimum Stock

Optimum Stock = Operational Security + Controlled Use of Capital

12 Mistakes Made in Minimum–Maximum Stock Systems

1. Setting minimum stock by guesswork

Consumption and lead time are not used.

2. Mistaking safety stock for minimum stock

The two concepts are confused.

3. Accepting the supplier's stated lead time as real

Actual delivery data is not tracked.

4. Applying the same safety stock to every product

Product criticality levels differ.

5. Using the same consumption all year

The seasonal effect is not seen.

6. Not using an occupancy forecast

Future consumption cannot be anticipated.

7. Not accounting for open orders

Double ordering can occur.

8. Setting maximum stock higher than necessary

Capital gets tied up in the warehouse.

9. Ignoring the expiry date

Attrition increases.

10. Ignoring warehouse capacity

Theoretical stock cannot be physically stored.

11. Evaluating critical technical parts only by consumption rate

Low-consumption but vital products can end up out of stock.

12. Never updating minimum–maximum levels

The system drifts away from real operations over time.

Setting the Stock Level with 10 Decision Gates

Decision Gate 1 — Consumption

Do we know the real consumption rate?

Decision Gate 2 — Lead Time

Do we know the product's real procurement time?

Decision Gate 3 — Variability

How much do consumption and delivery times vary?

Decision Gate 4 — Criticality

How much are operations affected if the product runs out?

Decision Gate 5 — Safety Stock

Is there enough buffer for uncertainty?

Decision Gate 6 — Reorder Point

Is it clear at which level the order will be triggered?

Decision Gate 7 — Maximum

Is there an upper limit that prevents excess stock?

Decision Gate 8 — Shelf Life

If the product rises to the maximum stock level, can it be consumed in time?

Decision Gate 9 — Finance

How much working capital is tied up in this stock?

Decision Gate 10 — Forecast

Are future occupancy and operating volume included in the calculation?

When these ten questions are answered, the stock level:

stops being a guess and becomes a management decision.

Minimum–Maximum Stock Checklist

• ☐ The SKU of every product is defined.
• ☐ The unit of measure is clear.
• ☐ Average daily consumption has been calculated.
• ☐ Average monthly consumption has been calculated.
• ☐ Real lead time has been measured.
• ☐ Lead time variability has been examined.
• ☐ The product criticality class has been determined.
• ☐ Safety stock has been determined.
• ☐ Minimum stock has been calculated.
• ☐ Maximum stock has been determined.
• ☐ The reorder point has been defined.
• ☐ The order quantity method has been defined.
• ☐ Par stock has been defined where needed.
• ☐ Open orders are visible in the system.
• ☐ Pack/carton size is taken into account.
• ☐ MOQ is checked.
• ☐ The expiry date is taken into account.
• ☐ FIFO/FEFO is applied.
• ☐ Warehouse capacity is checked.
• ☐ Stock cost is monitored.
• ☐ The occupancy forecast is used.
• ☐ Seasonal changes are taken into account.
• ☐ Stockouts are reported.
• ☐ Overstock is reported.
• ☐ Emergency purchases are reported.
• ☐ Minimum–maximum values are updated periodically.

The Complete Formula of the System

If we reduce hotel stock management to a simple chain:

Measure Real Consumption → Measure Lead Time → Determine the Product's Criticality → Determine Safety Stock → Calculate Minimum Stock → Determine the Reorder Point → Determine Maximum Stock → Calculate the Order Quantity → Check Open Orders → Check the Occupancy Forecast → Check Shelf Life and Warehouse Capacity → Place the Order → Measure Real Consumption Again → Update the Minimum–Maximum Levels

In this way, the stock system stops being a static Excel sheet.

It becomes a living operational system.

Conclusion

In hotel stock management, the right question is not:

“Is there enough product in the warehouse?”

The right question should be:

“Is there enough product to keep operations running safely, and am I tying up more capital in the warehouse than necessary?”

Minimum stock:

defines your lower safety limit.

Maximum stock:

limits unnecessary stock build-up.

Safety stock:

creates a buffer against uncertainties.

The Reorder Point:

tells you when to place an order.

And the order quantity:

determines how much you need to buy.

But none of these are fixed numbers.

Consumption changes.

Occupancy changes.

The season changes.

The supplier changes.

Lead time changes.

Prices change.

That is why the basic principle of good stock management is this:

The best stock system is not the one that stores the most products; it is the one that manages the least stock necessary without disrupting operations.

In short:

Right Stock = Consumption + Lead Time + Safety Stock + Operational Criticality + Forecast + Cost Control

Hotel Investment Guide — Volume IV: Procurement & Equipment

From the minimum–maximum stock system to par stock management, from reorder levels to critical stock control, and through FIFO/FEFO, counting, stock reconciliation, inventory turnover, and warehouse cost management, I cover the entire hotel stock system in more detail in Hotel Investment Guide — Volume IV: Procurement & Equipment.