Please Help

Summary Operating Statement Please complete the vertical and horizontal analysis, use formulas in Excel, DO NOT type in the figures. Current Period Actual Forecast/Budget Variance to Budget % $ % % Operating Revenue Rooms 1,124,350 1,136,692 Food and Beverage 500,025 186,531 Other Operated Departments 67,800 58,462 Miscellaneous Income 56,500 53,751 Total Operating Revenue 1,748,675 1,745,436 Departmental Expenses Rooms 292,331 298,950 Food and Beverage 365,018 354,168 Other Operated Departments 54,240 54,290 Total Departmental Expenses 711,589 707,408 Total Departmental Profit 1,037,086 1,038,028 Undistributed Operating Expenses Administrative and General 134,648 141,380 Information and Telecommunications Systems 52,460 24,436 Sales and Marketing 148,637 162,326 Property Operation and Maintenance 52,460 50,618 Utilities 69,947 78,545 Total Undistributed Expenses 458,152 457,305 Gross Operating Profit 578,934 580,723 Management Fees 52,460 52,363 Income Before Non-Operating Income and Expenses 526,474 528,360 Non-Operating Income and Expenses Income 20,000) (500) Rent 15,000 15,000 Property and Other Taxes 26,418 30,145 nsurance 28,125 25,875 Other 1,000) 500 Total Non-Operating Income and Expenses 48,543 71,020 Earnings Before Interest, Taxes, Depreciation, and Amortization 477,931 457,340 Replacement Reserve 87,434 87,272 EBITDA Less Replacement Reserve 390,497 370,068