You would like to determine a schedule that maximizes ad revenue. However, the network has a few conditions: • The schedule must include at least as many shows that are categorized as "General Interest" as shows that are categorized as "Graphic". • If you schedule "The Crown" then you must also schedule either "The Expanse" or "Law & Order" (or both). • You cannot schedule both "The Crown" and "Cosmos." Which shows should be scheduled? check all that apply The Good Place The Walking Dead Law & Order O The Expanse O Schitt's Creek Stranger Things The Crown Community O Cosmos

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...
icon
Related questions
Question

Hello,

Please help just one question:


Course: CIS 315: Intro Business Data Analytics"the integer optimization problem".

Please help, Thanks so much.

 

Please show your excel work to help the question in the print-screen.

Notes:

Use "SOLVER" in EXCEL to figure out the question about "Linear Optimization of binary"

Need to write constraints before running the "SOLVER" in EXCEL.

Please note that this is "the integer optimization problem".

Thanks.

 

 

 

You are the scheduling manager for a TV network. You must choose which 5 shows to air, you must
pick five. Each show generates ad revenue for the network (shown in millions of dollars). Each
show falls into one or more of the following categories: Drama, Comedy, Graphic, and General
Interest. A 1 indicates that the show is in the corresponding category and a 0 indicates it is not.
Revenue
General
Show
Graphic
Comedy
Drama
(in Millions)
Interest
The Good Place
$6
1
1
The Walking Dead
$10
1
1
Law & Order
$9
1
1
The Expanse
$4
1
1
Schitt's Creek
$5
1
Stranger Things
$2
1
The Crown
$6
1
1
Community
$7
1
Cosmos
$8
1
You would like to determine a schedule that maximizes ad revenue. However, the network has a few
conditions:
• The schedule must include at least as many shows that are categorized as "General Interest" as
shows that are categorized as "Graphic".
• If you schedule "The Crown" then you must also schedule either "The Expanse" or "Law & Order"
(or both).
• You cannot schedule both "The Crown" and "Cosmos."
Which shows should be scheduled? check all that apply
Transcribed Image Text:You are the scheduling manager for a TV network. You must choose which 5 shows to air, you must pick five. Each show generates ad revenue for the network (shown in millions of dollars). Each show falls into one or more of the following categories: Drama, Comedy, Graphic, and General Interest. A 1 indicates that the show is in the corresponding category and a 0 indicates it is not. Revenue General Show Graphic Comedy Drama (in Millions) Interest The Good Place $6 1 1 The Walking Dead $10 1 1 Law & Order $9 1 1 The Expanse $4 1 1 Schitt's Creek $5 1 Stranger Things $2 1 The Crown $6 1 1 Community $7 1 Cosmos $8 1 You would like to determine a schedule that maximizes ad revenue. However, the network has a few conditions: • The schedule must include at least as many shows that are categorized as "General Interest" as shows that are categorized as "Graphic". • If you schedule "The Crown" then you must also schedule either "The Expanse" or "Law & Order" (or both). • You cannot schedule both "The Crown" and "Cosmos." Which shows should be scheduled? check all that apply
You would like to determine a schedule that maximizes ad revenue. However, the network has a few
conditions:
• The schedule must include at least as many shows that are categorized as "General Interest" as
shows that are categorized as "Graphic".
• If you schedule "The Crown" then you must also schedule either "The Expanse" or "Law & Order"
(or both).
• You cannot schedule both "The Crown" and "Cosmos."
Which shows should be scheduled? check all that apply
The Good Place
The Walking Dead
Law & Order
O The Expanse
Schitt's Creek
Stranger Things
The Crown
Community
Cosmos
Transcribed Image Text:You would like to determine a schedule that maximizes ad revenue. However, the network has a few conditions: • The schedule must include at least as many shows that are categorized as "General Interest" as shows that are categorized as "Graphic". • If you schedule "The Crown" then you must also schedule either "The Expanse" or "Law & Order" (or both). • You cannot schedule both "The Crown" and "Cosmos." Which shows should be scheduled? check all that apply The Good Place The Walking Dead Law & Order O The Expanse Schitt's Creek Stranger Things The Crown Community Cosmos
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

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