Question

In: Operations Management

Transportation Homework Cost Table NY Boston LA Fl Japan 20 22 10 16 China 25 26...

Transportation Homework
Cost Table NY Boston LA Fl
Japan 20 22 10 16
China 25 26 12 14
Malysia 18 20 14 13
Philipines 22 19 8 14
India 24 11 20 16
Part(a) Submit an excel sheet (with solver) showing the min cost to send the 2500 units
Supply Demand
Japan 300 NY 520
China 500 Boston 630
Malysia 700 LA 740 TD
Philipines 600 TS Fl 850 2740
India 400 2500
Part(b) Submit an excel sheet (with solver) showing the min cost to send the 2500 units
Supply Demand
Japan 300 NY 370
China 500 Boston 530
Malysia 700 LA 440 TD
Philipines 600 TS Fl 850 2190
India 400 2500

Transportation HW

Given the COST TABLE in the excel file – solve the transportation problem TWO times.

Once with TS > TD and again with TS < TD

TS > TD should be in ONE worksheet

TS < TD should be in another worksheet

Solutions

Expert Solution

a)

b)


Related Solutions

Resident Commuter 22 25 27 23 26 28 26 24 18 20 19 18 22 25...
Resident Commuter 22 25 27 23 26 28 26 24 18 20 19 18 22 25 24 35 25 20 26 24 27 26 18 19 23 18 23 22 28 25 20 24 18 30 26 18 18 19 32 23 26 30 22 22 22 21 18 20 19 19 18 29 19 22 18 22 19 26 35 19 19 18 19 32 26 19 19 21 23 18 20 18 29 23 21 19 36 27...
Consider a sample with data values of 26, 25, 22, 16, 32, 33, 29, and 25....
Consider a sample with data values of 26, 25, 22, 16, 32, 33, 29, and 25. Compute the 20th, 25th, 65th, and 75th percentiles (to 1 decimal, if decimals are necessary).
Price: $25 $18 $20 $20 $30 $22 $26 What is the mean price for an adult...
Price: $25 $18 $20 $20 $30 $22 $26 What is the mean price for an adult haircut? What is the median price for an adult haircuit? What is the mode price for an adult haircut? Compute the 60th percentile. What does this value mean? Compute the second quartile. What does this value mean? What is the variance for the prices? What is the standard deviation?
PSY 312 Power Analysis Homework       h2     .02   .04 .06 .09 .12 .16   .20   .25   .30  ...
PSY 312 Power Analysis Homework       h2     .02   .04 .06 .09 .12 .16   .20   .25   .30   .36   .42   .49 power .30     93    53    34   24   18   14    11     9     8     7     6     5 .40      132    74    47   33   24   19    15    12    10     8     7     6 .50      170    95    60   42   30   23    18    14    12     9     8     7 .60      257 143    90   62   45   34    24    20    16    13    11     9 .70      300 167 105   72   52   39   ...
Day 9-10 Homework ± The Arrhenius Equation 20 of 23 Review | Constants | Periodic Table...
Day 9-10 Homework ± The Arrhenius Equation 20 of 23 Review | Constants | Periodic Table The Arrhenius equation shows the relationship between the rate constant kkk and the temperature TTT in kelvins and is typically written as k=Ae−Ea/RTk=Ae−Ea/RT where RRR is the gas constant (8.314 J/mol⋅K8.314 J/mol⋅K), AAA is a constant called the frequency factor, and EaEaE_ a is the activation energy for the reaction. However, a more practical form of this equation is lnk2k1=EaR(1T1−1T2)ln⁡k2k1=EaR(1T1−1T2) which is mathmatically equivalent...
Calculate the pH after addition of 0, 10, 20, 24, 24.90, 25, 25.10, 26, and 30...
Calculate the pH after addition of 0, 10, 20, 24, 24.90, 25, 25.10, 26, and 30 mL of 0.01 M NaOH in the titration of 50 mL of 0.005 M weak monoportic acid HA. Ka of the acid is = 1.00 x 10^-6 Kw= 1.00 x 10^-14 at 25 degrees Celsius
[25/10, 20:26] Atna Koh: Interest rates can be expressed in real or nominal terms. Which of...
[25/10, 20:26] Atna Koh: Interest rates can be expressed in real or nominal terms. Which of the following is most correct? [25/10, 20:26] Atna Koh: Select one: a. Market rates are always expressed in real terms, because it is important that inflation be included in financial assessment. b. Real interest rates can be accurately calculated as the difference between nominal rates and the inflation rate. c. Because market rates are usually in nominal terms, cash flows will usually be in...
The table below shows the one-year return distribution of Startup Inc. Probability 25% 20% 20% 10%...
The table below shows the one-year return distribution of Startup Inc. Probability 25% 20% 20% 10% ?% Return -60% -75% -50% -25% 1000% a. Calculate the expected return. b. Calculate the standard deviation of the return. c. Replace the expected return of 1000% in the last column in the table above with the expected return value that minimizes the standard deviation of the returns. a. The expected return is %. (round to one decimal) b. The standard deviation of the...
old by years Interval Frequency 35-37 two 32-34 three 29-31 five 26-28 Six 23-25 four 20-22...
old by years Interval Frequency 35-37 two 32-34 three 29-31 five 26-28 Six 23-25 four 20-22 five 17-19 nine 14-16 Sixteen Calculate the above when Passport first used 1- what is the shape of the old distribution? 2- Which accurate statements can describe the relationship between the mean and median old? he mean and median are the same The mean is bigger than the median The mean is less than the median 3- Calculate percentile rank corresponding to the old...
Table 10-4 Quantity Private Value Private Cost External Cost 1 $40 $20 $7 2 $38 $23...
Table 10-4 Quantity Private Value Private Cost External Cost 1 $40 $20 $7 2 $38 $23 $7 3 $36 $26 $7 4 $34 $29 $7 5 $32 $32 $7 6 $28 $35 $7 Refer to Table 10-4. Take into account private and external costs and assume the quantity of output is always a whole number (that is, fractional units of output are not possible). The maximum total surplus that can be achieved in this market is Group of answer choices...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT