Problem 21 Essay

312 Words2 Pages
Using a spreadsheet for Problem 21, find the following: (a) What would be your recommendation if the weight for the transportation cost went down to 10 and the weight for union relations went up to 25? (b) Suppose location A received a score of 3 for transport cost and location C received a score of 2 for transport cost. Would your recommendation change under these circumstances? (c) The VP of Finance has looked at your scoring model and feels that tax considerations should be included in the model with a weight of 15. In addition, the VP has scored the locations on tax considerations as follows: A-3, B-2, and C-1. How does this affect your recommendation? SOLUTION a. The spreadsheet shown in Problem 21 can be modified by changing the two weightings as follows: • The entry in cell B5 is changed from 10 to 25, and • The entry in cell B7 is changed from 25 to 10. The result of these changes is changes results in location A having a score of 195, location B a score of 225, and location C a score of 210. Location B, therefore, is the preferred location. b. The spreadsheet shown in Problem 21 can be modified by changing the two evaluations as follows: • The entry in cell C7 is changed from 1 to 3, and • The entry in cell E7 is changed from 3 to 2. Making these changes results in location A having a score of 215, location B a score of 210, and location C a score of 200. Location A is, therefore, the preferred location. c. The spreadsheet shown in Problem 21 can be modified as shown below by adding a new row for tax considerations. According to the results shown below, including tax considerations results in locations B and C both having an identical score of

More about Problem 21 Essay

Open Document