# Question

An automobile company produces cars in Los Angeles and Detroit and has a warehouse in Atlanta. The company supplies cars to customers in Houston and Tampa. The costs of shipping a car between various points are listed in the file S14_87.xlsx, where a blank means that a shipment is not allowed. Los Angeles can produce up to 1100 cars, and Detroit can produce up to 2900 cars. Houston must receive 2400 cars, and Tampa must receive 1500 cars.

a. Determine how to minimize the cost of meeting demands in Houston and Tampa.

b. Modify the answer to part a if shipments between Los Angeles and Detroit are not allowed.

c. Modify the answer to part a if shipments between Houston and Tampa are allowed at a cost of $5 per car.

a. Determine how to minimize the cost of meeting demands in Houston and Tampa.

b. Modify the answer to part a if shipments between Los Angeles and Detroit are not allowed.

c. Modify the answer to part a if shipments between Houston and Tampa are allowed at a cost of $5 per car.

## Answer to relevant Questions

An oil company produces oil from two wells. Well 1 can produce up to 150,000 barrels per day, and well 2 can produce up to 200,000 barrels per day. It is possible to ship oil directly from the wells to the company’s ...You are given the following means, standard deviations, and correlations for the annual return on three potential investments. The means are 0.12, 0.15, and 0.20. The standard deviations are 0.20, 0.30, and 0.40. The ...Each hour from 10 A.M. to 7 P.M., a bank receives checks and must process them. Its goal is to process all checks the same day they are received. The bank has 13 check processing machines, each of which can process up to 500 ...Use Excel’s functions (not @RISK) to generate 1000 random numbers from a normal distribution with mean 100 and standard deviation 10. Then freeze these random numbers.a. Calculate the mean and standard deviation of these ...Suppose you own an expensive car and purchase auto insurance. This insurance has a $1000 deductible, so that if you have an accident and the damage is less than $1000, you pay for it out of your pocket. However, if the ...Post your question

0