A firm has three purchasing options for a component used in its final product. Based on a market survey, the relative importance of each of the criteria and the extent to which each buying option satisfies each of the criteria (on a scale of 10) are determined and presented in the table below. Based on the weighted average scores, which option should be chosen? What is the corresponding weighted score? Hint: To expedite the solution process you can copy the table into Excel and use the SUMPRODUCT function. Criteria Weight Option 1 Option 2 Option 3 Brand 25% 4 5 2 Durability 30% 6 8 4 Functionality 30% 7 6 4 Modularity 15% 5 1 8