Module $3$ Case Study After watching the Module $3$ Case Study Videos, read the below background information for this case:

Caesars Palace$$ Las Vegas, owned and operated by Caesars Entertainment Corporation $($CZR$),$ opened in $1966.$ The Nevada hotel$-$and$-$casino complex has been featured in several movies, including Rain Man, Iron Man, and The Hangover Part III. Caesars Palace is the $14$th largest hotel in the world. Caesars Palace$$ Las Vegas includes six towers $($named Augustus, NOBU Hotel, Julius $[$formerly named Roman$],$ Palace, Octavius, and Forum$).$ Beyond guest accommodations, the complex also included casinos, retail shops, restaurants, nightclubs, a $4,296-$seat entertainment venue, and a large convention facility.

Assume you work in the accounting department of Caesars Entertainment and your supervisor, Logan Lacy, provides you with the attached Excel file containing food and beverage costs and the number of hotel rooms$/$suites for Caesars for the years $1993$ to $2023.$ Logan asks you to develop a cost prediction model using the number of hotel rooms$/$suites $($independent variable, x$-$axis$)$ to predict food and beverage costs $($dependent variable, y$-$axis$).$ Perform the analysis in Excel and think about the related questions $(3$ and $4$ below$).$ Then, write a memo to Logan in Word summarizing your findings and providing your responses to Logan$$s questions.

$1.$ Using the high$-$low method, calculate in Excel the following estimates:

$$ Variable food and beverage cost per hotel room$/$suite

$$ Fixed food and beverage costs per year

$\backslash$table$[[$ded$,$Food and beverage costs,No of hotel rooms & suites$],[\frac{12}{31}\frac{?}{23},1,090,956,000,41,640],[\frac{12}{31}\frac{?}{22},895,400,000,36,185],[\frac{12}{31}\frac{?}{21},792,850,000,32,852],[\frac{12}{31}\frac{?}{20},880,300,000,31,950],[\frac{12}{31}\frac{?}{19},641,000,000,36,780],[\frac{12}{31}\frac{?}{18},1,106,000,000,45,920],[\frac{12}{31}\frac{?}{17},555,300,000,47,460],[\frac{12}{31}\frac{?}{16},572,000,000,41,730],[\frac{12}{31}\frac{?}{15},399,000,000,41,180],[\frac{12}{31}\frac{?}{14},694,000,000,39,218],[\frac{12}{31}\frac{?}{13},639,000,000,42,200],[\frac{12}{31}\frac{?}{12},634,000,000,42,710],[\frac{12}{31}\frac{?}{11},665,700,000,42,890],[\frac{12}{31}\frac{?}{10},621,300,000,42,010],[\frac{12}{31}\frac{?}{09},596,000,000,41,830],[\frac{12}{31}\frac{?}{08},639,500,000,39,170],[\frac{12}{31}\frac{?}{07},716,500,000,38,130],[\frac{12}{31}\frac{?}{06},697,600,000,38,060],[\frac{12}{31}\frac{?}{05},482,300,000,42,870],[\frac{12}{31}\frac{?}{04},278,100,000,17,220],[\frac{12}{31}\frac{?}{03},255,200,000,14,780],[\frac{12}{31}\frac{?}{02},240,600,000,14,551],[\frac{12}{31}\frac{?}{01},232,400,000,13,598],[\frac{12}{31}\frac{?}{00},228,000,000,11,562],[\frac{12}{31}\frac{?}{99},218,600,000,11,760],[\frac{12}{31}\frac{?}{98},116,600,000,11,685],[\frac{12}{31}\frac{?}{97},103,600,000,8,197],[\frac{12}{31}\frac{?}{96},95,900,000,6,478],[\frac{12}{31}\frac{?}{95},91,500,000,5,736],[\frac{12}{31}\frac{?}{94},82,800,000,5,367],[\frac{12}{31}\frac{?}{93},76,500,000,5,348]]$