needing help with this question

QUESTION 4 Purchasing a car is something most of you are familiar with. In fact, as graduation gets closer, many of you may already be thinking of what car you will purchase upon graduating. For the purpose of this exam problem, we will assume that your candidates are the sports cars listed below ad you have collected the information given. Car Acceleration 0 to 60 mph (seconds) 8.5 MPG 20 Integra BMW 325 7.8 23 Price $22.275.00 $21,754.00 $32.167.00 $23,824.00 327,728.00 $31.734.00 Appearance Very Sporty Very Sporty Very Sporty OK Corvette 6.5 16 Stealth Turbo 5.7 10 RX-7 0.5 19 OK 300 ZX Turbo 0.0 18 OK To score these cars you will use a 3-point scale. It is important to scale all criteria with the same number of points, or the weighting scheme will be thrown off. Thus, if you score the cars on price using a 3-point scale, you must also use a 3-point scale for acceleration, MPG, and appearance. Make sure that the higher points are assigned to most favorable outcomes. After looking over the data you collected on the cars, assume that you have decided on the following 3-point scales for each of the criteria Criteria 1 point > 5 32.000 3 points 5 and 6 >17 and 20 OK 5 MPG C 17 520 Appearance More of a sedan Very sporty Let's assume that after careful thought you have arrived at the following weighting schemes: 40% 30%, 10% and 209 for the factors price, acceleration, MPG. and appearance respectively Based on these given information obtain and enter the composite score for each car below using a 3 point scale, you must also use a 3 point scale for acceleration, MPG, and appearance. Make sure that the higher points are assigned to m the data you collected on the cars, assure that you have decided on the following 3 point scales for each of the criteria: Criteria 1 point 3 points 2 points $25,000 to $32,000 Price >$32,000 5 and 6 MPG C 17 >17 and =20 Appearance More of a sedan OK Very sporty Let's assume that after careful thought you have arrived at the following weighting schemes: 40%, 30%, 10% and 20% for the factors price, accele Based on these given information, obtain and enter the composite score for each car below. Car Score Integra BMW 325 Corvette Stealth Turbo RX-7 300 ZX Turbo Indicate your first choice second choice and third choice FORMAT TO USE IN ENTERING VALUES: Round score values to the nearest tenth place, for example 3.138 rounded as 3.1 For your first second, and third choices, enter the name of the cars exactly as given