calculate the ADR, Total food and beverage Revenue, Total Revenues, dollar change for room revenue-actual to budget and last year,percentage change in room revenue_actual to budget and last year Dollar and percentage for rooms sold, occupancy percentage and sales mix percentages for room revenues, total & beverage revenue, and gift shop.

course: accounting

COURSE: Financial Accounting

5:26 Homework Assignm...t 1 Mix of Business - Saved K : fx B D E Actual Budget Last Year Dolla Chang Budge 2 WN 3 Room Revenue $720,000 $670,000 $700,000 $500,000 4. Room Profit $615,000 $470,000 5 Average Room Rate 6 Rooms Sold 10,300 10,000 9,900 7 Occupancy Percent 83.10% 79.80% 8 Restaurant Revenue $129,000 $ 136,000 $52.000 80.10% $132,000 $54,000 $275,000 9 $47,000 10 $260,000 $255,000 Beverage Revenue Catering Revenue Total Food & Beverage Revenue Gift Shop Revenue 11 12 $23,000 $22,000 $21,000 Total Revenues 13 14 15 16 Calculate the following 17 ADR, Total Food and Baverage Revenue, Dollar change for room revenueactual to Percentage change in room revenue actu Dollar and percentage change for rooms sc Sales mix percentages for room revenues, 18 19 20 21 22 23 Homework Assignm...t 1 Mix of Business - Saved so fx E F G H VUVITU Dollar Change Budget Dollar Change Last Year Per Cnet Change to Budget Per Cent Change to Last Year e Mix Per Cent P Actual 2. 3 4 5 6 7 8 9 10 11 12 13 14 15 venue, Total Revenues 16 Ictual to budget and last year 17 le-actual to budget and last year 18 ooms sold, occupancy percentage, and average rate - actual to 19 venues, total food & beverage revenue, and gift shop to Actual, 20 21 22 23 24 25 26 27 28 29 fx E F G H Dollar Change Budget Dollar Change Last Year Per Cnet Change to Budget Per Cent Change to Last Year e Mix Per CentP Actual E 2 3 4 5 6 7 8 9 10 11 12 13 14 15 venue, Total Revenues 16 ictual to budget and last year 17 le actual to budget and last year 18 ooms sold, occupancy percentage, and average rate - actual to 19 yenues, total food & beverage revenue, and gift shop to Actual, 20 21 22 23 24 25 26 fx B D E F G H 1 Actual Budget Last Year Dollar Change Budget Dollar Change Last Year Per Cnet Change to Budget Per Cent Change to Last Year Revenu Revenu e Mix e Mix Per Per Cent Cent Actual Budget Revenu e Mix Per Cent Last VA 2 3 3 4 5 6 7 8 Boom.Renne Amazon Sam Room Draft + SAE como samo Average Room Rate Rooms Sald A2 40.000 PRAA Occupancy Percent 83.10% 80.10% 79.80% Restaurant Revenue 26.000 22.000 Beverane Revenue on ASA2.000 CEA Catering Revenue casa con 7.200 Saec. Total Food & BGP et Shan Renaue Space 2.000 Total Revenues 9 10 11 12 Calculate the frain ADR, Total Food and Baverage Revenue, Total Revenues Dollar change for room revenue-actual to budget and last year Percentage change in room revenue actual to budget and last year Dollar and percentage change for rooms sold, occupancy percentage, and average rate - actual to budget and last year Sales mix percentages for room revenues, total food & beverage revenue, and gift shop to Actual, Budget and Last Year & of 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54