4. 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 $425 per person for Apparel Every sport will get $12 meal money per person for all home games Every sport will get $30 meal money per person for all away games Costs of a bus for each away game is $1,600 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 Men's Lacrosse 42 8 18 10.8 Women's Lacrosse 32 19 7 19.9 Baseball 45 22 22 9 Softball 26 24 20 7.2 Men's Lacrosse Overall Budget: Women's Lacrosse Overall Budget: Softball Overall Budget: Baseball Overall Budget: Total Fall Budget