Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
the Solver Parameter dialog box, the formula that must be written in the cell for the objective function value, and the cells where this formula should be copied. The results are shown in the spreadsheet. This solution is B D E F G H. 1 Win Big Gambling Club Radio 1 min. 2 Radio TV Newapaper 30 sec. 4 Variables X1 X2 X3 X4 5 Solution 6 Audience per ad 1.9688 6.2069 Total Audiance 5000 8500 2400 2800 67240.3017 8 Constraints LHS RHS 9 Max. TV 1. 1.9688 < 12 10 Маx. Newspарer 1 5 11 Max. 30-sec. radio 1 6.2069 < 25 12 Max. 1 min. radio 13 Cost 14 Radio dollars 15 Radio spots 20 8000 1800 1 800 925 290 380 8000 < 290 380 1800 < 1. 6.2069 > SOLVER PARAMETER INPUTS AND SELECTIONS KEY FORMULAS Set Objective: F6 Total Audience By Changing cells: B5:E5 6 =SUMPRODUCT($B$5:SE$5,86:E6) To: Max Copy F6 to F9:F15 Subject to the Constraints: F9:F14 <= H9:H14 F15 >= H15 Solving Method: Simplex LP

the Solver Parameter dialog box, the formula that must be written in the cell for the objective function value, and the cells where this formula should be copied. The results are shown in the spreadsheet. This solution is B D E F G H. 1 Win Big Gambling Club Radio 1 min. 2 Radio TV Newapaper 30 sec. 4 Variables X1 X2 X3 X4 5 Solution 6 Audience per ad 1.9688 6.2069 Total Audiance 5000 8500 2400 2800 67240.3017 8 Constraints LHS RHS 9 Max. TV 1. 1.9688 < 12 10 Маx. Newspарer 1 5 11 Max. 30-sec. radio 1 6.2069 < 25 12 Max. 1 min. radio 13 Cost 14 Radio dollars 15 Radio spots 20 8000 1800 1 800 925 290 380 8000 < 290 380 1800 < 1. 6.2069 > SOLVER PARAMETER INPUTS AND SELECTIONS KEY FORMULAS Set Objective: F6 Total Audience By Changing cells: B5:E5 6 =SUMPRODUCT($B$5:SE$5,86:E6) To: Max Copy F6 to F9:F15 Subject to the Constraints: F9:F14 <= H9:H14 F15 >= H15 Solving Method: Simplex LP

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Just problem 2 please. I have attached the example given. 

the Solver Parameter dialog box, the formula that must be written in the cell for the objective function value, and the cells where this formula should be copied. The results are shown in the spreadsheet. This solution is C E H. 1 Win Big Gambling Club Radio Radio TV Newspaper 30 sec. 1 min. 4 Variables X1 X2 X3 X4 5 Solution 1.9688 6.2069 Total Audience 6 Audience per ad 5000 8500 2400 2800 67240.3017 8 Constraints LHS RHS 9 Max. TV 1 1.9688 < 12 10 Max. Newspaper 1 5 < 11 Max. 30-sec. radio 1 6.2069 < 25 12 Max. 1 min. radio 1 20 13 Cost 800 925 290 380 8000 < 8000 1800 < 1800 14 Radio dollars 15 Radio spots 290 380 1 6.2069 > 5 SOLVER PARAMETER INPUTS AND SELECTIONS KEY FORMULAS Set Objective: F6 Total Audience By Changing cells: B5:E5 6 =SUMPRODUCT($B$5:$E$5,B6:E6) To: Мax Copy F6 to F9:F15 Subject to the Constraints: F9:F14 <= H9:H14 F15 >= H15 Solving Method: Simplex LP 291 <> 10:0 5 F.
Transcribed Image Text:the Solver Parameter dialog box, the formula that must be written in the cell for the objective function value, and the cells where this formula should be copied. The results are shown in the spreadsheet. This solution is C E H. 1 Win Big Gambling Club Radio Radio TV Newspaper 30 sec. 1 min. 4 Variables X1 X2 X3 X4 5 Solution 1.9688 6.2069 Total Audience 6 Audience per ad 5000 8500 2400 2800 67240.3017 8 Constraints LHS RHS 9 Max. TV 1 1.9688 < 12 10 Max. Newspaper 1 5 < 11 Max. 30-sec. radio 1 6.2069 < 25 12 Max. 1 min. radio 1 20 13 Cost 800 925 290 380 8000 < 8000 1800 < 1800 14 Radio dollars 15 Radio spots 290 380 1 6.2069 > 5 SOLVER PARAMETER INPUTS AND SELECTIONS KEY FORMULAS Set Objective: F6 Total Audience By Changing cells: B5:E5 6 =SUMPRODUCT($B$5:$E$5,B6:E6) To: Мax Copy F6 to F9:F15 Subject to the Constraints: F9:F14 <= H9:H14 F15 >= H15 Solving Method: Simplex LP 291 <> 10:0 5 F.
- TV sport: 11 Daily newspaper: 4 - Radio spot 30 seconds/prime time: 24 Radio spot 1 minute/afternoon: 19 Cost per ad has been reduced, as follows: -TV sport: $790 - Daily newspaper: $920 Radio spot 30 seconds/prime time: $285 Radio spot 1 minute/afternoon: $375 a) Formulate the problem in a MS-Excel spreadsheet, use the Solver Command to solve the problem. Highlight in "light green" the solution. b) Write a statement at the bottom of your MS-Excel explaining how the changes in constraints listed above impact the new maximum audience coverage, as compared to the example presented on the textbook. c) Upload the MS-Excel spreadsheet containing your problem resolution. 2. Modified Portfolio Selection example presented on textbook pages #300-303. Assume that the Interest Return for the investment possibilities have changed as follows: Trade credits: 8% Corporate bonds: 10% Gold stocks: 20% Constructions loans: 15% (remains the same) a) Formulate the problem in a MS-Excel spreadsheet, use the Solver Command to solve the problem. Highlight in "light green" the solution. b) Write a statement at the bottom of your MS-Excel explaining how the changes in constraints listed above impact the new maximum audience coverage, as compared to the example presented on the textbook. c) Upload the MS-Excel spreadsheet containing your problem resolution.
Transcribed Image Text:- TV sport: 11 Daily newspaper: 4 - Radio spot 30 seconds/prime time: 24 Radio spot 1 minute/afternoon: 19 Cost per ad has been reduced, as follows: -TV sport: $790 - Daily newspaper: $920 Radio spot 30 seconds/prime time: $285 Radio spot 1 minute/afternoon: $375 a) Formulate the problem in a MS-Excel spreadsheet, use the Solver Command to solve the problem. Highlight in "light green" the solution. b) Write a statement at the bottom of your MS-Excel explaining how the changes in constraints listed above impact the new maximum audience coverage, as compared to the example presented on the textbook. c) Upload the MS-Excel spreadsheet containing your problem resolution. 2. Modified Portfolio Selection example presented on textbook pages #300-303. Assume that the Interest Return for the investment possibilities have changed as follows: Trade credits: 8% Corporate bonds: 10% Gold stocks: 20% Constructions loans: 15% (remains the same) a) Formulate the problem in a MS-Excel spreadsheet, use the Solver Command to solve the problem. Highlight in "light green" the solution. b) Write a statement at the bottom of your MS-Excel explaining how the changes in constraints listed above impact the new maximum audience coverage, as compared to the example presented on the textbook. c) Upload the MS-Excel spreadsheet containing your problem resolution.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 4 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS