Guide

How to forecast amenity consumption per room night

Forecast amenity consumption by multiplying expected occupied room nights by a measured usage rate for each item, then adjusting for guests per room, length of stay and seasonality. A forecast built this way can be checked against stock counts and corrected, unlike a forecast copied from last year's orders.

By Hemang Jain, Founder, Anadoris

What is a usage rate?

A usage rate is the number of units, or the quantity in millilitres, consumed per occupied room night for one item. It is the single most important input in amenity planning. It varies by room type, guest mix, stay length and housekeeping practice, so it should come from your own property rather than a general rule.

Define the unit clearly. For miniatures, a unit is a bottle. For dispensers, measure millilitres, then convert to refill packs.

How to measure usage rates

  1. Count opening stock for each item.
  2. Record every delivery received during the period.
  3. Count closing stock at the end of the period.
  4. Consumption equals opening stock plus deliveries minus closing stock.
  5. Divide consumption by occupied room nights in the same period.

Use a period long enough to smooth out irregular deliveries. If you track issues from stores to floors, issues per room night is an easier proxy, though it includes items sitting on trolleys.

Measure each room type separately where the standard differs. A suite with a larger bottle and an extra lotion has a different usage rate from a standard room, and blending the two hides changes in the mix of rooms sold. Record the period, the room nights and the counting method beside each rate so the figure can be repeated and compared later.

STAY by Anadoris hospitality concept: rainforest sanctuary
Rainforest sanctuary

The forecast formula

For each item and each period:

Forecast units = R × U × S

  • R is forecast occupied room nights from the sales plan.
  • U is the measured usage rate per room night.
  • S is a seasonal or segment adjustment, equal to one when the period is typical.

For items handed to each guest, such as slippers or dental kits, replace R with guest nights, which is R multiplied by average guests per occupied room.

Adjusting for stay length and guest mix

Stay length changes usage in two directions. Longer stays tend to lower usage per night for items replaced on checkout, because one unit covers several nights. They can raise it for items guests use in larger quantities every night, such as body wash for families. Split R by segment where patterns differ, such as business, leisure, groups and long stays, and give each its own U.

SegmentRoom nightsUsage rateForecast
BusinessR(b)U(b)R(b) × U(b)
LeisureR(l)U(l)R(l) × U(l)
GroupsR(g)U(g)R(g) × U(g)
Long stayR(s)U(s)R(s) × U(s)
TotalSum of R—Sum of forecasts

How accurate does the forecast need to be?

It needs to be accurate enough to set order quantities and safety stock without running out or overbuying. Track forecast error each period: actual consumption minus forecast, divided by forecast. If the error is consistently in one direction, adjust U. If it swings both ways, look at the room night forecast or at how stock is counted. A forecast that is checked and corrected every period becomes reliable quickly.

Watch for one-off events that distort a period, such as a large group with its own amenity arrangement, a refurbishment closing a floor, or a stock count missed. Note them beside the figures and exclude them when updating the usage rate, or the forecast will learn from an exception.

STAY by Anadoris concept: powder blue slim tubes in a limestone vanity, lake and snowy peaks
Swiss lakeside hotel

Using the forecast

  • Set order quantities and timing from forecast consumption.
  • Set par levels for floors and trolleys; see par levels and reorder points.
  • Phase the budget across the year.
  • Brief your supplier on expected annual volume so they can plan production.

Sharing your annual forecast with STAY through the procurement page helps schedule production runs ahead of your peak periods.

Questions on this topic

Can I use purchase invoices instead of stock counts?

Only over long periods. Purchases lag consumption, so short-period figures will be distorted.

How often should usage rates be updated?

Whenever the room standard, replacement rule or guest mix changes, and at least once a year.

What if I have no history at all?

Start with a short measured trial in a sample of rooms, then refine the rate as data builds up.

Keep reading

Ready when you are

Tell us about your space. We will send samples.

CallRequest samples