Following are the financial results for January, 2004 Lumberjack Hotel:

Calculate the following:

a. Dollar change for room revenue, actual to budget and last year.

b. Percentage change in room revenue, actual to budget and last year.

c. Dollar and percentage change for rooms sold, occupancy percent and average rate-actual to budget and last year.

d. Sales mix percentages for room revenues, total food & beverage revenue, and gift shop revenue.

e. Sales mix percentages for restaurant, beverage, and catering revenues.

Transcribed Image Text:

Last Year Budget Actual $ 695,000 $ 500,000 $ 67.50 10,300 $680,000 $650,000 Room Revenue Room Profit $486,000 $ 68.00 $460,000 $ 65.66 Average Room Rate Rooms Sold 10,000 9,900 Occupancy Percent 83.1% 80.1% 79.8% $ 126,000 48,000 240,000 $ 414,000 $ 125,000 50,000 250,000 $ 425,000 $ 124,000 47,000 245.000 $ 416,000 Restaurant Revenue Beverage Revenue Catering Revenue Total Food & Beverage Revenue $ 22,000 $ 21,000 $ 23,000 Gift Shop Revenue $ 1,132,000 $ 1,127,000 $ 1,087,000 Total Revenues