Spring 125% v EE View Zoom Add Category Pivot Table Insert Table Ch Sheet1 Name Question #3 worth 25 points Please create a vertical and horizontal analysisto evaluate the performance Please address the differences in budget and make recommendations to address the issue Budget Performance Variance Variance % Regent Hotel Year 2022 Rooms 450 450 Occupancy % 75% 69% ADR $147.50 $140 Revenue Allowances $1,500 $7,500 Total Revenue Costs & Expenses Salaries $ 900,000 850,000 Wages $ 4,250,000 4,500,000 Property Operations $ 125,000 175,000 Linen replacement $ 20,000 32,000 Admin & General 750,000 890,000 Marketing 40,000 25,000 Utility Costs 650,000 800,000 Rent $ 2,000,000 2,000,000 Insurance $ 75,000 75,000 Total Costs & Exp. Operating Income