Assignment -
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 for trade show participation. Create a Pugh matrix/multifactor decision matrix spreadsheet for this request. For additional information on the decision matrix.
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.
Create an Excel document. On the Excel document, answer the prompts listed above, plus charts and tables.
Attachment:- Assignment File.rar