The University Of Wyomying Men’s Basketball Team Case Solution And Analysis, HBR Case Study Solution & Analysis of Harvard Case Studies

The University Of Wyomying Men’s Basketball Team Case Study Analysis

100 Simulation Season Using 50% Winning ratio

In order to predict the revenue for the upcoming season using a winning percentage of 50%, it is assumed that a total of 16 matches will be conducted in the upcoming 100 seasons, eight matches will be held with the conference team as an opponent and eight against the non-conference team. Moreover, in order to predict revenue of the 100 seasons, it is assumed that that 947 tickets will be sold for eight conference games, and 1173 tickets will be sold for matches against non-conference teams.

The assumption related to the number of tickets sold is based on the average tickets sold last year. Based on the assumptions and data used, it is predicted that the total revenue from ticket sales and concession sales will be $201036 in the upcoming 100 seasons. In addition, the total revenue has been predicted, after using the current ticket price of $12. (See Exhibit 4)

Simulation Using Random Win percentages

The winning percentage and total revenue from ticket and concession sales have a linear relationship which proves that the variable plays a vital role in the revenue forecast. Therefore, in order to project revenue, random win percentages are used to evaluate the effect of changes in winning percentages on the revenue of the tickets. In addition, the win percentage of 0.5 i.e. the average winning ratio of teams in the last four seasons is used.

The revenue has been forecasted for the upcoming 100 seasons using a ticket price of $12 and assuming there will be 16 matches in each season. The results of the simulation indicate that the revenues in a season are increasing as a result of the increased winning ratio of teams in that particular season. As a result of incorporating random winning percentages in the simulation, the average total revenue amounting to $106517 is predicted. (Annexure, Excel)

Conclusion

One of the major sources of revenue for the athletic department at the University of Wyoming (UW) was ticket and concession sales generated through matches and other sporting games held by the university. Therefore, the senior director of the athletic department had to report the forecasted revenue generated through these games however, there were many factors that affected the sales of the tickets and ultimately revenue, as the revenues were dependent on three variables, which are: day of the game, opponent and winning ratio i.e. performance of the team. The relationship between these variables and the ticket sales was evaluated using the multiple linear regression tool and Simulation Models...............................

This is just a sample partical work. Please place the order on the website to get your own originally done case solution.