. You are the Athletic Director at Reilly University and are trying to figure out Budgets for the spring sports. In Excel, use the following information to create a budget for the three sports listed below. Your budget for each sport must include a line for: apparel, meals, travel, recruiting, scholarships (fully funding) and total budget. Be sure to answer the questions below for full credit. (30 points)

Every sport will get $400 per person for Apparel

Every sport will get $16 meal money per person for all home games

Every sport will get $29 meal money per person for all away games

Costs of a bus for each away game is $1,675

Cost of attendance at Reilly University is: $52,798

Recruiting: Teams under 35 people will get $5,000

Teams with 35 people and over will get $7,000

Team	Roster Size	# of Home Games	# of Away Games	Max Equivalencies
Mens Lacrosse	41	8	8	10.8
Womens Lacrosse	33	7	9	9.9
Baseball	42	23	22	9
Softball	22	24	22	7.2

Mens Lacrosse Overall Budget:

Womens Lacrosse Overall Budget:

Softball Overall Budget: Baseball Overall Budget:

Total Spring Budget: