Our bar tends to have an understocking issue. Generally this isn't a problem, but sometimes we will have cooperate groups that come in and clean out our bar in one night, which we only have alcohol shipped in once a week. The best solution to the problem would be to check with the expected hotel occupancy and our sales department to see what corporate groups are coming in that week so that we can estimate what weeks to order additional alcohol in addition to our standard orders. 

One problem I discovered in addition to the understocking issue was a lack of familiarity with the alcohol brands that we sell. I created a spreadsheet that has every alcohol organized by type and additional information for each one that we sell so that those not familiar can have a quick reference to use and to study from.