Sunlight Computing wants to give each member of the sales team a small gift to honor his/her
Question:
Sunlight Computing wants to give each member of the sales team a small gift to honor his/her performance over the past year. The HR Manager gives her analyst the spreadsheet on the left that has the employee number of each employee and the employee's contribution to sales. She asks the analyst to fill in the Gift column with an indication of the type of gift to be given to the employee according to the following scheme:
If an employee's contribution is less than $22,000, he/she gets a pen with the Sunlight logo on it.
If an employee's contribution is between $22,000 and $64,000, the employee gets a money clip with the Midnight logo.
If an employee's contribution is between $64,000 and $106,000, the employee gets a large mug.
Contributions of $106,000 or more are to be recognized with a plaque.
According to the above, enter in column C the appropriate gift to be awarded to each employee, i.e., enter Pen, Clip, Mug or Plaque