Flexible Budget* Actual Results* Variancet 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 Oahu Division $ 18,400 12,260 $ 38,620 25,947 $ 18,470 12,246 $38,630 25,940 $70 F 140 $10 F 7U Total profit $ 30,660 $ 64,567 $ 30,716 $64,570 $56 F $ 3F Oahu Division Waimea Beach Resort Diamond Head Lodge Waikiki Sands Hotel $ 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 $25,940 $10 F 50 U 26 F $14U $40 F 70U 23 F $ 12,260 $ 7U $ $ $ (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 $ 1 F 1 U 1 F 40 F 15 U $ 3F 30 F 10U $ 4,110 $ 8,747 $ 4,136 $ 8,770 $26 F $23 F Total profit 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 Total profit Kitchen Kitchen staff wages Food Paper products Variable overhead Fixed overhead $ $ 1,260 3,750 605 1,760 $ 600 1,785 1,030) $ 1,355 $ 1,265 3,740 (2,173) $ 2,832 $ 5F 25 U 5F $ 5F 10U 5U (2,168) (1,025) $ 2,842 $ 1,340 $15 U $10U $ $ (80) (675) (120) (70) (85) $ (168) (1,420) (250) (150) (180) (78) (678) (115) (71) (83) $ (169) (1,421) (248) (154) (181) $ 2F 30 5F 1U 2 F $ 10 1U 2 F 4U 1U Total expense $ 1,030) $ (2,168) $ (1,025 $(2,173) $ 5F $ 50 born with 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) $ 720 1,940 (113) (760) (167) (103) (118) Actual Results March (in thousands)* $ 742 1,920 (114) (774) (164) (106) (135) *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 profit Kitchen Kitchen staff wages Food Paper products Variable overhead Fixed overhead Total expense
