Multiple Choice
Exhibit 7.1
The following questions are based on the problem below.
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.
-Refer to Exhibit 7.1. What formula goes in cell B9?
A) =SUM(B6:B8)
B) =B6+B7-B8
C) =B6-B7+B8
D) =B10-B8
Correct Answer:

Verified
Correct Answer:
Verified
Q3: Exhibit 7.1<br>The following questions are based on
Q4: A dietitian wants to formulate a low
Q5: A company wants to purchase large and
Q6: An investor wants to invest $50,000 in
Q7: Exhibit 7.1<br>The following questions are based on
Q9: Exhibit 7.2<br>The following questions are based on
Q10: Deviational variables<br>A) are added to constraints to
Q11: Goal programming solution feedback indicates that the
Q12: The "triple bottom line" incorporates multiple objective
Q13: What is the soft constraint form of