The Hotel Supply Problem Nobody Talks About (Until Guests Start Complaining)
I was brought in to look at operations for a multi-property hotel brand. The kind of properties that appeared to have their hotel supply management system in place. Purchasing and inventory software, vendor contracts, and a housekeeping team that knew what they were doing. On paper, everything was in order.
Then I started pulling the thread.
Guest complaints were coming in about inconsistent amenities. Different soap brands across rooms on the same floor. One coffee packet instead of two. No sugar packets. Wrong shower gel. A guest in room 104 getting a different experience than the guest in room 108; same night, same floor, same rate.
That is not a housekeeping service problem. That is a supply system problem.
When I went deeper, I found stock stashed on every floor “for convenience.” Unclassified, untracked, and unaccounted for items everywhere. Emergency purchases happening weekly because nobody saw the shortage coming. Overstocking in some areas while other items ran out mid-shift. Thousands of dollars bleeding out quietly, not from one big mistake, but from a system that looked controlled and wasn’t.
How I Got Here
During my school days, everyone around me said the same thing: “Danilo, you’re really good with numbers.” So naturally, and pushed by Mom and Dad, I signed up for accounting classes. That lasted about one semester…Yep, I quit. I walked away feeling like I wasn’t the numbers guy everyone said I was.
Then I started in hospitality. And later in there, I discovered process improvement, and numbers took on a completely different life.
I am not an accountant. I never will be. But like many of us, on the floor, numbers make sense to me in a way they never did in a classroom. How many rooms are turning today, how many nights we sold this week, or how much product moved through this floor. That is operational math, and it is something any operator can learn regardless of whether you have ever taken a financial class before.
That is exactly why I built what I am about to show you.
The Real Problem With Hotel Supply Management
Most properties think they have a system because they have a vendor and a purchase order. Some have inventory software. Some have both; however, they are still losing money.
The problem is not the tools. The problem is that many hotels manage their supplies as one undifferentiated pile. Ordered, received, stored, and consumed with no real visibility into what is happening at the room level. Most operators are not tracking how much product is actually moving. The drift goes unnoticed until the budget meeting at the end of the month.
By then the damage is done.
What I found at that brand was not a purchasing failure. It was a visibility failure. Unclassified stock scattered everywhere, no consumption data, and a team doing their best with a system nobody built for control.
The Number Nobody Is Tracking: Daily Consumption Rate
Everything starts here. Before you can forecast, before you can purchase intelligently, before you can catch a potentially expensive problem, you need to know how much of each item your property actually consumes per night.
This is your daily consumption rate. And most properties have no idea what it is.
There are two ways to calculate it depending on the type of supply.
For individually placed guest supplies (Individual Items)
Toilet paper, amenities, coffee packets, cups. The calculation is based on two things: nights sold and how much of each item is left after checkout. What was placed minus what came back tells you exactly what was consumed.
Track that over time and you have your consumption rate. From there you project forward based on your nights sold forecast.
For common use and cleaning supplies (Common Items)
Floor cleaner, bathroom disinfectant, glass cleaner. The calculation works differently because these items are not placed per room. They are consumed based on how much cleaning your team is doing, which means occupancy drives the number.
Here is the concept. You look back at a previous month, note how many bottles you used and what your average occupancy was that month. That gives you your baseline consumption at that occupancy level. From there you can project forward, so if occupancy goes up, consumption goes up proportionally. If it drops, you buy less.
The key is having at least one month of real tracked data to work from. If you are starting from zero, estimate conservatively your first month, track actual usage, and by month two you have a real baseline. From that point the system self-corrects as your data gets cleaner.
Nobody taught me this formula. I took the same logic the industry uses for revenue forecasting and applied it to supply consumption at the floor level. The result was something simple enough for any operator to run without software, a finance team, or a hospitality degree.
And honestly, most operators are already thinking this way. Twenty checkouts today, bring twenty towels. That instinct is right. What the formula does is take that thought out of your head and put it into a system that runs consistently whether you are there or not.
The OSTRO™ Framework: How I Built the System
Observe
I mapped the supply flow from receiving to the rooms. Where was stock landing. How was it being distributed. Who was making purchasing decisions and based on what information.
What I found confirmed what the guest complaints were already telling me. Unclassified stock everywhere. No consumption tracking. No standard. Many supplies were different brand and quality, and whoever restocked that floor grabbed whatever was available. There was no system telling them what the standard was or whether it was in stock.
Strategize
The first move was counting and organization. I counted whatever I had in storages and closets. Then I separated all supplies into three sets (In Rooms, In Rotation, and In Storage) and three operational categories (Guest Supplies, Cleaning Supplies, and Operating Supplies). Not for the financial statement but for the floor, so that every person on the housekeeping team could walk into a storage area and immediately know what was where and what they were working with.
|
Set |
Contents |
|---|---|
|
In Rooms |
Items currently placed or in active use in guest rooms |
|
In Rotation |
Items in floor closets and carts, ready for immediate use |
|
In Storage |
Items in main storage or receiving, not yet distributed |
|
Category |
Description |
|---|---|
|
Guest Supplies |
Consumable items placed in the room for each stay. Toilet paper, amenities, coffee packets, cups, sugar packets, shower gel. Anything the guest uses and you replenish at turnover |
|
Cleaning Supplies |
Everything used to clean the property. Chemicals, disinfectants, glass cleaner, floor cleaner, gloves, mops, brushes, vacuums. Consumed by use, not by room placement. |
|
Operating Supplies |
Reusable items that support the housekeeping operation. Irons, ironing boards, alarm clocks, hangers. Not consumed, but tracked and maintained. |
The second move was standardization. Same toilet paper brand across every room. Same soap, same amenities, same coffee setup. This alone eliminated the inconsistency complaints before we even touched the inventory numbers. When everything is the same, there is nothing to mix up.
The third move was building an inventory system in Excel incorporating consumption rates for every item using the method above, and turning those rates into a monthly purchasing forecast by supply category. More on this Excel file later.
Test
During this phase something we tested for about 21 days, and it became clear two things. The forecast told us what to buy, but we had no real-time feedback on what was actually being consumed day to day. That gap led to the development of a daily requisition process that closes the loop completely. I will cover that in a separate article.
Review and Operate
Once the system was running, we built a maintenance structure to keep it from drifting:
– Daily consumption rate adjustments as patterns changed – Weekly forecast check against actual usage – Monthly soft inventory count – Quarterly full physical inventory
Without this layer the system works for ninety days and then slowly goes back to what it was before. The review structure is what keeps it honest.
The same discipline needs to be applied to your linen and terry operation. If you have not set up your linen PAR levels yet, read this first: How to Calculate Your Hotel Linen PAR Levels and Fix Them Before They Fix You . A system without that foundation is only half built.
In my case, after running the system successfully for a month, one floor became the full property. The full property became five more hotels. Five hotels became a brand standard that is still running today.
A system built for the floor, operated by housekeeping teams.
How to Make It Work for Your Property
You do not need a purchasing department, an expensive software, or an accounting degree, trust me on that last one.
You need to know your consumption rates and standardized items so your team is always working with the same product. A monthly forecast built from actual data and a review cycle that keeps the system calibrated. All of that is handled in one Excel file.
I built this tool in two versions: a simple monthly tracker and a fully connected ops system. Both are field-tested and ready to turn guesswork into decisions.
Supply Inventory Tracker: A structured monthly tracking sheet. Enter your counts, your DCR, and your nights sold. See your monthly need by item. Free for subscribers in The Back Office, our operator resource library.
We also have Hotel Ops Supply Inventory System – $49.99 ,a fully connected system with multiple tabs. Property Setup, Inventory Tracker, Purchase Matrix, and Storage Locations all talking to each other automatically. Enter your data once and the system does the rest.
Final Thoughts
The guest who complained about the wrong soap was not being difficult. They were telling you that your supply system had no standard. That is the kind of feedback that costs you a five-star review, and it is completely preventable.
Preventable by developing and implementing the right system. Here is how:
Following the OSTRO™ Framework systematically, observing where control breaks down, strategizing your categorization and standardization based on your consumption rate, testing small and tracking it, then reviewing and operating while adjusting as you go. Like we say… fixing the plane while flying.
Fixing your supply inventory management is not a fast turnaround. When you are starting without historical data, month one is your baseline. Month two is your first real read. By month three the system starts working for you. Give it that time and it will run on its own.
The tools to get there are waiting for you in The Back Office. If you are not a member yet, join free and get access to resources built for operators like you. If you are already a member, go in and explore. New tools are added regularly, including the Hotel Ops Supply Inventory System.
Danilo,
