pter 12 Homework The following data pertain to the Walkikl Sands Hotel for the month of March Plexible Budget March (in thousands) $ 740 1,980 (121) (780) (179) (111) (126) Banquets and Catering Restaurants Kitchen staff wages Food Paper products Variable overhead Fixed overhead Actual Results March (in thousands) $ 766 1,956 (122) (798) (176) (114) (147) eBook Print References "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. (Indica the effect of each variance by selecting "F" for favorable, "U" for unfavorable. Select "None" and enter "O" for no effect (.e., ze 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 Ranaunts & Caterina 26F S 7401S 60 S 7661 Prey 1 of 3 Next > Flexible Budget Variance February Year to Date February Year to Date $ 64,587 $30,660 $ 18,400 12.260 $ 30,660 Actual Results February Year to Date $ 30,716 $64,570 $ 18,470 $38,630 12.246 25,940 $ 30,716 $64,570 $ 38,620 25,947 $ 64,567 $56F $70F 14U $56F $10F 50U Company Maui Division Oahu Division Total profit Oahu Division Walmea Beach Resort Diamond Head Lodge Waikid Sands Hotel Total profit Waikild Sands Hotel Grounds and Maintenance Housekeeping and Custodial Recreational Services Hospitality Food and Beverage Total profit $ 6,050 2.100 4,110 $ 12.260 $12.700 4,500 8,747 $ 25,947 $ 6,060 2,050 4,136 $ 12,246 $12,740 4.430 8.770 $25,940 26 F $140 $1F 10 $ (45) (40) 40 2,800 1,355 $ 4,110 $ (90) 190 85 6,000 2.842 $ 8.747 $ (44) (41) 41 2,840 1,340 $ 4,136 $ (90) (90) 88 6,030 2,832 $ 8.770 10U $23F $ Food and Beverage Department Banquets and Catering Restaurants Kitchen Total profit 600 1,785 1.030 1.355 $ 1.200 3,750 12.168) $ 2.842 $ 605 1.760 (1,025) $ 1,340 $1,265 3,740 2.173) $ 2,832 $ 5F 100 50 $ $100 $ (78) Kitchen Kitchen staff wages Food Paper products Variable overhead Foed overhead (675) (120) (70) $ (168) (1.420 (250) (150) (180) $ 2,168) 678) (115) (71) (83 S (1,025) $ (169) (1.421) (248) (154) (181) $2.173) Total expense (1.030) $ 50 MacBook Air pter 12 Homework The following data pertain to the Walkikl Sands Hotel for the month of March Plexible Budget March (in thousands) $ 740 1,980 (121) (780) (179) (111) (126) Banquets and Catering Restaurants Kitchen staff wages Food Paper products Variable overhead Fixed overhead Actual Results March (in thousands) $ 766 1,956 (122) (798) (176) (114) (147) eBook Print References "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. (Indica the effect of each variance by selecting "F" for favorable, "U" for unfavorable. Select "None" and enter "O" for no effect (.e., ze 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 Ranaunts & Caterina 26F S 7401S 60 S 7661 Prey 1 of 3 Next > Flexible Budget Variance February Year to Date February Year to Date $ 64,587 $30,660 $ 18,400 12.260 $ 30,660 Actual Results February Year to Date $ 30,716 $64,570 $ 18,470 $38,630 12.246 25,940 $ 30,716 $64,570 $ 38,620 25,947 $ 64,567 $56F $70F 14U $56F $10F 50U Company Maui Division Oahu Division Total profit Oahu Division Walmea Beach Resort Diamond Head Lodge Waikid Sands Hotel Total profit Waikild Sands Hotel Grounds and Maintenance Housekeeping and Custodial Recreational Services Hospitality Food and Beverage Total profit $ 6,050 2.100 4,110 $ 12.260 $12.700 4,500 8,747 $ 25,947 $ 6,060 2,050 4,136 $ 12,246 $12,740 4.430 8.770 $25,940 26 F $140 $1F 10 $ (45) (40) 40 2,800 1,355 $ 4,110 $ (90) 190 85 6,000 2.842 $ 8.747 $ (44) (41) 41 2,840 1,340 $ 4,136 $ (90) (90) 88 6,030 2,832 $ 8.770 10U $23F $ Food and Beverage Department Banquets and Catering Restaurants Kitchen Total profit 600 1,785 1.030 1.355 $ 1.200 3,750 12.168) $ 2.842 $ 605 1.760 (1,025) $ 1,340 $1,265 3,740 2.173) $ 2,832 $ 5F 100 50 $ $100 $ (78) Kitchen Kitchen staff wages Food Paper products Variable overhead Foed overhead (675) (120) (70) $ (168) (1.420 (250) (150) (180) $ 2,168) 678) (115) (71) (83 S (1,025) $ (169) (1.421) (248) (154) (181) $2.173) Total expense (1.030) $ 50 MacBook Air