BIS 155 Final Exam - Latest Version

For Order This And Any Other Course, Assignments, Discussions, Quizzes, Exams,

Test Banks And Solutions Manuals

Contact us At whisperhills@gmail.com

Or Visit Our website Acehomework.net

1. (TCO 1) Create a payment account for the employees in a supermarket. To do this maintain a record of the employees information, department, wages and include the number of hours of work invested by them individually. Additionally include the wages per hour to calculate the total daily wages of each worker. Perform the following tasks:

Part 1. Describe how to create an Excel workbook for payroll showing employee name, department, number of hours of work for a week taking into account regular hour and overtime hours (paying one and a half time of salary rate and double the rate for more than 55 hours of work (use appropiate formulas for calculations).

Part 2. Describe how to calculate the total wasges for each employee and grand total for all employees using Excel formulas.

Part 3. Describe how to sort the list in descending order of the total wages.

Part 4. Describe how to apply the concept of 3R's in your worksheet.

Part 5. Describe how to create a chart showing the wages per department.

(Points 40).......................