A hotel's inventory is three kinds of stock that behave differently, and one list has to hold all of them. Linen isn't used up: it circulates between the bed, the laundry and the shelf, wears out slowly, and is kept to a par, a fixed number of sets for each bed. Guest amenities and supplies are used up at a steady rate for each occupied room: soap, shampoo, coffee, paper. And food and drink, for breakfast and the minibar, has dates. A hotel inventory list gives every item a row with its department, what's on hand, what it cost and a level to reorder at. For linen that level is the par itself. Below is a list for a made-up 60-room inn, how the levels are set, and the file.
The short version
- One list, with the department in a column: linen, amenities, minibar, breakfast, laundry.
- Linen par = beds × sets for each bed. This inn holds three: one on, one in the wash, one on the shelf.
- Count linen when the laundry is caught up, or count all three places.
- Amenities: reorder level = room-nights while you wait for delivery × use a night.
- Breakfast and minibar stock get dates.
- Most of the money is in the linen room.
- TaroStack keeps stock by place and counts it on a phone. More below.
An example list
| Item | Department | Unit | On hand | Reorder at | Unit cost | Value | Status |
|---|---|---|---|---|---|---|---|
| Sheet set, queen | Linen | set | 288 | 300 | $22.00 | $6,336.00 | REORDER |
| Bath towel | Linen | each | 380 | 360 | $6.50 | $2,470.00 | OK |
| Shampoo, 1 oz | Guest amenities | each | 900 | 600 | $0.28 | $252.00 | OK |
| Coffee pods | In-room coffee | each | 1,400 | 900 | $0.31 | $434.00 | OK |
| Bottled water, 16.9 oz | Minibar | each | 260 | 240 | $0.45 | $117.00 | OK |
| Eggs, large | Breakfast | dozen | 30 | 20 | $2.90 | $87.00 | OK |
Ten rows in all, $10,475.60 at cost, with one flag: queen sheet sets. Linen is $8,806 of it, 84%.
Linen par
A par is how many sets you hold for each bed. This inn keeps three: one on the bed, one in the laundry, one clean on the shelf.
| Beds | Par for each | Par | On hand | Short | |
|---|---|---|---|---|---|
| Queen sheet sets | 100 | 3 | 300 | 288 | 12 |
| Bath towels (2 a room, 60 rooms) | 120 | 3 | 360 | 380 |
The sheet's reorder level for linen is the par, so any shortfall shows. Twelve sets short of 300 doesn't matter on a quiet Tuesday. On a full Saturday, with every bed changed and Friday's linen still in the dryers, it's twelve beds with nothing to put on them.
Counting linen is the hard part, because it's always in three places. Either count on the one morning the laundry is fully caught up, or count all three: on beds (rooms made up × sets), in the laundry, on the shelf.
Wear. Linen leaves the count by wearing out, staining and walking off. Mark each new batch with the month it went into service, on the hem, and write off what's pulled with the reason. After a year you'll know how long a sheet lasts in your laundry, which is the number the linen budget comes from.
Amenities by room-night
| Rooms | 60 |
| Occupancy this season | 70% |
| Room-nights a week | 294 |
| Shampoo used a room-night | 1 |
| Supplier takes | 2 weeks |
| Used while waiting | 588 |
| Reorder at | 600 |
The sum is the same for soap, coffee pods and paper: what one occupied room uses in a night, times the room-nights you expect before the delivery arrives. The level moves with the season. At 95% occupancy in summer, two weeks is nearly 800 room-nights, and 600 is too low.
Food and drink
| Received | Item | Quantity | Use by |
|---|---|---|---|
| Nov 16 | Eggs, large | 30 dozen | Dec 7 |
| Nov 18 | Orange juice | 12 gal | Nov 28 |
| Sep 2 | Bottled water | 480 | Sep 2 next year |
Breakfast stock is bought twice a week and dated like any kitchen's. The dates here are this inn's own. The minibar is small money that leaks: restock from a list for each room, and compare what was put in with what was charged. Kitchen stock is covered in walk-in cooler inventory sheet, food safety in HACCP plan for a hotel kitchen, and setting levels in general in reorder point example.
Get the list
Download the hotel inventory list. Four sheets: inventory with department, value and REORDER; deliveries with days left; a count sheet that works out each difference and what it's worth; and a read-me. It's an ordinary Excel file with no macros, and it works in Google Sheets, LibreOffice and Numbers.
Where this stops working
There are five store rooms: linen, housekeeping, the minibar cupboard, the kitchen and the laundry. Each has its own keeper and its own idea of what's there. The list is one spreadsheet on the manager's computer, updated when someone remembers to send a count. The Saturday the sheets ran short, the sheet said 300.
How TaroStack does it
TaroStack keeps each store room as its own place, counted by the people who work in it.
Stock is held by location. The linen room, the housekeeping store and the kitchen each have their own count.
Counting works on a phone, with no signal, in a basement store. A count shows what a difference is worth.
A reorder list in days of cover, with each supplier's lead time, and reorder points suggested from how fast things really go.
Every adjustment carries a reason, so linen written off as worn, stained or missing is a number.
Each delivery of food is a lot with its use-by, and an alert comes before a date arrives.
| The job | One spreadsheet | In TaroStack |
|---|---|---|
| What's in each store room | Whoever last emailed a count | Stock by location |
| Linen written off this year | Unknown | Adjustments by reason |
| When to reorder shampoo | A level set once | Days of cover, from real use |
| Breakfast stock near its date | Read the labels | An alert |
TaroStack doesn't track which room has which linen, run the laundry or post minibar charges. Stock, counts and reordering are on every plan, from $9.99 a month. The first 14 days are free, with no credit card. If you'd like a hand setting up, ask, and we'll do it with you.
