solve it using excel , with showing the equations that u type it in the excel plz

with showing all the steps

PROBLEMS S7-1. Sweats and Sweaters is a small chain of stores specializing in casual cotton clothing. The company currently has five stores in Georgia, South Carolina, and North Carolina, and it wants to open a new store in one of four new mall locations in the Southeast. A consulting firm has been hired to help the com- pany decide where to locate its new store. The company has indicated five factors that are important to its decision, in- cluding proximity of a college, community median income, mall vehicle traffic flow and parking, quality and number of stores in the mall, and proximity of other malls or shopping areas. The consulting firm had the company weight the im- portance of each factor. The consultants visited each potential location and rated them according to each factor, as follows: Scores (0 to 100) Weight Mall 1 Mall 2 Mall 3 Mall 4 0.30 40 60 90 50 0.25 80 75 70 0.25 60 90 79 74 0.10 90 100 80 90 0.10 80 30 60 70 Location Factor College proximity Median income Vehicle traffic Mall quality and size Proximity of other shopping 75