Hotel amenities purchasing becomes unreliable when a buyer orders from room count alone. A 100-room hotel does not consume 100 dental kits every day, and two properties with the same room count can use very different quantities because occupancy, average stay, room type and replenishment policy differ.
This guide shows a practical way to convert a 90-day operating forecast into an order by stock-keeping unit (SKU). The figures are an illustrative planning example, not a supplier quotation or a promise of actual consumption. Replace every assumption with your property data and confirm the supplier’s minimum order quantity, case pack, production lead time and packaging specification before placing an order.
1. Separate the demand drivers
Start by deciding what event causes each item to be issued. Three different units are commonly useful:
- Occupied room-night: one occupied room for one night. Use this for products replaced according to a daily room policy.
- Room arrival: the beginning of one occupied stay. Use this for a sealed welcome kit issued once per check-in.
- Guest-night or guest arrival: one guest for one night or one arriving guest. Use this only when the product policy depends on the number of people, rather than the number of rooms.
Do not use these units interchangeably. A three-night stay creates three occupied room-nights but only one room arrival. Record the issue rule beside every SKU before calculating quantity.
2. Build the 90-day room forecast
Forecast each room type separately. The core calculation is:
Occupied room-nights = available rooms × planning days × forecast occupancy
For arrival-based items, divide occupied room-nights by the expected average length of stay:
Expected room arrivals = occupied room-nights ÷ average stay
Round at the SKU stage, after all relevant room types have been calculated. Keep the unrounded figures in the worksheet so a small rounding difference is not repeated across many lines.
3. Worked example for a 100-room property
Assume a hotel has 80 standard rooms and 20 suites. Management is planning for 90 days and uses the following internal forecast:
| Room type | Rooms | Forecast occupancy | Occupied room-nights | Average stay | Expected arrivals |
|---|---|---|---|---|---|
| Standard | 80 | 72% | 80 × 90 × 0.72 = 5,184 | 3 nights | 5,184 ÷ 3 = 1,728 |
| Suite | 20 | 60% | 20 × 90 × 0.60 = 1,080 | 3 nights | 1,080 ÷ 3 = 360 |
| Total | 100 | — | 6,264 | — | 2,088 |
This calculation does not yet produce a purchase order. It only supplies the demand units. The next step is to map each SKU to a room policy.
4. Convert room activity into SKU demand
For this example, assume the property uses these operating rules:
- One standard dental kit per standard-room arrival.
- Two suite dental kits per suite arrival.
- One 30 ml shampoo bottle per occupied standard room-night and two per occupied suite room-night.
- One pair of slippers per standard-room arrival and two pairs per suite arrival.
| SKU | Base calculation | Base demand | After 8% operating allowance |
|---|---|---|---|
| Standard dental kit | 1,728 arrivals × 1 | 1,728 | 1,867 |
| Suite dental kit | 360 arrivals × 2 | 720 | 778 |
| 30 ml shampoo | (5,184 × 1) + (1,080 × 2) | 7,344 | 7,932 |
| Slippers | (1,728 × 1) + (360 × 2) | 2,448 pairs | 2,644 pairs |
The 8% allowance is a management assumption for this example. It is not a universal hotel benchmark. A property should set and review its own allowance using recorded replacement, handling and demand variance. Do not add another percentage for the same risk under a different label.
5. Deduct usable stock, then round to supplier packs
Count only stock that is usable for the coming period. Exclude damaged cartons, discontinued branding, expired products and stock reserved for another property. Deduct confirmed inbound stock only when its specification and arrival timing match the plan.
Net requirement = forecast demand with allowance − usable opening stock − confirmed suitable inbound stock
Then round the net requirement up to the supplier’s confirmed case pack. The following case sizes are illustrative only:
| SKU | Forecast with allowance | Usable opening stock | Net requirement | Illustrative case pack | Rounded order |
|---|---|---|---|---|---|
| Standard dental kit | 1,867 | 300 | 1,567 | 200 | 8 cases = 1,600 |
| Suite dental kit | 778 | 100 | 678 | 100 | 7 cases = 700 |
| 30 ml shampoo | 7,932 | 900 | 7,032 | 240 | 30 cases = 7,200 |
| Slippers | 2,644 pairs | 400 pairs | 2,244 pairs | 100 pairs | 23 cases = 2,300 pairs |
Case rounding creates a small residual quantity. Carry that residual into the next planning cycle instead of treating it as unexplained surplus.
6. Keep the purchase quantity separate from the reorder point
A 90-day purchase quantity answers “how much should we obtain for this plan?” A reorder point answers “when should we start the next replenishment?” They are related but are not the same calculation.
A simple internal trigger can be expressed as expected consumption during the confirmed replenishment lead time plus a defined safety quantity. The buyer should document what the quoted lead time covers: artwork approval, sample approval, production, packing, origin handling, transport and receiving. Use the parts that actually apply to the ordering decision, and review the trigger whenever demand or lead time changes.
7. Split the worksheet by room type, pack and version
Two items with the same product name should remain separate SKUs when their specification, branding, size, language, carton marking or room allocation differs. A suite dental kit should not be merged with a standard kit merely because both contain a toothbrush. Record the approved sample or artwork version beside each line so the replenishment order does not silently restore an obsolete pack.
For mixed properties, add fields for hotel, room class, outlet or spa, guest policy and storage location. This makes it possible to consolidate purchasing without losing the reason each quantity exists.
8. Buyer checklist before requesting quotations
- Planning start and end dates are fixed.
- Room inventory, occupancy and average-stay assumptions are recorded by room type.
- Every SKU has a clear issue rule based on room, arrival, guest or another measurable event.
- Welcome stock and daily replenishment stock are not counted twice.
- Operating allowance has a stated purpose and is not duplicated by another buffer.
- Opening stock is usable, correctly branded and available to this property.
- Inbound stock is deducted only when specification and arrival timing are confirmed.
- Supplier case packs, MOQ, sample costs, artwork requirements and production lead time are confirmed in writing.
- Product, inner-pack and shipping-carton versions are identified.
- Destination-specific product and label requirements are checked with the appropriate qualified party before approval.
9. Prepare a quotation that can be compared
Send suppliers the same SKU schedule, packaging brief and delivery boundary. Ask each bidder to separate confirmed items from assumptions and pending information. The MOEWORLDWIDE China import quotation checklist provides a structure for comparing specifications, inspection scope, shipping terms and exclusions.
Explore hotel amenities and hospitality supplies from China, or review the full China sourcing and export service directory. To request a supplier search or quotation review, send the product list, quantities, branding requirements and destination.
This guide is a purchasing-planning aid. Actual consumption, product suitability, regulatory requirements, supplier terms and shipment timing require property-specific and destination-specific confirmation.
