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

Need help on commenting on the trade off points. I do notunderstand what the trade off points tell me. How do trade offpoints using the goal seek function within a sensitivity table help me

\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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

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

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!