Skip to content
Solved Assignments

Management Report for Case Analysis � Prescott Maples Attendance

A business case analysis focusing on management strategies for employee attendance tracking.

Preview 4 of 10 pages

See the first 4 pages exactly as they appear in the document.

  1. Page 1
    Read page 1 as text

    Page 1 of 10 Management Report for Case Analysis – Prescott Maples Attendance In the case analysis of Prescott Maples Attendance, a multiple regression model was developed to predict game attendance based on regular ticket sales, advanced ticket sales, and hot dog sales. Based on the analysis provided, answer the following questions: 1. Interpret the findings from the regression analysis. What can be concluded about the relationship between regular ticket sales, advanced ticket sales, and hot dog sales with total attendance? How do these variables impact attendance predictions? 2. Discuss the significance of hot dog sales in predicting attendance. Why was hot dog sales excluded from the final model, and what implications does this have for future predictions? 3. Given the results from the exploratory data analysis (EDA), regression model, and predictions, what recommendations would you provide to Bud Ford and the staff of the Prescott Maples for improving their attendance forecasting methods? Word Count Requirement: 800 - 1000 words

  2. Page 2
  3. Page 3
    Read page 3 as text

    Page 2 of 10 Executive Summary Bud Ford, the general manager and owner of the double A farm team, the Prescott Maples, has been talking to his staff about a better way of predicting attendance at the Maple’s home games. To fulfill his objective his stadium manager and concession manager have been trying to figure out how they could better predict the attendance at five (5) typical Maple games by constructing a multiple regression between the total attendance as dependent variable and the regular ticket sales; advanced ticket sales; and Hot dogs sold at the game as predictors by collecting a sample of 20 observations on these variables. Performed exploratory data analysis by appropriate numerical and graphical summaries and found that none of these variables had normal distribution. The variable Hot dogs sold at the game is had a non - significant relationship with total attendance. So re - run the multiple regression with the variables those having significant linear relationship. Then better predict ed the attendance at five (5) typical Maple games by using that multiple regression equation. T he predicted attendance in Table 1 indicated that when the regular ticket sales and advance ticket sales are larger, then the total attendance is also larger and vice versa. Also found that the number of hot dogs that could be sold no way affect the estimated a ttendance . Background

  4. Page 4
    Read page 4 as text

    Page 3 of 10 Bud Ford, the general manager and owner of the double A farm team, the Prescott Maples, has been talking to his staff about a better way of predicting attendance at the Maple’s home games. Playing at ACE Stadium in west Prescott, the team averages about 2,000 people in attendance for each home game. The team sells season tickets, day of game tickets and gives away some tickets to sponsors, nonprofit organizations serving children, and for other good causes. So while the team may sell over the average number of seats, this does not translate into people actually attending a game. Bud said, “I just don’t understand it! They pay for a seat then don’t come. It makes no sense to me.” So his stadium manager and concession manager have been trying to figure out how they could better predict the attendance at five (5) typical Maple games. The concession manager, Ralph Peanut, believes that part of this prediction could be the estimated number of hot dogs that would be sold at the game. Bud and the stadium manager aren’t sure, but are willing to put this theory to the test. That’s where you come into the picture. Your job is to investigate the historical data prepared by Bud, and then using that data create a multiple regression that helps to predict the attendance at these five typical games. Problem The problem involved in this study is as stated below: What general things can you tell Bud Ford about projected attendance at these games? Does knowing the number of hot dogs that could be sold help or hurt the estimated attendance theory? Analysis

6 more pages in the full document

Unlock it once and it stays in your library, ready to chat with or turn into flashcards.

Unlock the full document

More Business Management study materials

See all

Study this document with CramX

Once it is in your library, every tool can work from it.