Show your work with Excel and Solver:

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 toems. Instead he wanted to use his money to support his true pas- the comer 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 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 toems. Instead he wanted to use his money to support his true pas- the comer 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