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)* $ 670 1,840 (93) (710) (137) (83) (98) Actual Results March (in thousands) $ 682 1,838 (94) (714) (134) (86) (185) *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 varlance by selecting "F" for favorable, "U" for unfavorable. Select "None" and enter "O" for no effect (I.e., zero varlance). Enter your answers in thousands.) Exhibit 12-4 Performance Reports for February: Selected Subunits of Aloha Hotels and Resorts (numbers in thousands) Flexible Budget* Actual Results Variancet Alol February Year to Date February Year to Date February Year to Date HOTELS & $64,570 $56 F $ 30,660 $ 18,400 12,260 $ 64,567 $ 38,620 25,947 $ 64,567 $ 30,716 $ 18,470 12,246 $ 30,716 $38,630 25,940 $70 F 140 $ 3F $10 F 7U $ 30,660 $64,570 $56 F Company Maui Division Oahu Division Total profit Oahu Division Waimea Beach Resort Diamond Head Lodge Waikiki Sands Hotel $ 3F $ 6,050 2,100 4.110 $ 12,700 4,500 8,747 $ 25,947 $ 6,060 2,050 4,136 $ 12,246 $12,740 4,430 8.770 $10 F 50 U 26 F $40 F 70U 23 F Total profit $ 12,260 $25,940 $14U $ 7U $ $ Waikiki Sands Hotel Grounds and Maintenance Housekeeping and Custodial Recreational Services Hospitality Food and Beverage Total profit Food and Beverage Department Banquets and Catering Restaurants Kitchen $ (45) (40) 40 2,800 1,355 (90) (90) 85 6,000 2,842 (44) (41) 41 2,840 1,340 $ (90) (90) 88 6,030 2,832 $ 1F 1U 1 F 40 F 15 U $26 F $ 3F 30 F 10U $ 4,110 $ 8,747 $ 4,136 $ 8.770 $23 F $ 600 1.785 (1,030) $ 1,260 3,750 (2,168) $ 2,842 $ 605 1.760 (1,025 $ 1.265 3,740 (2.173) $ 5F 25 U 5F $ 5F 10U 5U Total profit ........$ 1,355 $ 1,340 $ 2,832 $15 U $10U $ $ (168) $ (78) (678) Kitchen Kitchen staff wages Food Paper products Variable overhead Fixed overhead (80) (675) (120) (70) (85) (115) (1,420) (250) (150) (180) $ (169) (1,421) (248) (154) (181) $ 2F 3U 5F 1U 2F $ 5F $ 1U 1U 2 F 4U 1U (71) (83) Total expense $ 1,030) $ (2,168) $ (1,025) $(2,173) $ 5U *Numbers without parentheses denote profit; numbers with parentheses denote expenses; numbers in thousands. + F denotes favorable variance; U denotes unfavorable variance. WAIKIKI SANDS HOTEL Performance Reports for March (In Thousands) Flexible Budget Actual Results Year to Year to March Date March Date Variance March Year to Date $ $ F F 670 1.840 682 1,830 U U U U U U Food and Beverage Department Banquets & Catering Restaurants Kitchen Total profit Kitchen Kitchen staff wages Food Paper products Variable overhead Fixed overhead $ $ U U (94) (714) (134) (93) (710) (137) (83) (98) OOOOOOOOOO U OOOO OOOOOO U 2 DL PPP F F U U (86) (105) U U U Total expense U
