Please be neat and show all work.

A graduating senior has becn accepted hy three universities for an M.S. in engineering Two criteria have been identified. The first is the program and university's academic ranking. The second is the cost. A third criteria of location was initially considered, but re only made urrently enrolled in the first university, which is rated r academic rank and a 10 for cost. The second is a larger out-of-state public university, which is rated as an 8 for academic rank and a 6 for cost. The third is a prestigious private school, which is rated as a 10 academically and a 3 for its higher cost then the student recognized that it is only for about a year, and applications we to acceptable schools. The student is c as a 5 fo Use Excel to (a) Calculate the total score for each school if the two objectives have the same weight? Use (b) If academic rank has a weight of 75%, what is the total score for each school? (6 points)