Be clean with your work and show formulas used.

If you use excel, Use Formulas Used

I. Skiven, a software company, is evaluating four different surveillance cameras for a new security system at its facility. a. Skiven decided to select a camera based upon a multi-objective evaluation, with decision criteria of: price weight, picture clarity and low-light performance. The table below summarizes the data for each camera. Camera 2 3 Attribute Price, $ Camera weight, grams Picture clarity Low light performance Attribute Weight 10 15 35 40 1 230 900 3 243 640 5 274 910 3 4 313 433 5 6 4 5 7 Picture clarity and low-light performance have been evaluated on a 0-10 scale, with 10 being the best. Also note that the lighter the camera the better (e.g., a 300 gram is considered more appealing than a 400 gram camera). The Skiven management recognizes that to perform a SAW evaluation all value matrix elements must be on a consistent ratings scale. Please convert the Price and Camera weight data to a 0-10 scale, with 10 being the best. Show your results in the table below. Camera 1 2 3 4 Attribute Price Camera weight Attribute Weight 10 15 b. Use the data in part a, and your response to the question, to conduct a SAW analysis and select the preferred camera