The following data pertain to the Waikiki Sands Hotel for the month of March Flexible Budget Actual Results March March (in thousands)* $ 735 (in thousands ) Banquets and Catering 760 Restaurants 1,970 (119) (775) (176) (109) (124) 1,947 (120) (792) (173) (112) (144) Kitchen staff wages Food Paper products Variable overhead Fixed overhead Numbers without parentheses denote profit; numbers with parentheses denote expenses. Required: Ba 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.) Variance Flexible Budget* Actual Results* February Year to Date Year to Date Year to Date February February 3 F $30,660 $30,716 $64,570 $56 F Company $64,567 Maui Division $18,400 $38,620 $18,470 $38,630 $70 F $10 F Oahu Division 12,260 25,947 12,246 25,940 14 U 7 U $ 30,716 3 F Total profit $30,660 $64,567 $64,570 $56 F Oahu Division $12,700 Waimea Beach Resort $12,740 $10 F $40 F 6,050 6,060 Diamond Head Lodge 4,500 2,050 50 U 2,100 4,430 70 U Waikiki Sands Hotel 4,110 8,747 4,136 8,770 26 F 23 F $ 7 U $12,260 $25,947 $12,246 $25,940 $14 U Total profit Waikiki Sands Hotel 1 F $ (90 (90) Grounds and Maintenance (45) (40) (90) (90) 85 (44) (41) Housekeeping and Custodial Recreational Services 1 U 3 F 40 41 88 1 F Hospitality 30 F 2,800 6,000 2,840 6,030 40 F Food Beverage 2,842 1,340 2,832 15 U 10 U Total profit $ 8,770 $ 4,136 $ 8,747 $26 F $23 F L. $ 4,110 Food and Beverage Department Banquets and Catering 5 F $ $1,260 $ 1,265 $ 5 F 600 605 1,760 3,740 10 U Restaurants 1,785 3,750 25 U (1,030) (2,168) 5 U Kitchen (1,025) (2,173) 5 F $ 2,842 $ 2,832 $1,340 $15 U $10 U Total profit 1,355 Kitchen Kitchen staff wages $ (168) (1,420) (250) $ (169) (1,421) (248) (154) (181) 2 F 1 U (80 (78) (678) (115) (71) (83) Food (675) (120) (70) (85) 3 U 1 U Paper products 5 F 2 F Variable overhead (150) 1 U 4 U Fixed overhead 2 F 1 U (180) $ 5 F $5 U Total expense $(1,030) $(2,168) (1,025) $2,173) WAIKIKI SANDS HOTEL Performance Reports for March (In Thousands) Flexible Budget Variance Actual Results Year to Date March Year to Date March March Year to Date Food and Beverage Department 25 F Banquets & Catering $ 735 $ S 760 23 U U Restaurants 1,970 1,947 38 U Kitchen (1,303) (1,341) 1,366 36 U Total profit 1,402 $ U Kitchen 1 U Kitchen staff wages $ $ $ (119) (120) 17 U U Food (775) (792) 3 F 1F Paper products (176) (173) 3U Variable overhead (109) (112) 20 U U Fixed overhead (124) (144) 38 U $ Total expense (1,303) $ (1,341)