Problem $2$

You are thinking of advertising Microsoft products on a popular TV music program. You pay one

price for the first group of ads, but as you buy more ads, the price per ad decreases as shown in the

following table.

For example, if you buy $8$ ads, you pay $$12,000$ per ad for the first $5$ ads and $$11,000$ for each of the

next $3$ ads. If you buy $14$ ads, you pay $$12,000$ for each of the first $5$ ads, $$11,000$ for each of the next

$5$ ads, and $$10,000$ for each of the last $4$ ads. Write a formula that yields the total cost of purchasing

any number of ads. Hint: You probably need at least three columns in your table range, and your

formula might involve two lookup functions.You are thinking of advertising Microsoft products on a popular TV music program. You pay one

price for the first group of ads, but as you buy more ads, the price per ad decreases as shown in the

following table.

Number of ads Price per add

$1-5$ $$12,000$

$6-10$ $$11,000$

$11-20$ $$10,000$

$21$ and more $$9,000$

For example, if you buy $8$ ads, you pay $$12,000$ per ad for the first $5$ ads and $$11,000$ for each of the

next $3$ ads. If you buy $14$ ads, you pay $$12,000$ for each of the first $5$ ads, $$11,000$ for each of the next

$5$ ads, and $$10,000$ for each of the last $4$ ads. Write a formula that yields the total cost of purchasing

any number of ads. Hint: You probably need at least three columns in your table range, and your

formula might involve two lookup functions.