Management Report for Case Analysis � Prescott Maples Attendance

Preview (4 of 10 Pages)

100%

Management Report for Case Analysis � Prescott Maples Attendance - Page 1 preview image

Loading page ...

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

Management Report for Case Analysis � Prescott Maples Attendance - Page 2 preview image

Loading page ...

Management Report for Case Analysis � Prescott Maples Attendance - Page 3 preview image

Loading page ...

Page2of10Executive SummaryBud Ford, the general manager and owner of the double A farm team, the Prescott Maples, hasbeen talking to his staff about a better way of predicting attendance at the Maple’s home games.To fulfillhisobjective hisstadium manager and concession manager have been trying to figureout how they could better predict the attendanceat five (5) typical Maple games by constructinga multiple regression betweenthe totalattendanceas dependent variableand theregular ticketsales; advanced ticket sales; and Hot dogs sold at the gameas predictors by collecting a sampleof 20 observations on these variables.Performed exploratory data analysis by appropriate numerical and graphical summaries andfound that none of these variables had normal distribution. The variableHot dogs sold at thegameis had a non-significant relationship with total attendance. So re-run the multiple regressionwiththevariablesthosehavingsignificantlinearrelationship.Thenbetterpredictedtheattendanceat five (5) typical Maple games by using that multiple regression equation.Thepredicted attendance in Table 1 indicated that when the regular ticket sales and advanceticket sales are larger, then the total attendance is also larger and vice versa. Also found thatthenumber of hot dogs that could be soldno way affectthe estimatedattendance.Background

Management Report for Case Analysis � Prescott Maples Attendance - Page 4 preview image

Loading page ...

Page3of10Bud Ford, the general manager and owner of the double A farm team, the Prescott Maples, hasbeen talking to his staffabout 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 foreach home game. The team sells season tickets, day of game tickets and gives away some ticketsto 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 intopeople actually attending a game. Bud said, “I just don’t understand it! They pay for a seat thendon’t come. It makes no sense to me.” So his stadium manager and concession manager havebeen trying to figure out how they could better predict the attendance at five (5) typical Maplegames.The concession manager, Ralph Peanut, believes that part of this prediction could be theestimated number of hot dogs that would be sold at the game. Bud and the stadium manageraren’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 amultiple regression that helps to predict the attendance at these five typical games.ProblemThe problem involved in this study is as stated below:Whatgeneral things can you tell Bud Ford about projected attendance at these games?Doesknowing the number of hot dogs that could be sold help or hurt the estimated attendance theory?Analysis

Preview Mode

This document has 10 pages. Sign in to access the full document!

Report

Study Now!

Document Details

Related Documents

CIS 337 Unit 7 Assignment Final Project Part IV Pr

Analysis of Leadership in Monster Inc

Evaluation of Alphabet's Mission, Vision, and 8-29

Boundless Management

Uncovering the Martha Stewart Tax Scandal Insider

Boundless Business

JetBlue Airlines Case Analysis

Effective Speaker Notes Template for BUS 210 Prese

Leading as a Function of Management

McDonald's Q4 Earnings U

Company

Explore

Study Tools