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 an 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 $5,000,000. This amount represents an increase of $320,000 per year compared to pre-renovation. Also, assume that the variable cost per hotel room night after the renovation is $28; 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, Ashton Willow, 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: 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 500. Perform the above What-If Analysis in Excel and think about Ashtons below questions. Then, write a memo to Ashton in Word summarizing your findings and providing your responses to Ashtons questions. 1. 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 from the data table such as, Julius Tower needs between #### and #### hotel room nights per month booked at $150 to break even.) 2. 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? (Hint: Use the What-If Analysis data table to identify the target operating income point in the respective column (sales price per room night) or row (number of hotel room nights). Then, provide your answer as a range from the data table such as, Julius Tower needs between #### and #### hotel room nights per month booked at $150 to reach its target operating income.) The analysis revealed that Julius Tower needs to book approximately 12,857 to 13,333 hotel room nights per month at a sales price of $150 to break even. To reach the monthly target operating income of $2,000,000, Julius Tower needs to book 16,000 hotel room nights per month at the same sales price. HOW WERE THESE NUMBERS CALCULATED? CAN YOU PLEASE SHOW THE WORK?