Caesar Entertainment Corporation's Form 10-K contains a variety of data in addition to financial statements. Below is

Question:

Caesar Entertainment Corporation's Form 10-K contains a variety of data in addition to financial statements. Below is a list that contains Caesars' food and beverage costs (adapted) taken from its Statements of Operations for the past 22 years. In addition, the number of hotel rooms and suites owned by Caesars at the end of each of those 22 years has been gathered from other information provided in the Form 10-Ks.
# of hotel rooms & suites Year ended Food and beverage costs $ 694,000,000 $ 639,000,000 $ 634,000,000 $ 665,700,000 $ 6

Requirements
1. Using the high-low method, find the following cost estimates:
a. Variable food and beverage cost per hotel room/suite
b. Fixed food and beverage cost per hotel room/suite
2. Perform a regression analysis using Excel. Use # of hotel rooms & suites as the X and the Food and beverage costs as the Y in your regression analysis.
a. What is the estimated variable food and beverage cost per hotel room/suite?
b. What is the estimated fixed food and beverage cost per hotel room/suite?
c. In your opinion, is the number of hotel rooms and suites a good predictor of Caesars' food and beverage costs? Why or why not?
Compare the estimates of variable and fixed costs calculated using the high-low method to the estimates calculated using the regression method. Which method would most likely provide a better cost estimate? Explain.

Fantastic news! We've located the answer you've been seeking!

Step by Step Answer:

Related Book For  answer-question

Managerial Accounting

ISBN: 978-0134128528

5th edition

Authors: Karen W. Braun, Wendy M. Tietz

Question Posted: