Case 2: A marketing research professor is conducting a telephone survey and needs to contact at least 160 wives, 140 husbands, 110 single adult males, and 120 single adult females. It costs $2 to make a daytime call and $4 (because of higher labor costs) to make an evening call. The table shown below lists the expected results. For example, 10% of all daytime calls are answered by a single male, and 15% of all evening calls are answered by a single female. Because of a limited staff, at most half of all phone calls can be evening calls. Determine how to minimize the cost of completing the survey. Percentages Daytime Evening Wife 25% 25% Husband 15% 30% Single male 10% 25% Single female 15% 15% None 35% 5% Develop a Report for the following using the Solver application on Excel 1) State the decision variables and constraints in this problem. 2) What is the objective function in this problem? 3) Find the optimal solution. State the call plan and total cost.

Case 2: A marketing research professor is conducting a telephone survey and needs to contact at least 160 wives, 140 husbands, 110 single adult males, and 120 single adult females. It costs $2 to make a daytime call and $4 (because of higher labor costs) to make an evening call. The table shown below lists the expected results. For example, 10% of all daytime calls are answered by a single male, and 15% of all evening calls are answered by a single female. Because of a limited staff, at most half of all phone calls can be evening calls. Determine how to minimize the cost of completing the survey. Percentages Daytime Evening Wife 25% 25% Husband 15% 30% Single male 10% 25% Single female 15% 15% None 35% 5% Develop a Report for the following using the Solver application on Excel 1) State the decision variables and constraints in this problem. 2) What is the objective function in this problem? 3) Find the optimal solution. State the call plan and total cost.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter6: Optimization Models With Integer Variables

Section: Chapter Questions

Problem 61P

See similar textbooks

Similar questions

