Exercise 12-30 Performance Report; Hotel (LO 12-3) The following data pertain to the Waikiki Sands Hotel for the month of March Flexible Budget March Ketua Rut March Xin thousanda in thousanda) Banqueta and Catering 5740 $ 766 Restauranta 1.980 1.956 Kitchen start wages (121) (122) Food (700) (790) Paper producto (179) (176) Variable overhead (114) Fixed overhead (126) 1147) *Numbers without parentheses denote profit, numbers with parentheses denote expenses. Required: Based on Exhibit 12-4, prepare a March performance report and use the same data for year to date columns in your report. (Indicate the effect of each variance by selecting "P" for favorable, "U" for unfavorable, Select "None" and enter "o" for no effect (ie, zero variance). Enter your answers in thousands.) WAIKIKI SANDS HOTEL Check my work once CHF your answers I woulus.) WAIKIKI SANDS HOTEL Performance Reports for March (In Thousands) Flexible Budget Actual Results March Year to Date March Year to Date Variance March Year to Date $ $ F 740 1.980 1317 1403 766 1,956 1,357 1,365 26 2410 U 400 $ $ 38 U U Food and Beverage Department Banquets & Catering Restaurants Kitchen Total profil Kitchen Kitchen staff wages Food Paper products Variable overhead Fixed overhead Total expense $ $ 121 780 179 111 126 1,317 122 798 178 114 U 1 18/ 3F 310 210 40U U $ 147 1.357 Flucblo Budget Actual Varian February Year to Date February Your fo Bate February Year to Dal 70 Company $ 30,660 $ 64,567 $ 30,716 $64,570 $56 F $ 3F Maul Division $ 18,400 $ 38,620 $ 18,470 $38,630 $70 F $10 F Oahu Division 12,260 25,947 12,246 25,940 140 Total profit $ 30,660 $ 64,567 $ 30,716 $64,570 $56 F $ 3F Oahu Division Waimea Beach Resort $ 6,050 $ 12,700 $ 6,060 $12.740 $10F $40 F Diamond Head Lodge 2,100 4,500 2.050 4,430 50 U 700 Waikiki Sands Hotel 4,110 8,747 4,136 8,770 26 F 23 F Total profit $ 12,280 $ 25,947 $ 12,246 $25,940 $140 $ 70 Waikiki Sands Hotel Grounds and Maintenance $ (45) $ (90) (44) (90) $ 1F Housekeeping and Custodial (40) (90) (41) (90) TU Recreational Services 40 85 41 88 1 F $ 3F Hospitality 2.800 6.000 2,840 6,030 40 F 30 F Food and Beverage 1,355 2.842 1,340 2,832 15 U 10U Total profit $ 8,747 $ 4136 $ 8.710 $267 $23 F Food and Beverage Department Banquets and Catering $ 600 $ 1.260 $ 1.265 S 5F $ 5F Restaurants 1.785 3,750 1.760 3,740 250 100 Kiche 1,030) (2.168) 11.025 (2.173) 5F 50 Total profit $ 1,355 $ 2.842 $ 1,340 $ 2.832 $150 $100 Kitchen Kitchen staff wage $80) $ 28 $ 2F $10 Food 1675) (1.420) 878) (1,421) 30 TU Paper products (120) (250) (205) 5F 2 Variable overhead (70) (150) 71 (154) TU 4U Fixed overhead (85) (180) (181 2F TU $11.030 $ 2.168) $ (1,025) $(2.173) $ 5F $ 50 "Numbers without parentheses denote profit numbers with parentheses denote expenses; numbers in thousands F denotes favorana 605 $ (168) $ 109 (115) Total expense
