Weyden Hotel & Casino is situated on beautiful Lake Tahoe in Nevada. The complex includes a 300-room hotel, a casino, and a restaurant As Weyden's new controller, your manager asks you to recommend the basis the hotel should use for allocating fixed overhead costs to the three divisions in 2017. You are presented with the following income statement information for 2016 (Click the icon to view the data.) Requirement 1. Calculate division margins in percentage terms prior to allocating fixed overhead costs. (Round your answers to two decimal places, XXX) Restaurant Casino Hotel 50.52% Allocated fixed overhead costs Operating margin Operating margin% 45.68 % Hotel 7655256 2273744 % Division margin Requirement 2. Allocate indirect costs to the three divisions using each of the three allocation bases suggested. For each allocation base, calculate division operating margins after allocations, in dollars and as a por Allocate the indirect costs, then calculate the division operating margin in dollars and as a percentage of revenue for each segment Begin with cost allocation based on direct costs. (Round percentages, including intermediate calculations, to two decimal places, XXX%. Round dollar amounts to the nearest dollar. Use parentheses or a minus sign for negative amounts.) Weyden 63 30 % Restaurant 3393552 231848 Casino 3591192 4277108 14640000 6782700 Data table You are also given the following data on the three divisions. (Click the icon to view the data) Revenues Direct costs Segment margin You are told that you may choose to allocate Indirect costs based on one of the following direct costs, floor space, or the number of employees. Total fixed overhead costs for 2016 were $14,640,000. Read the requirements $ Hotel 19,654,000 $ 9,725,000 9,929,000 S Restaurant 7,936,000 $ 4.310,600 3,625,400 $ Data table Casino 12.430,000 4.561,700 7,868,300 Floor space (square feet) Number of employees Requirements Print Hotel Restaurant Casino 75.000 15,000 60,000 160 200 Done 40 1. Calculate division margins in percentage terms prior to allocating fixed overhead costs 2. Allocate indirect costs to the three divisions using each of the three allocation bases suggested. For each allocation base, calculate division operating margins after allocations, in dollars and as a percentage of revenues 3. Discuss the results. How would you decide how to allocate indirect costs to the divisions? Why?
Weyden Hotel & Casino is situated on beautiful Lake Tahoe in Nevada. The complex includes a 300-room hotel, a casino, and a restaurant As Weyden's new controller, your manager asks you to recommend the basis the hotel should use for allocating fixed overhead costs to the three divisions in 2017. You are presented with the following income statement information for 2016 (Click the icon to view the data.) Requirement 1. Calculate division margins in percentage terms prior to allocating fixed overhead costs. (Round your answers to two decimal places, XXX) Restaurant Casino Hotel 50.52% Allocated fixed overhead costs Operating margin Operating margin% 45.68 % Hotel 7655256 2273744 % Division margin Requirement 2. Allocate indirect costs to the three divisions using each of the three allocation bases suggested. For each allocation base, calculate division operating margins after allocations, in dollars and as a por Allocate the indirect costs, then calculate the division operating margin in dollars and as a percentage of revenue for each segment Begin with cost allocation based on direct costs. (Round percentages, including intermediate calculations, to two decimal places, XXX%. Round dollar amounts to the nearest dollar. Use parentheses or a minus sign for negative amounts.) Weyden 63 30 % Restaurant 3393552 231848 Casino 3591192 4277108 14640000 6782700 Data table You are also given the following data on the three divisions. (Click the icon to view the data) Revenues Direct costs Segment margin You are told that you may choose to allocate Indirect costs based on one of the following direct costs, floor space, or the number of employees. Total fixed overhead costs for 2016 were $14,640,000. Read the requirements $ Hotel 19,654,000 $ 9,725,000 9,929,000 S Restaurant 7,936,000 $ 4.310,600 3,625,400 $ Data table Casino 12.430,000 4.561,700 7,868,300 Floor space (square feet) Number of employees Requirements Print Hotel Restaurant Casino 75.000 15,000 60,000 160 200 Done 40 1. Calculate division margins in percentage terms prior to allocating fixed overhead costs 2. Allocate indirect costs to the three divisions using each of the three allocation bases suggested. For each allocation base, calculate division operating margins after allocations, in dollars and as a percentage of revenues 3. Discuss the results. How would you decide how to allocate indirect costs to the divisions? Why?
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Please solve with Explanation and do not give image format

Transcribed Image Text:Weyden Hotel & Casino is situated on beautiful Lake Tahoe in Nevada. The complex includes a 300-room hotel, a casino, and a restaurant. As
Weyden's new controller, your manager asks you to recommend the basis the hotel should use for allocating fixed overhead costs to the three divisions
in 2017. You are presented with the following income statement information for 2016:
(Click the icon to view the data.)
Requirement 1. Calculate division margins in percentage terms prior to allocating fixed overhead costs. (Round your answers to two decimal places, XXX.)
Restaurant
Casino
63.30 %
Hotel
50.52 %
Allocated fixed overhead costs
Operating margin
Operating margin %
45.68 %
Hotel
7655256
2273744
Division margin
Requirement 2. Allocate indirect costs to the three divisions using each of the three allocation bases suggested. For each allocation base, calculate division operating margins after allocations, in dollars and as a perd
Allocate the indirect costs, then calculate the division operating margin in dollars and as a percentage of revenue for each segment.
Begin with cost allocation based on direct costs. (Round percentages, including intermediate calculations, to two decimal places, X.XX%. Round dollar amounts to the nearest dollar. Use parentheses or a minus sign for negative amounts.)
Weyden
%
Restaurant
3393552
231848
%
Casino
3591192
4277108
%
14640000
6782700
Data table
Revenues
Direct costs
Segment margin
You are also given the following data on the three divisions.
(Click the icon to view the data.)
You are told that you may choose to allocate indirect costs based on one of the following direct costs, floor space, or the number of employees.
Total fixed overhead costs for 2016 were $14,640,000.
Read the requirements
$
$
Hotel
19.654,000 $
9,725,000
9,929,000 $
Print
Restaurant
7,936,000 S
4,310,600
3,625,400 S
Done
Data table
Casino
12.430,000
4,561,700
7,868,300
Floor space (square feet)
Number of employees
Requirements
Print
Hotel Restaurant Casino
75,000
60,000
160
200
15,000
40
Done
1. Calculate division margins in percentage terms prior to allocating fixed
overhead costs.
2. Allocate indirect costs to the three divisions using each of the three allocation
bases suggested. For each allocation base, calculate division operating
margins after allocations, in dollars and as a percentage of revenues.
3. Discuss the results. How would you decide how to allocate indirect costs to
the divisions? Why?
4. Would you recommend closing any of the three divisions (and possibly
reallocating resources to other divisions) as a result of your analysis? If so.
which division would you close and why?
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 2 images

Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,


Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,

Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON

Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education