Case 2: A marketing research professor is conducting a telephone survey and needs to contact atleast 160 wives, 140 husbands, 110 single adult males, and 120 single adult females. It costs $2 tomake a daytime call and $4 (because of higher labor costs) to make an evening call. The table shownbelow lists the expected results. For example, 10% of all daytime calls are answered by a single male,and 15% of all evening calls are answered by a single female. Because of a limited staff, at most halfof all phone calls can be evening calls. Determine how to minimize the cost of completing thesurvey. Percentages Daytime Evening Wife 25% 25% Husband 15% 30% Single male 10% 25% Single female 15% 15% None 35% 5% Develop a Report for the following1) State the decision variables and constraints in this problem. 2) What is the objective function in this problem?…
Case 2: A marketing research professor is conducting a telephone survey and needs to contact atleast 160 wives, 140 husbands, 110 single adult males, and 120 single adult females. It costs $2 tomake a daytime call and $4 (because of higher labor costs) to make an evening call. The table shownbelow lists the expected results. For example, 10% of all daytime calls are answered by a single male,and 15% of all evening calls are answered by a single female. Because of a limited staff, at most halfof all phone calls can be evening calls. Determine how to minimize the cost of completing thesurvey. Percentages Daytime Evening Wife 25% 25% Husband 15% 30% Single male 10% 25% Single female 15% 15% None 35% 5% Develop a Report for the following using the Solver application in Excel 4) Obtain a sensitivity report for the reported solution. Which constraints…
The Pine Valley Board of Education must hire teachers for the coming school year. The types of teachersand the salaries that must be paid are as follows:Teacher can teach Number applying Annual salaryHistory, science 20 $21, 000History, math 15 $22, 000English, science 12 $23, 000English, math 14 $24, 000English, history 13 $25, 000Science, math 12 $26, 000For example, 20 teachers who are qualified to teach history and science have applied for jobs, and eachof these teachers must be paid an annual salary of $21, 000. Each teacher who is hired teaches the twosubjects he or she is qualified to teach. Pine Valley needs to hire 35 teachers qualified to teach history,30 teachers qualified to teach science, 40 teachers qualified to teach math, and 32 teachers qualified toteach English. The board has $1.4 million to spend on teachers’ salaries. A penalty cost of $1 is incurredfor each dollar the board goes over budget. For each teacher by which Pine Valley’s goals are unmet,the following…
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 5 6 7 Estimated Profit ($million) 17 10 15 19 7 13 9 Capital Required for Investment Opportunity ($million) Capital Available ($million) 1 2 3 4 5 6 7 Capital 43 28 34 48 17 32 23 100 The total amount of capital available for these investments is $100 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…
An Insurance Company is introducing two new product lines: special risk insuranceand mortgages. The expected profit is $5 per unit on special risk insurance and $2 per unit onmortgages. Management wishes to establish sales quotas for the new product lines tomaximize total expected profit. Please see figure for work requirements. The sensitivity report for this optimization problem is given in the following figure 1 - Can you determine the optimal value (maximum expected profit) based on the sensitivityreport? 2 - Identify the non-binding constraint(s).
A garden store prepares various grades of pine bark for mulch: nuggets (x1), mini-nuggets (x2), and chips (x3). The process requires pine bark, machine time, labor time, and storage space. The following model has been developed. Maximize 9x1 + 9x2+ 6x3 (profit) Subject to Bark 5x1 + 6x2 + 3x3 ≤ 600 pounds Machine 2x1 + 4x2 + 5x3 ≤ 600 minutes Labor 2x1 + 4x2 + 3x3 ≤ 480 hours Storage 1x1 + 1x2 + 1x3 ≤ 150 bags x1, x2, x3 ≥ 0 a-1. What is the marginal value of a pound of pine bark? a-2. Over what range is this price value appropriate? b. What is the maximum price the store would be justified in paying for additional pine bark? c-1. What is the marginal value of labor? c-2. Over what range is this value in effect? d. If the manager could add an additional 60 minutes of labor, should she? Yes or No e. If the manager can obtain either additional pine bark or additional storage space, which one should she choose and how much (assuming additional…
The Shop at Home Network sells various household goods during live television broadcasts. The company owns several warehouses to hold many of the goods it sells but also leases extra warehouse space when needed. During the next five months, the company expects it will need to lease the following amounts of extra warehouse space: Month 1 2 3 4 5 Square Feet Needed 20,000 30,000 40,000 35,000 50,000 At the beginning of any month, the company can lease extra space for one or more months at the following costs: Lease term (months) 1 2 3 4 5 Cost per Sq. Ft. Leased $55 $95 $130 $155 $185 So, for instance, at the start of month 1 the company can lease as much space as it wants for four months at a cost of $155 per square foot. Similarly, at the start of month 3, the company can lease any amount of space for two months at a cost of $95 per square foot. The company wants to determine the least costly way of meeting its…
Case Problem: Textbook Publishing ASW Publishing, Inc., a small publisher of college textbooks, must make a decision regarding which books to publish next year. The books under consideration are listed in the following table, along with the projected threeyear sales expected from each book. Book Subject Type of Book Projected Sales (000s) Business calculus New 20 Finite mathematics Revision 30 General statistics New 15 Mathematical statistics New 10 Business statistics Revision 25 Finance New 18 Financial accounting New 25 Managerial accounting Revision 50 English…
You have a new job as a Financial Planning assistant. Your client wants to invest money in stocks, bonds, and treasuries that have the dividend yields shown in the table below. Your job is to allocate their money across these three investments such that the total dollars of stocks is at least $10,000 more than the total dollars in bonds plus treasuries. In addition, they have identified the maximum investment in each of those three investment types (also shown below). Maximize the dividends earned. Your answer will be the total Dividends earned (rounded to whole dollars). Scenario 3 Stocks: yield % 1.14 Bonds: yield % 3.03 Treasuries: yield % 2.08 Stocks: $ max 410,000 Bonds: $ max 300,000 Treasuries: $ max 300,000
Your employer is trying to select from a list of possible capital projects. The projects, along with their cost and benefits, are listed below. The capital budget available is $1 million. In addition to spending constraints, your employer would like to select at least 3 projects. Projects 2 and 5 cannot both be selected together. Formulate the problem as a linear program and determine the optimal solution. Project Cost Net Present Value 1 $225,000 $770,000 2 $200,000 $580,000 3 $235,000 $400,000 4 $275,000 $630,000 5 $275,000 $720,000 Which projects should be selected? What is the total net present value of these projects
Problem There are three factories on the Momiss River. Each emits two types of pollutants, labeled P1 and P2, into the river. If the waste from each factory is processed, the pollution in the river can be reduced. It costs $1500 to process a ton of factory 1 waste, and each ton processed reduces the amount of P1 by 0.10 ton and the amount of P2 by 0.45 ton. It costs $1000 to process a ton of factory 2 waste, and each ton processed reduces the amount of P1 by 0.20 ton and the amount of P2 by 0.25 ton. It costs $2000 to process a ton of factory 3 waste, and each ton processed reduces the amount of P1 by 0.40 ton and the amount of P2 by 0.30 ton. The state wants to reduce the amount of P 1in the river by at least 30 tons and the amount of P2 by at least 40 tons. Use Solver to determine how to minimize the cost of reducing pollution by the desired amounts. Use SolverTable to investigate the effects of increases in the minimal reductions required by the state. Specifically, see what…
The Skimmer Boat Company manufactures three kinds of molded fiberglass recreational boatsa bass fishing boat, a ski boat, and a speedboat. The profit for a bass boat is $20,500, the profit for a ski boat is $12,000, and the profit for a speedboat is $22,300. The company believes it will sell more bass boats than the other two boats combined but no more than twice as many. The ski boat is its standard production model, and bass boats and speedboats are modifications. The company has production capacity to manufacture 210 standard (ski-type) boats; however, a bass boat requires 1.3 times the standard production capacity, and a speedboat requires 1.5 times the normal production capacity. In addition, only 160 of the high-powered engines that are installed in the bass boats and 2 of those installed in the speedboats are available. The company wants to know how many boats of each type to produce to maximize profit. Formulate and solve an integer programming model for this problem.