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 are the main reasons why women frequently invested less in-on-the-job training than men? What changed this tendency?* What government or employer policies would be likely to accelerate this...
-
What are three technologies or techniques that significantly increase the security of a wireless network? Explain your answer.
-
Consider the automobile gasoline mileage data in Table B.3. a. Build a linear regression model relating gasoline mileage \(y\) to engine displacement \(x_{1}\) and the type of transmission...
-
Eberts Printing Company completed the following transactions during the year ended December 31: June 16 Received a 60-day, 5.5 percent note, dated June 16, for $ 2,160 from Carlos Office Supply for...
-
Consider the recorded transactions below. Transaction Account Name Debit Credit 1. Accounts Receivable 7,400 Service Revenue 7,400 2. Supplies 1,800 Accounts Payable 1,800 3. Cash 9,200 Accounts...
-
Read the Workplace Policies and Procedures Example - Pinkies Pizza and Pasta A: You witness a fellow staff member cough into his hand. The staff member then picks up pre-made sandwiches (without...
-
On March 23, 2021 GME stock price closed at 181.75. After the closing bell, GME released earnings and immediately the stock jumped but later on an earnings call the stock began to plummet. The...
-
Exercise Drill No. 4 The income statement of a taxpayer sales, net of returns, allowances and discounts Less : Cost of Sales Gross income from operations Add: other income machinery Gain on sale of...
-
American Technologies, Inc. 1. American Technologies, Inc. provides an array of services to enhance a customer's cloud computing, storage and networking resources. At the close 2021, it reported the...
-
53. A taxpayer collected the following passive income during the year: Passive income Interest income from banks P300,000 Royalties from books Philippines Rent properties 200,000 400,000 Abroad...
-
Using the monthly return data given is the geometric mean excess return? what
-
The most recent financial statements for Locke, Inc., are shown here: INCOME STATEMENT BALANCE SHEET Assets $131,700 Debt $43,500 Sales Costs $62,000 51,400 Equity 88,200 Taxable $ 10,600 Total...
-
A 5-year Treasury bond has a 4.9% yield. A 10-year Treasury bond yields 6.45%, and a 10-year corporate bond yields E inflation will average 3% over the next 10 years (IP103%). Assume that there is no...
-
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
-
Verify that the log-likelihood of model (7.7) is \(\sum_{i=1}^{k}\left[n_{i} \lambda-\exp (\lambda) ight]\). (a) Compute MLE of \(\lambda\). (b) Compute the Pearson chi-square statistic and compare...
-
Think about the general concept of a relationship, not necessarily in a business setting, but just relationships in general between any two parties. What aspects of relationships are inherently...
-
What is value? In what ways does a relationship selling approach add value to your customers, to you the salesperson, and to your sales organization?
Study smarter with the SolutionInn App