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
monopolistically competitive firms are unable to produce enough output to reach the average total cost because of the presence o
stich3 [128]

Monopolistically competitive firms are unable to produce enough output to reach the average total cost because of the presence of other monopolistically competitive firms in the industry.

  • Monopolistic competition arises when several businesses provide rival goods or services that are comparable but imperfect replacements.
  • Entry barriers are low in monopolistic competitive industries, and actions made by one business do not immediately impact those of its rivals. Pricing and marketing choices are how the rival firms set themselves apart.
  • Businesses engaged in monopolistic rivalry distinguish their goods through price and marketing tactics.
  • The expenses or other impediments that prohibit new rivals from joining a market are minimal in monopolistic competition.
  • Between perfect and monopolistic competition, known as monopolistic competition, there is monopolistic competition, which incorporates aspects of both and entails businesses with comparable but distinct product offers.

Learn more about Monopolistic competition, here

brainly.com/question/28189773

#SPJ4

4 0
1 year ago
Cash receipts and cash disbursement budgets for a government: Should be prepared monthly or as needed to enhance cash management
nlexa [21]

Answer:

Should be prepared monthly or as needed to enhance cash management, investment management, and short-term debt management.

Explanation:

The government budget with respect to the cash receipts and cash disbursement should be prepared on the monthly basis or it should be prepared as per the requirement so that the managing of the cash could be enhanced also along with it the managing of the investing and managing of the short term debt could also be enhances

Therefore the first option is correct

7 0
3 years ago
Game theory is useful in analyzing oligopoly behavior because: advertising is so common among oligopoly firms. it explains why o
hoa [83]
I think the answer is trying<span> to maximize profits is essentially a game in all types of markets. Oligopoly is focused on monopolizing all the markets by gaining much profit that would make it dominate the businesses. This can help players understand strategic skills in marketing.</span>
5 0
3 years ago
Yolanda (41), a freelance photographer, reports a net profit of $50,000 on Schedule C, Profit or Loss from Business. This is her
AleksandrR [38]

Answer:

the self-employment tax is $7,065

Explanation:

The computation of the self-employment tax is given below:

Given that

net profit = $50,000

Now the 92.35% of net profit is $46,175

As it is lower than $128,400

So,

= 15.3% of $46,175

= $7,065

Hence, the self-employment tax is $7,065

6 0
3 years ago
What are the four types of costs that a business must consider in making business decisions
klio [65]

Fixed and Variable

Direct and Indirect  

Product and Period

7 0
3 years ago
Other questions:
  • A country has national saving of $50 billion, government expenditures of $20 billion, domestic investment of $10 billion, and ne
    15·1 answer
  • Suppose that Firms A and B each produce high-resolution computer monitors, but Firm A can do so at a lower cost. Cassie and Davi
    5·1 answer
  • Suppose that in a month the price of oranges increases from $.75 to $1. At the same time, the quantity of oranges demanded decre
    7·1 answer
  • The Forestville Freeze is regionally known for its employee training programs. Managers at the Freeze conduct research to determ
    6·1 answer
  • Davidson Electronics has the following: Units Unit Cost Inventory, Jan. 1 5,000 $ 8 Purchase, April 2 15,000 10 Purchase, Aug. 2
    5·1 answer
  • On June 1, 2021, Wildhorse &amp; Sons sold equipment to James Landscaping Service in exchange for a zero-interest bearing note w
    6·1 answer
  • Evaluate how organizations can use one-sample hypothesis testing to determine if there are performance issues in the organizatio
    15·1 answer
  • Ken, whose primary job is supervising a small production group, is not getting cooperation from all members on the cross-functio
    10·1 answer
  • 2) Assume that you invest 5 percent of your salary and receive the full 5 percent match from East Coast Yachts. What EAR do you
    13·1 answer
  • Dirty data is an MIS problem, not a business problem. Group startsTrue or FalseTrue, unselectedFalse
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!