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 vages Food Paper products Variable overhead, Fixed overhead Flexible Budget March (in thousands) $ 670 1,840 (93) (710) (137) (83) (98) Actual Results March (in thousands) $ 682 1,830 (94) (714) (134) (86) (105) "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 March Year to Date March Actual Results Year to Date Variance March Year to Date + Banquets and Catering Restaurants Kitchen staff wages. Food Paper products Variable overhead Fixed overhead Flexible Budget March (in thousands)* $ 670 1,840 (93) (710) (137) (83) (98) Actual Results March. (in thousands)* $ 682 1,830 (94) (714) (134) (86) (105) "Numbers without parentheses denote profit; numbers with parentheses denote expenses. bit 12-4 Performance Reports for February: Selected Subunits of Alona Hotels and Resorts Flexible Budget Actual Results Variance February Year to Date February Year to Date February Year to Date 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 14U 70 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 $10 F $40 F Diamond Head Lodge 2,100 4,500 2,050 4,430 50 U 70U 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 $ 70 Waikiki Sands Hotel Grounds and Maintenance (45) $ (90) S (44) $ (90) Housekeeping and Custodial (40) (90) (41) (90) 33 $1F 10 Recreational Services 40 85 41 88 1F $ 3 F 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 Kitchen (1.030) 3,750 (2,168) 1,760 (1,025) 3,740 25U 10U (2.173) 5F 5U Total profit $ 1,355 $ 2,842 $ 1,340 $ 2,832 $15 U $100 Kitchen Kitchen staff wages $ (80) Food (675) $ (168) (1,420) $ (78) $ (169) $2F $10 (678) (1.421) 30 1U Paper products (120) (250) (115) (248) 5F 2F Variable overhead (70) (150) (71) (154) 10 40 Fixed overhead (85) (180) (83) (181) 2F 1U Total expense $ (1,030) $ (2,168) "Numbers without parentheses denote profit; numbers with parentheses denote expenses; numbers in thousands. + E denotes favorable variance: 11 denotes unfavorable variance $ (1,025) $2.173) $ 5F $ 50 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) Actual Results Flexible Budget Year to March Date March Variance Year to Date March Year to Datel F U 0000 CCCTCC U 000000 F U U U CCCTCC 1600