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
Willy makes proper use of the wiki feature on the company intranet when he ________. science forums
beks73 [17]

Answer:

Adds some updated features to product information, that way, he can effectively utilize the wiki feature as he so desires.

7 0
3 years ago
during the cooling off period, underwriters would be allowed to do all of the following except a) take indications of interest.
ss7ja [257]

During the cooling off period, underwriters would be allowed to do all of the aforementioned except: b) advertise the issue.

<h3>Who is an underwriter?</h3>

An underwriter can be defined as an individual or business firm that is saddled with the responsibility of evaluating and assuming another party's financial risk for an agreed amount of money (fee), which is often paid as a spread, commission, interest, or premium.

This ultimately implies that, an underwriter helps a lender (financial institution) in determining the level of risk associated with an issue.

As a general rule, underwriters would be allowed to do all of the following during the cooling off period:

  • Take indications of interest.
  • Publish a tombstone.
  • Distribute a preliminary prospectus.

In this context, we can reasonably infer and logically deduce that during the cooling off period, underwriters would only be allowed to do all of the aforementioned except distribute sale or advertise the issue.

Read more on underwriters here: brainly.com/question/28026586

#SPJ1

3 0
1 year ago
Think of a business idea that offers opportunity for customer credit. Assuming that you want to adopt this idea, what criteria w
mezya [45]

Answer:

an example for a company that offers back customers credit is Jimmy Johns, they have online rewards that you can sign up with you or phone number or online to earn points for your meals. When you sign up they promote you to go buy a sandwich for your first free sandwich, after that every time you come back and buy something you will be racking up points for free things like sandwiches, chips, cookies, pickles, and drinks.They also have special offers like on your birthday you get a free sub (and after you sign up).  If I wanted to do something similar with my business I make would make a rewards systems where you earn points for discounts.

Explanation:

Identify a business idea with which you can proceed. For example, you start a business that designs and creates landscaping for customers (front garden space, back patio, and so on).

This type of business provides opportunity for consumer credit, as most people would not want to pay a huge amount upfront in cash or even through credit cards.

Since the only other way is to offer credit facility, you will have to make a list of questions. You will then have to research the customer’s credit worthiness.

Check for the customer’s credit rating with the credit- and information-management companies, such as TransUnion or Equifax.

Check for the customers’ current financial positions. You can do so by finding out whether they have a secure job or a well-performing business, number of earning members in the family, and so on.

Depending on the information you acquire, you may decide either to offer complete credit, with a relatively shorter credit period, or only offer a certain percentage of credit spread across a wider credit period.

7 0
2 years ago
Kingbird Company is negotiating to lease a piece of equipment to MTBA, Inc. MTBA requests that the lease be for 9 years. The equ
kolbaska11 [484]

Answer:

$ 7,994

Explanation:

Fair Value of lease 60,000

Less Present value of garanteed residual value$ 2,368

($4000*1/1.06^9)

Amount to be recovered through periodic payment $ 57,632

PVAD (9 years ,6%) 7.20979

Minimum Lease at the beginning of each year (C/D) $ 7,994

Therefore the amount of the annual rental payments Kingbird demands of MTBA, assuming each payment will be made at the beginning of each year and Kingbird wishes to earn a rate of return on the lease of 6 $7,994

8 0
2 years ago
HELP ASAP! ACCURATE ANSWERS PLEASE! WILL GIVE BRANLIEST IF THE ANSWER IS GOOD
zlopas [31]

Answer: tell them what you observe and sometimes you will have to reward them such as candies in order to show them that they did a splendid job. This will let them realize that they did a great job.

Explanation:

4 0
3 years ago
Other questions:
  • Google's mission statement is “to organize the world's information and make it universally accessible and useful.” When the CEO,
    6·1 answer
  • When Kimberly begins working for Pharmco Industries the company tells her that at a future after so many years of employment wit
    13·1 answer
  • reply to the task: I'm going to be in DC next week and I want to go see the original Declaration of Independence. Where is that?
    12·1 answer
  • To evaluate solutions, you must usually
    8·1 answer
  • order for the auto parts shop is $80; the holding cost of carrying 1 unit is $1.2 per year. The shop has 360 working days per ye
    12·2 answers
  • Android Products, Inc., agreed to accept a $1,000, one-year, 10 percent note from C. Mate. On its maturity date of December 16,
    14·1 answer
  • Presently, Stock A pays a dividend of $1.00 a share, and you expect the dividend to grow rapidly for the next four years at 20 p
    10·1 answer
  • Karla bought her dress for the recital not because she liked the color and style, but because it made her feel good about hersel
    5·1 answer
  • The federal reserve engages in another round of quantitative easing. what are the effects of this policy on the economy?
    14·1 answer
  • what is the bank discount rate on a $100,000 face value t-bill priced at $97,500, maturing in 181 days?
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!