On Excel

Case 7-1 Assigning Art It had been a dream come true for Ash Briggs, a struggling art ist living in the San Francisco Bay area. He had made a trip to al items. Instead he wanted to use his money to support his true pas- the corner grocery store late one Friday afternoon to buy some sion: art. Ash knew all too well the difficulties of gaining recognition milk, and, on impulse, he had also purchased a California lottery as an artist in this post-industrial, technological society where artistic ticket. One week later, he was a multimillionaire Ash did not want to squander his winnings on materialistic, triv- appreciation is rare and financial support even rarer. He therefore (SKIP TO THE NEXT PAGE and THEN RETURN TO THIS SPOT) to play favorites among these two artists. He therefore decides to Please explore the following questions independently except where otherwise indicated. display as many pieces from David Lyman as from Rick Rawls and to display at least one piece from each of them. Although Ziggy Lite is very popular within art circles, Ash believes Ziggy a. Ash decides to allocate $4 million to fund the exhibit. Given the picces available and the specific requirements from Ash and Celeste, formulate and solve a binary integer program- ming problem to maximize the number of pieces displayed in the exhibit without exceeding the budget. How many pieces are displayed? Which pieces are displayed? makes a mockery of art. Ash will therefore only accept one dis- play piece from Ziggy, if any at all Celeste also possesses her own agenda for the exhibit. As a museum director, she is interested in representing a diverse pop- ulation of artists, appealing to a wide audience, and creating a politically correct exhibit. To advance feminism, she decides to include at least one piece from a female artist for every two pieces included from a male artist. To advance environmentalism, she decides to include either one or both of the pieces Aging Eartlh and Wasted Resources. To advance Native American rights, she decides to include at least one piece by Bear Canton. To advance science, she decides to include at least one of the following pieces: Chaos Reigns, Who Has Control?, Beyond, and Pioneers. c. An influential patron of Rita Losky's work who chairs the b. To ensure that the exhibit draws the attention of the pub- lic, Celeste decides that it must include at least 20 pieces Formulate and solve a binary integer programming prob- lem to minimize the cost of the exhibit while displaying at least 20 pieces and meeting the requirements set by Ash and Celeste. How much does the exhibit cost? Which pieces are displayed? Celeste also understands that space is limited at the museum museum's board of directors learns that Celeste requires at least 20 pieces in the exhibit. He offers to pay the minimum amount required on top of Ash's S4 million to ensure that exactly 20 pieces are displayed in the exhibit and that all of Rita's pieces are displayed. How much does the patron have to pay? Which pieces are displayed? The museum only has enough floor space for four sculptures and enough wall space for 20 paintings, collages, and drawings Finally, Celeste decides that if Narcissism is displayed, Reflection should also be displayed since Reflection also sug gests narcissism Case 7-1 Assigning Art It had been a dream come true for Ash Briggs, a struggling art ist living in the San Francisco Bay area. He had made a trip to al items. Instead he wanted to use his money to support his true pas- the corner grocery store late one Friday afternoon to buy some sion: art. Ash knew all too well the difficulties of gaining recognition milk, and, on impulse, he had also purchased a California lottery as an artist in this post-industrial, technological society where artistic ticket. One week later, he was a multimillionaire Ash did not want to squander his winnings on materialistic, triv- appreciation is rare and financial support even rarer. He therefore (SKIP TO THE NEXT PAGE and THEN RETURN TO THIS SPOT) to play favorites among these two artists. He therefore decides to Please explore the following questions independently except where otherwise indicated. display as many pieces from David Lyman as from Rick Rawls and to display at least one piece from each of them. Although Ziggy Lite is very popular within art circles, Ash believes Ziggy a. Ash decides to allocate $4 million to fund the exhibit. Given the picces available and the specific requirements from Ash and Celeste, formulate and solve a binary integer program- ming problem to maximize the number of pieces displayed in the exhibit without exceeding the budget. How many pieces are displayed? Which pieces are displayed? makes a mockery of art. Ash will therefore only accept one dis- play piece from Ziggy, if any at all Celeste also possesses her own agenda for the exhibit. As a museum director, she is interested in representing a diverse pop- ulation of artists, appealing to a wide audience, and creating a politically correct exhibit. To advance feminism, she decides to include at least one piece from a female artist for every two pieces included from a male artist. To advance environmentalism, she decides to include either one or both of the pieces Aging Eartlh and Wasted Resources. To advance Native American rights, she decides to include at least one piece by Bear Canton. To advance science, she decides to include at least one of the following pieces: Chaos Reigns, Who Has Control?, Beyond, and Pioneers. c. An influential patron of Rita Losky's work who chairs the b. To ensure that the exhibit draws the attention of the pub- lic, Celeste decides that it must include at least 20 pieces Formulate and solve a binary integer programming prob- lem to minimize the cost of the exhibit while displaying at least 20 pieces and meeting the requirements set by Ash and Celeste. How much does the exhibit cost? Which pieces are displayed? Celeste also understands that space is limited at the museum museum's board of directors learns that Celeste requires at least 20 pieces in the exhibit. He offers to pay the minimum amount required on top of Ash's S4 million to ensure that exactly 20 pieces are displayed in the exhibit and that all of Rita's pieces are displayed. How much does the patron have to pay? Which pieces are displayed? The museum only has enough floor space for four sculptures and enough wall space for 20 paintings, collages, and drawings Finally, Celeste decides that if Narcissism is displayed, Reflection should also be displayed since Reflection also sug gests narcissism