A company wants to advertise on TV and radio. The company wants to produce about 6 TV ads and 12 radio ads. Each TV ad costs $20,000 and is viewed by 10 million people. Radio ads cost $10,000 and are heard by 7 million people. The company wants to reach about 140 million people and spend about $200,000 for all the ads. The problem has been set up in the following Excel spreadsheet:

What formula goes in cell D6 in the above spreadsheet? Group of answer choices

=SUMPRODUCT(B2:B3,B6:B7)

=B2*C2+B6*C6

=SUMPRODUCT(B2:C2,B10:C10)

=SUMPRODUCT(B2:C2,B6:C6)

What formula goes in cell B9 in the above spreadsheet?

Group of answer choices

=SUM(B6:B8)

=B6+B7-B8

=B6-B7+B8

=B10-B8

Which of the following is a constraint specified to Solver in Excel for this model?

Group of answer choices

$B$9:$E$9=$B$6:$E$6

$B$9:$E$9<$B$10:$E$10

$B$9:$E$9=$B$10:$E$10

$B$9:$E$9>$B$10:$E$10

Which cells are the variable cells in this model?

Group of answer choices

$B$6:$C$6, $B$7:$E$8

$B$6:$C$6

$B$9:$E$9

$B$6:$E$8

Which cell(s) is(are) the objective cell(s) in this model?

Group of answer choices

$B$16

$D$6

$E$6

$B$13:$E$14, $B$9:$E$9

If the company is very concerned about going over the $200,000 budget, which cell value should change and how should it change?

Group of answer choices

D13, increase

D13, decrease

D14, increase

D14, decrease