course name: operation research
solve : A , B and D: write cplex code plz
solve A and B and D i want cplex code writing
9.6-5. The Makonsel Company is a fully integrated company that both produecs goods and sells them at its retail outlets. After production, the goods are stored in the company's two warehouses until needed by the retail outlets. Trucks are used to transport the goods from the rwo plants to the warehouses, and then from the warehouses to the three retail outlets. Using units of full truckloads, the following table shows each plant's monthly output, its shipping cost per truckload sent to each warehouse, and the maximum amount that it can ship per month to each warchouse. For each retail cutlet (RO), the next table shows its monthly demand, its shipping cost per truckload from each warehouse, and the maximum amount that can be shipped per month from each warehouse. For exch retail cutlet (RO), the next table shows its monthly demand, its shipping cost per trueklead from each warehouse, and the maximum amount that can be shipped per month from each warehouse. Management now wants to determine a disfibuion plan (number of truckloads shipped per month from eishi. plant to each warehouse and from cach warehouse to each retail hullet) that will minimize the total slipping cost. (a) Dray a network that depicts the company's distribution network. Idenrify the supply nodes, transshipment nodes, and denaad nodes in this network. (b) Fermulate, this problem as a minimurn cost flow problem by inserting th the neciessary dita into this network. (c) Formulate and solve a spreadsheet model for this problem. C (d) Use the computer to solve this problem without using Excel. 9.6-5. The Makonsel Company is a fully integrated compuny that both produces goods and sells them at its retail outlets. Afier production, the goods are stored in the company's two warehouses until needed by the retail outlets. Trucks are used to transpon the goods from the two plants to the warchouses, and then from the warehouses to the three retail outlets. Using units of full truckloads, the following table sbows each plant's monthly output, its shipping cost per truckloed sent to each warehouse, and the maximum amount that it can ship per moeth to each warehouse. For cach retail outlet (RO), the next table shows its monihly demand, its shipping cost per truckload from cach warchouse, and the maximum amount that can be shipped per month froen each warehouse Management now wants to determine a distribution plan (mumber of truckloads shipped per month trom each plant to cach warehouse and from each warehouse to each retail outlet) that will misimire the total shipping cost. (a) Draw a network that depicts the company's distribution network. Identify the supply nodes, transhipment nodes, and demand nodes in this network: (b) Formulate this problem as a minimum cost flow problem by inserting all the necessary data into this network: C (c) Formulate and solve a spreadshect model for this problem. C (d) Use the computer to solve this problem without using Excel
