Exhibit 7.1 The Following Questions Are Based on the Problem Below

question 77

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 cell(s) is(are) the objective cell(s) in this model?

• A) $B$20
• B) $D$6
• C) $E$6
• D) $B$13:$E$14, $B$9:$E$9

---

Definitions:

Services Sector

A segment of the economy composed of businesses and individuals that provide intangible goods or services to consumers, such as healthcare, education, finance, and hospitality.

Enterprise Resource Planning (ERP)

An integrated management of main business processes, often in real time and mediated by software and technology, aimed at improving efficiency and data accuracy.

Global Database

A comprehensive collection of data or information accessible from multiple countries, often used for research, analysis, or business intelligence.

Surplus Materials

Excess resources or goods that are available after satisfying the planned demand or requirement.