The following data pertain to the Waikiki Sands Hotel for the month of March. Flexible Budget March (in thousands) * $ 685 1,870 (99) (725) (146) (89) (104) Actual Results March (in thousands)* $ 700 1,857 (100) (732) (143) (92) (114) Banquets and Catering Restaurants Kitchen staff wages Food Paper products Variable overhead Fixed overhead "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

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
The following data pertain to the Waikiki Sands Hotel for the month of March.
Flexible Budget March
(in thousands)*
2$
Actual Results March
(in thousands)*
$ 700
1,857
(100)
(732)
(143)
(92)
(114)
Banquets and Catering
Restaurants
Kitchen staff wages
Food
Paper products
Variable overhead
Fixed overhead
685
1,870
(99)
(725)
(146)
(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 "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
Prev
1 of 3
Next >
MacBook Pro
#3
3
$
4
%
&
2
5
7
8.
W
E
Y
OP
F
G
K
C
B
MOSISO
S'
Transcribed Image Text:The following data pertain to the Waikiki Sands Hotel for the month of March. Flexible Budget March (in thousands)* 2$ Actual Results March (in thousands)* $ 700 1,857 (100) (732) (143) (92) (114) Banquets and Catering Restaurants Kitchen staff wages Food Paper products Variable overhead Fixed overhead 685 1,870 (99) (725) (146) (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 "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 Prev 1 of 3 Next > MacBook Pro #3 3 $ 4 % & 2 5 7 8. W E Y OP F G K C B MOSISO S'
Flexible Budget*
Actual Results
Variance
Alols3
Year to Date SA
February
Year to Date
February
Year to Date
February
Company
;► $ 30,660
$ 64,567
$ 30,716
$64,570
$56 F
$ 3 F
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
Total profit
$ 30,660
$ 64,567
$ 30,716
$64.570
$56 F
$ 3F
Oahu Division
Waimea Beach Resort
$ 6,050
$ 12,700
$ 6,060
$12,740
$10 F
$40 F
Diamond Head Lodge
Waikiki Sands Hotel
2,100
4,500
2,050
4,430
50 U
70 U
4,110
8,747
4,136
8,770
26 F
23 F
Total profit
$ 12,260
$ 25,947
$ 12,246
$25,940
$14 U
$ 7U
Waikiki Sands Hotel
Grounds and Maintenance
$ (45)
$ 90)
$ (44)
$ (90)
(90)
$ 1F
Housekeeping and Custodial
(40)
(90)
(41)
1U
Recreational Services
40
85
41
88
1 F
$ 3F
Hospitality
Food and Beverage
2,800
6,000
2,840
6,030
40 F
30 F
1.355
2,842
1,340
2,832
15 U
10 U
Total profit
L $ 4,110
$ 8,747
$ 4,136
$ 8,770
$26 F
$23 F
Food and Beverage Department
Banquets and Catering
$ 600
$ 1,260
605
$ 1,265
$ 5F
$ 5F
Restaurants
1,785
3,750
1,760
3,740
25 U
10 U
Kitchen
(1,030)
(2,168)
(1,025)
(2.173)
5 F
5U
Total profit
$ 1,355
$ 2,842
$ 1,340
$ 2,832
$15 U
$10U
Kitchen
Kitchen staff wages
Food
$ (80)
(675)
$ (168)
(1,420)
(250)
(150
(180)
$ (169)
(1,421)
(248)
(154)
(181)
24
(78)
$ 2F
$ 1U
(678)
(115)
(71)
3U
1U
Paper products
Variable overhead
(120)
5 F
2F
(70)
(85)
1 U
4 U
Fixed overhead
(83)
2F
Total expense
$1,030)
$ (2,168
$ (1,025)
$2,173)
$ 5F
$ 5U
*Numbers without parentheses denote profit; numbers with parentheses denote expenses; numbers in thousands.
tF denotes favorable variance; U denotes unfavorable variance.
MacBook Pro
%23
%24
4
%
&
5
8
9
W
E
Y
G
H.
K
N
MOSISO
B8
F.
Transcribed Image Text:Flexible Budget* Actual Results Variance Alols3 Year to Date SA February Year to Date February Year to Date February Company ;► $ 30,660 $ 64,567 $ 30,716 $64,570 $56 F $ 3 F 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 Total profit $ 30,660 $ 64,567 $ 30,716 $64.570 $56 F $ 3F Oahu Division Waimea Beach Resort $ 6,050 $ 12,700 $ 6,060 $12,740 $10 F $40 F Diamond Head Lodge Waikiki Sands Hotel 2,100 4,500 2,050 4,430 50 U 70 U 4,110 8,747 4,136 8,770 26 F 23 F Total profit $ 12,260 $ 25,947 $ 12,246 $25,940 $14 U $ 7U Waikiki Sands Hotel Grounds and Maintenance $ (45) $ 90) $ (44) $ (90) (90) $ 1F Housekeeping and Custodial (40) (90) (41) 1U Recreational Services 40 85 41 88 1 F $ 3F Hospitality Food and Beverage 2,800 6,000 2,840 6,030 40 F 30 F 1.355 2,842 1,340 2,832 15 U 10 U Total profit L $ 4,110 $ 8,747 $ 4,136 $ 8,770 $26 F $23 F Food and Beverage Department Banquets and Catering $ 600 $ 1,260 605 $ 1,265 $ 5F $ 5F Restaurants 1,785 3,750 1,760 3,740 25 U 10 U Kitchen (1,030) (2,168) (1,025) (2.173) 5 F 5U Total profit $ 1,355 $ 2,842 $ 1,340 $ 2,832 $15 U $10U Kitchen Kitchen staff wages Food $ (80) (675) $ (168) (1,420) (250) (150 (180) $ (169) (1,421) (248) (154) (181) 24 (78) $ 2F $ 1U (678) (115) (71) 3U 1U Paper products Variable overhead (120) 5 F 2F (70) (85) 1 U 4 U Fixed overhead (83) 2F Total expense $1,030) $ (2,168 $ (1,025) $2,173) $ 5F $ 5U *Numbers without parentheses denote profit; numbers with parentheses denote expenses; numbers in thousands. tF denotes favorable variance; U denotes unfavorable variance. MacBook Pro %23 %24 4 % & 5 8 9 W E Y G H. K N MOSISO B8 F.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education