transportation

how to solve in excel !?

Part Four: 25 marks Red Stone is a factory located in Orlando, Colorado and Ohio. These are shipped to regional distribution centers in New York and New Jersey, where they are delivered to the supply houses in Texas, Tennessee, and Arizona. The available supplies at the factories, the demands at the final destination, and shipping costs are shown in Table 1. Notice that Red Stone may not be shipped directly from Bahrain, Kuwait and Oman to any of the final destinations but must first go to either Damam, Riyadh or Jeddah. Red Stone would like to minimize the transportation costs associated with shipping sufficient Red Stone to meet the demands at the four destinations while not exceeding the supply at each factory. The shipping cost per unit from each of the sources to each of the destinations is shown in the following table: Orlando Colorado Ohio New York Texas Tennessee Anne 213 100 400 New Jersey 112 230 340 Orlando Colorado Ohio New York New Jersey Texas Tennessee Arizona 340 430 330 230 380 410 The following table present information on the supply and demand in cach factory and destination points. Demand side New York Texas Tennessee Arizona 1000 1600 3200 2300 Demand amount Supply side Supply amount Orlando Ohio Colorado 2800 4300 3000 How many units should be shipped from each suppling point to each of destination if cost is to be minimized? What is the total cost? Consider the following 1. 1000 units should be shipped to New York 2. Units can be shipped from Orlando and Ohio to the three destination through the transmission point of New York and New Jersey 3. Units can be shipped from Colorado to the three destination through the transmission point of only New Jersey 4- Units can be shipped from the transmission point of New York to Texas, Tennessee only 5. Units can be shipped from the transmission point of New York to Texas, Tennessee only Part Four: 25 marks Red Stone is a factory located in Orlando, Colorado and Ohio. These are shipped to regional distribution centers in New York and New Jersey, where they are delivered to the supply houses in Texas, Tennessee, and Arizona. The available supplies at the factories, the demands at the final destination, and shipping costs are shown in Table 1. Notice that Red Stone may not be shipped directly from Bahrain, Kuwait and Oman to any of the final destinations but must first go to either Damam, Riyadh or Jeddah. Red Stone would like to minimize the transportation costs associated with shipping sufficient Red Stone to meet the demands at the four destinations while not exceeding the supply at each factory. The shipping cost per unit from each of the sources to each of the destinations is shown in the following table: Orlando Colorado Ohio New York Texas Tennessee Anne 213 100 400 New Jersey 112 230 340 Orlando Colorado Ohio New York New Jersey Texas Tennessee Arizona 340 430 330 230 380 410 The following table present information on the supply and demand in cach factory and destination points. Demand side New York Texas Tennessee Arizona 1000 1600 3200 2300 Demand amount Supply side Supply amount Orlando Ohio Colorado 2800 4300 3000 How many units should be shipped from each suppling point to each of destination if cost is to be minimized? What is the total cost? Consider the following 1. 1000 units should be shipped to New York 2. Units can be shipped from Orlando and Ohio to the three destination through the transmission point of New York and New Jersey 3. Units can be shipped from Colorado to the three destination through the transmission point of only New Jersey 4- Units can be shipped from the transmission point of New York to Texas, Tennessee only 5. Units can be shipped from the transmission point of New York to Texas, Tennessee only