Please solve this question in an Excel spreadsheet, and provide a Word file with
ID: 421049 • Letter: P
Question
Please solve this question in an Excel spreadsheet, and provide a Word file with a brief description of an equation.
Case 4 The distributor is interested in selecting the best location for a new warehouse. After a detailed study of 10 sites, the three location finalists are Smithfield, New South Wales; Eagle Farm, Quensland; and Derrimut, Victoria. The management provides the following data on the location criteria, criteria importance, and location ratings. Conduct TOPSIS in an Excel spreadsheet to determine the best location for the new plant. What do the results suggest? Weight Ratings Eagle Farm, Criteria Objective Smithfield NSW Derrimut, QLD Land cost Labour cost Labour availabilit Construction cost Transportation Access to customers Long-range goals 6 6 Min Min Max Min Max Max 6 6 6 6 9 6 Max (15 marks)Explanation / Answer
So we use the equaion for maximization, and so using sore =
Highest is Eagle farm.
Rating MR Modified Rating Wt S EF D Obj Eq Subpart S EF D Criteria 4 5 7 6 Min 10- rating 5 3 4 Land Cost 6 7 6 6 Min 10- rating 3 4 4 Labor cost 8 6 7 5 max Rating 6 7 5 Labor Avail 5 5 6 7 Min 10- rating 5 4 3 Constr. Cost 5 6 6 7 max Rating 6 6 7 TransAccess to cust 9 8 7 7 max Rating 8 7 7 Long range goals 7 5 7 6 max Rating 5 7 6 Total 44 Score We*MR 5.636364 5.772727 5.340909 (Sumproduct (Wt, MR)/Total (Wt)