Exercise 12-30 Performance Report; Hotel (LO 12-3) The following data pertain to the Walkiki Sands Hotel for the month of March. Flexible Budget March Actual Results March (in thousands)* (in thousands)* Banquets and Catering $ 695 $ 712 Restaurants 1, 890 1, 875 Kitchen staff wages (103) (184 ) Food (735) (744) Paper products (152) (149) Variable overhead (93) (96) Fixed overhead (108) (120) "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 "0" for no effect (L.e., zero varlance). Enter your answers In thousands.) WAIKIKI SANDS HOTEL Performance Reports for March (In Thousands) Flexible Budget Actual Results Variance March Year to Date March Year to Date March Year to Date Food and Beverage Department Banquets & Catering Restaurants Kitchen Total profit Kitchen Kitchen staff wages Food Paper products Variable overhead Fixed overhead Total expenseExhibit 12-4 Performance Reports for February: Selected Subunits of Aloha Hotels and Resorts (numbers in thousands) Flexible Budget* Actual Results* Variancet Aloly February Year to Date February Year to Date February Year to Date HOTELS & RESITE Company $ 30,660 $ 64,567 $ 30,716 $64,570 $56 F $ 3F Maui Division $ 18,400 $ 38,620 $ 18,470 $38,630 $70 F $10 F Oahu Division 12,260 25,947 12,246 25,940 14 U 70 Total profit $ 30,660 $ 64,567 $ 30,716 $64,570 $56 F $ 3 F Oahu Division Waimea Beach Resort $ 6,050 $ 12,700 $ 6,060 $12,740 $10 F $ 40 F Diamond Head Lodge 2,100 4,500 2,050 4,430 50 U 70 U Waikiki Sands Hotel 4,110 8,747 4,136 8,770 26 F 23 F Total profit $ 12,260 $ 25,947 $ 12,246 $25,940 $14 U $ 7U Waikiki Sands Hotel Grounds and Maintenance $ (45) (90) (44) $ (90) $ 1F Housekeeping and Custodial (40) (90) (41) (90) 1 U 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 .... $ 4,110 $ 8,747 $ 4,136 $ 8,770 $26 F $23 F Food and Beverage Department Banquets and Catering $ 600 $ 1,260 605 $ 1,265 $ 5F $ 5F Restaurants 1,785 3,750 1,760 3,740 25 U 10U Kitchen 1.030 (2,168) (1,025) (2,173) 5 F 5U Total profit i...... $ 1,355 $ 2,842 $ 1,340 $ 2,832 $15 U $10U Kitchen Kitchen staff wages (80) $ (168) $ (78) $ (169) $ 2 F $ 10 Food (675 (1,420) (678 (1,421) 3U 10 Paper products (120) (250) (115) (248) 5 F 2 F Variable overhead (70) (150) (71) (154) 10 4U Fixed overhead (85) 180) 83) (181) 2 F 10 Total expense $ (1,030) $ (2, 168) $ (1,025) $(2,173) $ 5 F $ 50 *Numbers without parentheses denote profit; numbers with parentheses denote expenses; numbers in thousands. I F denotes favorable variance; U denotes unfavorable variance