1 - Using the problem on page 21-22. Select Wheels, Create the spreadsheet to do the Weighted Total Scores example for each car. In addition to the actual spreadsheet also put in a table (like Table B) describing the weights and scales were evaluated. Additionally, make sure that you show the totals of the weights. Note: the 'how to write formulas' in Table C is NOT included and rows 9. 11 in Table D are not needed. ALSO, add a cell E: Total and E2: the sum of the three weights Use formatting to make the spreadsheets data more presentable. Use the function sumproduct and other functions, as needed, for the calculations/solution 1.5 SELECTING PROJECTS TO MEET ORGANIZATIONAL OBJECTIVES 21 Using a Weighted Scoring Model to Select Wheels As a college student, you now find that you need to purchase a car in order to get to your new part-time job and around town more quickly. This is not going to be your "forever" car, and your income is limited; basically, you need reliable wheels. You have two primary criteria of equal importance, cost and reliability. You have a limited budget and would like to spend no more than $4,200 on the car. In terms of reliability, you can't afford to have the car break down on your way to work, or for that matter, cost a lot to repair. Beyond these two major criteria, you consider everything else a "nicety" such as comfort, heat and air, appearance, handling, and so on. Such niceties you consider only half as important as either cost or reliability. Table B shows a set of scales you created for your three criteria, converted into quantitative scores. Table B: Criteria Scales and Equivalent Scores Scores Criterion 2 3 4 5 Cost >$5,000 $4,000-5,000 $3,000 4,000 2,000-3,000 $5,000 $4,000-5,000 $3,000 4,000 2,000-3,000