Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Raphael Hotel & Casino is situated on beautiful Lake Tahoe in Nevada. The complex includes a 300-room hotel, a casino, and a restaurant. As Raphael's
Raphael Hotel & Casino is situated on beautiful Lake Tahoe in Nevada. The complex includes a 300-room hotel, a casino, and a restaurant. As Raphael'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.) You are also given the following data on the three divisions. B3 (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,590,000. Read the requirements. Data Table Hotel Restaurant Casino Revenues $ 19,654,000 $ 9,650,000 5,931,000 $ 4,310,600 12,390,000 4,475,500 Direct costs $ 10,004,000 $ 1,620,400 $ 7,914,500 Segment margin - X Data Table Hotel Restaurant Casino 125,000 25,000 100,000 Floor space (square feet) Number of employees 160 40 200 Print Done Requirement 1. Calculate division margins in percentage terms prior to allocating fixed overhead costs. (Round your answers to two decimal places, X.XX.) Hotel Restaurant Casino Division margin 50.90 % 27.32 % 63.88 % 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 percentage of revenues. 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.) Hotel Restaurant Casino Raphael Allocated fixed overhead costs 7636838 3411332 3541831 14590001 Operating margin Operating margin % % % %
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started