Question

The following data pertain to the Waikiki Sands Hotel for the month of March Flexible Budget Actual Results March March (in thousands)* (in thousands)* $ 665 1,830 $ 676 1,821 Banquets and Catering Restaurants Kitchen staff wages Food Paper products Variable overhead Fixed overhead (92) (708) (131) (84) (102) (91) (705) (134) (81) (96) "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 "0" 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 Variance March Year to Date March Year to Date 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 Flexible Budget Variance Actual Results February Year to Date $ 64,567 $ 38,620 25,947 $ 64,567 February $ 30,716 $18,470 12,246 $ 30,716 Year to Date February $56 F $70 F Year to Date 30,660 $18,400 12,260 30,660 $64,570 $38,630 25,940 $64,570 Company Maui Division 0ahu Division Total profit $56 F 0ahu Division 6,050 2,100 4,110 $12,260 $12,740 4,430 8,770 $25,940 $12,700 4,500 8,747 $25,947 Waimea Beach Resort Diamond Head Lodge Waikiki Sands Hotel Total profit $ 6,060 2,050 $10 F $40 F $ 12,246 Waikiki Sands Hotel Grounds and Maintenance Housekeeping and Custodial Recreational Services Hospitality Food and Beverage Total profit $ (44) 41 41 2,840 1,340 $ 4,136 (90) 85 6,000 2,842 $ 8,747 (90) 40 6,030 2,832 $8,770 2,800 15 U 10 U $4,110 $26 F $23 F Food and Beverage Department $ 600 1,785 (1,030) $ 605 1,760 1,025 $ 1,340 1,265 3,740 $ 1,260 3,750 Banquets and Catering Restaurants Kitchen 25 U 10 U 1,352842 1340 2832 $15U $10U Total profit $ 2,842 $2,832 $15 U $10 U Kitchen $ (169) 1.421) $ 2 F Kitchen staff wages Food Paper products Variable overhead Fixed overhead $ (80) $ (168) (1,420) (181) $(2,173) (85) $ (1,030) (83) $(1,025) $ (2,168) Total expense

Answer 1

WAIKIKI SANDS HOTEL
Performance Reports for March
(In Thousands)
	Flexible Budget		Actual Results		Variance
	March	Year to Date	March	Year to Date	March		Year to Date
Food and Beverage Department
Banquets & Catering	$             665	$           1,925	$             676	$           1,941	$           11	F	$           16	F
Restaurants	1,830	5,580	1,821	5,561	9	U	19	U
Kitchen	(1,107)	(3,275)	(1,117)	(3,290)	10	U	15	U
Total Profit	$         1,388	$           4,230	$         1,380	$           4,212	$              8	U	$           18	U
Kitchen
Kitchen Staff Wages	$             (91)	$             (259)	$             (92)	$             (261)	$              1	U	$              2	U
Food	(705)	(2,125)	(708)	(2,129)	3	U	4	U
Paper Products	(134)	(384)	(131)	(379)	3	F	5	F
Variable Overhead	(81)	(231)	(84)	(238)	3	U	7	U
Fixed Overhead	(96)	(276)	(102)	(283)	6	U	7	U
Total Expense	$       (1,107)	$         (3,275)	$       (1,117)	$         (3,290)	$           10	U	$           15	U