Part 2a: 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 Period Average Food Check Food Cost %
Breakfast $14.50 10%
Lunch $17.50 20%
Dinner $22.60 30%

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.

Found something interesting ?

• On-time delivery guarantee
• PhD-level professional writers
• Free Plagiarism Report

• 100% money-back guarantee
• Absolute Privacy & Confidentiality
• High Quality custom-written papers

Grab your Discount!

25% Coupon Code: SAVE25
get 25% !!