Central Corporation has six sales people. The following sales results by quarter for the year are...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Central Corporation has six sales people. The following sales results by quarter for the year are given below: Total Quarter 1 Quarter 2 Quarter 3 Quarter 4 Annual Sales Sales Sales Sales Sales Task A Task B Task C Task D Salesperson Tasker 85,000 $ 88,000 S 81,000 S 86,000 S 340,000 TRUE TRUE 34,000 Willingham 74,000 72,000 68,000 76,000 290,000 FALSE TRUE 15,000 7,400 Jensen 282,000 74,000 71,000 81,000 71,000 69,000 68,000 FALSE TRUE Vogel 70,000 68,000 72,000 281,000 FALSE TRUE 332,000 256,000 Lin 84,000 82,000 85,000 TRUE TRUE 33,200 Fletcher 61,000 64,000 66,000 65,000 FALSE FALSE Instructions: Perform the following tasks using Excel's logical functions. Task A: (2 points) Identify the sales people who had sales greater than $70,000 in all four quarters of the year. Use the AND function. Task B: (2 points) Identify the sales people who had sales greater than $70,000 in at least one quarter during the year. Use the OR function. Task C: (2 points) Any sales person who had average quarterly sales greater than $72,000 are entitled to a 10% bonus on their average quarterly sales. Compute the bonus for those sales people entitied to the bonus. The result for those not entitled to the bonus should be a zero. Use the IF function. Task D (5 points): Any sales person who had average quarterly sales of at least $80,000 qualifies for a 12% commission on average quarterly sales. Any sales person who does not have average quarterly sales of at least $80,000 can still qualify for a 5% commission on their average quarterly sales in one of two ways: (1) if the sales person had sales of at least $75,000 in one quarter of the year or (2) if the sales person had average quarterly sales greater than $70,000 and sales in at least one quarter of the year greater than $72,000. Compute the commission for those sales people entitied to the bonus. The result for those not entitled to the bonus should be a zero. Use nested functions of your choice. Grading: Each correct answer is worth 1 point. Central Corporation has six sales people. The following sales results by quarter for the year are given below: Total Quarter 1 Quarter 2 Quarter 3 Quarter 4 Annual Sales Sales Sales Sales Sales Task A Task B Task C Task D Salesperson Tasker 85,000 $ 88,000 S 81,000 S 86,000 S 340,000 TRUE TRUE 34,000 Willingham 74,000 72,000 68,000 76,000 290,000 FALSE TRUE 15,000 7,400 Jensen 282,000 74,000 71,000 81,000 71,000 69,000 68,000 FALSE TRUE Vogel 70,000 68,000 72,000 281,000 FALSE TRUE 332,000 256,000 Lin 84,000 82,000 85,000 TRUE TRUE 33,200 Fletcher 61,000 64,000 66,000 65,000 FALSE FALSE Instructions: Perform the following tasks using Excel's logical functions. Task A: (2 points) Identify the sales people who had sales greater than $70,000 in all four quarters of the year. Use the AND function. Task B: (2 points) Identify the sales people who had sales greater than $70,000 in at least one quarter during the year. Use the OR function. Task C: (2 points) Any sales person who had average quarterly sales greater than $72,000 are entitled to a 10% bonus on their average quarterly sales. Compute the bonus for those sales people entitied to the bonus. The result for those not entitled to the bonus should be a zero. Use the IF function. Task D (5 points): Any sales person who had average quarterly sales of at least $80,000 qualifies for a 12% commission on average quarterly sales. Any sales person who does not have average quarterly sales of at least $80,000 can still qualify for a 5% commission on their average quarterly sales in one of two ways: (1) if the sales person had sales of at least $75,000 in one quarter of the year or (2) if the sales person had average quarterly sales greater than $70,000 and sales in at least one quarter of the year greater than $72,000. Compute the commission for those sales people entitied to the bonus. The result for those not entitled to the bonus should be a zero. Use nested functions of your choice. Grading: Each correct answer is worth 1 point.
Expert Answer:
Answer rating: 100% (QA)
Note It is apparent from the reading of Task D that Average Quarter... View the full answer
Related Book For
Posted Date:
Students also viewed these general management questions
-
A certain reaction A + B C + D has one reactant, B, that has a characteristic color. When the system at equilibrium is heated up, the B color diminishes. a) What does that tell us about the...
-
The reaction A + B C + D is at equilibrium for = 0.1. What does this tell you about the variation of G pure with ?
-
a) Let a < b and c < d be real numbers. Sketch a graph of the rectangle [a, b] [c, d] := {(x, y) : x [a, b], y [c, d]}, and decide whether this set is connected. Explain your answers, b) Sketch a...
-
A company sells four types of gift packages. The cost per unit and demand for each package type is shown in the table below. A fixed cost of $1,000 is also incurred for each different type of gift...
-
How do defensive market strategies contribute to the long-run share position and profit performance for a company like General Motors?
-
What is the field inside a 2.00-m-long solenoid that has 2000 loops and carries a 1600-A current? Strategy To find the field strength inside a solenoid, we use B = 0 nI. First, we note the number of...
-
A study found that the smartphones made by a certain manufacturer had a failure rate of 43%. Four smartphones made by this manufacturer are selected at random. Find the probability that the fourth...
-
Target Corporation prepares its financial statements according to U.S. GAAP. Targets financial statements and disclosure notes for the year ended February 3, 2018, are available in Connect. This...
-
CASE STUDY: PROFITS AND THE EVOLUTION OF THE COMPUTER INDUSTRY. When profits in a given industry are higher than in other industries, new firms will attempt to enter that industry. CASE STUDY:...
-
1. a. How much did the materials cost per unit change between June and July? b. How much did the conversion cost per unit change between June and July? 2. Which is the optimal choice of material and...
-
The Circle R golf pro shop uses a markup rate of 3 9 % on a set of Tour Pro golf clubs that costs the shop $ 2 1 0 . What is the selling price?
-
Explain how judges bargain and negotiate on collegial courts.?
-
Question 3: Given m = 0110 and n = 1100 in two's complement notation (ie., m = 6 and n = - - 4). Show your working on computation of the product p = m n using Booth's algorithm. Also, verify your...
-
Monthly Salary: $5,000 Deposit: 2% of monthly salary towards college account Yearly Salary: increases by 1% every year College Account is paying 4% interest compounded monthly. How much money will...
-
Develop an AI-powered recommendation system that personalizes content for users based on their behavior and preferences. The system should be scalable, handle a large user base, and provide real-time...
-
Suppose the risk-free rate (Rf) is 3.64% and an analyst assumes a market risk premium (Rm - Rf) of 7.50%. Firm A just paid a dividend of $1.05 per share (i.e., DO = 1.05). The analyst estimates the...
-
How long does it take a car traveling 18 m/s at 40 degrees west of north to go 900m West?
-
By referring to Figure 13.18, determine the mass of each of the following salts required to form a saturated solution in 250 g of water at 30 oC: (a) KClO3, (b) Pb(NO3)2, (c) Ce2(SO4)3.
-
Why is the radial probability function rather than * (r) (r) r 2 sin dr d d the best measure of the probability of finding the electron at a distance r from the nucleus?
-
Calculate the longest and the shortest wavelength observed in the Balmer series.
-
Is the total energy wave function An eigenfunction of any other operators? If so, which ones? What are the eigenvalues? 2. 572 W310(r. 0, ) cose -r/3a, .2 81 af do ao
-
For a 2000-line encoder sampled at 5 kHz, what is the speed resolution absent filtering?
-
a. What are the two advantages of resolvers over encoders? b. What are the two advantages of encoders over resolvers?
-
What servo drive configuration is the least intelligent? And the most intelligent?
Study smarter with the SolutionInn App