The board of directors of General Wheels Company is considering seven large capital Investments. Each Investment can be made only once. These Investments differ in the estimated long-run profit (net present value) that they will generate as well as in the amount of capital required, as shown by the following table. Investment Opportunity 1 2 3 4 56 7 Estimated Profit ($million) Capital Capital Required for 17 10 15 19 7 13 9 Investment Opportunity ($million) Capital Available 1 2 3 4 5 6 7 ($million) 28 34 48 17 32 23 43 Click here for the Excel Data File 80 The total amount of capital available for these Investments is $80 million. Investment opportunities 1 and 2 are mutually exclusive, and so are 3 and 4. Furthermore, neither 3 nor 4 can be undertaken unless one of the first two opportunities is undertaken. There are no such restrictions on Investment opportunities 5, 6, and 7. The objective is to select the combination of capital Investments that will maximize the total estimated long-run profit (net present value). Formulate and solve a BIP model on a spreadsheet for this problem. a. Determine the combination of capital Investments that will maximize profit. Note: Leave no cells blank. Enter "O" wherever required.

The board of directors of General Wheels Company is considering seven large capital Investments. Each Investment can be made only once. These Investments differ in the estimated long-run profit (net present value) that they will generate as well as in the amount of capital required, as shown by the following table. Investment Opportunity 1 2 3 4 56 7 Estimated Profit ($million) Capital Capital Required for 17 10 15 19 7 13 9 Investment Opportunity ($million) Capital Available 1 2 3 4 5 6 7 ($million) 28 34 48 17 32 23 43 Click here for the Excel Data File 80 The total amount of capital available for these Investments is $80 million. Investment opportunities 1 and 2 are mutually exclusive, and so are 3 and 4. Furthermore, neither 3 nor 4 can be undertaken unless one of the first two opportunities is undertaken. There are no such restrictions on Investment opportunities 5, 6, and 7. The objective is to select the combination of capital Investments that will maximize the total estimated long-run profit (net present value). Formulate and solve a BIP model on a spreadsheet for this problem. a. Determine the combination of capital Investments that will maximize profit. Note: Leave no cells blank. Enter "O" wherever required.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter3: Introduction To Optimization Modeling

Section: Chapter Questions

Problem 41P

See similar textbooks

Similar questions

This problem is based on Motorolas online method for choosing suppliers. Suppose Motorola solicits bids from five suppliers for eight products. The list price for each product and the quantity of each product that Motorola needs to purchase during the next year are listed in the file P06_93.xlsx. Each supplier has submitted the percentage discount it will offer on each product. These percentages are also listed in the file. For example, supplier 1 offers a 7% discount on product 1 and a 30% discount on product 2. The following considerations also apply: There is an administrative cost of 5000 associated with setting up a suppliers account. For example, if Motorola uses three suppliers, it incurs an administrative cost of 15,000. To ensure reliability, no supplier can supply more than 80% of Motorolas demand for any product. A supplier must supply an integer amount of each product it supplies. Develop a linear integer model to help Motorola minimize the sum of its purchase and administrative costs.
If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.
Solve Problem 1 with the extra assumption that the investments can be grouped naturally as follows: 14, 58, 912, 1316, and 1720. a. Find the optimal investments when at most one investment from each group can be selected. b. Find the optimal investments when at least one investment from each group must be selected. (If the budget isnt large enough to permit this, increase the budget to a larger value.)
Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the companys mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. The following data are available: If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog. If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives. If a customer last placed an order two catalogs ago, there is a 12% chance she will order from the next catalog she receives. If a customer last placed an order three catalogs ago, there is an 8% chance she will order from the next catalog she receives. If a customer last placed an order four catalogs ago, there is a 4% chance she will order from the next catalog she receives. If a customer last placed an order five catalogs ago, there is a 2% chance she will order from the next catalog she receives. It costs 2 to send a catalog, and the average profit per order is 30. Assume a customer has just placed an order. To maximize expected profit per customer, would Seas Beginning make more money canceling such a customer after six nonorders or four nonorders?