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:

Cost of Goods Sold

The direct financial costs required for the manufacture of a company’s products, involving materials and labor expenses.

FIFO

An accounting method for valuing the cost of goods sold that assumes the earliest items purchased are the first to be sold.

Weighted Average Method

An inventory costing method that assigns a cost to inventory items based on the average cost of all similar items in inventory, weighted by the quantities purchased at different prices.

LIFO

An inventory valuation method, "Last In, First Out," where the most recently produced or purchased items are recorded as sold first.