Question: Please solve ASAP. Solve using solver on excel A transportation company contracts with farmers In Nebraska, Kansas, Illinols, and M Issourl for monthly wheat shipments.
Please solve ASAP. Solve using solver on excel
A transportation company contracts with farmers In Nebraska, Kansas, Illinols, and M Issourl for monthly wheat shipments. They plck up wheats at the farms and shlp mostly by truck (and sometimes by rall) to Its sorting and distrlbution centers in Maryland, New Mexlco, and Kentucky. At these centers the wheat Is cleaned, rejects are discarded, and the rest is sorted according to quality. They are then shipped to combination plants and distrlbution centers inNew Hampsire, lowa, Florlda, and Arizona, where the company produces a varlety of wheat product and dlstrlbutes them to stores. Exceptions are the Maryland distribution center, which will accept wheat only from farms in Nebraska, Kansas, and Missourl, In addition, New Hampshire plant does not accept shipments from New Mexlco, lowa does not accept shipments from Maryland, and Florida does not accept shipments from Kentucky. Following are summaries of the shipping costs from the farms to the distribution centers and the processing and shipping costs from the distribution centers to the plants, as well as the avallable monthly supply at each farm, the processing capacity at the distribution centers, and the final demand at the plants (In bushels); Formulate and solve a liner optimization model to determine the optimal monthly shipments from the farms to the distribution centers and from the distribution centers to the plants to minimize the total shipping and processing costs. A transportation company contracts with farmers In Nebraska, Kansas, Illinols, and M Issourl for monthly wheat shipments. They plck up wheats at the farms and shlp mostly by truck (and sometimes by rall) to Its sorting and distrlbution centers in Maryland, New Mexlco, and Kentucky. At these centers the wheat Is cleaned, rejects are discarded, and the rest is sorted according to quality. They are then shipped to combination plants and distrlbution centers inNew Hampsire, lowa, Florlda, and Arizona, where the company produces a varlety of wheat product and dlstrlbutes them to stores. Exceptions are the Maryland distribution center, which will accept wheat only from farms in Nebraska, Kansas, and Missourl, In addition, New Hampshire plant does not accept shipments from New Mexlco, lowa does not accept shipments from Maryland, and Florida does not accept shipments from Kentucky. Following are summaries of the shipping costs from the farms to the distribution centers and the processing and shipping costs from the distribution centers to the plants, as well as the avallable monthly supply at each farm, the processing capacity at the distribution centers, and the final demand at the plants (In bushels); Formulate and solve a liner optimization model to determine the optimal monthly shipments from the farms to the distribution centers and from the distribution centers to the plants to minimize the total shipping and processing costs
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
