Module 4 - Case Study Caesars Palace Las Vegas made headlines when it undertook a $75...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Module 4 - Case Study Caesars Palace Las Vegas made headlines when it undertook a $75 million renovation. During the renovation, the hotel closed its then-named Roman Tower, which was last updated 14 years prior, and started a major renovation of the 567 rooms housed in that tower. On January 1, 2016, the newly renamed Julius Tower reopened, replacing the Roman Tower. In addition to renovating the existing rooms and suites in the former Roman Tower, 33 guest rooms were added to the Roman Tower. With the renovation completed, Caesars expects the Julius Tower room rate to average around $150 per night. This increase, a $25 or 20% increase, reflects, in part, the room improvements. Julius Tower expects to have 16,000 room nights booked per month, which is a 88.88 % occupancy rate (16,000 rooms booked / (600 rooms available x 30 days per month)). Caesars' target operating income for Julius Tower is $2,000,000 per month. Assume that the annual fixed operating costs for the Julius Tower are $4,680,000. This amount represents an increase of $200,000 per year compared to pre-renovation. Also, assume that the variable cost per hotel room night after the renovation is $27; before the renovation, the variable cost per room night was $20. Instructions: Assume you work in the accounting department of Caesars Entertainment and your supervisor, Logan Lacy, provides you with the above information and asks you to use the What-if Analysis tool in Excel to analyze sales price volume and profit related to the Julius Tower. For the What if Analysis: Module 4 - Case Study Caesars Palace Las Vegas made headlines when it undertook a $75 million renovation. During the renovation, the hotel closed its then-named Roman Tower, which was last updated 14 years prior, and started a major renovation of the 567 rooms housed in that tower. On January 1, 2016, the newly renamed Julius Tower reopened, replacing the Roman Tower. In addition to renovating the existing rooms and suites in the former Roman Tower, 33 guest rooms were added to the Roman Tower. With the renovation completed, Caesars expects the Julius Tower room rate to average around $150 per night. This increase, a $25 or 20% increase, reflects, in part, the room improvements. Julius Tower expects to have 16,000 room nights booked per month, which is a 88.88 % occupancy rate (16,000 rooms booked / (600 rooms available x 30 days per month)). Caesars' target operating income for Julius Tower is $2,000,000 per month. Assume that the annual fixed operating costs for the Julius Tower are $4,680,000. This amount represents an increase of $200,000 per year compared to pre-renovation. Also, assume that the variable cost per hotel room night after the renovation is $27; before the renovation, the variable cost per room night was $20. Instructions: Assume you work in the accounting department of Caesars Entertainment and your supervisor, Logan Lacy, provides you with the above information and asks you to use the What-if Analysis tool in Excel to analyze sales price volume and profit related to the Julius Tower. For the What if Analysis:
Expert Answer:
Answer rating: 100% (QA)
To perform a whatif analysis on the Julius Tower renovation we will create a scenario that reflects the potential impact of the renovation on the towe... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Caesars Palace Las Vegas made headlines when it undertook a $75 million renovation. In mid-September 2015, the hotel closed its then-named Roman Tower, which was last updated in 2001, and started a...
-
This case is a continuation of the Caesars Entertainment Corporation serial case that began in Chapter 1. Refer to the introductory story in Chapter 1 (see page 43) for additional background. (The...
-
pick 1 1 point A small island nation has license plates that consist of 2 letters ( \( A-Z \) allowed) followed by 3 numbers (0 \( -9 \) allowed). How many plates are possible that do not repeat the...
-
If n = 5 and p = 0.40, what is the probability that a. X = 4? b. X ( 3? c. X < 2? d. X > 1?
-
Give an example of each kind of riskpersonal, property, and liability.
-
Discuss why entry into the assurance services market is important to public accounting firms.
-
During fiscal year 2014, the City of Hickory Hills issued purchase orders to various vendors in the amounts shown for the following functions of the city: General Government ....... $ 82,500 Public...
-
The government of Bangladesh believes that production of its exportable good (Jute) generates positive externalities in its country. The world price of this good is $25. The external benefit is...
-
Refer to the North Valley Real Estate data, which report information on homes sold during the last year. For the variable price, select an appropriate class interval and organize the selling prices...
-
A local university has a goal of raising $500,000 for an escrow account. Their fund-raising committee has committed to raising $5,000 a month until they reach their goal. These funds are deposited...
-
Write a client of Percolation like PercolationVisualizer that does a series of experiments for a value of n taken from the command line where the site vacancy probability p increases from 0 to 1 by a...
-
For the frame in Figure P8.33, compute the horizontal and vertical displacements at joint \(B\). Given: \(I=150\) in. \({ }^{4}, E=29,000 \mathrm{kips} / \mathrm{in} .{ }^{2}\). Consider only the...
-
A light ray travels inside a block of sodium fluoride that has index of refraction \(n=1.33\) as shown in Figure \(\mathrm{P} 18.16\). The ray strikes the vertical wall at the critical angle, totally...
-
A car is \(12 \mathrm{~m}\) from the bottom of a ramp that is \(8.0 \mathrm{~m}\) long at its base and \(6.0 \mathrm{~m}\) high (Figure P3.81). The car moves from rest toward the ramp with an...
-
Modified quotas are given in Problems 7-14. Round your answers to two decimal places. a. Find the lower and upper quotas. b. Find the arithmetic mean of the lower and upper quotas. c. Find the...
-
Harley Company has sales of $500,000,variable costs are 75% of sales, and operating income is $40,000.What is Harley's operating leverage? A) 0.0 B) 1.2 C) 1.3 D) 3.1
-
How do network effects help Facebook fend off smaller social-networking rivals? Could an online retailer doing half as much business compete on an equal footing with Amazon in terms of costs? Explain.
-
Giant Construction Toys Corp. is using a costs-of-quality approach to evaluate design engineering efforts for a new toy robot. The company's senior managers expect the engineering work to reduce...
-
Melody Leigh, owner of Broadway Floral, operates a local chain of floral shops. Each shop has its own delivery van. Instead of charging a flat delivery fee, Leigh wants to set the delivery fee based...
-
Newton Industries has a relevant range extending to 31,800 units each month. The following performance report provides information about Newton's budget and actual performance for April: Requirement...
-
What are the three main techniques used to analyze capital budgeting projects? Discuss the advantages and disadvantages of each method.
-
Define concept growth. What does this mean to entrepreneurial firms?
-
What are the main components of capital budgeting? What are the three main types of cash flows?
Study smarter with the SolutionInn App