I\'m not sure why you didn\'t get the snapshots that was included but here they
ID: 2908744 • Letter: I
Question
I'm not sure why you didn't get the snapshots that was included but here they are again. 3 screenshots for the question. I'm awaiting a solution in excel, using excel solver
Thanks
Athens Bulldogs After a season in which he made extensive use of all 12 players on his team, a coach is trying to select the starting team for postseason tournament play. The following are the season statistics on the players: Player Position Height Rebounds Points Assists FGA FTA Turnovers Fouls Dave Guard 70 1.3 1.6 3.3 58 90 2.1 3.2 Al Guard 72 1.3 3.2 4.5 53 85 1.2 2.1 Tom Guard 69 2.8 12.1 2.2 47 70 3.3 1.2 Joe Guard 73 3.3 3.2 3.6 41 72 2.0 2.4 Paul Guard 68 1.1 9.6 2.0 42 68 2.2 3.4 Sean Forward 76 7.7 6.7 2.2 38 70 2.8 4.1 Ron Forward 75 4.5 13.0 2.7 49 75 1.5 2.1 Bob Forward 77 2.0 15.6 2.8 52 85 4.0 3.0 Jim Forward 79 7.5 16.2 2.3 47 60 2.1 2.2 Ben Center 80 3.0 3.9 4.8 45 65 2.3 2.2 Herb Center 82 8.9 12.8 1.0 40 60 1.0 3.6 John Center 83 5.0 8.2 1.2 56 88 2.2 1.9 In choosing his starting team, the coach has 8 goals he would like to meet. They are: 1. Average starting team height at least 75 inches. 2. Total team average rebounds per game at least 24. 3. Total team average points per game at least 58. 4. Total team average assists per game at least 13. 5. Team field goal average (FGA) at least 50. 6. Team free throw goal average (FTA) at least 75. 7. Total team average turnovers per game no more than 11. 8. Total team average fouls per game no more than 12. The coach also intends to impose the following restriction on the starting team: 1. At least one guard must start. 2. Exactly one center must start. 3. If either Al or Ron starts, Jim cannot start. Create a Solver-based spreadsheet model based on goal programming methods to determine which players should start and solve the model. Comments and Hints: 1. For those unfamiliar with basketball, exactly five players must be selected. 2. For those unfamiliar with basketball, it is desirable to overachieve the first 6 goals and desirable to underachieve the final 2 goals. 3. Take care when calculating actual values for the goals, noting the SUMPRODUCT calculation must be divided by 5 for goals 1, 5, and 6. 4. Build a truth table for the logically tricky constraint of If Al, or Ron, then not Jim. Try combinations of adding and subtracting the three terms. You might need to multiple one term by 2 in order to create logic to achieve desirable relationships.
File Edit View Windew Help Home Tools Theme-park proble Sign In Athens Bulldogs Export PU After a season in which he made extensive use of all 12 players on his team, a coach is trying to select the starting team for postseason tournament play. The following are the season statistics on the players: Adobe Export PDF Select POF Fie athees hult.senptiona Player |Position |Height Rebounds Points Assists FGAFTA Turnovers Fouls Dave Guard AI 70 72 69 58 53 85 47 70 1.3 1.6 3.2 3.3 4.5 90 3.2 2.1 Microscht werd (..dn? ? Guard 1.2 Tom Guard Joe Guard Ccoament Langusg Enqlsh (us change Guard 68 9.6 6.7 13.0 15.6 2.0 42 68 38 70 49 52 85 Sean Forward 76 Ron Forward 75 Bob Forward 77 Jim Forward Ben Center 8 Herb Center Covert 75 3.0 516.2 2.347 60 2.1 2.2 2.8 4.0 Create PD m Forward 79 Edit PDh 3.0 8.9 45 65 40 60 82 1.0 1.0 3.6 John Center 83 5.0 8.1. 5688 2.2 1.9 ?Combine Files?? ED organize Pages choosing his starting team, the coach has 8 goals he would like to meet. They are: Hedact Average starting team height at least 75 inches. Total team average rebounds per game at least 24. Total team average points per game at least 58 Total team average assists per game at least 13 Team field goal average (FGA) at least 50 Team free throw goal average (FTA) at least 75 2. 3. 4. Protect optimize PDF nd share files in Lesm MoreExplanation / Answer
nd he’s about to play his last regular-season game at Stegeman Coliseum for the Bulldogs.
Tonight is Senior Night for Georgia. Maten will be recognized along with fellow seniors Pape Diatta and Juwan Parker in a ceremony that will start 15 minutes before the 8:35 p.m. tipoff against Texas A&M. All three have overcome their own obstacles and made their respective contributions to the team and the university. Tears are in the forecast.
“To walk the journey from young man to man with them is an incredible experience,” coach Mark Fox said of honoring the three seniors. “So, yeah, there’s a lot of emotion involved. They’ve been terrific young people for our team.”
In addition to being a reflective occasion, it also happens to be a contest of great importance for both teams. Maten will figure prominently in that as well. There are only two SEC players averaging more rebounds than Maten and they both play for the Aggies — Robert Willams (6-foot-10, 240 pounds) and Tyler Davis (6-10, 264).
That’s why it’s kind of hard for Maten to be real contemplative at the moment. Between trying to fight and claw for a few more wins to earn NCAA tournament consideration and being the focus every opponent’s defensive strategy in every game, Maten’s not much into retrospection right now.