Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help on commenting on the trade off points. I do not understand what the trade off points tell me. How do trade off points

Need help on commenting on the trade off points. I do not understand what the trade off points tell me.

How do trade off points using the goal seek function within a sensitivity table help me make a decision?

Current vs Houston .35

Current vs Mexico .23

Houston vs Mexico .51

image text in transcribedimage text in transcribedimage text in transcribed
\fStates of Nature Unfavorable Alternatives Decision Favorable Market Market Current Plant 10,955,986 560,301 New Plant in Houston 30,981,793 (10,334,181) New Plant in Mexico 24,313,553 (3,329,126) Outsource to China 13,822,832 9,265,912 Sensitivity Table New Plant in New Plant in Outsource to Current vs. New Current vs New P(Favorable) Current Plant Houston Mexico China Houston Mexico Plant 560,301 (10,334,181) 3,329,126) $ 9,265,912 10,894,482 $ 3,889,427 0.1 1,599,870 (6,202,584) (564,858) $ 9,721,604 7,802,453 2,164,728 0.2 2,639,438 (2,070,986) 2,199,410 10,177,296 4,710,424 440,028 0.3 3,679,007 2,060,611 4,963,678 $ 10,632,988 1,618,395 (1,284,671) 0.4 $ 4,718,575 6,192,208 7,727,946 11,088,680 (1,473,633) (3,009,371) 0.5 5,758,144 10,323,806 10,492,214 11,544,372 (4,565,662) (4,734,070) 0.6 $ 6,797,712 14,455,403 13,256,481 12,000,064 (7,657,691) (6,458,769) 0.7 7,837,281 18,587,001 16,020,749 12,455,756 (10,749,720) (8,183,469) 8,876,849 22,718,598 18,785,017 12,911,448 (13,841,749) $ (9,908,168) 0.9 9,916,418 26,850,195 21,549,285 13,367,140 (16,933,778) $ (11,632,868) 10,955,986 30,981,793 24,313,553 13,822,832 (20,025,807) $ (13,357,567) 0.35234089 4,223,126 4,223,126 6,410,520 10,871,501 0.225513326 2,904,666.50 (1,016,878.39) $ 2,904,666 10,293,558 $ 0.512316546 $ 5,886,182.43 $ 10,832,675.89 10,832,676 $ 11,600,498

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Marketing

Authors: Philip R Cateora, John Graham, Mary Gilly

18th Edition

1260547876, 9781260547870

More Books

Students also viewed these Economics questions