Madonna - Song 5 Song 6 Song 7 Song 8 BalReqd...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Type Length (minute) Song 1 Ballad 4 Song 2 Hit 5 Song 3 Ballad 3 Song 4 Hit 2 Song 5 Ballad 4 Song 6 Hit 3 Song 7 Filler 5 Song 8 Ballad and Hit 4 MADONNA'S ALBUM ARRANGEMENT (NO OBJECTIVE FUNCTION: ONLY FEAIBLE SOLUTION) You have been assigned to arrenge the songs on the casette version of Madonna's latest album. A cass sides (1 and 2). The songs on each side of the cassette must total between 14 and 16 minutes in length. type of each song are are given in the table below. The assignment of songs to the tape must satisfy the conditions: 1- Each side must have exactly two ballads. 2- Side 1 must have at least three hit songs. 3- Either song 5 or song 6 must be on side 1. Determine whether there is an arrangement of songs satisftying these restrictions. (Hint: You may just le Cell box in the Solver dialog box empty.)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
sette tape has two . The length and e following eave the Target
Background image of page 2
Problem 5.12 Madonna's album arrangement Range names ActTimes =Sheet1!$D$20:$D$21 Data on songs Ballads =Sheet1!$B$25:$B$26 Song 1 Song 2 Song 3 Song 4
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Song 5 Song 6 Song 7 Song 8 BalReqd =Sheet1!$D$25:$D$26 Ballad? 1 1 1 1 ColSums =Sheet1!$B$14:$I$14 Hit? 1 1 1 1 Included =Sheet1!$B$12:$I$13 Filler? 1 MaxTimes =Sheet1!$F$20:$F$21 Length 4 5 3 2 4 3 5 4 MinTimes =Sheet1!$B$20:$B$21 Side1Hits =Sheet1!$B$30 Songs included on each side (1 if included, 0 if not) Side1Reqd =Sheet1!$D$30 Song 1 Song 2 Song 3 Song 4 Song 5 Song 6 Song 7 Song 8 Songs5_6 =Sheet1!$B$34 Side 1 1 1 1 1 Songs5_6Reqd =Sheet1!$D$34 Side 2 1 1 1 1 Sum 1 1 1 1 1 1 1 1 = = = = = = = = Required 1 1 1 1 1 1 1 1 Time length constraints Min Actual Max Side 1 14 <= 16 <= 16 Side 2 14 <= 14 <= 16 Ballad constraints Included Required Side 1 2 = 2 Side 2 2 = 2 Side 1 constraint # hit songs Required 3 >= 3 Song 5, 6 constraint # on side 1 Required 1 >= 1 A B C D E F G H I J K L M N 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34...
View Full Document

This note was uploaded on 05/31/2009 for the course MBA 4500 taught by Professor Eyupcetin during the Spring '09 term at Istanbul Technical University.

Page1 / 3

Madonna - Song 5 Song 6 Song 7 Song 8 BalReqd...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online