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 two single-spaced pages to the 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 the budget, including the logic behind the decisions you've made and the potential impact of those decisions 3. Additionally, you will turn in your Excel budget. 4. Both items are due at 11:59 PM on Sunday, November 84.2020. Grading Rubrics: You will be evaluated on how well you met the requirements of the assignment (4 pts), the logic rationale behind the budgeting decisions you made (8 pts), the use of Excel (4 pts), and the quality of writing in your memo (4 pts). o 1 HAMPTON ROADS STATE UNIVERSITY ATHLETIC BUDGET-FISCAL YEAR 2019-20 PROGRAM SUMMARY PARTICIPATION SCHOLARSHIPS MALE FEMALE MALE FEMALE PROFIT 3 BUDGET SUMMARY 1 SPORT REVENUE EXPENSES 6 7 Football 780 000.00 1055,000.00 8 Men's Basketbal 982 000 00 646,400.00 9 Women's Basketbal 91,000.00 422 800 00 10 Baseball 0.00 145,300.00 11 Men's Swimming 0.00 81,400.00 12 Women's Swimming 0.00 76,400.00 13 Men's Tennis 000 45,020.00 14 Women's Tennis 0.00 55,400.00 15 Mort's Golf 0.00 53,050.00 10 Women's Golf 0.00 10,250.00 17 Men's Track 0.00 107,600.00 18 Women's Track 0.00 104.750.00 19 Men's Gymnasiet 6,400 00 50.100.00 20 Women's Gymnastics 14 000 00 51.400.00 21 Volleyball 44000.00 93,850.00 22 Softball 0.00 2 150.00 23 24 25 OTHER 25. Capital Expenses 0.00 271,000.00 27 Administrative 5,351 900.00 5.000.000.00 20 29 Total 7,749,300.00 0.486,670.00 30 31 32 295,000.00 335,600.00 331,800.00 -145,300.00 81,400.00 -76.400.00 45,020.00 55,400.00 53,050.00 40,25000 107,000.00 104,750 00 62,700.00 37,400.00 49,050.00 32.150.00 85.00 13.00 0.00 28.00 20.00 0.00 11.00 000 13.00 0.00 3100 0.00 1200 0.00 0.00 000 000 0.00 15.00 0.00 000 25.00 0.00 13.00 0.00 1100 0.00 37 00 0.00 14.00 22 00 33.00 6300 13 00 0.00 450 250 0.00 150 000 2.50 0.00 3.50 0.00 2.00 0.00 0.00 0.00 0.00 0.00 15.00 0.00 0.00 5.00 0.00 350 000 3:50 0.00 13.50 0.00 010 12.00 1200) Total 213,00 170.00 92 50 71,00 % 5561 1439 58.57 1313 271 000.00 Nesto HIRSU undergraduate students = 50/50 M 755,000.00 -737,570,00 34 35 Overall Football Men's Basketball Women's Basketboll Baseball Man's Swimming Women's Swimming in Polded View Enable Editing V prve pro Women CAC officials met with Jones and the HRSU athletic staff recently to gather information about the project and learned several 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 (ie reducing one or more from a program or dropping sports programs altogether), you can reduce the scholarship expenses by $18,000 for each scholarship (not participant) eliminated 3. HRSU is concemed 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 two single-spaced pages to the 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 the budget, including the logic behind the decisions you've made and the potential impact of those decisions 3. Additionally, you will turn in your Excel budget. 4. Both items are due at 11:59 PM on Sunday, November 84.2020. Grading Rubrics: You will be evaluated on how well you met the requirements of the assignment (4 pts), the logic rationale behind the budgeting decisions you made (8 pts), the use of Excel (4 pts), and the quality of writing in your memo (4 pts). o 1 HAMPTON ROADS STATE UNIVERSITY ATHLETIC BUDGET-FISCAL YEAR 2019-20 PROGRAM SUMMARY PARTICIPATION SCHOLARSHIPS MALE FEMALE MALE FEMALE PROFIT 3 BUDGET SUMMARY 1 SPORT REVENUE EXPENSES 6 7 Football 780 000.00 1055,000.00 8 Men's Basketbal 982 000 00 646,400.00 9 Women's Basketbal 91,000.00 422 800 00 10 Baseball 0.00 145,300.00 11 Men's Swimming 0.00 81,400.00 12 Women's Swimming 0.00 76,400.00 13 Men's Tennis 000 45,020.00 14 Women's Tennis 0.00 55,400.00 15 Mort's Golf 0.00 53,050.00 10 Women's Golf 0.00 10,250.00 17 Men's Track 0.00 107,600.00 18 Women's Track 0.00 104.750.00 19 Men's Gymnasiet 6,400 00 50.100.00 20 Women's Gymnastics 14 000 00 51.400.00 21 Volleyball 44000.00 93,850.00 22 Softball 0.00 2 150.00 23 24 25 OTHER 25. Capital Expenses 0.00 271,000.00 27 Administrative 5,351 900.00 5.000.000.00 20 29 Total 7,749,300.00 0.486,670.00 30 31 32 295,000.00 335,600.00 331,800.00 -145,300.00 81,400.00 -76.400.00 45,020.00 55,400.00 53,050.00 40,25000 107,000.00 104,750 00 62,700.00 37,400.00 49,050.00 32.150.00 85.00 13.00 0.00 28.00 20.00 0.00 11.00 000 13.00 0.00 3100 0.00 1200 0.00 0.00 000 000 0.00 15.00 0.00 000 25.00 0.00 13.00 0.00 1100 0.00 37 00 0.00 14.00 22 00 33.00 6300 13 00 0.00 450 250 0.00 150 000 2.50 0.00 3.50 0.00 2.00 0.00 0.00 0.00 0.00 0.00 15.00 0.00 0.00 5.00 0.00 350 000 3:50 0.00 13.50 0.00 010 12.00 1200) Total 213,00 170.00 92 50 71,00 % 5561 1439 58.57 1313 271 000.00 Nesto HIRSU undergraduate students = 50/50 M 755,000.00 -737,570,00 34 35 Overall Football Men's Basketball Women's Basketboll Baseball Man's Swimming Women's Swimming in Polded View Enable Editing V prve pro Women CAC officials met with Jones and the HRSU athletic staff recently to gather information about the project and learned several 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 (ie reducing one or more from a program or dropping sports programs altogether), you can reduce the scholarship expenses by $18,000 for each scholarship (not participant) eliminated 3. HRSU is concemed 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