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)* $ 675 1,850 (95) (715) (140) (85) (100) Actual Results March (in thousands)* $ 688 1,839 (96) (720) (137) (88) (108) "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.) Food and Beverage Department Banquets & Catering Restaurants Kitchen Total profit Kitchen Kitchen staff wages Food Paper products Variable overhead Fixed overhead Total expense 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 Exhibit 12-4 Performance Reports for February: Selected Subunits of Aloha Hotels and Resorts (numbers in thousands) Flexible Badget Actual Results Variance Alol February Year to Date February Year to Date: February Year to Date Company Maul Division $30,660 $64.567 $30,716 $64,570 $56 F $ 3F $18,400 $38,620 $18,470 $38,630 $70F $10F Oahu Division Total profit 12.260 25,947 12.246 25,940 14U $30,660 $64,567 $30,716 $64,570 $56 F $ 3F Dahu 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 50U 70U Wakai Sands Hotel 4,110 8,747 4,136 8,770 26 F 23 F Total prof $12.200 $25,947 $12.240 $25,940 $14 U 5.70 -Waikiki Sands Hotel Grounds and Maintenance $ (45) $ (90) $ (44) $ (90) $1F Housekeeping and Custodial (40) (90) (41) (90) 10 Recreational Services 40 05 41 M 1F Hospitality 2,800 6,000 2.840 6,000 40 F 30 F Food and Beverage 1.355 2.842 1,340 2.832 15U 10U Total profit $ 4.110 $8.747 $ 4,136 $8.770 $26F $23 F -Food and Beverage Department Banquets and Catering $ 600 $ 1,200 $ 605 $1,265 $5F $5F Restaurants 1,785 3,750 1,760 3,740 25U 100 Kichen 1.030) (2.168) (1.025) Q.173) 5F Total profit $ 1,355 $ 2.842 $1,340 $ 2.832 $150 $10 U Kitchen Kitchen staff wages $ (80) $ (168) $ (78) $ (169) $2F $10 Food 675) (1,420) (678) (1.421) 30 Paper products (120) (250) (115) 2) 5F Variable overhead (70) (150) (71) (154) 10 Fed overhead (85) (180) (83) (181) 2F Total expense $1,000) $ 2,168) $ (1,025) $2.173) $5F "Numbers without parentheses denote profit; numbers with parentheses denote expenses; numbers in thousands 1F denotes favorable variance; U denotes unfavorable variance