# Assigning Art

Topics: Painting, Collage, Cubism Pages: 8 (1917 words) Published: August 25, 2013
Case 7-1
Assigning Art
a). Ash decides to allocate \$4 million to fund the exhibit. Given the pieces available and the specific requirements from Ash and Celeste, formulate and solve a BIP model to maximize the number of pieces displayed in the exhibit without exceeding the budget. How many pieces are displayed? Which pieces are displayed? Decision Variable

X1| 1| If "Perfection" of Colin Zweibell is displayed|
| 0| otherwise|
| | |
X2| 1| If “Burden” of Colin Zweibell is displayed|
| 0| otherwise|
| | |
X3| 1| If “The Great Equalizer” of Colin Zweibell is displayed| | 0| otherwise|
| | |
X4| 1| If “Chaos Reigns” of Rita Losky is displayed| | 0| otherwise|
| | |
X5| 1| If “Who Has Control?” of Rita Losky is displayed| | 0| otherwise|
| | |
X6| 1| If “Domestication” of Rita Losky is displayed| | 0| otherwise|
| | |
X7| 1| If “Innocence” of Rita Losky is displayed|
| 0| otherwise|
| | |
X8| 1| If “Aging Earth” of Norm Marson is displayed| | 0| otherwise|
| | |
X9| 1| If “Wasted Resources” of Norm Marson is displayed| | 0| otherwise|
| | |
X10| 1| If “Serenity” of Candy Tate is displayed|
| 0| otherwise|
| | |
X11| 1| If “Calm Before the Storm” of Candy Tate is displayed| | 0| otherwise|
| | |
X12| 1| If “Void” of Robert Bayer is displayed|
| 0| otherwise|
| | |
X13| 1| If “Sun” of Robert Bayer is displayed|
| 0| otherwise|
| | |
X14| 1| If “Storefront Window” of David Lyman is displayed| | 0| otherwise|
| | |
X15| 1| If “Harley” of David Lyman is displayed|
| 0| otherwise|
| | |
X16| 1| If “Consumerism” of Angie Oldman is displayed| | 0| otherwise|
| | |
X17| 1| If “Reflection” of Angie Oldman is displayed| | 0| otherwise|
| | |
X18| 1| If “Trojan Victory” of Angie Oldman is displayed| | 0| otherwise|
| | |
X19| 1| If “Rick” of Rick Rawls is displayed|
| 0| otherwise|
| | |
X20| 1| If “Rick II” of Rick Rawls is displayed|
| 0| otherwise|
| | |
X21| 1| If “Rick III” of Rick Rawls is displayed|
| 0| otherwise|
| | |
X22| 1| If “Beyond” of Bill Reynolds is displayed|
| 0| otherwise|
| | |
X23| 1| If “Pioneers” of Bill Reynolds is displayed| | 0| otherwise|
| | |
X24| 1| If “Wisdom” of Bear Canton is displayed|
| 0| otherwise|
| | |
X25| 1| If “Superior Powers” of Bear Canton is displayed| | 0| otherwise|
| | |
X26| 1| If “Living Land” of Bear Canton is displayed| | 0| otherwise|
| | |
X27| 1| If “Study of a Violin” of Helen Row is displayed| | 0| otherwise|
| | |
X28| 1| If “Study of a Fruit Bowl” of Helen Row is displayed| | 0| otherwise|
| | |
X29| 1| If “My Namesake” of Ziggy Lite is displayed| | 0| otherwise|
| | |
X30| 1| If “Narcissism” of Ziggy Lite is displayed|
| 0| otherwise|
| | |
X31| 1| If “All That Glitters” of Ash Briggs is displayed| | 0| otherwise|
| | |
X32| 1| If “The Rock” of Ash Briggs is displayed|
| 0| otherwise|
| | |
X33| 1| If “Winding Road” of Ash Briggs is displayed| | 0| otherwise|
| | |
X34| 1| If “Dreams Come True” of Ash Briggs is displayed| | 0| otherwise|

Objective Function
Max. Total pieces displayed at the exhibit
Z = X1 + X2 + X3 + X4 + X5 +….+X34
Subject to
Constraint 1 : Budget constraint not exceed \$4,000,000
300,000X1 + 250,000X2 + 125,000X3 + 400,000X4 + 500,000X5 + 400,000X6 + 550,000X7 + 700,000X8 + 575,000X9 + 200,000X10 + 225,000X11 + 150,000X12 + 150,000X13 + 850,000X14 + 750,000X15 + 400,000X16 + 175,000X17 + 450,000X18 + 500,000X19 + 500,000X20 + 500,000X21 + 650,000X22 + 650,000X23 + 250,000X24 + 350,000X25 + 450,000X26 + 400,000X27 + 400,000X28 + 300,000X29 + 300,000X30 + 50,000X31 + 50,000X32...