Case StudyCaesars 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 representsan 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:• Go to Learning Objective 6 in Chapter 7 of the textbook and follow the instructions – How to Use the “What-If” Analysis to Create a Data Table• The profit calculation should be for a one-month period using Caesars’ information above for the Julius Tower (i.e., after the renovation).• Sales price is the sales price per room per night – use a range of $50 to $200 in increments of $10.• Volume is the number of hotel room nights in a month, assuming 30 days per month – use a range of 1,000 to 20,000 in increments of 1,000.Perform the above What-If Analysis in Excel and think about Logan’s below questions. Then, write a memo to Logan in Word summarizing your findings and providing your responses to Logan’s questions.
Assuming costs remain unchanged, in order for Julius Tower to break even:a. How many hotel room nights need to be booked per month at $150 per room night?b. What sales price per room night needs to be charged for 16,000 room nights per month?(Hint: Use the What-If Analysis data table to identify the break-even point in the respective column (sales price per room night) or row (number of hotel room nights). Then, provide your answer as a range of from the data table such as, Julius Tower needs between #### and #### hotel room nights per month booked at $150 to break even.)
Assuming costs remain unchanged, in order for Julius Tower to reach the monthly target operating income:a. How many hotel room nights need to be booked per month at $150 per room night?b. What sales price per room night needs to be charged for 16,000 room nights per month?
Without increasing the number of hotel room nights booked per month or increasing the sales price per room night, the other option to increase operating income to the monthly target is to reducecosts. Provide 5 examples of costs typically associated with a hotel that Julius Tower could evaluate for potential cost reductions. For each cost, state if the cost is a variable cost or a fixed cost for Julius Tower.
Is Julius Tower at risk of not reaching break-even? Explain why.
If you were the manager of Julius Tower, would you think Caesars’ target for monthly operating income of $2,000,0000 is too high, too low, or about right for Julius Tower? Explain why
regards to the osmosis of pieces into lumps. Mill operator recognizes pieces and lumps of data, the differentiation being that a piece is comprised of various pieces of data. It is fascinating regards to the osmosis of pieces into lumps. Mill operator recognizes pieces and lumps of data, the differentiation being that a piece is comprised of various pieces of data. It is fascinating to take note of that while there is a limited ability to recall lumps of data, how much pieces in every one of those lumps can change broadly (Miller, 1956). Anyway it’s anything but a straightforward instance of having the memorable option huge pieces right away, somewhat that as each piece turns out to be more natural, it very well may be acclimatized into a lump, which is then recollected itself. Recoding is the interaction by which individual pieces are ‘recoded’ and allocated to lumps. Consequently the ends that can be drawn from Miller’s unique work is that, while there is an acknowledged breaking point to the quantity of pi>
GET ANSWER
Share on Facebook
Tweet
Follow us
- WE OFFER THE BEST CUSTOM PAPER WRITING SERVICES. WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU.
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
QUALITY: 100% ORIGINAL PAPER – NO PLAGIARISM – CUSTOM PAPER
Why Choose Us?
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How It Works
- Click on the “Place Your Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the “PAPER DETAILS” section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.
About AcademicWritersBay.com
AcademicWritersBay.com is an easy-to-use and reliable service that is ready to assist you with your papers 24/7/ 365days a year. 99% of our customers are happy with their papers. Our team is efficient and will always tackle your essay needs comprehensively assuring you of excellent results. Feel free to ask them anything concerning your essay demands or Order.
AcademicWritersBay.com is a private company that offers academic support and assistance to students at all levels. Our mission is to provide proficient and high quality academic services to our highly esteemed clients. AcademicWritersBay.com is equipped with competent and proficient writers to tackle all types of your academic needs, and provide you with excellent results. Most of our writers are holders of master’s degrees or PhDs, which is an surety of excellent results to our clients. We provide assistance to students all over the world.
We provide high quality term papers, research papers, essays, proposals, theses and many others. At AcademicWritersBay.com, you can be sure of excellent grades in your assignments and final exams.
