Recently, the athletics program at Hampton Roads State University (HRSU), a hypothetical NCAA Division I-AA school...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Recently, the athletics program at Hampton Roads State University (HRSU), a hypothetical NCAA Division I-AA school in the mid-major Eastern Atlantic Athletic Conference (EAAC), completed its annual budget review. The current fiscal year is about to begin in just a few months. Word is rapidly spreading across campus that the state legislature, facing a budget crisis in this election year, has pulled back a considerable portion of the money originally allocated to all state universities for the upcoming fiscal year. As a result, the university president, not known as a supporter of intercollegiate athletics, has chosen to take back $800,000 of student fee money promised to HRSU Athletics for the upcoming year and re-allocate that money to cover the funds withdrawn by the state legislature. The Microsoft Excel spreadsheet found on Canvas represents the recently approved budget for HRSU Athletics for the 2023-24 fiscal year. As you will see on the budget, $800,000 in student fee revenues was deleted from the budget, leaving HRSU Athletics with a projected budget deficit of $737,500 for the upcoming year. HRSU Athletic Director Bob Jones has historically budgeted somewhat conservatively during his five-year tenure at the school, trying to project a budget surplus of $50,000 or more to cover unexpected expenses that always occur throughout the year. While this was the case again this year (a surplus of $62,430 had been projected), that surplus was only a small fraction of the amount needed to compensate for the large loss of student fee money that must now be accounted for. Smith made the decision today to hire Collegiate Athletics Consulting (CAC), a recently created sports consulting firm, to provide an unbiased way to balance the department's budget. CAC, of which you are one of the employees, has a very short period of time to provide HRSU Athletics with a recommended solution to its budget crisis. The short turn-around time on this project was necessitated by the fact that HRSU is nearing the beginning of the new fiscal year and needs a solution immediately in order to proceed with its preparations for the upcoming year. CAC has agreed to come in as a consultant for this budgeting crisis at a fee of $10,000. You have been appointed to serve on a CAC project committee that will handle this project. CAC officials met with Jones and the HRSU athletic staff recently in order to gather information about the project and learned a number of important things, including: 1. Revenue numbers have been conservatively predicted for the upcoming year and are not to be altered by CAC, with two possible exceptions: (1) The University of Virginia has extended an invitation to HRSU to play a football game next fall in Charlottesville. UV will pay HRSU an up-front guarantee of $100,000 for the game, but HRSU will have to cancel one of its five scheduled home games in order to accept UV's invitation.; (2) Our staff economist has analyzed data on HRSU athletic patrons and found that an additional $40,000 in marketing/advertising would likely result in a five percent increase in ticket sales for all sports that charge admission. 2. Methods of balancing the budget available to CAC include trimming expenses in a variety of ways, including dismissing employees, and dropping sports. When CAC interviewed HRSU staff members about ways in which they might balance the budget, feedback centered on ideas like trying to be fair to all sports in the cuts, dropping a sport only if necessary, and trying to avoid directly impacting student-athletes' experiences as much as possible. Note: if you choose to eliminate scholarships (i.e. reducing one or more from a particular program or dropping sports programs altogether), you can reduce the scholarship expenses by $18,000 for each scholarship (not participant) eliminated. 3. HRSU is concerned about its compliance with gender equity legislation, particularly Title IX and the Equal Pay Act. CAC budget recommendations to HRSU should include compliance with these laws in areas such as the granting of scholarships, the number of athletic participants, and coaches' salaries. For Title IX purposes, you can assume that the university's student body is 50% female and 50% male and that recent courts have used five percent as their benchmark for determining substantial proportionality. Writing & Submission Guidelines: 1. You are expected to consider all the information listed above, and examine possible alternatives for balancing HRSU's athletic budget. 2. You are to write a memo of approximately one single-spaced pages to CAC Chief Executive Officer describing how you personally would balance the budget if the decision were entirely up to you. In this memo, you do not have to account for balancing every single penny, but rather, you should describe in some detail how you have balanced of those decisions. the budget, including the logic behind the decisions you've made and the potential impact 3. Additionally, you will turn in your Excel budget. 4. Both of these items are due at 11:59 PM on Mar. 19th, 2023. Grading Rubrics: You will be evaluated on how well you met the requirements of the assignment (2 pts), the logic/rationale behind the budgeting decisions you made (4 pts), the use of Excel (2 pts), and the quality of writing in your memo (2 pts). Recently, the athletics program at Hampton Roads State University (HRSU), a hypothetical NCAA Division I-AA school in the mid-major Eastern Atlantic Athletic Conference (EAAC), completed its annual budget review. The current fiscal year is about to begin in just a few months. Word is rapidly spreading across campus that the state legislature, facing a budget crisis in this election year, has pulled back a considerable portion of the money originally allocated to all state universities for the upcoming fiscal year. As a result, the university president, not known as a supporter of intercollegiate athletics, has chosen to take back $800,000 of student fee money promised to HRSU Athletics for the upcoming year and re-allocate that money to cover the funds withdrawn by the state legislature. The Microsoft Excel spreadsheet found on Canvas represents the recently approved budget for HRSU Athletics for the 2023-24 fiscal year. As you will see on the budget, $800,000 in student fee revenues was deleted from the budget, leaving HRSU Athletics with a projected budget deficit of $737,500 for the upcoming year. HRSU Athletic Director Bob Jones has historically budgeted somewhat conservatively during his five-year tenure at the school, trying to project a budget surplus of $50,000 or more to cover unexpected expenses that always occur throughout the year. While this was the case again this year (a surplus of $62,430 had been projected), that surplus was only a small fraction of the amount needed to compensate for the large loss of student fee money that must now be accounted for. Smith made the decision today to hire Collegiate Athletics Consulting (CAC), a recently created sports consulting firm, to provide an unbiased way to balance the department's budget. CAC, of which you are one of the employees, has a very short period of time to provide HRSU Athletics with a recommended solution to its budget crisis. The short turn-around time on this project was necessitated by the fact that HRSU is nearing the beginning of the new fiscal year and needs a solution immediately in order to proceed with its preparations for the upcoming year. CAC has agreed to come in as a consultant for this budgeting crisis at a fee of $10,000. You have been appointed to serve on a CAC project committee that will handle this project. CAC officials met with Jones and the HRSU athletic staff recently in order to gather information about the project and learned a number of important things, including: 1. Revenue numbers have been conservatively predicted for the upcoming year and are not to be altered by CAC, with two possible exceptions: (1) The University of Virginia has extended an invitation to HRSU to play a football game next fall in Charlottesville. UV will pay HRSU an up-front guarantee of $100,000 for the game, but HRSU will have to cancel one of its five scheduled home games in order to accept UV's invitation.; (2) Our staff economist has analyzed data on HRSU athletic patrons and found that an additional $40,000 in marketing/advertising would likely result in a five percent increase in ticket sales for all sports that charge admission. 2. Methods of balancing the budget available to CAC include trimming expenses in a variety of ways, including dismissing employees, and dropping sports. When CAC interviewed HRSU staff members about ways in which they might balance the budget, feedback centered on ideas like trying to be fair to all sports in the cuts, dropping a sport only if necessary, and trying to avoid directly impacting student-athletes' experiences as much as possible. Note: if you choose to eliminate scholarships (i.e. reducing one or more from a particular program or dropping sports programs altogether), you can reduce the scholarship expenses by $18,000 for each scholarship (not participant) eliminated. 3. HRSU is concerned about its compliance with gender equity legislation, particularly Title IX and the Equal Pay Act. CAC budget recommendations to HRSU should include compliance with these laws in areas such as the granting of scholarships, the number of athletic participants, and coaches' salaries. For Title IX purposes, you can assume that the university's student body is 50% female and 50% male and that recent courts have used five percent as their benchmark for determining substantial proportionality. Writing & Submission Guidelines: 1. You are expected to consider all the information listed above, and examine possible alternatives for balancing HRSU's athletic budget. 2. You are to write a memo of approximately one single-spaced pages to CAC Chief Executive Officer describing how you personally would balance the budget if the decision were entirely up to you. In this memo, you do not have to account for balancing every single penny, but rather, you should describe in some detail how you have balanced of those decisions. the budget, including the logic behind the decisions you've made and the potential impact 3. Additionally, you will turn in your Excel budget. 4. Both of these items are due at 11:59 PM on Mar. 19th, 2023. Grading Rubrics: You will be evaluated on how well you met the requirements of the assignment (2 pts), the logic/rationale behind the budgeting decisions you made (4 pts), the use of Excel (2 pts), and the quality of writing in your memo (2 pts).
Expert Answer:
Related Book For
Posted Date:
Students also viewed these general management questions
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
apple company: 1.what are key characteristics of the industry? 2. where is the company in its life cycle?
-
Find intervals containing solutions to the following equations. a. x 3x = 0 b. 4x2 ex = 0 c. x3 2x2 4x + 2 = 0 d. x3 + 4.001x2 + 4.002x + 1.101 = 0
-
Rita decided to invest the stock market and decided to Purchase 100 shares of stock for $20 per share. During the year, Rita received dividend cheques amount of $150. After 3 years, Rita sold the...
-
Three bars, each made of different materials, are connected together and placed between two walls when the temperature is T 1 = 12C. Determine the force exerted on the (rigid) supports when the...
-
The Borrell Company purchased four delivery trucks on January 2, 2007 for $22,000 each. The company expected two of the trucks to last five years and have a residual value of $3,500 each. The other...
-
You win a $10,000,000 Lottery which is paid in equal annual installments of $500,000 over 20 years. If the discount rate is 4%, how much is the Lottery prize actually worth today?
-
Some of SIA's HR practices would be frowned upon in the US and Europe (e.g., having cabin crew on time-based contracts that are renewable every five years). Is this fair competition (i.e., desired...
-
Over a great circle route between an earthquake epicentre off the coast of Chile and Hawaii the average depth is 100m for 150 n.m. (1 nautical mile 1852 m), 3300m for 390 nautical miles, 4000m for...
-
Here is my code, I am still confused about this import java.util.Scanner; public class J1_09_3 { public static void main(String[] args) { Scanner input = new Scanner(System. in ); Circle...
-
(Simplify your answer.)
-
Two words, word1 and word2, are similar if and only if all the characters in word1 are in word2; and all the characters in word2 are in word1; including the same number of duplication. For example,...
-
Assuming Phil's wages were $60,000 and Linda's wages were $71,000 for 2022 and they had no other income, what is the maximum amount of Phil and Linda's deductions for contributions to a traditional...
-
Journalize the adjusting entries below at year-end December 31, XXXX. Please share your supporting calculations for the adjusting entries requiring computations. (a) Beginning prepaid insurance,...
-
Smiths Family Fashions implemented a balanced scorecard performance measurement system several years ago. Smiths is a locally owned clothing retailer with fashions for men, women, teens, and...
-
Repeat Exercise 13.3, but this time work on the assumption that non-current assets that had originally cost :30,000, with accumulated depreciation of :12,000, had been sold during the year ended 31...
-
Study Figure 13.6. Write a short report on Bayers management of its cash flows over the period reported. Figure 13.6 Bayer Group's consolidated statement of cash flows Income after taxes Income taxes...
-
Expenses and revenues are subjective; cash flows are facts. Therefore cash flow statements cannot mislead. Discuss.
Study smarter with the SolutionInn App