Calculate her gross monthly sales commissions

Assignment Help Business Management
Reference no: EM132374535

1. Roz wants to calculate her gross monthly sales commissions. The rule is that she gets a 2.7% commission on the total sales amount every month, and she receives 3.5% if her sales exceeded $80,000 in a given month.

In cell B31, (what would I use for) formula using the IF function to check whether the value of cell B10 is greater than 80000.

a. If this condition is true, the function should multiply cell B10 by 3.5% to determine Roz's commission. (Hint: For the if true value, use B10*.035.)

b. If this condition is false, the function should multiply the value in cell B10 by 2.7% to determine Roz's commission. (Hint: For the if false value, use B10*.027.)

Reference no: EM132374535

Questions Cloud

Determine the profitability organizational arrangements : Assignment Description - This assignment is intended to determine the efficiency and profitability of different organizational arrangements
What are symptoms of groupthink : What are symptoms of groupthink, and how can you assure groupthink will not become a problem in your meeting?
Explain the conflict resolution skills displayed by leader : Explain the conflict resolution skills displayed by the leader in the scenario. On a scale of 1-10, how would you rate those of the leader?
Explain the role of the community health nurse : Explain the role of the community health nurse (case finding, reporting, data collection, data analysis, and follow-up) and why demographic data are necessary.
Calculate her gross monthly sales commissions : The rule is that she gets a 2.7% commission on the total sales amount every month, and she receives 3.5% if her sales exceeded $80,000 in a given month.
If you were asked to advise a private employer : If you were asked to advise a private employer (with no government contracts) of its equal employment opportunity responsibilities, what would you say?
Amazon com competitive strategy : What do you think is Amazon.com's competitive strategy? Justify your answer.
Define the escalation of commitment phenomenon : Define the escalation of commitment phenomenon, and some key strategies a manager can use to avoid the escalation of commitment cycle?
Give several examples of logical fallacies : Give several examples of logical fallacies that you find in commercials on television and why they are fallacies.

Reviews

Write a Review

Business Management Questions & Answers

  Controversies regarding reimbursement for telemedicine

There are many controversies regarding reimbursement for telemedicine services. Imagine that you are negotiating with an insurance carrier to obtain

  High performance organizations hpowhat is the difference

high performance organizations hpowhat is the difference between groups and high performance organizations hpo? how can

  Labor market were in market-clearing equilibrium

Suppose a particular labor market were in market-clearing equilibrium. What could happen to cause the equilibrium wage to fall?

  About the business''s approach toward ethics and social

about the business's approach toward ethics and social responsibility

  Show what are the inherent conflicts and how would they be

show what are the inherent conflicts and how would they be mitigated? how can management work to make good decisions

  New venture for a venture capitalist investora venture

new venture for a venture capitalist investora venture capitalist has expressed interest in potentially funding the new

  How does the interviewee handle change management

How does the interviewee handle change management

  Write a research paper on the topic managing stress

Write a research paper on the topic "Managing Stress". Your paper should be 3-5 pages in length NOT including the cover and reference page.

  Describe lewins three- step change process

Describe Lewins three- step change process. How is it different from the change process needed in the white - water rapids metaphor of change?

  Solicitation provision

Trying to condensed the section below, so I can have a better understanding. 7.202 Policy, summarize the information in that section, and so on : 7.203, 7.204

  What coefficients signs would be essential

What coefficients signs would be essential to see the type of relationship the manager believes to be true?

  Calculate the probability of occurring

A coin is tossed twice. Calculate the probability of each of the following occurring, commenting briefly on the basis of your calculation:

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd