Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

L HAMPTON ROADS STATE UNIVERSITY ATHLETIC BUDGET - FISCAL YEAR 2019-20 2 3 BUDGET SUMMARY PROGRAM SUMMARY 4 PARTICIPATION SCHOLARSHIPS 5 SPORT REVENUE EXPENSES PROFIT

image text in transcribed
image text in transcribed
L HAMPTON ROADS STATE UNIVERSITY ATHLETIC BUDGET - FISCAL YEAR 2019-20 2 3 BUDGET SUMMARY PROGRAM SUMMARY 4 PARTICIPATION SCHOLARSHIPS 5 SPORT REVENUE EXPENSES PROFIT MALE FEMALE MALE FEMALE 5 7 Footbal 760,000.00 1,055,000.00 -295,000.00 85.00 0.00 63.00 0.00 B Men's Basketball 982,000.00 646,400.00 335,600.00 13.00 0.00 13.00 0.00 3 Women's Basketbal 91,000.00 422,800.00 -331,800.00 0.00 15.00 0.00 15.00 10 Baseball 0.00 145,300.00 -145,300.00 28.00 0.00 4.50 0.00 11 Men's Swimming 0.00 81,400.00 81,400.00 20.00 0.00 2.50 0.00 12 Women's Swimming 0.00 76,400.00 -76,400.00 0.00 25.00 0.00 5.00 13 Men's Tennis 0.00 45,020.00 45,020.00 11.00 0.00 1.50 0.00 14 Women's Tennis 0.00 55,400.00 -55,400.00 0.00 13.00 0.00 3.50 15 Men's Golf 0.00 53,050.00 -53,050.00 13.00 0.00 2.50 0.00 15 Women's Gol 0.00 40,250.00 40,250.00 0.00 11.00 0.00 3.50 17 Men's Track 0.00 107,600.00 -107,600.00 31.00 0.00 3.50 0.00 18 Women's Track 0.00 104,750.00 -104,750.00 0.00 37.00 0.00 13.50 19 Men's Gymnastics 6,400.00 59,100.00 -52.700.00 12.00 0.00 2.00 0.00 20 Women's Gymnastics 14,000.00 51,400.00 37,400.00 0.00 14.00 0.00 6.50 21 Volleyball 44,000.00 93,850.00 49,850.00 0.00 22.00 0.00 12.00 22 Softbal 0.00 82,150.00 82,150.00 0.00 33.00 0.00 12.00 23 24 Total 213.00 170.00 92.50 71.00 25 OTHER % 55.61 44.39 56.57 43.43 26 Capital Expenses 0.00 271,000.00 271 000.00 Note: HRSU undergraduate students 50/50 MF 27 Administrative 5.851,900.00 5,096,000.00 755,900.00 28 29 Totals 7,749,300.00 8,486,870.00 -737,570.00 30 2.150 71,000 096,000 486,070 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 tum in your Excel budget. L HAMPTON ROADS STATE UNIVERSITY ATHLETIC BUDGET - FISCAL YEAR 2019-20 2 3 BUDGET SUMMARY PROGRAM SUMMARY 4 PARTICIPATION SCHOLARSHIPS 5 SPORT REVENUE EXPENSES PROFIT MALE FEMALE MALE FEMALE 5 7 Footbal 760,000.00 1,055,000.00 -295,000.00 85.00 0.00 63.00 0.00 B Men's Basketball 982,000.00 646,400.00 335,600.00 13.00 0.00 13.00 0.00 3 Women's Basketbal 91,000.00 422,800.00 -331,800.00 0.00 15.00 0.00 15.00 10 Baseball 0.00 145,300.00 -145,300.00 28.00 0.00 4.50 0.00 11 Men's Swimming 0.00 81,400.00 81,400.00 20.00 0.00 2.50 0.00 12 Women's Swimming 0.00 76,400.00 -76,400.00 0.00 25.00 0.00 5.00 13 Men's Tennis 0.00 45,020.00 45,020.00 11.00 0.00 1.50 0.00 14 Women's Tennis 0.00 55,400.00 -55,400.00 0.00 13.00 0.00 3.50 15 Men's Golf 0.00 53,050.00 -53,050.00 13.00 0.00 2.50 0.00 15 Women's Gol 0.00 40,250.00 40,250.00 0.00 11.00 0.00 3.50 17 Men's Track 0.00 107,600.00 -107,600.00 31.00 0.00 3.50 0.00 18 Women's Track 0.00 104,750.00 -104,750.00 0.00 37.00 0.00 13.50 19 Men's Gymnastics 6,400.00 59,100.00 -52.700.00 12.00 0.00 2.00 0.00 20 Women's Gymnastics 14,000.00 51,400.00 37,400.00 0.00 14.00 0.00 6.50 21 Volleyball 44,000.00 93,850.00 49,850.00 0.00 22.00 0.00 12.00 22 Softbal 0.00 82,150.00 82,150.00 0.00 33.00 0.00 12.00 23 24 Total 213.00 170.00 92.50 71.00 25 OTHER % 55.61 44.39 56.57 43.43 26 Capital Expenses 0.00 271,000.00 271 000.00 Note: HRSU undergraduate students 50/50 MF 27 Administrative 5.851,900.00 5,096,000.00 755,900.00 28 29 Totals 7,749,300.00 8,486,870.00 -737,570.00 30 2.150 71,000 096,000 486,070 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 tum in your Excel budget

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Count Down The Past, Present And Uncertain Future Of The Big Four Accounting Firms

Authors: Jim Peterson

2nd Edition

1787147010, 9781787147010

More Books

Students also viewed these Accounting questions