Question: 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

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?

Step by Step Solution

★★★★★

3.47 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a The spreadsheet shown in Problem 21 can be modified by changing the two weightings as follows The ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

132-B-M-L-P-M (934).docx

120 KBs Word File

Students Have Also Explored These Related Management Leadership Questions!

What would be your reaction if you were told you were not hired based on your responses to this questionnaire?

For each of the following studies, what would be the most appropriate statistical technique? (a) A study in which the researcher has a complex theory of the pattern of cause and effect among several...

For each of the following situations, what would be the impact on the sandwich-making plan and total cost? If it is possible to compute the new cost or sandwich-making plan, do so. (a) The quantity...

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...

qsn no 3 and 4 EXERCISES 1. A 4-year financial project is forecast to have net cash inflows of $20,000 $25,000; $30,000; and $50,000 in the next 4 years. It will cost $75,000 to implement the...

Please answer questions 2 and 3. (please don't repost answers that have been posted before and please show the calculation . Thank you ! CASE 14.1 Nrnberg Augsburg Maschinenwerke (N.A.M.) The Nrnberg...

Case 14.1 - Nrnberg Augsburg Maschinenwerke please answer question 7 only *Be as detailed as possible and support your answer* CASE CASE 14.1 Nrnberg Augsburg Maschinenwerke (N.A.M.) The Nrnberg...

Case 14.1 - Nrnberg Augsburg Maschinenwerke NAM please answer 1,2,4 and 8 *Be as detailed as possible on question 8 please! thanks CASE CASE 14.1 Nrnberg Augsburg Maschinenwerke (N.A.M.) The Nrnberg...

a) Global Venture Sdn. Bhd. has received a few proposal that requesting them to run a project. Ammar is the project manager for this new project selection. In order to make decision, Ammar need to...

Please Answer Asap Thank you! A30. SUPPLEMENT A SPREADSHEET MODELING: AN INTRODUCTION Problems 1. Kaizer Plastic produces a variety of plastic items for pack Soek can work only with a single "Set...

Differentiate between mass percentage and parts per thousand.

Brad purchased 10 shares of stock for $10 per share. He paid a $5 commission. One year later, he purchased another 10 shares at $9 per share. Again, he paid a $5 commission. In the second year, his...

6. Types of Random Variables. Listed below is a series of experiments and associated random variables. In each case, identify the values that the random variable can assume and state whether the...

24.18 Airline flight delays. Here are the numbers of flights on time and delayed, for two airlines at four airports during a one-month period. Overall on-time percentages for each airline are often...

The following activities were listed during a brainstorming session on product development. Find the appropriate predecessor-successor relationships and then construct an AON network to reflect the...

Given the fact that a projects resource requirements are clearly spelled out in the projects action plan, why are PMs so concerned with resource allocation? LO6

Explain the difference between a project that has a fixed delivery day and one that has a fixed limit on resource usage. Why might a PM be interested in this LO6 difference?

Based on the above data for your company, which of the following statements is false? Your company's drone sales and market share were positively impacted by your company's well above-average...

Insert Page Layout Chin BIU Good Normal Conditional Formatas Calculation Formatting Table- Explanatory.. Input Merge & Center - Alignment A B D E F G H 1 What is the future value if $5000 is invested...

For each of the following transactions, propose a journal entry, and show T account. Assume each one occurred June 1, 2015. a. The company spent $200,000 to buy equipment b. The company bought a...