I need help with question 15. Thank you!

A resort hotel has 85 guest rooms and a small dining room with 50 seats. The hotel recorded the following information for the month of June. Room Revenue was $96, 508. A total of 1825 rooms were occupied. A total of 3480 guests are using the 1825 rooms occupied. Dining room food revenue was $50, 209 Dining room beverage revenue was $15, 500 The dining room serviced a total of 3900 guests Cost of Sales-Food was $19, 950 Cost of Sales-Beverage was $5205 Guest rooms labour costs were $23, 500 Dining room labour costs were $16, 900 (1) Average rate per room occupied (2) Rooms occupancy percentage (3) Room double occupancy percentage (4) Food Cost percentage (5) Beverage Cost percentage (6) Rooms Labour cost percentage (7) Dining room Labour cost percentage (8) Total average check, dining room (9) Dining room average daily seat turnover (10) Average monthly revenue per dining room seat (11) Beverage Sales Revenue to food sales revenue percentage (12) Total dining sales revenue to rooms sales revenue percentage (a) Complete a comparative horizontal analysis showing dollar changes and percentage of change (b) Complete a common size vertical analysis for the two months Budgeted vodka sales revenue from a vodka tasting function were 2,000 drinks at $7.50 each Actual sales were 2, 600 drinks at $7.30. Determine the price and sales volume variances. Prior to the Prime Minister's wedding for 500 people the Chateau Oris budgeted that one server would be required for every 10 people. The basic wage rate per hour is $8.95 and each server is expected to work an 8 hour shift. a) Calculate the budgeted payroll for the event. b) After the wedding records indicated the event actually required 425 hours of labour at a total cost of $4, 125. Analyze total payroll for cost and quantity variances