#### Question Details

##### [solution] » You are thinking of advertising Microsoft products on a sports

**Brief item decscription**

Step-by-step solution file

**Item details:**

You are thinking of advertising Microsoft products on a sports**More:**You are thinking of advertising Microsoft products on a sports telecast. As you buy more ads, the price of each ad decreases as shown in the following table:

** **

Number of ads | Price per ad |

1-5 | $ 12,000 |

6-10 | $11,000 |

11-20 | $10,000 |

21 and higher | $ 9000 |

** **

** **

**For example, if you buy 8 ads, you pay $11,000 per ad, but if you buy 14 ads, you pay $10,000 per ad. Write a formula that yields the total cost of purchasing any number of ads.**

** **

Internal Assignment for Business proficiency Tool

Internal Assignment for Business proficiency Tool

1. You are thinking of advertising Microsoft products on a sports telecast. As you buy more ads, the price of

each ad decreases as shown in the following table:

Number of ads

1-5

6-10

11-20

21 and higher Price per ad

$ 12,000

$11,000

$10,000

$ 9000 For example, if you buy 8 ads, you pay $11,000 per ad, but if you buy 14 ads, you pay $10,000 per ad.

Write a formula that yields the total cost of purchasing any number of ads.

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:

Number of ads

1-5

6-10

11-20

21 and higher Price per ad

$ 12,000

$11,000

$10,000

$ 9000 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.

3. In the Pinevalley.xlsx file, the first worksheet contains the salaries of several employees at Pine Valley

University, the second worksheet contains the age of the employees, and the third worksheet contains the

years of experience. Create a fourth worksheet that contains the salary, age, and experience for each

employee.

Use File MakeupFilter 4.

5.

6.

7. Find all transactions in which Hallagan sold eyeliner in the West region.

Find all transactions that rank in the top 5 percent with regard to units sold.

Find the top 20 revenue-generating transactions that involve foundation sales.

Find all transactions involving sales of at least 60 units during 2004 for which the per-unit price was a 8. maximum of $3.10.

Find all foundation transactions during the first three months of 2004 for which the per-unit price was 9.

10.

11.

12.

13. larger than the average price received for foundation during the entire period.

Find all transactions in which Zaret or Betsy sold either lipstick or foundation.

Find all unique combinations of product and salesperson?s name.

Find all the top 30 sales (by units) occurring in 2005 that involved lip gloss or mascara.

Find all sales by Jen between August 10 and September 15, 2005.

. Find all sales of lipstick sold by Colleen for which the number of units sold is higher than the average number of units in a lipstick transaction.

14. . Find all unique combinations of name, product, and location occurring during the first three months of

2006. Internal Assignment for Business proficiency Tool

15. . Find all records in which the product cell is colored yellow.

**About this question:****STATUS**

Answered

QUALITY

Approved

ANSWER RATING

Pay using PayPal (No PayPal account Required) or your credit card. All your purchases are securely protected by PayPal.

Answered

QUALITY

Approved

ANSWER RATING

This question was answered on: * Feb 21, 2020 *

* * Solution~00066571713.zip (18.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free copy (Deadline assured. Flexible pricing. TurnItIn Report provided)

### Need a similar solution fast, written anew from scratch? Place your own custom order

We have top-notch tutors who can help you with your essay at a reasonable cost and then you can simply use that essay as a template to build your own arguments. This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student. New solution orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.