Reference no: EM13245795
Complete the Technical Problems 1-5 using the Solver add-in for Microsoft Excel at the end of the Online Topic 2 Student Workbook. Submit your work using Microsoft Excel. 1. Solve the following linear programming problem graphically: maximize (pie symbol)=2X1 + 3X2 subject to X1 = 8 X2 =6 X1 +2X2 = 16 X1, X2 = 0 2. In problem 1, how would the optimal solution change if the restrictions imposed (i.e., the ri's) were all cut in half? 3. Solve the following linear programming problem using the general solution method: minimize C= 3X1+ 4X2 subject to X1+X2 = 2 2X1 + 4X2 = 5 X1, X2 = 0 4. Form the dual to the linear programming problem presented in problem 3; then solve it to obtain the optimal value of C. Does the minimum value of C for the primal in Problem 3 equal the maximum value of C in the dual for this problem? 5. The advertising manager at Cadillac wishes to run both television and magazine ads to promote the new Cadillac GTS in the greater Chicago area market. Each 30-second television ad will reach 30,000 viewers in the target age group of buyers 35 to 55 years old. Running one full page ad in Cool Driver magazine will reach 10,000 readers in the 35 to 55 year-old target market. To further promote the new GTS, the manager wishes to stimulate prospective buyers to come in to Chicago area dealerships to test drive the GTS. Past experience in Chicago indicates that a television ad will generate 500 test drives, while a magazine ad will generate only 250 test drives. In order to reach the desired level of new-model penetration in the Chicago area, the advertising manager believes it is necessary to reach at least 90,000 potential buyers in the 35 to 55 age bracket and to get at least 2,000 of these potential buyers to take a test drive. Each 30- second TV ad costs $100,000 and each magazine ad costs $40,000. In reaching these objectives, the manager wishes to minimize the total expenditure on TV and magazine ads.
a. State the linear programming problem facing this advertising manager. Be sure to formulate the objective function and inequality constraints (including appropriate non-negativity constraints).
b. Solve the linear programming problem. What is the optimal number of TV ads and magazine ads? What will be the minimum possible level of total expenditures on television and magazine ads necessary to successfully promote the GTS in Chicago?
c. Suppose the local television stations, in order to reduce set-up costs, require Cadillac to run its ad two or more times. How would this constraint alter the solution to this linear programming problem?
|
What would happen to total expenditures if tax frozen
: In particular, the number of workers is rising slowly, while the number of retirees is rising quickly. Concerned about the future of Social Security, some members of Congress propose a "freeze" on the program.
|
|
Whats wrong with this way of thinking
: What's wrong with this way of thinking? "When the government runs a budget deficit, it simply pays its bills by printing more money
|
|
Compute the equilibrium concentration of each ion
: Lead(II) phosphate, Pb3(PO4)2 (s), is allowed to come to equilibrium with its ions in otherwise pure water. Ksp = 3.0 x 10?44. Calculate the equilibrium concentration of each ion.
|
|
Research authoritative articles using the news and the
: Research authoritative articles using the news and the DeVry Online Library (http://library.devry.edu) for a recent case of antitrust investigation.
|
|
What is the optimal number of tv ads and magazine ads
: What is the optimal number of TV ads and magazine ads What will be the minimum possible level of total expenditures on television and magazine ads necessary to successfully promote the GTS in Chicago
|
|
Relative to the npv if it proceeds today
: Assuming that all cash flows are discounted at 10%, if NPC chooses to wait a year before proceeding, how much will this increase or decrease the project's expected NPV in today's dollars (i.e., at t = 0), relative to the NPV if it proceeds today?
|
|
What is the resistance at 20 degrees c
: A copper wire with a cross sectional area of 3.00 mm^2 and a length of 2.00 m at 20.0 degrees C is connected to a 25.0 V battery, what is the resistance at 20.0 degrees C
|
|
The equation with phase changes for an electrochemical cell
: Write a balanced equation with phase changes for an electrochemical cell that has a copper cathode immersed in a solution of cu+2 ions and a lead anode immersed in a solution of Pb+2 ions
|
|
Explain the molecular mass of nh3
: A solution of NH3 was prepared by diluting 8.29 mL of 27.62 wt% NH3 [density=0.89 g/mL] up to 564.0 mL. The molecular mass of NH3 is 17.0305 g/mol. Find the concentration of NH3 in M.
|