. You have a band that has recorded 2 albums. Because of Covid, you havent performed an album release concert, so with Covid winding down, you are planning a double-album concert. The concert will be performed in two halves, with an intermission between them. Each album has 9 original songs, and you would like to perform all 18 songs at the concert. Your albums, with their song lengths (in minutes and seconds), are as follows: Cosmos Sing the Blues Bring on the Sun 3:29 Blue Aint So Bad 4:12 Comet 3:34 Loose Ends 3:32 Dancin Cross the Universe 4:18 Love Me Blue 4:19 Down the Milky Way 6:31 My Blue Love 7:27 Heaven 5:33 Outta Here 6:07 My Superstar 3:11 Precious 3:19 No Country for Spacemen 5:53 Suck It Up 5:24 The Space Between Us 4:26 Thats How Ya Sing the Blues 4:49 Walkin On The Moon 7:29 The Lady Has the Blues 4:12 You would like to determine the optimal set list by assigning these songs to either the concerts first or second half. You would like to meet the following criteria: a. You would like the two halves to be as close in time as possible. b. You do not want to perform more than 5 songs from either album before or after intermission. (In other words, you must have at least 4 songs from each album in each half of the concert.) How should you split your 2 albums up (by assigning songs to either the first or second half) to meet these criteria? What is the time difference between the two halves?

Solve using Excel Solver and show steps