Exhibit 7.1 The Following Questions Are Based on the Problem Below

question 49

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. Which cells are the variable cells in this model?

• A) $B$6:$C$6, $B$7:$E$8
• B) $B$6:$C$6
• C) $B$9:$E$9
• D) $B$6:$E$8

---

Definitions:

Outsourcing

The practice of delegating certain job functions or tasks to outside parties or companies.

Human Relations

Refers to the interactions between employers and employees and the ways in which they establish and manage relationships in the workplace.

Chief Hospital Administrator

The highest-ranking official in a hospital, responsible for overseeing all administrative and operational aspects.

Night Shift

A work shift that takes place during the nighttime hours, often starting late in the evening and ending early in the morning.