For this part of the assignment, we are going to pretend that Major League Baseball has just terminated all long-term contracts, and every team in the league now has to re-negotiate the salaries for each player. The new salaries will be renegotiated every year. You are hired to advise the board members of your particular team, and your job is to decide how much each player on the team will be paid this year, based on their performance last year.

You have been given a roster of 15 players, their statistics from last year, and a team salary budget. You can find this information on the Excel spreadsheet on the sheet with your particular team label. It shows the information on these players for the 2019 year. The players include 10 position players and 5 pitchers. You have been given hitting statistics for the position players and pitching statistics for the pitchers. You will need to decide how to use these statistics in order to figure out how much you want to pay each of these players, keeping in mind the constraints of your budget.

There is a cap on total salaries. Each team has its own salary budget which is approximately 75% of its actual budget for 2019. There are actually 25 players who will share in that budget so, dont use all of that budget that you are given for your 15 players (as 10 more will need to be paid). The other 25% of the teams actual payroll budget will cover the entire 40 man roster (but, you dont need to address that this is just for your information).

Based on the data on your list of players and their salaries, you need to determine how much of your budget given will be distributed to each of your 15 players. You need to provide justification on why you made your decisions about those salaries, and all the work that you did to complete the project. You need to your list the salaries per player, graph it, and provide an explanation as to why you made those choices. Your explanation must include a description of how you decided how much each player was worth and which statistics you found most useful in making your decisions

3B 4 2 1 RK Player Pos G 5 Andrus, E SS 147 8 Choo, S LF 151 17 Odor, R 2B 145 4 Santana, D 2B 130 7 Mazara, N RF 116 11 DeShields, D CF 118 13 Cabrera, A 3B 93 14 Forsythe, L 1B 101 6 Calhoun, W LF 83 2 Pence, H DH 83 AB R H 2B 600 81 165 27 563 93 149 31 522 77 107 30 474 81 134 23 429 69 115 27 357 42 89 15 323 45 76 15 317 38 72 17 309 51 83 14 286 53 85 17 6 1 4 0 HR RBI BB SO SB CS AVGV OBP SLG OPS 12 72 34 96 31 8 0.275 0.31 0.39 0.71 24 61 78 165 15 1 0.265 0.37 0.46 0.83 30 93 52 178 11 9 0.205 0.28 0.44 0.72 28 81 25 151 21 6 0.283 0.32 0.53 0.86 19 66 28 108 4 1 0.268 0.32 0.47 0.79 4 32 38 100 24 6 0.249 0.33 0.35 0.67 12 51 38 85 4 0 0.235 0.32 0.39 0.71 7 39 44 100 2 0 0.227 0.33 0.35 0.68 21 48 23 53 0 0 0.269 0.32 0.52 0.85 18 59 26 69 6 1 0.297 0.36 0.55 0.91 1 1 1 6 RK Player Minor, M 7 Lynn, L 22 Sampson, A 21 Jurado, A 12 Chavez, W L ERA A G GS SV SVO 14 10 3.59 32 32 0 0 16 11 3.67 33 33 0 0 6 8 5.89 35 150 7 11 5.81 32 18 0 0 3 5 4.85 48 9 2 IP H R ER HR BB 208 190 86 83 30 68 208 195 89 85 21 59 125 156 86 82 29 36 122 148 94 79 21 36 78 82 48 42 12 22 SO AVG WHIP 200 0.24 1.24 246 0.24 1.22 101 0.3 1.53 81 0.3 1.5 72 0.27 1.33 1 EX A 3B 4 2 1 RK Player Pos G 5 Andrus, E SS 147 8 Choo, S LF 151 17 Odor, R 2B 145 4 Santana, D 2B 130 7 Mazara, N RF 116 11 DeShields, D CF 118 13 Cabrera, A 3B 93 14 Forsythe, L 1B 101 6 Calhoun, W LF 83 2 Pence, H DH 83 AB R H 2B 600 81 165 27 563 93 149 31 522 77 107 30 474 81 134 23 429 69 115 27 357 42 89 15 323 45 76 15 317 38 72 17 309 51 83 14 286 53 85 17 6 1 4 0 HR RBI BB SO SB CS AVGV OBP SLG OPS 12 72 34 96 31 8 0.275 0.31 0.39 0.71 24 61 78 165 15 1 0.265 0.37 0.46 0.83 30 93 52 178 11 9 0.205 0.28 0.44 0.72 28 81 25 151 21 6 0.283 0.32 0.53 0.86 19 66 28 108 4 1 0.268 0.32 0.47 0.79 4 32 38 100 24 6 0.249 0.33 0.35 0.67 12 51 38 85 4 0 0.235 0.32 0.39 0.71 7 39 44 100 2 0 0.227 0.33 0.35 0.68 21 48 23 53 0 0 0.269 0.32 0.52 0.85 18 59 26 69 6 1 0.297 0.36 0.55 0.91 1 1 1 6 RK Player Minor, M 7 Lynn, L 22 Sampson, A 21 Jurado, A 12 Chavez, W L ERA A G GS SV SVO 14 10 3.59 32 32 0 0 16 11 3.67 33 33 0 0 6 8 5.89 35 150 7 11 5.81 32 18 0 0 3 5 4.85 48 9 2 IP H R ER HR BB 208 190 86 83 30 68 208 195 89 85 21 59 125 156 86 82 29 36 122 148 94 79 21 36 78 82 48 42 12 22 SO AVG WHIP 200 0.24 1.24 246 0.24 1.22 101 0.3 1.53 81 0.3 1.5 72 0.27 1.33 1 EX A