I need help with this assignment. This assignment requires the use of SOLVER in EXCEL, so if you do not have the program, Solver, please allow another who does to help out.

These are the requirements:

1) Provide the background of the problem you are attempting to resolve.

2) Create a mathematical equation for the problem on the first tab of your Excel Worksheet

3) Solve the problem using Solver (linear programming) on the second tab of your Excel Worksheet.

4) Provide a management report (discuss results, sensitivity analysis, and provide recommendations) for your findings in a Word Document. Students should use screen shots to insert both the Solver solution and the sensitivity analysis in the management report completed in Word.

THIS is the case problem the above requirements apply to:

Case Problem College Softball Recruiting College softball programs have a limited number of scholarships to offer promising high school seniors, so the programs invest a great deal of effort in evaluating these players. ne measure of performance the programs commonly use to evaluate recruits is the batting averagethe proportion of at-hats [excluding times when the player is walked or hit by a pitch} in which the player gets a hit For example. a player who gets it] hits in 15!} at-hats has a batting average of El] m 0.333 A college soithall program is considering two players, Fran Hayes and Millie Marshall, who have recently completed their senior years of high school. Their respective statistics for their junior and senior years are as shown in TE]; 2.3. Summary of Batting Performances in Junior and Senior 't'ears by Hayes and Marshall starlet-veer Shr't'r Ala-BIB I-ll'tl lit-Ids I-ll Fr." Hm son to 4o 15 "title Harehall 196 E? 1'05 t5 Managerial Report The Athletic Director and Coach of the women's softball team at a large public university are trying to decide to which of these two players they will offer an athletic scholarship (i.e., an opporhinity to attend the university for free in exchange for playing on the university's softball team). Take the following steps to determine which player had the better batting average over the twoyear period provided in the table, and use your results to advise the Athletic Director and lCoach on their decision. 1. Calculate the batting average of each player for her junior year; then also calculate the batting average of each player for her senior year. Which player would this analysis lead you to choose? 2. Calculate the batting average of each player for her combined junior and senior years. Which player would this analysis lead you to choose? 3. After considering both of your analyses, which player would you choose? Why? 'it. Prepare a report on your ndings for the atheletic director and coach of the college program. Focus on clearly explaining the discrepancy in your two analyses