please help witb part 2!

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. Hint: You need to calculate number of estimated guests to calculate the revenue figures. First figure out volumes and then figure out guests based on the information provided. Part 2b: Budget Variances Assume the following were the actual results for June. calculate the revenue variances for all English (United States) O Focus vords sign Layout References Mailings Review View 12 ' AO E AL ADA E DE Styles Styles Pane Dictate Sens Hint: You need to calculate number of estimated guests to calculate the revenue figures. First figure out volumes and then figure out guests based on the information provided. Part 2b: Budget Variances Assume the following were the actual results for June, calculate the revenue variances for all three meal periods and the cost of sales variance for all three meal periods. Use the formulas discussed in the lectures and show all your work. Use an Excel Worksheet to do so. Meal Period Revenue Guests Cost of Sales Breakfast $150,000 10,000 $22,500 Lunch $56,000 3,500 $11,200 Dinner $186,300 8,100 $52,164