1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Lelechka [254]
2 years ago
14

9. Amir also needs to calculate the commissions paid each month. If the company earns $275,000 or more in a month, the commissio

n is 26% of the sales. If the company earns less than $275,000 in a month, the commission is 17% of the sales. Calculate the commissions as follows: a. In cell B16, enter a formula that uses the IF function and tests whether the total sales for July (cell B9) is greater than or equal to 275000. b. If the condition is true, multiply the total sales for July (cell B9) by 0.26 to calculate a commission of 26%. c. If the condition is false, multiple the total sales for July (cell B9) by 0.17 to calculate a commission of 17%.
Business
1 answer:
nadezda [96]2 years ago
5 0

The required excel function which calculates the amount of commission for July is <em>=IF(B9>=275000, B9*0.26, B9*0.17)</em>.

  • The IF function in excel uses the syntax ; <em>=IF(condition, statement 1, statement 2)</em>

  • The first argument in the function is the condition which is to check if the value in <em>B9 is greater than or equal to 275000</em>.

  • Next argument is the statement to execute if the condition is true, which is to multiply the value in B9 by the commission percentage ; 26%

  • Next argument is the statement to execute if the condition is False, which is to multiply the value in B9 by 17%.

Therefore, the required expression is <em>=IF(B9>=275000, B9*0.26, B9*0.17)</em>

Learn more :brainly.com/question/20620378?referrer=searchResults

You might be interested in
Colson Inc. declared a $320,000 cash dividend. It currently has 12,000 shares of 7%, $100 par value cumulative preferred stock o
Alex787 [66]

Answer:

The divided for common stockholders is $152000

Explanation:

The preferred stock is cumulative whch means any arrears in preference dividend will be paid whenever the dividend is declared.

The amount of yearly preference dividends is = 12000 * 100 * 0.07 = 84000

Thus, when 320000 cash dividend is declared, 2 years ( current year and arrear year) preference dividend will be paid first and the remaining will be distributed among common stock holders.

The dividedn for common stockholders is 320000 - (84000 * 2) = $152000

4 0
3 years ago
Which player in the economy supplies labor in the factor market?
djyliett [7]

The player in the economy that supplies labor in the factor market is households.

Economists refer to all of the resources that firms utilize to buy, rent, or hire the equipment they use to generate goods or services as the "factor market."

The factors of production—raw materials, land, labor, and capital—are what are required to meet these needs.

The input market is another name for the factor market.

By this definition, all markets fall into one of two categories: those that provide businesses with the resources they require, or those that provide consumers with the goods and services they need to make purchases.

The market for finished goods or services is referred to as an output market, whereas a factor market is referred to as an input market.

This can be seen as a closed-loop flow where households are sellers and businesses are buyers in the factor market and vice versa in the market for goods and services.

Hence, The player in the economy that supplies labor in the factor market is households.

Learn more about supply:

brainly.com/question/4804206

#SPJ1

5 0
2 years ago
Which of the following is a result of over-diversification through acquisition? Select one:
Aleksandr-060686 [28]

Answer:

3) Corporations use acquisition as a substitute for innovation.

Explanation:

The fastest way in which a corporation can enter a new market or develop new products is through buying existing companies that already operate in the new target markets or have developed the new products that the corporation wishes to sell.

Research and development is very costly and time consuming, and on many occasions the results aren't even good or are not as good as expected. By acquiring a smaller company that has already developed the product, then the corporation might even save money.  

6 0
3 years ago
A company handbook states that employees will be given warnings for three instances of arriving late for work, after which they
zhenek [66]

Answer:

"at-will" simply means the employer can let you go without cause

Explanation:

At-will means that an employer can terminate an employee at any time for any reason, except an illegal one, or for no reason without incurring legal liability. Likewise, an employee is free to leave a job at any time for any or no reason with no adverse legal consequences.

3 0
2 years ago
Workers at a company were assigned to one of two conditions: one group completed a stress management-training program; another g
Sergeu [11.5K]

answer:

Independent Variable: Group that completed the stress management training vs. Group that had no training)

Dependent Variable: Number of sick days

Explanation:

The dependent variables also called Predicated variable is a type of variable that depends on the independent variable which happens as a result of the circumstances surrounding the  independent during an experimental investigations. it also predicts the  outcome resulting from altering the controlled variable. for example in the question, the dependent variable is Number of sick days

The independent variable is the variable the which can be  changed or controlled during an experimental investigation which dependent variable relies on directly. for example from the question, the independent variable is the Group- (Group that completed the stress management training vs. Group that had no training)

8 0
3 years ago
Other questions:
  • What potential challenges will you have supporting your argument with this demographic?
    5·1 answer
  • 9. Objective of IS security is to ensure
    13·1 answer
  • Steve introduces in-house technical training programs for employees, as well as a provision to reimburse the tuition fees for em
    11·1 answer
  • Shawn is creating a business that provides advertising on public restroom stall doors. He is funding the project from his person
    9·1 answer
  • Abby left her native land in Eastern Europe in order to become a nanny for a family in a western suburb of Chicago, Illinois. On
    6·1 answer
  • To assess risk and return involved in a purchase decision, which practical questions should a potential buyer ask? Check all tha
    12·2 answers
  • The subject is a 15 year old duplex that would cost $240,000 to build new today. It is in good condition and you estimate the ef
    10·1 answer
  • Things that the minister of sports could consider for sports to be a nation builder
    14·1 answer
  • Lunker Lures makes ten different models of fishing lures. All ten models are completely crafted by hand using the same basic mat
    8·1 answer
  • Imagine that instead of hiring each assitant right away in the hiring assistant problem. we wait until the end to hire the best
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!