Part 2 Column Chart and Other Statistics (5 marks) (a) Create a Column chart to show the distribution of Net Salary paid to each staff. (b) (3 marks) Use the Excel function of "SUMIF" to compute the Total Gross Salary for staff having the age of 50 and below. (2 marks) Part 3-Computation of Loans (5 marks) The management has recently approved a 10-years study loan for one of the staff member who wanted to pursue his post-graduate studies. The total amount of the loan is $55,000 at a very favourable annual interest rate of 2.38%. The management has decided to deduct the repayment of the loan by following an affordable monthly installment plan over 120 months from the staff's monthly salary. You are required to demonstrate how to use the PMT function in Excel to compute the monthly loan repayment amount to be deducted from the staff's salary. (5 marks). 3 Part 1-Computation of Salaries using Excel (20 marks) Time-in-Motion Pte Ltd is a fast-growing local watch retailer that offers a wide range of internationally recognised brands of watches. The company has been well known for offering the most extensive range of fashion and branded watches at competitive prices. The company currently has a physical retail store located in the Paragon Shopping Centre at Orchard Road. All staff members of the company are paid according to their basic monthly pay plus an incentive component based on their overall sales for the month. The performance incentive is computed based on an additional percentage of their basic pay if they were able to achieve the minimum amount of targeted overall sales amount indicated in the Performance Incentives table below. You are required to develop a worksheet to compute the monthly payroll of the staff members using MS Excel. Staff Salary Table Date of Birth Date Joined Basic Salary Overall Sales Per Month Staff Name ID for the month S01 Elena Tan 20/01/1968 01/02/2010 $3500 $8000 S02 Faith Chan 08/08/1990 15/01/2015 $2000 $6000 S03 Gabriel 10/02/1978 01/07/2010 $3000 $12000 Monteiro S04. Haslinda Bte Kashim 15/12/1959 15/08/2013 $2500 $6000 S05 Isabella Gan 01/07/1986 01/03/2010 $3300 $10000 Performance Incentive Table Overall Monthly Performance Incentive Sales in $ 0 to 3999 4000 to 5999 6000 to 7999 8000 to 9999 10000 and above Additional 0% of basic pay for the month Additional 2% of basic pay for the month Additional 4% of basic pay for the month Additional 6% of basic pay for the month Additional 8% of basic pay for the month 1