Please use Excel DONT use a code . can i have screenshots and formulas to please . thank you

the question wants to know what is the optimal arrangement for students staying 2 in a room. Who do you want to be roomate with

Problem 3 40 Points Bluefield State College is considering building on-campus dorms to house 40 students. In order to maximize student satisfaction a survey consisting of 6 questions has been developed and administered to the students who will be staying in the dorms. The questions pertain to issues such as sleep time, noise, smoking, etc. The following questions along with the potential response are reported below. 1. What time do you go to bed at night? 6pm 6, Midnight 12, 2am 14, etc. 2. What time do you get up in the morning? 6am 6, noon- 12, 2pm 14, etc 3. How neat are you? 1 Messy, 2 Moderate, 3 Very neat 4. Do you smoke? O no, 10 yes 5. How much noise do you like in your environment? 1-Little noise, 2 moderate noise, 3 -lots of noise 6. How many guests do you like having over? 1 No guests, 2 some guests, 3 lots of guests The responses for each of the 40 students are reported in table 1. Formulate the problem as an optimization model and determine what is the optimal (or near optimal) arrangement for students staying two to a room. As a hint, this problem should be formulated as a TSP and the Alldifferent constraint will be used. The objective function should consist of a total root sum of squares between 20 different sets of two roommates. The evolutionary solver in Excel will also have to be used. Be creative and try to think of how you would actually try to solve this problem and what criteria you need to use. If you were a potential roommate, who would you want to be paired with. Then extend this to the entire group