Hello,
Please help just one question:
Course: CIS 315:
Intro Business Data Analytics
-
"the integer optimization problem".
Please help, Thanks so much.
Pleaseshow 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.
Extracted 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
Extracted 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