Excel projects

SALARY PAYROLL FOR SUNRISE LIMITED

Salary insight for Sunrise Limited was generated for the month of January. The payroll shows hourly wage of each employee, normal hours worked for the week, overtime hours worked for the week, 25 % overtime bonus pay and total amount earned by each employee for the month of January.

From the insight generated, the highest earning employee and the least earning employee was known.

EMPLOYEE GRADE BOOK FOR SUNRISE LIMITED

The employees were graded based on the following parameters; safety test, company philosophy test, financial scales test, and drug test. The percentage performance of each employee was generated and the decision on which employee to fire was made. The points scored were visualized with the appropriate chart.

From the insight generated, the best performing employer was known and the least performing was also determined. The decision on which employee to fire was easily made.