2 3 SUMMARY OPERATING STATEMENT THE COUGAR HOTEL FOR THE MONTH ENDING SEPTEMBER 30, 20X2 20x2 5 6 7 8 9 10 11 12 Current Period Budget S 20x1 Variance to Budget Variance to Prior Year 5 5 5 5 1 Operating Revenue Rooms Food and Beverage Other Operated Departments Miscellaneous Income Total Operating Revenue 1,174,351 500,025 67,800 56,500 1,798,676 1,136,694 486,531 68,462 53,751 1,745,438 1,122,196 480,981 67,140 52,189 1,722,506 13 14 15 16 17 18 19 20 21 22 23 Departmental Expenses Rooms Food and Beverage Other Operated Departments Total Departmental Expenses 305,992 365,018 54,240 724,650 319,430 355,168 54,290 728,888 307,000 954964 54,316 716,280 Total Departmental Profit 1,074,026 1,016,550 1,006,226 Undistributed Operating Expenses Administrative and General 25 161,811 157,042 155,293 TAB 1--SUMMARY OPERATING STMT TAB 2--ROOMS OPERATING SCHEDULE TAB 3 --ADMIN AND + . E F G H L M N o 24 25 25 27 28 D Undistributed Operating Expenses Administrative and General Information and Telecommunications Systems Sales and Marketing Property Operation and Maintenance Utilities Total Undistributed Expenses 161,811 52,460 148,637 52,460 69,947 485,315 157,042 24,436 162,326 50,618 78,545 472,967 155,293 25,838 179,140 74,068 77,513 511,852 30 31 32 33 Gross Operating Profit 588,711 543,583 494,374 Management Fees 53,960 52,363 51,675 Income Before Non-Operating Income and Expenses 534,751 491,220 442,699 35 35 37 38 39 40 Non-Operating Income and Expenses Income Rent Property and Other Taxes Insurance Other Total Non-Operating Income and Expenses (20,000) 15,000 26,418 28,125 (1.000) 48,543 (500) 15 000 30,145 25,875 500 71,020 (500) 14,500 28.708 22,229 (1.500 63,437 42 43 44 45 46 47 48 49 50 Earnings Before Interest, Taxes, Depreciation, and Amortization 486,208 420,200 379,262 Replacement Reserve 87,434 87,272 77,513 EBITDA Less Replacement Reserve TAB 1. SUMMARY OPERATING STMT 398,774 332,928 TAB 2--ROOMS OPERATING SCHEDULE 301,749 TAB 3 --ADMIN AND .. + Highlight the line item you will be analyzing in yellow. Answer the following questions: 1. What measurement did you use to justify that the line item selected required further analysis (i.e. was it the percentage increase, the dollar increase the change in proportions)? 2. What types of transactions or activities does this account represent? (Use the GHACP or your PowerPoints if you don't remember what is included in the line items). 3. What are the action items that the hotel should take in regard to improving or continuing the results found in this line item? 1 2 3 SUMMARY OPERATING STATEMENT THE COUGAR HOTEL FOR THE MONTH ENDING SEPTEMBER 30, 20X2 20x2 5 6 7 8 9 10 11 12 Current Period Budget S 20x1 Variance to Budget Variance to Prior Year 5 5 5 5 1 Operating Revenue Rooms Food and Beverage Other Operated Departments Miscellaneous Income Total Operating Revenue 1,174,351 500,025 67,800 56,500 1,798,676 1,136,694 486,531 68,462 53,751 1,745,438 1,122,196 480,981 67,140 52,189 1,722,506 13 14 15 16 17 18 19 20 21 22 23 Departmental Expenses Rooms Food and Beverage Other Operated Departments Total Departmental Expenses 305,992 365,018 54,240 724,650 319,430 355,168 54,290 728,888 307,000 954964 54,316 716,280 Total Departmental Profit 1,074,026 1,016,550 1,006,226 Undistributed Operating Expenses Administrative and General 25 161,811 157,042 155,293 TAB 1--SUMMARY OPERATING STMT TAB 2--ROOMS OPERATING SCHEDULE TAB 3 --ADMIN AND + . E F G H L M N o 24 25 25 27 28 D Undistributed Operating Expenses Administrative and General Information and Telecommunications Systems Sales and Marketing Property Operation and Maintenance Utilities Total Undistributed Expenses 161,811 52,460 148,637 52,460 69,947 485,315 157,042 24,436 162,326 50,618 78,545 472,967 155,293 25,838 179,140 74,068 77,513 511,852 30 31 32 33 Gross Operating Profit 588,711 543,583 494,374 Management Fees 53,960 52,363 51,675 Income Before Non-Operating Income and Expenses 534,751 491,220 442,699 35 35 37 38 39 40 Non-Operating Income and Expenses Income Rent Property and Other Taxes Insurance Other Total Non-Operating Income and Expenses (20,000) 15,000 26,418 28,125 (1.000) 48,543 (500) 15 000 30,145 25,875 500 71,020 (500) 14,500 28.708 22,229 (1.500 63,437 42 43 44 45 46 47 48 49 50 Earnings Before Interest, Taxes, Depreciation, and Amortization 486,208 420,200 379,262 Replacement Reserve 87,434 87,272 77,513 EBITDA Less Replacement Reserve TAB 1. SUMMARY OPERATING STMT 398,774 332,928 TAB 2--ROOMS OPERATING SCHEDULE 301,749 TAB 3 --ADMIN AND .. + Highlight the line item you will be analyzing in yellow. Answer the following questions: 1. What measurement did you use to justify that the line item selected required further analysis (i.e. was it the percentage increase, the dollar increase the change in proportions)? 2. What types of transactions or activities does this account represent? (Use the GHACP or your PowerPoints if you don't remember what is included in the line items). 3. What are the action items that the hotel should take in regard to improving or continuing the results found in this line item? 1