Business, 18.07.2020 18:01 LeandraMiller3398

The bonus rates for each salesperson are determined by sales amounts using the following scale:. Sales greater than $35,000 earn a bonus rate of 5%, sales greater than $25,000 earn a bonus rate of 4%.
All other sales (any amount greater than 0) earn a bonus rate of 2%.
With the sheets still grouped, in cell C5 use an IFS function to determine the commission rate for the first salesperson whose sales are in cell B5.
Fill the formula down through cell C8.

Answers: 2

Show answers

Another question on Business

Business, 22.06.2019 11:10

Which of the following is an example of a production quota? a. the government sets an upper limit on the quantity that each dairy farmer can produce. b. the government sets a price floor in the market for dairy products. c. the government sets a lower limit on the quantity that each dairy farmer can produce. d. the government guarantees to buy a specified quantity of dairy products from farmers.

Answers: 2

Answer

Business, 22.06.2019 17:40

Turrubiates corporation makes a product that uses a material with the following standards standard quantity 8.0 liters per unit standard price $2.50 per liter standard cost $20.00 per unit the company budgeted for production of 3,800 units in april, but actual production was 3,900 units. the company used 32,000 liters of direct material to produce this output. the company purchased 20,100 liters of the direct material at $2.6 per liter. the direct materials purchases variance is computed when the materials are purchased. the materials quantity variance for april is:

Answers: 1

Answer

Business, 22.06.2019 20:00

Experienced problem solvers always consider both the value and units of their answer to a problem. why?

Answers: 3

Answer

Business, 22.06.2019 20:10

Assume that a local bank sells two services, checking accounts and atm card services. the bank’s only two customers are mr. donethat and ms. beenthere. mr. donethat is willing to pay $8 a month for the bank to service his checking account and $2 a month for unlimited use of his atm card. ms. beenthere is willing to pay only $5 for a checking account, but is willing to pay $9 for unlimited use of her atm card. assume that the bank can provide each of these services at zero marginal cost.refer to scenario 17-5. if the bank is unable to use tying, what is the profit-maximizing price to charge for a checking account

Answers: 3

Answer

You know the right answer?

The bonus rates for each salesperson are determined by sales amounts using the following scale:. Sa...

Questions