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]
3 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]3 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
If you were given a large data set, such as the sales over the last year of our top 100 customers, what might you be able to do
Daniel [21]
<span>The best thing to do with data such as sales over the last year of the top 1000 customers would be to answer questions like:
1) what products sell the most: This would help the marketing department,for example on targeting what items to push.
2) what groups of people buy what product: Again this would be targeting who buys what. We may discover that males prefer product A and females prefer product B. Or young customers prefer different products that older. This would help marketing also on targeting sales.</span>
8 0
3 years ago
Read 2 more answers
If an account is collected after having been previously written off:
Orlov [11]

Answer:

d. there will be both a debit and a credit to accounts receivable.

Explanation:

Bad debt is defined as the portion of accounts receivable that is considered to be lost and is written off as a loss to the business within a given period.

When a bad debt is written off it impacts directly on the profit of the business.

If an account has been collected after previously being written off, there will be a credit to accounts receivable to show an increase in a recievable by the business.

Also there is a debit to accounts receivable to show that the recovered funds has been moved to profit or revenue account of the business.

8 0
3 years ago
Read 2 more answers
Excel provides _____ in categories such as financial management and budgets.
a_sh-v [17]

Excel provides <u>Expenses</u> in categories such as financial management and budgets.

Excel is a Microsoft Office application designed to carry out variation functions, including financial analysis.

Microsoft Excel can be used in many ways. When it comes to finances, it can be used for budgeting or costing before a product or project is made, where each expense is categorized under a different heading.

Microsoft Excel can also carry out a valuation of expenses made, with each expense listed under different categories.

Hence, in this case, it is concluded that Microsoft Excel is a vital tool in financial management.

Learn more here: brainly.com/question/23960987

7 0
2 years ago
Crane purchases equipment by signing a note payable with the equipment dealer for $10,000. The accounts affected for Crane are _
maxonik [38]

Answer:

Equipment and notes payable

Explanation:

Since the equipment is purchased by signing the note payable which affected the two accounts i.e equipment and the note payable. In this, the cash transaction is not involved, so cash should not be considered

The journal entry would be

Equipment A/c Dr $10,000

        To Notes payable $10,000

(Being the equipment is purchased  by signing a note payable)

7 0
3 years ago
(01.02 mc) which of these actions was an economic cause of increased tensions between the north and south?
Damm [24]

The correct option is (b) Protective tariffs

Protective tariffs aim to make imported goods more expensive while protecting domestic producers from overseas rivalry.

<h3 /><h3>What is protective tarrifs?</h3>
  • An illustration of a protective tariff would be the US raising the customs charge on clothing imported from Britain so that it is significantly more expensive than clothing made domestically.
  • The importing countries profit the most from tariffs since they design the policy and receive the cash.
  • The main advantage of tariffs is that they generate income from imported products and services. Tariffs may also serve as a springboard for negotiations between two countries.
  • Protective tariffs are designed to shield vital American industries from international competition, stop foreign manufacturers from dumping inexpensive goods in the US, or both.

Learn more about the Tarrifs with the help of the given link:

brainly.com/question/11672570

#SPJ4

I understand that the question you are looking for is "Which of these actions was an economic cause of increased tensions between the North and South?

(a) Dred Scott decision

(b) Protective tariffs

(c) Bleeding Kansas

(d) Lincoln’s election"

6 0
1 year ago
Other questions:
  • Parents want to setup an account for their child studying abroad for next 2 years, where they can receive a monthly allowance of
    11·2 answers
  • Oswego clay pipe company sold of pipe to southeast water district #45 on of the current year with terms . oswego uses the gross
    6·1 answer
  • Which of the following is considered a need
    14·2 answers
  • A $53 petty cash fund has cash of $24 and receipts of $37. The journal entry to replenish the account would include a
    5·1 answer
  • It took you four months to find a job, and you were almost out of money, when you finally landed your position. Today your boss
    15·1 answer
  • Portfolio standard deviation and diversification: You are asked to give financial advice to a mutual fund manager. The fund has
    10·1 answer
  • Keenan Industries has a bond outstanding with 15 years to maturity, an 8.25% nominal coupon, semiannual payments, and a $1,000 p
    14·1 answer
  • For more than a thousand years, the Catholic Church required its members to abstain from meat on Fridays. Catholics customarily
    5·1 answer
  • What has happened to income inequality in the United States in recent years?
    9·2 answers
  • Justin Company's budget includes the following credit sales for the current year: September, $25,000; October, $36,000; November
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!