Purchase Solution

The Westar Hotel - Beverage Regression Analysis

Not what you're looking for?

Ask Custom Question

(See attached file for full problem description)

The Westar hotel, a 250-room business hotel located in a resort area of the Colorado Rockies, has two lounges on its premises: the Pour Nous Lounge, a pub-style lounge that seats about 50, and Gaiete, a 200-seat nightclub.

Jane Bartley is a staff analyst for Westar's corporate parent, charged (among other things) with predicting and analyzing beverage sales (liquor, beer, and wine, primarily) for the chain's business hotels. In fact, her deadline for producing some sort of forecast for Westar beverage sales was the end of the week. After years in the business, Jane had seen a lot of approaches to forecasting beverage sales, but none that struck her as particularly helpful. Most of them used only room occupancy as a basis for forecasting.

What factors appear to influence beverage sales at the Westar?

Should Westar consider re-hiring the piano player for the Pour Nous Lounge?

How about happy hour food?

Can you suggest a new forecasting method for Jane to try out?

***USE THE MULTIPLE REGRESSION MODEL***

Attachments
Purchase this Solution
Solution Summary

The solution explains in details the concept of multiple regression analysis and then provides step-by-step calculations for the problem.

Solution Preview

This question can be approached using the Excel Analysis Tool. It is one of the Add-Ins options. If you don't normally have this tool, it needs to be installed from a Microsoft Office CD-ROM.

Firstly i have re-typed the data and put them in the sheet called "Raw data".
I then use the Multiple Regression analysis tool by going to Tools - Data Analysis in Excel and chose Regression.
Here you can specify ...

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • Multiple Regression and Model Building

    See attached excel file for the Dataset, Multiple Regression and Model Building - Westar Beverage Sales Case Study BEWARE OF MULTICOLLINEARITY. The statistical analysis of the data involves Multiple Regression analysis.

  • A Case study using Multiple Regression Analysis

    276376 MULTIPLE REGRESSION MODEL The Westar hotel, a 250 room business hotel has 2 lounges on its premises: Pour Nous Lounge (for 50 people)and Gaisete - for 200. We need to forcast beverage sales.

  • Regression model to forecast sales of cold beverages for the

    For problem description, please see posting 78450 in the solution library. In this example, what factors appear to influence beverage sales at the Westar? Should Westar consider re-hiring the piano player for the Pour Nous Lounge?

  • Financial ratio analysis for hotel in Costa Mesa, California

    324707 Financial ratio analysis for hotel in Costa Mesa, California See attached files. Prepare a analysis of Situation 9.6 In your financial analysis, discuss the findings from your calculations and how they effect the organization.

  • Facilities Management and Design in Hospitality and Tourism

    It is imperative for the architect to put into consideration the number of people that the food and beverage outlet can hold.

  • Regression analysis for baseball data

    113860 Regression analysis for baseball data The manager of the Ramona Inn Hotel near Cloverleaf Stadium believes that how well the local Blue Sox professional baseball team is playing has an impact on the occupancy rate at the hotel during the summer

  • Perform simple regression analysis and calculate Durbin-Watson statistic

    Answer: we run the regression analysis in excel. I include the excel file. The regression equation is Time=17.08-5(Tamp) 
b. Predict the separation time for a tamp distance of 0.50 inch.

  • Hospitality Industry Experience and Management

    Food and Beverage and General Manager Our experience with the Food and Beverage Manager was a personal one as he was at every meal and attended the weekly cocktail party for guests.

  • Food and beverage in the gaming industry?

    In addition, food and beverage services in the gaming industry are usually owned and managed by the same individuals that own and manage the hotel, casino, or other facility that is hosting the gaming activities.

View More Related Solutions