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



\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
Get step-by-step solutions from verified subject matter experts
