# Question

The Makonsel Company is a fully integrated company that both produces 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 two 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 warehouse.

For each retail outlet (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.

Management now wants to determine a distribution plan (number of truckloads shipped per month from each plant to each warehouse and from each warehouse to each retail outlet) that will minimize the total shipping cost.

(a) Draw a network that depicts the company’s distribution network. Identify the supply nodes, transshipment 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) Formulate and solve a spreadsheet model for this problem.

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 warehouse.

For each retail outlet (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.

Management now wants to determine a distribution plan (number of truckloads shipped per month from each plant to each warehouse and from each warehouse to each retail outlet) that will minimize the total shipping cost.

(a) Draw a network that depicts the company’s distribution network. Identify the supply nodes, transshipment 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) Formulate and solve a spreadsheet model for this problem.

## Answer to relevant Questions

The Audiofile Company produces boomboxes. However, management has decided to subcontract out the production of the speakers needed for the boomboxes. Three vendors are available to supply the speakers. Their price for each ...For the P & T Co. transportation problem given in Table 9.2, consider its network representation as a minimum cost flow problem presented in Fig. 9.2. Use the northwest corner rule to obtain an initial BF solution from Table ...The 21st Century Studios is about to begin the production of its most important (and most expensive) movie of the year. The movie’s producer, Dusty Hoffmer, has decided to use PERT/CPM to help plan and control this key ...The Quick Company has learned that a competitor is planning to come out with a new kind of product with a great sales potential. Quick has been working on a similar product that had been scheduled to come to market in 20 ...Consider the following nonlinear programming problem. Maximize Z = x31 + 4x22 + 16x3, Subject to x1 x2 x3 =4 and x1 ≥ 1, x2 ≥ 1, x3 ≥ 1. (a) Solve by dynamic programming when, in addition to the given constraints, all ...Post your question

0