Do your own rating for a choic... CREATING YOUR OWN EXCEL SPREADSHEETS Program 2.1 illustrates how to build an Excel spreadsheet for the data in Example 1. In this example the factar rating method is used to compare National Architects three potential outsourcing providers. This sheet provides the data inputs for seven important factors, including their weights (0.9-10) and rating (1-5 scale where is the highest rating) for each country. As we see, BIM is most highly rated, with a score, versus 33 for S.P.C. and 3.8 for Telca Enter factor names and weights in columns A and B. Enter scores that come from manager ratings for BIM, S.PC, and Telco on each factor in columns C, D, and E National Architects, Inc 2 Factor IMPORTANCE WEIGHT OUTSOURCE PROVIDES SM TELCO ENRIA ISRAEUS 1 1 3 4 3 3 3 3 2 3 4 3 3 FACTORACHTEN 1. Can we spent 72 Canele capitales 3. Suled personel 4.Canimerovelty 19 5. Cangan ccess to technology not is the company Cantina capacity Alges with polichroyeur 02 21 01 Actions Copy C14 to 14 and E14 -SUMPRODUCT($B$4:$B$12,C6.C12) Compute the weighted scores as the sum of the product of the weights and the scores for each option using the SUMPRODUCT function