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
Directions: After reading the texts, choose the best answer for the multiple-choice questions below and respond to
creativ13 [48]

Answer:

Their study of data from the Gallup-Healthways Well-Being Index found that while “life evaluations rise steadily with income,” emotional well-being drops off at about $75,000 a year. Beyond $75,000, money is important for life evaluation but does nothing for happiness, enjoyment, sadness, or stress.

Explanation:

6 0
3 years ago
Read 2 more answers
How can you filter the for review tab to see all the transactions quickbooks online thinks it has found a good match for?
irga5000 [103]

Answer:

Click on the Recognized tab

Explanation:

If you want to filter the for review tab to find the good match all you have to do is:

Step 1: Go at "For Review" Tab

Step 2: Above the transactions their will be Recognized Tab. Click on it which would filter all the transactions that provides a good match.

6 0
3 years ago
The Sisyphean Company is considering a new project that will have an annual depreciation expense of $3.6 million. If Sisyphean's
castortr0y [4]

Answer:

$1,260,000

Explanation:

Given that,

Annual depreciation expense = $3.6 million

Marginal corporate tax rate = 35%

Average corporate tax rate = 30%

The reason to use marginal tax shield is that the firm would save additional amount it would have paid in taxes.

Value of the depreciation tax shield:

= Marginal corporate tax rate × Annual depreciation expense

= 35% × $3,600,000

= $1,260,000

Therefore, the value of the depreciation tax shield on the company's new project is $1,260,000.

3 0
3 years ago
Windsor, Inc. has had 4 years of net income. Due to this success, the market price of its 350,000 shares of $5 par value common
kvasek [131]

Answer:

1.

a.

$9,788,000

b.

$12,700,000

2.

a.

$18,860,000

b.

$18,860,000

Explanation:

Stock dividend is the payment of dividend to stockholder in the form of stock/shares of the company. Stock are issued at the market price and the value of the dividend is transferred from the retained earning to the add-in-capital accounts.

Stock Dividend = 350,000 x 16% x $52 = $2,912,000

Stock split increase the numbers of shares with a specific given ratio but the common equity value remains same that's why the par value of the share decreases with respective ratio.

Stock Split = 350,000 x 2 / 1 x $5/2 = $1,750,000

Total Stockholders equity section includes the paid in capital of common and preferred stocks, additional paid in capital, retained earnings and reserves accounts.

Total Stockholders equity

Common Stock                      $1,750,000

Paid In Capital account         $4,410,000.

Retained Earning                   <u>$12,700,000</u>

Total Stockholder's Equity    <u>$18,860,000</u>

1.

a.

Retained Earning = $12,700,000 - $2,912,000 = $9,788,000

b.

NO change in retained earning after stock split. Stock split only changes the outstanding numbers of shares and par value of the share.

2.

a.

It will remains the same because balances are transferred from retained earnings to the common stock and paid in capital accounts but the total balance remains the same.

b.

As there is no changes to value of any equity account, so total stockholders equity will remain the same.

6 0
2 years ago
how can the size of the industrial/service sector and the agriculture employment rate indicate the level of industrialization?​
dolphi86 [110]

Answer:

A larger industrial and service sector, and a larger number of people working outside of agriculture, can indicate a higher level of industrialization in the economy and vice versa. This means that the size of industrial service and the sector of agriculture employment rate indicates the level of industrialization because if the agriculture employment is higher than the industrial service it means that the country is not fully developed yet and therefore the level of industrialization is lower. But if the industrial service is higher than the agriculture employment that suggests or indicates that the country is developing or developed. For example in the United States the size of the industrial/service sector is much larger than it's agricultural employment and therefore this should suggest that country is much more industrialized or developed and the United States is. In comparison you take a developing country such as Chad and you can see that the agricultural employment is higher than the size of the industrial/service sector and in relation to this you can see that Chad must have a lower level of industrialization and in fact it does.

Explanation:

3 0
2 years ago
Other questions:
  • Hannah allowed her friend Carol to borrow her laptop computer for a week during Thanksgiving Break. During that time Carol, with
    10·1 answer
  • What is a subcontractor
    5·1 answer
  • In regard to an operating budget identifiable costs may generally include _________.
    9·1 answer
  • According to the five forces model, an attractive industry would include all of the following characteristics EXCEPT: a. low thr
    12·1 answer
  • Suppose an economic boom drives up wages for the sales representatives who work for cell phone companies. This will cause the:__
    14·1 answer
  • Loss of the Gocha mangrove forests has caused coastal erosion, reducing fish populations and requiring the Gocha Fishing Coopera
    12·1 answer
  • Fixed costs can be defined as costs that A. vary inversely with production. B. vary in proportion with production. C. are incurr
    10·1 answer
  • Brown Office Supplies recently reported $15,500 of sales, $8,250 of operating costs other than depreciation, and $1,750 of depre
    12·1 answer
  • coomer co had net sales of 600000 net income of 35260 and average total assets of 680000 what is the return on total assets
    10·2 answers
  • One of the advantages of the Weighted Point Evaluation Method is that it: A. Keeps the number of suppliers in a Supply Chain low
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!