Calculate her gross monthly sales commissions

Assignment Help Business Management
Reference no: EM132375993

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: EM132375993

Questions Cloud

What are the regulations and policies for access control : What are the issues and root causes that necessitates the enactment and/or establishment of Federal, state and local government laws, and the establishment.
Do bit of research on the hearsay rule in legal proceedings : Do a bit of research on the hearsay rule in legal proceedings. Explain the hearsay rule and describe how it relates to the concept of an expert witness.
Which interpretation do you find more compelling : Some critics view Edna's suicide at the end of the novel as a failure to complete her escape from convention-an inability to defy society once stripped.
Write a brief discussion describing the terrorism attack : Write a brief Discussion describing the terrorism attack and it's aftermath. Comment on ways the attack could have been prevented.
Calculate her gross monthly sales commissions : 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
About theoretical or conceptual framework for your study : You are asked to spend time thinking about the theoretical or conceptual framework for your study.
Write report about their understanding of business research : Holmes Institute-Australia-HI6008 Business Research Project-The Research Design and Methodology is to ensure each student is able to contribute to construction.
Industry evolve into a profitable business : What is necessary to have sport industry evolve into a profitable business? Please provide specific examples.
How could jack''s perception of eileen performance : How could Jack's perception of Eileen's performance affect his leader behaviors when interacting with her?

Reviews

Write a Review

Business Management Questions & Answers

  Describe the objectivist and subjectivist approaches

Describe the objectivist (positivist) and subjectivist (interpretivist) approaches to the understanding the nature of reality. include an example for each.

  Question regarding the long-term incentives

Please provide an example how long term incentive plans have helped a company meet their strategic goals. Explain whether or not you believe most long term incentives are attainable.

  Leading organizations and people

What implications does studying "Leading Organizations and People" have on your SMART goal, career aspirations, and short-term developmental skills progress?

  Overview of the evolution of business ethics in america.

The first part of your reading in Daniel Terris' book will include an overview of Lockheed Martin's organization and will lay out the research plan that Terris used to obtain information necessary for his work. This will be followed by a genera..

  Change in real money balance

For a country A, the GDP growth rate is 8 percent and inflation is 4 percent. If the velocity of money remains constant, what is the change in real money balance?

  Locate or develop a team diagnostic survey

Locate or develop a team diagnostic survey. Upload the survey. How does it reflect the common team problems discussed in this chapter? What additional questions would you ask on such a survey?

  How are the needs for affiliation

How are the needs for affiliation, intimacy, and power similar to and different from needs for inclusion, control and affection?

  What is her opportunity cost for buying the business

Her next best option is buying a CD. Current CD rates are at 2%. What is her opportunity cost for buying the business?

  Generate ideas using the concepts

Generate ideas using the concepts and theories related to entrepreneurship and innovation

  Drivers for a firewire

What factors must you consider about a system when selecting I/O devices? For example, think about compatibility.

  Outline the organization mission

A leader must develop and outline the organization's mission, vision, strategies, and goals, and then communicate these to employees, stakeholders, the public, and regulatory agencies, to name a few.

  Procedure on staff requirement assessment

Staff requirement in an organization is an important function. Prepare a standard operating procedure on staff requirement assessment and recruitment.

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