Question: 2. Write out the model and then use Excel Solver to solve the following assignment problem: The Dubuque Sackers, a class D baseball team, face

2. Write out the model and then use Excel Solver to solve the following assignment problem: The Dubuque Sackers, a class D baseball team, face a tough 4 game road trip against league rivals Des Moines, Davenport, Omaha and Peoria. Manager "Red" Revelle faces the task of scheduling his four starting pitchers for appropriate games. Because the games are to be played back to back in less than one week, Revelle cannot count on any pitcher to start in more than one game. Revelle knows the strengths and weaknesses not only of his pitchers, but also of his opponents. He has developed a performance rating for each of his starting pitchers against each of these teams. The ratings are listed in the table below. What pitching rotation should manager Revelle set to provide the highest total of the performance ratings? Opponent Starting Pitcher Des Moines Davenport Omaha Peoria Jones 0.6 0.8 0.5 0.4 Baker 0.7 0.4 0.8 0.3 Parker 0.9 0.8 0.7 0.8 Wilson 0.5 0.3 0.4 0.2

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Quantitative Methods Assessment 2 a ) Write out the model for the following transportation problem - i . e . define the variables and state the objective function and constraints. b ) Use Excel...

a ) Write out the model and then b ) Use Excel Solver to solve the following assignment problem: The Dubuque Sackers, a class D baseball team, face a tough 4 game road trip against league rivals Des...

IS 601 Assignment 7 1. The production of car tires in any given year is related to the number of cars produced that year and in prior years. Suppose our econometric model resulted in the following...

answer all parts111 Your second essay assignment requires you to critically examine the American Psychological Association code of ethics. But does the code of ethics from your own profession...

Please write each step specifically, thank you. Problem 1 (Assignment Problem) A team of four LCB students collaborate on a project with four tasks to be completed. The four members (i = 1,2,3,4)...

The Optimization Case Study corresponds to concepts taught in Module 2 (Optimization -Part 1) and Module 3 (Optimization - Part 2). This is a team assignment. The instructions require you to complete...

The Optimization Case Study corresponds to concepts taught in Module 2 (Optimization - Part 1) and Module 3 (Optimization - Part 2). This is a team assignment. The instructions require you to...

Hello, I need help with with Return of the Tallahassee Beancounters Case (the 2010 version). The solution and teachers handouts for the 2003 version have already been made available, however it's...

2017/4/7 Section 5.6 (Part A) [43 points] 1. -/3 points A standard deck of playing cards has 52 cards, consisting of 13 "ranks" (2, 3, 4, 5, 6, 7, 8, 9, 10, jack, queen, king, ace) of each of the 4...

Reconsider Prob. 9.1-6. Starting with Russell's approximation method, interactively apply the transportation simplex method to obtain an optimal solution for this problem. In problem After several...

Businesses often give quantity discounts. Below, you will analyze how such discounts can impact choice sets. A: I recently discovered that a local copy service charges our economics department $0.05...

Which one of the following entails the use of computers to monitor prices and also to submit trade orders in response to arbitrage opportunities? computer hedging cach - futures panity program...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...