You have been assigned to arrange the songs on the cassette version of Madonna’s latest album. (Feel free to substitute your own favorite rock star for Madonna!) A cassette tape has two sides (1 and...

You have been assigned to arrange the songs on the cassette version of Madonna’s latest album. (Feel free to substitute your own favorite rock star for Madonna!) A cassette tape has two sides (1 and 2). The songs on each side of the cassette must total between 14 and 16 minutes in length. The length and type of each song are given in the file P06_72.xlsx. The assignment of songs to the tape must satisfy the following conditions:


■ Each side must have exactly two ballads.


■ Side 1 must have at least three hit songs.


■ Either song 5 or song 6 must be on side 1. Determine whether there is an arrangement of songs satisfying these restrictions. (Hint: You do not need a target cell when using Solver. In the Solver dialog box, just leave the Target Cell box empty.)