Central Corporation has six sales people. The following sales results by quarter for the year are...

 

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.

Answer rating: 100% (QA)

Note It is apparent from the reading of Task D that Average Quarter... View the full answer