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 care 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.

BIU hat OA IMI IM Merge & Center G H Athletic Director Budget F418 General Operational Cost One Time Cost Equipment Recurring Cost Medical wrance 45,000 Catastrophicins 5,000 NAIA Dues 7.500 SSAC Dues 15,000 Promotions + Copier +Paper Letterhead Envelopes Postage Travel Long Distance 1.000 Misc Neptune 1.200 Past Season Fund 0 Facilities improv Sub Total: 74,700 Sub Total 0 Total 74.700 Athletic Budget Summary Seal Costs Scholarships Travel Oper AD Budget $104,275 So $0 $74,700 Total $178,975 Fees Fundratung Concesion/Tickets 1.595,207.00 130,000.00 20,000.00 Add footer AD Budget Salary Operations B I W Merge Center $% fx =H7*0.5 D G H Athletic Department Budget F418 Stall Salary and Benefits TOTAL Comp. Athletic Stan Salaries Salary FICA RET INS BENE. Total Package ATH. Portion TAG Portion 14,273 13,788 14,273 13,788 AzNotic Director Associate Athletic Director Sports Information Director Trainer Trainer 2 14,273 13,788 13,980 13,980 13.90 13,980 13.980 13.980 13,990 13.980 13.900 7,137 6,894 6,990 6,990 6.990 7,137 6,894 6.910 5.990 6.990 7,062 BAHC Men's Basketball HC Men's and Women's Cross Country HC Men and Women's Tennis HC Woman'ladketball HC Serba HC Women's Soccer HC Women's Golf HC 14,124 14,124 13.788 13,980 7.062 0273 7,062 7,062 6,894 6,990 14.124 14,124 13,788 13,980 4,872 . 4.872 13,728 12,912 12,912 14,124 14,124 13.785 13,980 4,872 6872 13,728 12,912 4,872 2.43 4.872 13,728 12,912 12,912 1.949 5,854 6,456 6,456 2.46 2.923 685 456 12.912 Last Baseball 4.872 AMB 4.872 Max 4.872 Asus Tennis AW Autoba An Soccer Loccer 4,872 4,872 4,672 4.980 4 872 4,872 4472 4,960 4,872 4,872 4,872 4.872 4,872 4.980 4.522 4,872 2,436.00 2,436.00 2,436.00 2.46.00 2,416.00 1.436.00 2,436.00 2.435.00 2,490.00 2,416.00 2,416.00 2.490.00 4.872 2.46.00 2.436.00 Student AVM clocks Tosil 104.27 Add footer AD et S Operatione 0! FY21 BMS Athletic Budget-SMGT 4 art Dean Page Layout Formulas Data Review View Tell me Calibr (Body 11 - = Number 2 Wrap Test Merge & Center 8 TU OA $% % Condition Farrutti F D Athletic Team Buket21 Mon-Salpensa MS Max Scholarship Alles COA-14.115 Partits A ch There KOWI be 15 12 16 Cross Country 10 5 10 5 TI Scholarship Scholip Toris 0 o O UX DO 20 12 Thai 10 11 Screet 25 12 Dirty 10 5 10 5 Golf 10 5 0 Scholt Non Scholarela Teer women, D 0 o IN Show to wr D Add footer BIU hat OA IMI IM Merge & Center G H Athletic Director Budget F418 General Operational Cost One Time Cost Equipment Recurring Cost Medical wrance 45,000 Catastrophicins 5,000 NAIA Dues 7.500 SSAC Dues 15,000 Promotions + Copier +Paper Letterhead Envelopes Postage Travel Long Distance 1.000 Misc Neptune 1.200 Past Season Fund 0 Facilities improv Sub Total: 74,700 Sub Total 0 Total 74.700 Athletic Budget Summary Seal Costs Scholarships Travel Oper AD Budget $104,275 So $0 $74,700 Total $178,975 Fees Fundratung Concesion/Tickets 1.595,207.00 130,000.00 20,000.00 Add footer AD Budget Salary Operations B I W Merge Center $% fx =H7*0.5 D G H Athletic Department Budget F418 Stall Salary and Benefits TOTAL Comp. Athletic Stan Salaries Salary FICA RET INS BENE. Total Package ATH. Portion TAG Portion 14,273 13,788 14,273 13,788 AzNotic Director Associate Athletic Director Sports Information Director Trainer Trainer 2 14,273 13,788 13,980 13,980 13.90 13,980 13.980 13.980 13,990 13.980 13.900 7,137 6,894 6,990 6,990 6.990 7,137 6,894 6.910 5.990 6.990 7,062 BAHC Men's Basketball HC Men's and Women's Cross Country HC Men and Women's Tennis HC Woman'ladketball HC Serba HC Women's Soccer HC Women's Golf HC 14,124 14,124 13.788 13,980 7.062 0273 7,062 7,062 6,894 6,990 14.124 14,124 13,788 13,980 4,872 . 4.872 13,728 12,912 12,912 14,124 14,124 13.785 13,980 4,872 6872 13,728 12,912 4,872 2.43 4.872 13,728 12,912 12,912 1.949 5,854 6,456 6,456 2.46 2.923 685 456 12.912 Last Baseball 4.872 AMB 4.872 Max 4.872 Asus Tennis AW Autoba An Soccer Loccer 4,872 4,872 4,672 4.980 4 872 4,872 4472 4,960 4,872 4,872 4,872 4.872 4,872 4.980 4.522 4,872 2,436.00 2,436.00 2,436.00 2.46.00 2,416.00 1.436.00 2,436.00 2.435.00 2,490.00 2,416.00 2,416.00 2.490.00 4.872 2.46.00 2.436.00 Student AVM clocks Tosil 104.27 Add footer AD et S Operatione 0! FY21 BMS Athletic Budget-SMGT 4 art Dean Page Layout Formulas Data Review View Tell me Calibr (Body 11 - = Number 2 Wrap Test Merge & Center 8 TU OA $% % Condition Farrutti F D Athletic Team Buket21 Mon-Salpensa MS Max Scholarship Alles COA-14.115 Partits A ch There KOWI be 15 12 16 Cross Country 10 5 10 5 TI Scholarship Scholip Toris 0 o O UX DO 20 12 Thai 10 11 Screet 25 12 Dirty 10 5 10 5 Golf 10 5 0 Scholt Non Scholarela Teer women, D 0 o IN Show to wr D Add footer