Homework Help is Here – Start Your Trial Now!
Business
Accounting
1 The following data pertain to the Waikiki Sands Hotel for the month of March. 33.33 points Banquets and Catering Restaurants Kitchen staff wages Food Paper products Variable overhead Fixed overhead Flexible Budget March (in thousands)* $ 715 1,930 (111) (755) (164) (101) (116) Actual Results March (in thousands)* $ 736 1,911 (112) (768) (161) (104) (132) *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 (l.e., zero varlance). Enter your answers in thousands.) Food and Beverage Department Answer is complete but not entirely correct. WAIKIKI SANDS HOTEL Performance Reports for March Flexible Budget March Year to Date (In Thousands) Actual Results March Year to Date Variance March Year to Date 0000 000000 Banquets & Catering Restaurants Kitchen Total profit $ 715 S 715 S 736 S 736 S 21 F 1,930 1.930 x 1,911 1,911 (19) U (111) (111) x (112) (112) X (1) U $ 2,534 S 2,534 $ 2,535 S 2,535 S (1) U Kitchen Kitchen staff wages $ (111) S (111) $ (112) S (112) S (1) U Food (755) (755) (768) (768) (13) U Paper products (164) (164) (161) (161) x 3 F Variable overhead (101) (101) (104) (104) (3) U Fixed overhead (116) (116) (132) (132) (16) U Total expense (1,247) S (1,247) $ (1.277) (1,277) S (30) U 0000 000000 21 F (19) U (1) U (1) U $ (1) U (13) U 3 F (3) U (16) U (30) U

1 The following data pertain to the Waikiki Sands Hotel for the month of March. 33.33 points Banquets and Catering Restaurants Kitchen staff wages Food Paper products Variable overhead Fixed overhead Flexible Budget March (in thousands)* $ 715 1,930 (111) (755) (164) (101) (116) Actual Results March (in thousands)* $ 736 1,911 (112) (768) (161) (104) (132) *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 (l.e., zero varlance). Enter your answers in thousands.) Food and Beverage Department Answer is complete but not entirely correct. WAIKIKI SANDS HOTEL Performance Reports for March Flexible Budget March Year to Date (In Thousands) Actual Results March Year to Date Variance March Year to Date 0000 000000 Banquets & Catering Restaurants Kitchen Total profit $ 715 S 715 S 736 S 736 S 21 F 1,930 1.930 x 1,911 1,911 (19) U (111) (111) x (112) (112) X (1) U $ 2,534 S 2,534 $ 2,535 S 2,535 S (1) U Kitchen Kitchen staff wages $ (111) S (111) $ (112) S (112) S (1) U Food (755) (755) (768) (768) (13) U Paper products (164) (164) (161) (161) x 3 F Variable overhead (101) (101) (104) (104) (3) U Fixed overhead (116) (116) (132) (132) (16) U Total expense (1,247) S (1,247) $ (1.277) (1,277) S (30) U 0000 000000 21 F (19) U (1) U (1) U $ (1) U (13) U 3 F (3) U (16) U (30) U

Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter23: Flexible Budgeting (flexbud)
Section: Chapter Questions
Problem 4R
See similar textbooks
icon
Related questions
Question
None
1 The following data pertain to the Waikiki Sands Hotel for the month of March. 33.33 points Banquets and Catering Restaurants Kitchen staff wages Food Paper products Variable overhead Fixed overhead Flexible Budget March (in thousands)* $ 715 1,930 (111) (755) (164) (101) (116) Actual Results March (in thousands)* $ 736 1,911 (112) (768) (161) (104) (132) *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 (l.e., zero varlance). Enter your answers in thousands.) Food and Beverage Department Answer is complete but not entirely correct. WAIKIKI SANDS HOTEL Performance Reports for March Flexible Budget March Year to Date (In Thousands) Actual Results March Year to Date Variance March Year to Date 0000 000000 Banquets & Catering Restaurants Kitchen Total profit $ 715 S 715 S 736 S 736 S 21 F 1,930 1.930 x 1,911 1,911 (19) U (111) (111) x (112) (112) X (1) U $ 2,534 S 2,534 $ 2,535 S 2,535 S (1) U Kitchen Kitchen staff wages $ (111) S (111) $ (112) S (112) S (1) U Food (755) (755) (768) (768) (13) U Paper products (164) (164) (161) (161) x 3 F Variable overhead (101) (101) (104) (104) (3) U Fixed overhead (116) (116) (132) (132) (16) U Total expense (1,247) S (1,247) $ (1.277) (1,277) S (30) U 0000 000000 21 F (19) U (1) U (1) U $ (1) U (13) U 3 F (3) U (16) U (30) U
Transcribed Image Text:1 The following data pertain to the Waikiki Sands Hotel for the month of March. 33.33 points Banquets and Catering Restaurants Kitchen staff wages Food Paper products Variable overhead Fixed overhead Flexible Budget March (in thousands)* $ 715 1,930 (111) (755) (164) (101) (116) Actual Results March (in thousands)* $ 736 1,911 (112) (768) (161) (104) (132) *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 (l.e., zero varlance). Enter your answers in thousands.) Food and Beverage Department Answer is complete but not entirely correct. WAIKIKI SANDS HOTEL Performance Reports for March Flexible Budget March Year to Date (In Thousands) Actual Results March Year to Date Variance March Year to Date 0000 000000 Banquets & Catering Restaurants Kitchen Total profit $ 715 S 715 S 736 S 736 S 21 F 1,930 1.930 x 1,911 1,911 (19) U (111) (111) x (112) (112) X (1) U $ 2,534 S 2,534 $ 2,535 S 2,535 S (1) U Kitchen Kitchen staff wages $ (111) S (111) $ (112) S (112) S (1) U Food (755) (755) (768) (768) (13) U Paper products (164) (164) (161) (161) x 3 F Variable overhead (101) (101) (104) (104) (3) U Fixed overhead (116) (116) (132) (132) (16) U Total expense (1,247) S (1,247) $ (1.277) (1,277) S (30) U 0000 000000 21 F (19) U (1) U (1) U $ (1) U (13) U 3 F (3) U (16) U (30) U
Expert Solution
steps

Step by step

Solved in 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Accounting (Text Only)
Accounting (Text Only)
Accounting
ISBN:
9781285743615
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
SEE MORE TEXTBOOKS