Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Solve the following problems: 1. Modified Media Selection example presented on textbook pages #289-291: Assume that the following constraints have changed: Maximum ads per week has been reduced, as follows: - 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 sc b) Write a statement at the bottom of your MS-Excel explaining how the changes in constraints listed above impact the new maximu presented on the textbook. C Unload the MS-Excol

Solve the following problems: 1. Modified Media Selection example presented on textbook pages #289-291: Assume that the following constraints have changed: Maximum ads per week has been reduced, as follows: - 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 sc b) Write a statement at the bottom of your MS-Excel explaining how the changes in constraints listed above impact the new maximu presented on the textbook. C Unload the MS-Excol

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 1 please. I have attached the example given 

**Solve the following problems:** **1. Modified Media Selection example as presented in textbook, pages #289-291:** Assume the following constraints have changed: - **Maximum ads per week has been reduced, as follows:** - 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 in the textbook. c) Upload the MS-Excel spreadsheet containing your problem resolution. --- **2. Modified Portfolio Selection example as presented in 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% - Construction 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 interest returns impact the new investment strategy, as compared to the example presented in the textbook.
Transcribed Image Text:**Solve the following problems:** **1. Modified Media Selection example as presented in textbook, pages #289-291:** Assume the following constraints have changed: - **Maximum ads per week has been reduced, as follows:** - 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 in the textbook. c) Upload the MS-Excel spreadsheet containing your problem resolution. --- **2. Modified Portfolio Selection example as presented in 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% - Construction 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 interest returns impact the new investment strategy, as compared to the example presented in the textbook.
## Advertising Strategy Optimization: Win Big Gambling Club ### Problem Overview The objective is to optimize the advertising strategy for Win Big Gambling Club by determining the number of ads in different media to maximize the total audience reached. ### Variables and Audience Reach (per ad) - **X1 (TV)**: 5000 people - **X2 (Newspaper)**: 8500 people - **X3 (Radio 30 sec)**: 2400 people - **X4 (Radio 1 min)**: 2800 people ### Solutions - **TV (X1)**: 1.9688 ads - **Newspaper (X2)**: 5 ads - **Radio 30 sec (X3)**: 6.2069 ads - **Radio 1 min (X4)**: 0 ads Total Audience Reach: **67,240.3017 people** ### Constraints - **Max TV ads**: 12 - **Max Newspaper ads**: 5 - **Max Radio 30 sec ads**: 25 - **Max Radio 1 min ads**: 5 - **Budgetary Limits**: - Cost (per ad): TV - $800, Newspaper - $925, 30 sec Radio - $290, 1 min Radio - $380 - Maximum Budget: $8000 - **Radio Spots**: Minimum required - 5 ### Solver Parameter Inputs and Selections - **Set Objective**: Cell F6 (Total Audience) - **Changing Cells**: B5:E5 (Number of ads for each media) - **Optimization Goal**: Maximize the total audience - **Subject to Constraints**: - F9:F14 (advertisement constraints) ≤ H9:H14 (constraints maximum) - F15 (radio spots) ≥ H15 (minimum spots) - **Solver Method**: Simplex Linear Programming ### Key Formulas - **Total Audience (Cell F5)**: \[ \text{=SUMPRODUCT(}\$B\$5:\$E\$5, B6:E6\text{)} \] Copy the formula from F6 to F9:F15 for appropriate calculations.
Transcribed Image Text:## Advertising Strategy Optimization: Win Big Gambling Club ### Problem Overview The objective is to optimize the advertising strategy for Win Big Gambling Club by determining the number of ads in different media to maximize the total audience reached. ### Variables and Audience Reach (per ad) - **X1 (TV)**: 5000 people - **X2 (Newspaper)**: 8500 people - **X3 (Radio 30 sec)**: 2400 people - **X4 (Radio 1 min)**: 2800 people ### Solutions - **TV (X1)**: 1.9688 ads - **Newspaper (X2)**: 5 ads - **Radio 30 sec (X3)**: 6.2069 ads - **Radio 1 min (X4)**: 0 ads Total Audience Reach: **67,240.3017 people** ### Constraints - **Max TV ads**: 12 - **Max Newspaper ads**: 5 - **Max Radio 30 sec ads**: 25 - **Max Radio 1 min ads**: 5 - **Budgetary Limits**: - Cost (per ad): TV - $800, Newspaper - $925, 30 sec Radio - $290, 1 min Radio - $380 - Maximum Budget: $8000 - **Radio Spots**: Minimum required - 5 ### Solver Parameter Inputs and Selections - **Set Objective**: Cell F6 (Total Audience) - **Changing Cells**: B5:E5 (Number of ads for each media) - **Optimization Goal**: Maximize the total audience - **Subject to Constraints**: - F9:F14 (advertisement constraints) ≤ H9:H14 (constraints maximum) - F15 (radio spots) ≥ H15 (minimum spots) - **Solver Method**: Simplex Linear Programming ### Key Formulas - **Total Audience (Cell F5)**: \[ \text{=SUMPRODUCT(}\$B\$5:\$E\$5, B6:E6\text{)} \] Copy the formula from F6 to F9:F15 for appropriate calculations.
Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
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