Q4: Finding a suitable home to live is a difficult task. There are many constraints to satisfy before an ideal home can be found. Few of the many constraints are: if the school district is good, whether it will take half an hour or an hour to commute from home to work, if there is open space for recreation close to home, property insurance you have to pay, if there is provision of hospital services nearby, distance from grocery store, distance from main road, a playground for kids, recreation center for the family to visit, and distance from places to eat out. How will you decide which house to buy with all these constraints? A multi-criteria method has been proposed in GIS and Management Science where one can optimally find the best house satisfying several constraints? Suppose there are four houses that you are looking at for possibly buying it or renting for next year. There are three criteria that you are examining: (1) proximity to schools, (2) property insurance, and (3) proximity to main roads. How will you decide which house to purchase since you have conflicting interests? One property may have less insurance but may be further away from the main road, another might have the acceptable insurance you want to pay but far away from the school, yet another may be close to the main road and school but the property insurance might be excessive. Given these constraints how will you decide which house to buy or rent? Proximity to school (minutes) Propertv Insurance (\$) Proximity to main roads (meters) Questions 1) Using the multi criteria evaluation technique find the most suitable house (parcel) if two different weights are used for two different families. Family A has proximity to school as the most important criteria (Weight-I) and Family B has property insurance as the most important criterion (Weight-II). Show your working like Excel example