Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

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,

image text in transcribed

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 to know what is included in the line items).

3) What are the action items you think that the hotel should focus on to improve or continue the results found in this line item?

20X2 Current Period BUDGET $ % 20x1 Varlance to Budget $ % Variance to Prior Year $ % $ % $ % 6,626,139 1,995,825 3,327,040 1,317,245 13,266,249 33.296 10.0% 16.7% 6.6% 66.5% 5,786,824 1,285,959 3,857,877 1.928,947 12,859,607 30.7% 7,231,329 6.8% 625,452 20.4% 2.501,710 10.2% 1.876,340 68.1% 12,234,831 39.2% 3.4% 13.5% 839,315 709,866 (530,837 1611.7021 406,642 12.796 (605,190) 35.6% 1,370,373 -16.096 825,330 -46.496 (559,095) 3.1% 1,031,418 -8.496 219.1% 33.0% 29.896 8.496 10.2% 66.2% Revenue Transient Rooms Revenue Retail Discount Negotiated Wholesale Total Transient Rooms Revenue Group Rooms Revenue Corporate Association/Convention SMERF Total Group Rooms Revenue Contract Rooms Revenue Other Rooms Revenue Less: Allowances 2,414,948 1,337 203 1,596,660 5.348.811 1,237,412 205,570 (99,791) 12.1% 6.7% 8.0% 26.8% 6.2% 1.0% -0.5% 2,363,905 1.654.735 709 170 4,727,810 945,565 378,325 (31,733) 12.5% 8.8% 3.8% 25.0% 5.0% 2.0% -0.296 2,105,981 1,545,861 940974 4,592,816 1,344,239 336,051 (37,333 11.4% 8.4% 5.1% 24.99 7.396 1.8% -0.2% 51,043 1317 5321 887,490 621,001 291,847 (172,755) (68,058) 2.1% 308,967 -23.796 (208,658) ( 55.6% 655,686 11.6% 755,995 23.6% (106,827) -84 09 (130 481) 68.296 162,458) 14.796 -13.5% 69.79% 16.5% -7.9% -38.896 167.396 Total Rooms Revenue 19,958,251 100.0% 18,879,574 100.0% 18,470.604 100.0% 1,078,677 5.49 1,487,647 8.1% 222,143 4.4% 212,919 4.3% 245,249 4.9% 9,224 4.2% (23,106) 9.2% 2.7% 21.7% 9.9% Expenses Labor Costs and Related Expenses Salaries, Wages, Service Charges, Contracted Labor and Bonuses Salaries and Wages Management Non-Management Front Office Guest Services Housekeeping Laundry Reservations Sub-Total: Salaries and Wages Contracted, Leased and Outsourced Labor Bonuses and Incentives Total Salaries, Wages, Service Charges, Contracted Labor and Bd Payroll-Related Expenses Payroll Taxes Supplemental Pay Employee Benefits Total Payroll-Related Expenses 354,228 159,102 855,551 450,290 66,043 2,107,357 154,600 100.134 2,362,091 7.0% 3.2% 17.0% 8.9% 1.3% 41.8% 3.1 2.0% 46 9% 452,462 133,083 1,064,632 485,546 79,856 2,428,498 59,386 53,230 2,541,114 1.6% 49.5% 1.296 1.1% 51.8% 380,285 103,434 957,617 537,207 58,398 2,282,190 93,434 70071 2,445,695 7.5% 2.1% 19.0% 10.7% 1.2% 45.3% 1.9% 1.496 48.5% (98,234) 26,019 (209.081) (35,256) (13,813) (321,141) 95,214 46,904 (179023) -27.796 (26,057) 16.4% 55,668 -24 495 (102,066) -7.896 (86,917) -20.99 7,645 -15.29 (174,833) 61.696 61,166 46.8% 30,063 -7.6% (83,604) -6.996 53.8% -10.796 -16.2961 13.196 -7.79 65.596 42.9% -3.4% % 234.151 78,050 327,641 639,842 4.6% 1.5% 6.5% 12.7% 171,771 92,020 349,672 613,463 3.5% 1.9% 7.1% 12.5% 198,381 87,195 344,356 629,932 3.9% 1.7% 6.8% 12.5% 62 380 (13.970) (22,031) 26,379 26.6% 17.996 -6.796 4.196 35,770 (9,145) (16,715) 9,910 18.096 -10.5% -4.9 1.6% Total Labor Costs and Related Expenses 3,001,933 59.6% 3,154,577 64 3% 3,075,627 61.0% (152,644) -5.196 (73,694) -2.4% 2.796 182.896 464.19 -72.696 Other Expenses Cleaning Supplies Cluster Services Commissions Commissions and Fees-Group Complimentary Food and Beverage Complimentary Services and Gifts Contract Services Corporate Office Reimbursables Equipment Rental Guest Supplies Laundry and Dry Cleaning Licenses and Permits Linen Miscellaneous Operating Supplies Postage and Overnight Delivery Charges Printing and Stationery Reservations Training Travel-Meals and Entertainment Travel-Other Uniform Costs Uniform Laundry Total Other Expenses 431,531 93,634 140,451 61,066 16,284 7,124 20,355 6,107 2.036 431,531 173,019 2,036 36,639 1,832 50,888 1,527 14,249 405,069 8.6% % 1.9% 2.8% 1.296 0.3% 0.1% 0.4% 0.1% 0.0% 8.6% 3.4% 0.0% 0.7% 0.0% 1.0% 0.0% 0.3% 8.0% 0.0% 0.2% 0.9% 1.6% 0.1% 40.4% 374,695 41,390 25,596 94,088 11,589 6,622 51,655 4,967 2,483 468,369 234,184 1,242 42,152 1,656 23,427 2,069 18,741 234,184 82,780 4,139 8,278 11,589 4,553 1,750,448 7.6% 0.8% 0.5% 1.9% 0.2% 0.1% 1.1% 0.1% 0.1% 9.5% 4.8% 0.0% 0.99 0.0% 0.5% 0.0% 0.4% 4.896 1.7% 0.1% 0.2% 0.2% 0.1% 35.796 420,340 33,112 24,900 222,943 13,245 8,824 66,224 10,679 1,365 468,369 281,021 1,656 51,522 3,526 28,096 3,725 23,427 187,348 77,946 3,030 10,761 14,073 6755 1,962,887 8.3% 0.7% 0.5% 4.496 0.3% 0.2% 1.3% 0.2% 0.0% 9.3% 5.6% 0.0% 1.0% 0.1% 0.6% 0.1% % 0.5% 3.7% 1.5% 0.1% 0.2% 0.3% 0.1% 39.0% 56,836 52,244 114,855 (33,022) 4,695 502 (31,300 1.140 (447) (36,838) (61.165) 794 15,513) 176 27.461 (542) ) (4,492) 170.885 (82,780) 6,039 36,504 69,831 1787 285,076 13.296 11,191 55 896 60,522 81.8% 115,551 -54.1% (161,877) 28.896 3,039 70% (1,700) 153.896 (45,869) 18.796 (4,572) -22.096 671 -8.5% (36,838 -35.4% (108,002) 39.0% 380 -15.0% (14,883) 9.6% (1,694) 54.096 22,792 -35.5% (2,198) -31.5% (9,178) 42.29 217,721 177,946) 59.396 7,148 81.5% 34,021 85.896 67,347 -20.996 (2,989) 14.0961 72,637 22.996 -19.395 -69.3% -42.8% 49.29 -7.99% -38.4% 22.9% 28.9% -48.0% 81.196 -59.0% -39.29 116.296 -100.0% 235.9% 316.296 478.6% -44.296 3.7% 10,178 44,782 81,420 3,766 2,035,524 Total Expenses 5,037,457 100.0% 4,905,025 100.0% 5,038,514 100.0% 132,432 2.696 (1,057) 0.096 Departmental Profit 14,920,794 13,974,549 13,432,090 946,245 6.3% 1,488,704 11.19 20X2 Current Period BUDGET $ % 20x1 Varlance to Budget $ % Variance to Prior Year $ % $ % $ % 6,626,139 1,995,825 3,327,040 1,317,245 13,266,249 33.296 10.0% 16.7% 6.6% 66.5% 5,786,824 1,285,959 3,857,877 1.928,947 12,859,607 30.7% 7,231,329 6.8% 625,452 20.4% 2.501,710 10.2% 1.876,340 68.1% 12,234,831 39.2% 3.4% 13.5% 839,315 709,866 (530,837 1611.7021 406,642 12.796 (605,190) 35.6% 1,370,373 -16.096 825,330 -46.496 (559,095) 3.1% 1,031,418 -8.496 219.1% 33.0% 29.896 8.496 10.2% 66.2% Revenue Transient Rooms Revenue Retail Discount Negotiated Wholesale Total Transient Rooms Revenue Group Rooms Revenue Corporate Association/Convention SMERF Total Group Rooms Revenue Contract Rooms Revenue Other Rooms Revenue Less: Allowances 2,414,948 1,337 203 1,596,660 5.348.811 1,237,412 205,570 (99,791) 12.1% 6.7% 8.0% 26.8% 6.2% 1.0% -0.5% 2,363,905 1.654.735 709 170 4,727,810 945,565 378,325 (31,733) 12.5% 8.8% 3.8% 25.0% 5.0% 2.0% -0.296 2,105,981 1,545,861 940974 4,592,816 1,344,239 336,051 (37,333 11.4% 8.4% 5.1% 24.99 7.396 1.8% -0.2% 51,043 1317 5321 887,490 621,001 291,847 (172,755) (68,058) 2.1% 308,967 -23.796 (208,658) ( 55.6% 655,686 11.6% 755,995 23.6% (106,827) -84 09 (130 481) 68.296 162,458) 14.796 -13.5% 69.79% 16.5% -7.9% -38.896 167.396 Total Rooms Revenue 19,958,251 100.0% 18,879,574 100.0% 18,470.604 100.0% 1,078,677 5.49 1,487,647 8.1% 222,143 4.4% 212,919 4.3% 245,249 4.9% 9,224 4.2% (23,106) 9.2% 2.7% 21.7% 9.9% Expenses Labor Costs and Related Expenses Salaries, Wages, Service Charges, Contracted Labor and Bonuses Salaries and Wages Management Non-Management Front Office Guest Services Housekeeping Laundry Reservations Sub-Total: Salaries and Wages Contracted, Leased and Outsourced Labor Bonuses and Incentives Total Salaries, Wages, Service Charges, Contracted Labor and Bd Payroll-Related Expenses Payroll Taxes Supplemental Pay Employee Benefits Total Payroll-Related Expenses 354,228 159,102 855,551 450,290 66,043 2,107,357 154,600 100.134 2,362,091 7.0% 3.2% 17.0% 8.9% 1.3% 41.8% 3.1 2.0% 46 9% 452,462 133,083 1,064,632 485,546 79,856 2,428,498 59,386 53,230 2,541,114 1.6% 49.5% 1.296 1.1% 51.8% 380,285 103,434 957,617 537,207 58,398 2,282,190 93,434 70071 2,445,695 7.5% 2.1% 19.0% 10.7% 1.2% 45.3% 1.9% 1.496 48.5% (98,234) 26,019 (209.081) (35,256) (13,813) (321,141) 95,214 46,904 (179023) -27.796 (26,057) 16.4% 55,668 -24 495 (102,066) -7.896 (86,917) -20.99 7,645 -15.29 (174,833) 61.696 61,166 46.8% 30,063 -7.6% (83,604) -6.996 53.8% -10.796 -16.2961 13.196 -7.79 65.596 42.9% -3.4% % 234.151 78,050 327,641 639,842 4.6% 1.5% 6.5% 12.7% 171,771 92,020 349,672 613,463 3.5% 1.9% 7.1% 12.5% 198,381 87,195 344,356 629,932 3.9% 1.7% 6.8% 12.5% 62 380 (13.970) (22,031) 26,379 26.6% 17.996 -6.796 4.196 35,770 (9,145) (16,715) 9,910 18.096 -10.5% -4.9 1.6% Total Labor Costs and Related Expenses 3,001,933 59.6% 3,154,577 64 3% 3,075,627 61.0% (152,644) -5.196 (73,694) -2.4% 2.796 182.896 464.19 -72.696 Other Expenses Cleaning Supplies Cluster Services Commissions Commissions and Fees-Group Complimentary Food and Beverage Complimentary Services and Gifts Contract Services Corporate Office Reimbursables Equipment Rental Guest Supplies Laundry and Dry Cleaning Licenses and Permits Linen Miscellaneous Operating Supplies Postage and Overnight Delivery Charges Printing and Stationery Reservations Training Travel-Meals and Entertainment Travel-Other Uniform Costs Uniform Laundry Total Other Expenses 431,531 93,634 140,451 61,066 16,284 7,124 20,355 6,107 2.036 431,531 173,019 2,036 36,639 1,832 50,888 1,527 14,249 405,069 8.6% % 1.9% 2.8% 1.296 0.3% 0.1% 0.4% 0.1% 0.0% 8.6% 3.4% 0.0% 0.7% 0.0% 1.0% 0.0% 0.3% 8.0% 0.0% 0.2% 0.9% 1.6% 0.1% 40.4% 374,695 41,390 25,596 94,088 11,589 6,622 51,655 4,967 2,483 468,369 234,184 1,242 42,152 1,656 23,427 2,069 18,741 234,184 82,780 4,139 8,278 11,589 4,553 1,750,448 7.6% 0.8% 0.5% 1.9% 0.2% 0.1% 1.1% 0.1% 0.1% 9.5% 4.8% 0.0% 0.99 0.0% 0.5% 0.0% 0.4% 4.896 1.7% 0.1% 0.2% 0.2% 0.1% 35.796 420,340 33,112 24,900 222,943 13,245 8,824 66,224 10,679 1,365 468,369 281,021 1,656 51,522 3,526 28,096 3,725 23,427 187,348 77,946 3,030 10,761 14,073 6755 1,962,887 8.3% 0.7% 0.5% 4.496 0.3% 0.2% 1.3% 0.2% 0.0% 9.3% 5.6% 0.0% 1.0% 0.1% 0.6% 0.1% % 0.5% 3.7% 1.5% 0.1% 0.2% 0.3% 0.1% 39.0% 56,836 52,244 114,855 (33,022) 4,695 502 (31,300 1.140 (447) (36,838) (61.165) 794 15,513) 176 27.461 (542) ) (4,492) 170.885 (82,780) 6,039 36,504 69,831 1787 285,076 13.296 11,191 55 896 60,522 81.8% 115,551 -54.1% (161,877) 28.896 3,039 70% (1,700) 153.896 (45,869) 18.796 (4,572) -22.096 671 -8.5% (36,838 -35.4% (108,002) 39.0% 380 -15.0% (14,883) 9.6% (1,694) 54.096 22,792 -35.5% (2,198) -31.5% (9,178) 42.29 217,721 177,946) 59.396 7,148 81.5% 34,021 85.896 67,347 -20.996 (2,989) 14.0961 72,637 22.996 -19.395 -69.3% -42.8% 49.29 -7.99% -38.4% 22.9% 28.9% -48.0% 81.196 -59.0% -39.29 116.296 -100.0% 235.9% 316.296 478.6% -44.296 3.7% 10,178 44,782 81,420 3,766 2,035,524 Total Expenses 5,037,457 100.0% 4,905,025 100.0% 5,038,514 100.0% 132,432 2.696 (1,057) 0.096 Departmental Profit 14,920,794 13,974,549 13,432,090 946,245 6.3% 1,488,704 11.19

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions