Your final project will be to develop a budget for an Interscholastic Program. The assignment will require a spreadsheet AND paper. The spreadsheet will include your full budget with all required items and must balance. Your paper will explain how you made each balance and why you spent money in each area and for each team you committed money to in the spreadsheet. It will also explain your fundraising ideas and explain how they will raise amount of money you expect to raise.
The attached excel spreadsheet is a fictional college spreadsheet listing areas you must commit finances too. Your budget is given below along with what amount you must raise as the Athletic Director of the Blue Mountain State Mountain Goats located in north Georgia and are acting members of the Southern States Athletic Conference and the NAIA. They have 10 sports and a budget of $1,748,207 of which $150,000 is raised by the department each year through fundraisers, concessions, and ticket sales. $20,000 comes from tickets and concessions. Some data is filled in such as participants, maximum scholarships, cost of attendance (COA), NAIA dues, SSAC dues, insurance for employees and student-athletes and others. In addition, most cells should be pre-formatted to carry the items from one spreadsheet to another and to total certain columns.
Participation numbers are completed in order to match the 57% female student body per Title IX requirements. You need to match scholarship amounts to this as closely as possible. Benefits and insurance are filled in and FICA and RET will populate when you enter the salary for coaches. Each coach’s salary is split between the athletics budget and E&G from the institution and is calculated already as you enter the salaries for each. Two coaches each coach two teams (Tennis and Cross Country) and must be full time employees, however, if you wish to make a coach for another sport part-time, you may do so. Be sure to add money for Student Assistants for game management and other duties in the department.
For athletic staff to include head coaches, assistant coaches, and administration, you must set a salary for each within your budget. AD, AAD, SID, and Trainers must be full time but can receive a salary which is for a 10 month position for the trainers. Assistant coaches are 10 month employees and salaries should reflect it.
After completing the budget and submitting for the year, your Chief Financial Officer (CFO) finds that in August your revenues listed for “Fees” on the AD Budget page are short of the projections and you must cut $80,000 from your budget. All scholarship offers made will stand so you cannot cut in that area but you can choose to have 5 of the 10 sports who have held back 10% of what you gave them. Find where to cut $80,000 that has not already been committed in the budgets and cut it from the total, and no you cannot say you will raise any more than what is indicated on the first spreadsheet of $150,000 total.
Your final submission will include 2 spreadsheets, your initial proposal and one with a reduction of $80,000. You will have one paper with the submissions which will explain what you did in your initial budgets and where money was cut for the adjustments as well as how you will raise the $130,000 required.
