Please help with part 2b Budget Variances. And please include all formulas that were used in excel! Thank you

Perl References ABC 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% cat 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. es 07 English MacBook Air 988 4 1 4 3 $ 4 % 5 A 6 * 8 2 7 9 0 W O E R T Y U I P A S D F G H J KL ; Design Laul References Mailings Share The New CD Aalbo 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 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 1 13 GOTwo English (United States MacBook Air 888 4 110 W # 3 $ 4 + % 5 2 & 7 * 8 6 9 0 Q W E R T YU I Excel file Edit View Insert Format Tools Data AutoSave GO Window Help Problem 2 Review View Tell me Home Insert Draw Page Layout Formulas Data Calibri Body! 14 A A bwa Gener - Merpe & Center $ % 9 22 Con A10 Occupancy B D E G M Budgeting Revenue & Cost of Sales of Cena: R130 per room "120 rooms: person Number of people Breakfast Lunch Dinner 95 75 30 Oca 11 check $17.50 ting 15 Budgeting $45.00 Total SOS 19 Food.com to and cost Part Part tv MacBook Air esc so ODD FI F2 F3 G004 FS 67 A 2 # 3 $ 4 % 5 & 7 6 &