As you learned in KT decision analysis chapter, open the Excel sheet to solve the questions:

Read the questions and fill the table to have the correct answers.

File Home Insert Page Layout Formulas Data Review View Help Share Comments PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing P11 X fr D E F 1 J K L M N O P Q R S T V 1 A customer needs to buy a new mobile, he has only SR 2,600. After visiting the local and online stores, he summarized his options as follow: 2 3 4 5 6 7 8 Cost Brand Rating Memory Rating Camera Rating Alternative A Alternative B Alternative C Alternative D SR 2,500 SR 1,000 SR 550 SR 2,999 7 out of 10 9 out of 10 5 out of 10 10 out of 10 9 out of 10 9 out of 10 9 out of 10 9 out of 10 8 out of 10 9 out of 10 7 out of 10 8 out of 10 9 10 11 12 A- Complete the following KT Decision Analysis Table: 13 14 15 16 17 18 19 20 KT Decision Analysis Musts Cost GO / NO GO Brand GO/NO GO Memory GO / NO GO Resolution GO / NO GO Wants Weights Rating Score Cost convenience 7 Brand image 6 Memory size 4 High resolution 3 Total A = B-What would be the best option for the customer to buy? Alternative: B GO / NO GO GO / NO GO GO / NO GO GO / NO GO Rating Score GO/NO GO GO/ NO GO GO/NO GO GO / NO GO Rating Score D GO / NO GO GO/ NO GO GO/NO GO GO / NO GO Rating Score 21 22 23 24 25 Total B = Total = Total D = 26 27 File Home Insert Page Layout Formulas Data Review View Help Share Comments PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing P11 X fr D E F 1 J K L M N O P Q R S T V 1 A customer needs to buy a new mobile, he has only SR 2,600. After visiting the local and online stores, he summarized his options as follow: 2 3 4 5 6 7 8 Cost Brand Rating Memory Rating Camera Rating Alternative A Alternative B Alternative C Alternative D SR 2,500 SR 1,000 SR 550 SR 2,999 7 out of 10 9 out of 10 5 out of 10 10 out of 10 9 out of 10 9 out of 10 9 out of 10 9 out of 10 8 out of 10 9 out of 10 7 out of 10 8 out of 10 9 10 11 12 A- Complete the following KT Decision Analysis Table: 13 14 15 16 17 18 19 20 KT Decision Analysis Musts Cost GO / NO GO Brand GO/NO GO Memory GO / NO GO Resolution GO / NO GO Wants Weights Rating Score Cost convenience 7 Brand image 6 Memory size 4 High resolution 3 Total A = B-What would be the best option for the customer to buy? Alternative: B GO / NO GO GO / NO GO GO / NO GO GO / NO GO Rating Score GO/NO GO GO/ NO GO GO/NO GO GO / NO GO Rating Score D GO / NO GO GO/ NO GO GO/NO GO GO / NO GO Rating Score 21 22 23 24 25 Total B = Total = Total D = 26 27