Tags | |
The Guest Count Forecasting calculator estimates the guest count based on last years guest count and the predicted percent increase.
INSTRUCTIONS: Enter the following:
- (LY) Guest Count Last Year
- (IE) Expected Change from Last Year
Guest Count Forecast (GCF): The calculator returns the estimated guest count for this year.
The Math / Science
The formula for the Guest Count Forecast is:
GCF = LY + (LY • IE)
where:
- GCF = Guest Count Forecast
- LY = Guests Last Year during the same period
- IE = Percent Expected Increase or Decrease
Guest Count Forecasting is the process of a company predicting what its future guest count will be. This forecast is done for a particular period of a time in the near future, usually the next fiscal year.
Hospitality Calculators
- Average Cost per Room - Average expense per room for a period of time.
- Average Daily Rate - Average daily income rate for rooms rented
- Average Sales per Guest Forecast - Forecast based on total forecast and guest count forecast.
- Break-Even Point in Guests Served - Computes the number of guests needed to break even based on fixed costs and margin per guest.
- Contribution Margin per Guest - Computes the margin per guest based on selling price per guest and variable cost per guest.
- Contribution Marge Percent - Computes the percent of contribution margin based on the Selling Price percent and the Variable Cost percent.
- Cost of Food Consumed - Computes the cost of food based on inventory change and purchases.
- Estimated Room Expenses - Computes the estimated annual expense of rooms based on the expense per room and number of rooms.
- Food Cost Percent for a Restaurant - Computes the percent of costs associated with food for a restaurant.
- Food Selling Price - Computes selling price based on Item Food Cost and percent allocated to food commodity.
- GOPPAR - Gross Operating Profit Per Available Room - Computes the profit based on the gross profit and the total rooms available.
- Guest Count Forecast - Guest count forecast based on last year's and an expected increase.
- Percent Sales Variance - Computes the percentage of the difference in sales in two periods.
Resource:
- Dopson, Lea R., and David K. Hayes. Managerial Accounting for the Hospitality Industry. Hoboken, NJ: Wiley, 2009. Print.
- "Sales Forecasting Definition - at TrackMaven.com." TrackMaven. N.p., n.d. Web. 08 Aug. 2015.