https://courseworkassignment.com/wp-content/uploads/2021/07/LOGO-300x75.png 0 0 Dennis https://courseworkassignment.com/wp-content/uploads/2021/07/LOGO-300x75.png Dennis2021-08-04 10:12:172021-08-04 10:12:17Linear programming with excel and math skills Number 2
Linear programming with excel and math skills Number 2
Use Solver to set up and solve problem No. 32, page 125 of your textbook. Make sure to embed your formulation to the Linear Programming problem within your Excel solution. This problem is a classic transportation problem application where locations 1 and 2 serve as the â€œsupply nodesâ€, and locations 3, 4, 5 and 6 serve as the â€œdemand nodesâ€. In addition to the typical supply and demand constraints that you need to include, make sure to also account for the constraints which will ensure that locations 3, 4, 5, and 6 each receive at least 5 cars.