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...
-
What responsibility do you think e-marketers should assume for helping to close the digital divide? Do you think consumers and governments should assume some responsibility, as well? Explain your...
-
________ stock is the type of stock issued by a corporation when only one class of stock is issued. a. Preferred b. Common c. Capital d. Dividend
-
Everlast Batteries Inc. has hired you as a consultant. The firm had after-tax operating earnings in 1998 of $180 million and net income of $100 million, and it paid a dividend of $50 million. The...
-
Nicholson Roofing Materials, Inc., is considering two mutually exclusive projects, each with an initial investment of $150,000. The companys board of directors has set a maximum 4-year payback...
-
Tucker Company makes chairs. Tucker has the following productionbudget for January - March. January February March Units Produced9,612 10,597 11,002 Each chair produced uses 4 board feet of wood.Ma 2...
-
Selected transactions for M. Acosta, an interior decorator, in her first month of business, are as follows. Jan. 2 Invested $10,000 cash in business. 3 Purchased used car for $3,000 cash for use in...
-
17. Which of the following pairs of compounds are identical? CI wf- CH3 (a) F CH3 + Br A H Br- (c) + F CH3 CH3 H -Br F Br H H (b) (d) H H -H + + H CI- I HI H H H
-
You opened a savings account five years ago and deposited $500 at that time. The following year, you added another $400 to the account. You did not add any more money until today when you deposited...
-
Oil is siphoned from the bottom of an atmospheric ( open ) feeding tank to a lower level tank through a 2 c m diameter pipe 4 0 m in length. The bottom of the feeding tank is 1 . 5 m above the exit...
-
Can you elaborate on the mechanisms of localized corrosion, such as pitting and crevice corrosion, and discuss the microstructural and environmental conditions that contribute to their initiation and...
-
Answer the questions using the following graph. D 20 B 27 5 F 8 14 A E 17 12 30 10 G 15 7 G (a) Draw the sequence of edges (represented by edge weight) added to the minimal-cost spanning tree...
-
Which has a greater impact on effective patient care ethics or law? justify your answer.
-
The average student took 1 hour and 15 minutes to complete Quiz 1 and 1 hour to complete Quiz 2. According to the Learning Curve methodology, how long will it take for an average student to complete...
-
(a) Explain why the concentration of dissolved oxygen in freshwater is an important indicator of the quality of the water. (b) How is the solubility of oxygen in water affected by increasing...
-
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
-
The trial balance of Jeremina plc as at 31 March 2002 is as follows: (i) Stock of finished goods on 31 March 2002 163,000. (ii) Motor expenses and depreciation on motors to be apportioned:...
-
You are Br erired: with the following information relating to Plott plc for the year to 31 March 2011: Additional information: 1. The above information has been obtained after the compilation of the...
-
The following information has been extracted from the books of Quire plc as at 30 September 2011. The following additional information is to be taken into account: 1. Stocks at 30 September 2011 were...
Study smarter with the SolutionInn App