whatsapp

Connect on Whatsapp : +1 206 673 2541, Uninterrupted Access 24x7, 100% Confidential. Connect Now

Calculate the budgeted dining room revenue and food cost dollars for the month.

Budgeting Revenues and Cost of Sales

A resort hotel has a dining room that has no business from street traffic; it is dependent solely on the occupancy of its rooms for its sales revenues. It has 150 rooms. During the month of June, it expects 80% occupancy of those rooms. Because the resort caters to families, there is on average three people per occupied room per night. From past experience, management knows that 95% of the people occupying a room eat breakfast, 25% eat lunch, and 75% eat dinner in the hotel’s dining room. The dining room is open seven days a week for all three meals. Its average meal prices and food cost percentages are:

 

Meal PeriodAverage Food CheckFood Cost %
Breakfast$14.5010%
Lunch$17.5020%
Dinner$22.6030%

 

Calculate the budgeted dining room revenue and food cost dollars for the month of June, show all your work. Please use an Excel Worksheet to do so.

Solution:

Looking for help with your homework?
Grab a 30% Discount and Get your paper done!

30% OFF
Turnitin Report
Formatting
Title Page
Citation
Place an Order

Calculate your paper price
Pages (550 words)
Approximate price: -