Answered step by step
Verified Expert Solution
Question
1 Approved Answer
44. A convenience store chain is considering opening a new store at one of four locations. They have developed the following multi-criteria scoring model for
44. A convenience store chain is considering opening a new store at one of four locations. They have developed the following multi-criteria scoring model for this problem. Complete the following table. This is to prepare the spreadsheet for use in generating a Weighted Score radar chart but you DO NOT need to generate the Radar chart? A B C D E F G H 1 Scores 2 Site Site Site Site Criterion 3 Criterion A B C D Weights 4 Sales 0.65 0.75 0.70 0.80 0.50 S Location 0.95 0.80 0.88 0.70 0.20 6 Security 0.50 0.50 0.60 0.40 0.25 7 Growth 0.85 0.60 0.80 0.60 0.05 8 Weighted average score 0.6825 0.69 0.716 0.67 1 9 10 Scores 11 Site Site Site Site Criterion 12 Criterion A B C D Weights 13 Sales ? ? ? ? 0.50 14 Location ? 2 ? ? 0.20 15 Security 7 ? ? ? 0.25 16 Growth 2 ? 7 0.05 17 1
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started