solve on LINGO (OR R) EX 3.6-1

USE LINGO TO FORMULATE THIS MODEL IN A COMPACT FORM .THEN USE LINGO SOLVER TO SOLVE THE MODEL.

products and then sells them to wholesalers within its half of the product 1 and $7 per unit of product 2 is incurred. ui country. The orders from wholesalers have already been received for the next 2 months (February and March), where the number of hof units requested are shown below. (The company is not obligated to completely fill these orders but will do so if it can without decreas- ing its profits.) Plant 2 Plant 1 March March February 4,900 5,100 6,300 5,400 4,200 6,000 the United States. Each of these plants produces the same two plant. When this happens, an extra shipping cost of $9 per unit of PROBLEMS his Product February 3,600 4,500 Each plant has 20 production days available in February and 23 production days available in March to produce and ship these prod- ucts. Inventories are depleted at the end of January, but each plant has enough inventory capacity to hold 1.000 units total of the two March. In either plant, the cost of holding inventory in this way is 2. $3 per unit of product and $4 per unit of product Each plant has the same two production processes, each of which can be used to produce either of the two products. The pro- duction cost per unit produced of each product is shown below for each process in each plant. Plant 1 Plant 2 Product Process 1 Process 2 Process 1 $62 $59 $61 $65 2 $78 $85 $89 $86 The production rate for each product (number of units produced per day devoted to that product) also is given for each process in each plant below. Plant 2 Process 2 1 2 110 130 3.6-1. The Philbrick Company has two plants on opposite sides of Process 2 Plant 1 Product Process 1 Process 2 Process 1 100 120 140 150 130 160 The net sales revenue (selling price minus normal shipping costs) the company receives when a plant sells the products to its own customers (the wholesalers in its half of the country) is $83 per unit of product 1 and $112 per unit of product 2. However, it also is possible (and occasionally desirable) for a plant to make a ship- ment to the other half of the country to help fill the sales of the other 90 CHAPTER 3 INTRODUCTION TO uct should be produced by each production process in each planting th during each month, as well as how much each plant should sell of each product in each month and how much each plant should ship of each product in each month to the other plant's customers. The objective is to determine which feasible plan would maximize the mont of eac distril Management now needs to determine how much of each prod- mach each total profit (total net sales revenue minus the sum of the produc- tion costs, inventory costs, and extra shipping costs). (a) Formulate a complete linear programming model in algebraic form that shows the individual constraints and decision vari- ables for this problem. C (b) Formulate this same model on an Excel spreadsheet instead. Then use the Excel Solver to solve the model. C (C) Use MPL to formulate this model in a compact form. Then use a MPL solver to solve the model. C (d) Use LINGO to formulate this model in a compact form. Then use the LINGO solver to solve the model. products and then sells them to wholesalers within its half of the product 1 and $7 per unit of product 2 is incurred. ui country. The orders from wholesalers have already been received for the next 2 months (February and March), where the number of hof units requested are shown below. (The company is not obligated to completely fill these orders but will do so if it can without decreas- ing its profits.) Plant 2 Plant 1 March March February 4,900 5,100 6,300 5,400 4,200 6,000 the United States. Each of these plants produces the same two plant. When this happens, an extra shipping cost of $9 per unit of PROBLEMS his Product February 3,600 4,500 Each plant has 20 production days available in February and 23 production days available in March to produce and ship these prod- ucts. Inventories are depleted at the end of January, but each plant has enough inventory capacity to hold 1.000 units total of the two March. In either plant, the cost of holding inventory in this way is 2. $3 per unit of product and $4 per unit of product Each plant has the same two production processes, each of which can be used to produce either of the two products. The pro- duction cost per unit produced of each product is shown below for each process in each plant. Plant 1 Plant 2 Product Process 1 Process 2 Process 1 $62 $59 $61 $65 2 $78 $85 $89 $86 The production rate for each product (number of units produced per day devoted to that product) also is given for each process in each plant below. Plant 2 Process 2 1 2 110 130 3.6-1. The Philbrick Company has two plants on opposite sides of Process 2 Plant 1 Product Process 1 Process 2 Process 1 100 120 140 150 130 160 The net sales revenue (selling price minus normal shipping costs) the company receives when a plant sells the products to its own customers (the wholesalers in its half of the country) is $83 per unit of product 1 and $112 per unit of product 2. However, it also is possible (and occasionally desirable) for a plant to make a ship- ment to the other half of the country to help fill the sales of the other 90 CHAPTER 3 INTRODUCTION TO uct should be produced by each production process in each planting th during each month, as well as how much each plant should sell of each product in each month and how much each plant should ship of each product in each month to the other plant's customers. The objective is to determine which feasible plan would maximize the mont of eac distril Management now needs to determine how much of each prod- mach each total profit (total net sales revenue minus the sum of the produc- tion costs, inventory costs, and extra shipping costs). (a) Formulate a complete linear programming model in algebraic form that shows the individual constraints and decision vari- ables for this problem. C (b) Formulate this same model on an Excel spreadsheet instead. Then use the Excel Solver to solve the model. C (C) Use MPL to formulate this model in a compact form. Then use a MPL solver to solve the model. C (d) Use LINGO to formulate this model in a compact form. Then use the LINGO solver to solve the model