please solbe using EXCEL and explain step by step your formulas and data pack tooks used

3. [30 points Be prepared it is a long story. In the last class meeting of a "BORING" course, you were informed that the second exam would include 4 questions out of the 7 potential types of problems covered in this course. The night before the exam, you had an unbelievable dream (with a good night of sleep), in which you correctly guessed the four types questions of this exam, i.e., Shortest Path. CPM, ILP, Transportation. In the morning, you confirmed the "RUMOR" that students are allowed to bring an 8X11 cheat sheet (one sided). The area or space needed to write down the content in the cheat sheet for each type of question can be found in the following Table. In addition, you have another option, that is to memorize the content of any type of question. But to memorize, it takes more time, which also can be found in the table. The expected scores for each type by using the two different strategies are different and shown in the following table as well. Requirements/Costs/Benefits Type of Shortest CPM ILP Transportation Questions Path Area Needed (in 2) 35 45 30 30 Time to Write Down (minute) 15 29 50 23 Time to learn and memorize (minute) 26 35 80 21 Expected Score (using cheat sheet) 25 15 25 25 Expected Score (memorizing) 29 20 30 20 To help understand the table better, for example, the "Shortest Path" column shows the areas/spaces (35 in^2) needed to write it down on the cheat sheet, how much time it takes to either write it down on cheat sheet or memorize it (suppose you do not have enough time to allow you do both), the expected scores you will get by using the two different strategies. Right before you start the preparation after you got up, your roommate (a.k.a., your best friend) throws a surprise party with no chance you can possibly resist. After the **FANTASTIC" party, you only have 3 hours to prepare. But you decide to use half an hour to figure out your best preparation strategy, which you name it "B-R-F". Please tell us the rest of your story (i.e., formulate an optimization model, B-R-F, and solve it using either EXCEL or GAMS, and ehplain your strategy)