The following data pertain to the Waikiki Sands Hotel for the month of March. Flexible Budget...

Transcribed Image Text:

The following data pertain to the Waikiki Sands Hotel for the month of March. Flexible Budget Actual Results March March (in thousands)* $ 685 1,870 (in thousands) * $ 700 1,857 Banquets and Catering Restaurants Kitchen staff wages Food Paper products Variable overhead Fixed overhead (89) (104) *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.) Food and Beverage Department Banquets & Catering Restaurants Kitchen Total profit Kitchen Kitchen staff wages Food Paper products Variable overhead Fixed overhead Total expense (99) (725) (146) March Flexible Budget WAIKIKI SANDS HOTEL Performance Reports for March (In Thousands) (100) (732) (143) (92) (114) Year to Date Actual Results March Year to Date March F U U U U וכב U F U U U Variance. Year to Date F U U U U U F U U U Company Maui Division Oahu Division Total profit Oahu 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 Kitchen Total profit Kitchen Kitchen staff wages Food Paper products Variable overhead Fixed overhead Total expense February $ 30,660 $18,400 12,260 $ 30,660 Flexible Budget* $ 6,050 2,100 4,110 $12,260 $ (45) (40) 40 2,800 1,355 $4,110 $ $ 600 1,785 (1,030) $1,355 (80) (675) (120) (70) (85) $(1,030) Year to Date $ 64,567 $38,620 25,947 $ 64,567 $12,700 4,500 8,747 $ 25,947 $ (90) (90) 85 6,000 2,842 $8,747 $ 1,260 3,750 (2,168) $ 2,842 $ (168) (1,420) (250) (150) (180) $(2,168) Actual Results* February $30,716 $18,470. 12,246 $ 30,716 $6,060 2,050 4.136 $12,246 $ (44) (41) 41 2,840 1,340 $ 4,136 $ 605 1,760 (1,025) $ 1,340 $ (78) (678) (115) (71) (83) $ (1,025) Year to Date $64,570 $38,630 25,940 $64,570 $12,740 4,430 8,770 $25,940 $ (90) (90) 88 6,030 2,832 $ 8,770 $ 1,265 3,740 (2,173) $ 2,832 $ (169) (1,421) (248) (154) (181) $(2,173) February $56 F $70 F 14 U $56 F $10 F 50 U 26 F $14 U $1F 1 U 1 F 40 F 15 U $26 F $5F 25 U 5 F $15 U Variance+ $2F 3U 5 F 1 U 2F $ 5F Year to Date $3 F $10 F 7U $ 3 F $40 F 70 U 23 F $ 7U $ 3F 30 F $23 F $ 5F 10 U 5 U $10 U $ 1 U 1 U 2 F 4 U 1 U $5U The following data pertain to the Waikiki Sands Hotel for the month of March. Flexible Budget Actual Results March March (in thousands)* $ 685 1,870 (in thousands) * $ 700 1,857 Banquets and Catering Restaurants Kitchen staff wages Food Paper products Variable overhead Fixed overhead (89) (104) *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.) Food and Beverage Department Banquets & Catering Restaurants Kitchen Total profit Kitchen Kitchen staff wages Food Paper products Variable overhead Fixed overhead Total expense (99) (725) (146) March Flexible Budget WAIKIKI SANDS HOTEL Performance Reports for March (In Thousands) (100) (732) (143) (92) (114) Year to Date Actual Results March Year to Date March F U U U U וכב U F U U U Variance. Year to Date F U U U U U F U U U Company Maui Division Oahu Division Total profit Oahu 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 Kitchen Total profit Kitchen Kitchen staff wages Food Paper products Variable overhead Fixed overhead Total expense February $ 30,660 $18,400 12,260 $ 30,660 Flexible Budget* $ 6,050 2,100 4,110 $12,260 $ (45) (40) 40 2,800 1,355 $4,110 $ $ 600 1,785 (1,030) $1,355 (80) (675) (120) (70) (85) $(1,030) Year to Date $ 64,567 $38,620 25,947 $ 64,567 $12,700 4,500 8,747 $ 25,947 $ (90) (90) 85 6,000 2,842 $8,747 $ 1,260 3,750 (2,168) $ 2,842 $ (168) (1,420) (250) (150) (180) $(2,168) Actual Results* February $30,716 $18,470. 12,246 $ 30,716 $6,060 2,050 4.136 $12,246 $ (44) (41) 41 2,840 1,340 $ 4,136 $ 605 1,760 (1,025) $ 1,340 $ (78) (678) (115) (71) (83) $ (1,025) Year to Date $64,570 $38,630 25,940 $64,570 $12,740 4,430 8,770 $25,940 $ (90) (90) 88 6,030 2,832 $ 8,770 $ 1,265 3,740 (2,173) $ 2,832 $ (169) (1,421) (248) (154) (181) $(2,173) February $56 F $70 F 14 U $56 F $10 F 50 U 26 F $14 U $1F 1 U 1 F 40 F 15 U $26 F $5F 25 U 5 F $15 U Variance+ $2F 3U 5 F 1 U 2F $ 5F Year to Date $3 F $10 F 7U $ 3 F $40 F 70 U 23 F $ 7U $ 3F 30 F $23 F $ 5F 10 U 5 U $10 U $ 1 U 1 U 2 F 4 U 1 U $5U

Answer rating: 100% (QA)

Food and beverage department Banquets and catering Restaurant Kitchen From total expense below Total ... View the full answer