INSTRUCTIONS:
For this assignment, you willread the scenario below and answerthe prompts provided.
ETPI’s marketing department intends to participate in several trade shows this year. While the marketing department has relied on some rules of thumb regarding choosing which shows in which to participate in the past, more rigorous analysis will be used this year. As the consultant, you will develop a multifactor analysis to determine which trade shows to participate in.
Location Planning:
The marketing department has asked for a spreadsheet model to use in selecting locations fortrade show participation. Create a Pugh matrix/multifactor decision matrix spreadsheet forthis request. For additional information on the decision matrix, see https://asq.org/learn-about-quality/decision-making-tools/overview/decision-matrix.html. (https://asq.org/learn-about-quality/decision-making-tools/overview/decision-matrix.html)
Develop at least 10 criteria for seven possible alternative locations. Also develop a set of weights that can be modified by the marketing department. Make sure that the spreadsheet model is well-formatted and calculates total scores for each alternative.