The following data pertain to the Waikiki Sands Hotel for the month of March Flexible Budget March (in thousands)* Actual Results March (in thousands 1,950 (115) 1.929 (116) Banquets and Catering Restaurants Kitchen staff wages Food Paper products Variable overhead Fixed overhead (170) (195) (120) (167) (108) (138) "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.) Flexible Budget Actual Results Varianoet February Year to Date February Year to Date Year to Date 30.660 4.567 630716 February 8567 $70F Company Maui Division Dahu Division s 35 38.620 1618,400) | 12.260 5 18 470 | 12246 04.570 638,630 125,900 164,570 $10F 170 $ 3F 1630,660 SB4567 30,716 $56 F $12,700 4,500 8747 1 6,050 2.100 14.110 4 12,260) S 6,060 2050 4.136 12.740 4490 18,770 610 1500 540F 700 26 F 3140 $25,947 $ 12246 $ 70 (45) $ 1900 3 190 1144) 1141 6,000 2,800 1156 2840 11340 Total profit - Bahu Division Waimea Beach Resort Diamond Head Lodge Waikiki Sands Hotel 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 Kichen Total profit Kitchen Kitchen staff wages Food Paper products Variable overhead Fixed overhead Total expense GIF 11 0 17 40F 1150 $26 F 2842 - 1 4.110 $ 8.747 S 4136 $ 8.720 $23F S 600 1 $ SF | 1,785 1,260 | 3,750 12.16 $ 2,842 IS 605 | 1,760 | 1025) 8 1,340 $ 1285 13740 121733 110300 S 5F 100 150 Se $ 1,355 $ 2,832 150 S100 $ 16 $ 78) 880 11875) 1200 | 11420 678) * 100 1142) 11241 (154) 122500 1500 185 (180 (181) Tee (1,0300 $ 2168 $ 1,025 12.173) $5F Flexible Budget Actual Results Varianoet February Year to Date February Year to Date Year to Date 30.660 4.567 630716 February 8567 $70F Company Maui Division Dahu Division s 35 38.620 1618,400) | 12.260 5 18 470 | 12246 04.570 638,630 125,900 164,570 $10F 170 $ 3F 1630,660 SB4567 30,716 $56 F $12,700 4,500 8747 1 6,050 2.100 14.110 4 12,260) S 6,060 2050 4.136 12.740 4490 18,770 610 1500 540F 700 26 F 3140 $25,947 $ 12246 $ 70 (45) $ 1900 3 190 1144) 1141 6,000 2,800 1156 2840 11340 Total profit - Bahu Division Waimea Beach Resort Diamond Head Lodge Waikiki Sands Hotel 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 Kichen Total profit Kitchen Kitchen staff wages Food Paper products Variable overhead Fixed overhead Total expense GIF 11 0 17 40F 1150 $26 F 2842 - 1 4.110 $ 8.747 S 4136 $ 8.720 $23F S 600 1 $ SF | 1,785 1,260 | 3,750 12.16 $ 2,842 IS 605 | 1,760 | 1025) 8 1,340 $ 1285 13740 121733 110300 S 5F 100 150 Se $ 1,355 $ 2,832 150 S100 $ 16 $ 78) 880 11875) 1200 | 11420 678) * 100 1142) 11241 (154) 122500 1500 185 (180 (181) Tee (1,0300 $ 2168 $ 1,025 12.173) $5F