i need to know how to write it's answer on excel amd gams

8.4.2022 IE 232 - Operation Research I Spring 2022 Recitation 7 1. You have been assigned to arrange the songs on the CD version of Madonna's latest album. This album will consist of two CDs (1 and 2). The songs on each CD must total between 14 and 16 minutes in length. The length and type of each song are given in the following table. The assignment of songs to the tape must satisfy the following conditions: 1 Each CD must have exactly two ballads. 2 CD I must have at least three hit songs. 3 Either song 5 or song 6 must be on CDI. 6 4 If songs 2 and 4 are on CD1, then song 5 must be on CD2. Explain how you could use an integer programming formulation to determine whether there is an arrangement of songs satisfying these restrictions. Song Length Type (in minutes) 1 Ballad 4 Hit 5 Ballad 4 Hit 5 Ballad Hit 3 7 5 Ballad and hit 2 3 3 2 4 6 8 4