The Philharmonic Orchestra of Philo (POoP) consists of eight (8) of the most diversely fabulous musicians in the known universe. They are planning their set for performance on the main stage as the headline act at the upcoming Philo Pholk Phestival. Specifically, they are attempting to determine which musician should play each instrument for a light-hearted, fun-filled performance of a new concerto named Phlight of the Phlea Phlicker which they co-wrote. The musicians, the instruments, and number of unintentional flubs that could be expected from each musician on each instrument during a full 30-minute performance are shown in the table below. Unintentional flubs add to the light-hearted, fun-filled atmosphere POOP is trying to create in a way that simply cannot be replicated by intentional" flubs. Therefore, the conductor is trying to select the musician for each instrument in such a way that the total number of unintentional flubs to be expected during the performance is maximized. Instrument: Kazoo Harmonica Recorder Cowbell Maraca Mouth Bongos Bango Harp Musician Rodney Stevie 31 85 Jay 24 Wendy 30 Ryan 92 14 52 Kim 89 Puffy 47 66 3 20 82 29 43 61 59 3 70 68 5 89 88 92 9 90 3 19 45 63 81 61 32 42 35 30 65 93 97 4 46 93 Ian 67 13 97 55 22 31 38 74 91 18 8 98 22 70 61 39 25 54 91 60 a. (20 points) Use Excel Solver to obtain the optimal pairings of musicians and instruments. Each musician must be assigned to one instrument, and each instrument must have one a. (20 points) Use Excel Solver to obtain the optimal pairings of musicians and instruments. Each musician must be assigned to one instrument, and each instrument must have one musician assigned. Obtain an Answer Report and a Sensitivity Report. What musician should play each instrument? How many unintentional flubs will be expected during the performance? b. (20 points) On the day of the performance, Stevie, Jay and lan are flat in bed with the flu. Fortunately, Ryan and Rodney remind the conductor that the score and the musical instruments are such that one musician could play both the Kazoo and the Bongos, another musician could play both the Harmonica and the Bango, and a third musician could play both the Mouth Harp and the Cowbell. No matter what musician is assigned to each of these combinations of instruments, it is expected that their number of unintentional flubs on each instrument will double. For example, if Rodney plays both the Kazoo and the Bongos, it is expected that he would have 94 unintentional flubs on the Kazoo and 86 on the Bongos. Use Excel Solver to obtain the optimal pairings of musicians and instruments so that the five musicians that are not out with the flu play all eight instruments with the specific combinations of instruments given. Obtain an Answer Report and a Sensitivity Report. What musician should play each instrument? How many unintentional flubs will be expected during the performance? Will the resulting performance be more or less desirable than that obtained in part a? Explain. The Philharmonic Orchestra of Philo (POoP) consists of eight (8) of the most diversely fabulous musicians in the known universe. They are planning their set for performance on the main stage as the headline act at the upcoming Philo Pholk Phestival. Specifically, they are attempting to determine which musician should play each instrument for a light-hearted, fun-filled performance of a new concerto named Phlight of the Phlea Phlicker which they co-wrote. The musicians, the instruments, and number of unintentional flubs that could be expected from each musician on each instrument during a full 30-minute performance are shown in the table below. Unintentional flubs add to the light-hearted, fun-filled atmosphere POOP is trying to create in a way that simply cannot be replicated by intentional" flubs. Therefore, the conductor is trying to select the musician for each instrument in such a way that the total number of unintentional flubs to be expected during the performance is maximized. Instrument: Kazoo Harmonica Recorder Cowbell Maraca Mouth Bongos Bango Harp Musician Rodney Stevie 31 85 Jay 24 Wendy 30 Ryan 92 14 52 Kim 89 Puffy 47 66 3 20 82 29 43 61 59 3 70 68 5 89 88 92 9 90 3 19 45 63 81 61 32 42 35 30 65 93 97 4 46 93 Ian 67 13 97 55 22 31 38 74 91 18 8 98 22 70 61 39 25 54 91 60 a. (20 points) Use Excel Solver to obtain the optimal pairings of musicians and instruments. Each musician must be assigned to one instrument, and each instrument must have one a. (20 points) Use Excel Solver to obtain the optimal pairings of musicians and instruments. Each musician must be assigned to one instrument, and each instrument must have one musician assigned. Obtain an Answer Report and a Sensitivity Report. What musician should play each instrument? How many unintentional flubs will be expected during the performance? b. (20 points) On the day of the performance, Stevie, Jay and lan are flat in bed with the flu. Fortunately, Ryan and Rodney remind the conductor that the score and the musical instruments are such that one musician could play both the Kazoo and the Bongos, another musician could play both the Harmonica and the Bango, and a third musician could play both the Mouth Harp and the Cowbell. No matter what musician is assigned to each of these combinations of instruments, it is expected that their number of unintentional flubs on each instrument will double. For example, if Rodney plays both the Kazoo and the Bongos, it is expected that he would have 94 unintentional flubs on the Kazoo and 86 on the Bongos. Use Excel Solver to obtain the optimal pairings of musicians and instruments so that the five musicians that are not out with the flu play all eight instruments with the specific combinations of instruments given. Obtain an Answer Report and a Sensitivity Report. What musician should play each instrument? How many unintentional flubs will be expected during the performance? Will the resulting performance be more or less desirable than that obtained in part a? Explain
