Exercise 12-30 Performance Report; Hotel (LO 12-3) The following data pertain to the Waikiki Sands Hotel for the month of March Banquets and Catering Restaurants Kitchen staff wages Food Paper products Variable overhead Fixed overhead Flexible Budget March (in thousands: $ 730 1,960 (117) (770) (173) (107) (122) Actual Results March (in thousands) $ 754 1,938 (118) (786) (170) (110) (141) "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 "F" for favorable, "U" for unfavorable. Select "None" and enter "O" for no effect (ie, zero variance). Enter your answers in thousands.) 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 Food and Beverage Department Banquets & Catering Restaurants Kachan Total profit Exhibit 12-4 Performance Reports for February: Selected Subunits of Aloha Hotels and Resorts (numbers in thousands 140 Total Flexible Budget Actual Results Variance Alls February Year to Date February Year to Date February Year to Date and Company $30,660 $64,567 $30.716 $64.570 $56F $ 3F Mari Division $ 18,400 $ 38,620 $ 18,470 $38,630 $70F $10 F Oahu Division 12,260 25.947 12246 25,940 70 Total profit $ 30,660 $ 64,567 $ 30.716 $64,570 $56F $ 3F Oahu Division Waimea Beach Resort $ 6.050 $ 12,700 $ 6,060 $12.740 $10F $40F Diamond Head Lodge 2.100 4,500 2,050 4430 SOU 70U Wild Sands Hotel 4110 8.747 4.136 8.770 26 F 23F $12,260 $25.947 $ 12.246 $25,940 $140 $ 70 Waikiki Sande Hotel Grounds and Maintenance $ 145 $ 990 $ (44) $1F Housekeeping and Custo (40) 30 (41) 90 TU Recreation Service 40 85 41 10 TF $ 3F Henpitality 2,800 6,000 2,840 6,010 40F 30 F Food wd Beverage 1,355 2,842 1.340 2832 15U TOU Total prolt $ 4110 $ 8.747 $ 4,136 $ 0,770 $26 $23F Food and Beverage Department Banquets and Catering $ 600 $ 1.200 $ 605 $ 1.205 $ 5F $ 5F Restaurants 1.785 3.750 1.700 3,740 25U 100 Kichen 11.030 2.168 (1025 2.1731 5F 50 Total $1,356 $ 2142 $ 1,340 $2832 $150 $100 Kichen Kachen staff wa $80 5 (108 $100 52 STU Food 675 11.420 678) (1421) 30 TU Paper products (120 650 0115 26 5F ZF Variable whead 070 (150 71 1154 10 40 Fandoverhead 85 1160 83 1181 2 TU St00 5.2.16 5.1.0.25 $2122 $57 S SU *Numbers without partes denote profit; numbers with parentheses denote expenses; numbers in thousands F denotes favorable variance, Udenotes unfavorable variance Fixed overhead (122) (141) "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 "F" for favorable, "U" for unfavorable. Select "None" and enter "o" for no effect (i.e., zero variance). Enter your answers in thousands.) 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 Food and Beverage Department Banquets & Catering Restaurants Kitchen Total profil Kitchen Kitchen staff wages Food Paper products Variable overhead Foed overhead Total expense