Question: solve this question im stuck in the question Using excel create a data base for the Food and Beverage department at Reggae Foods Ltd. The

solve this question im stuck in the question Using excel create asolve this question im stuck in the question

Using excel create a data base for the Food and Beverage department at Reggae Foods Ltd. The company has three (3) fortnightly paid workers Nicholas, Patrice and Evan. Each employee receives a non-taxable uniform allowance of 83,000 per annum. Patrice has a credit union deduction (CRM Credit Union Ltd) of 3500 per week. Patrice has a JNBS Mortgage deduction of $8000 per fortnight. . All employees pay trade union dues (STEM Trade Union) of $150 per month. Nicholas receives a non-taxable travel allowance of $4400 per fortnight. . All employees contribute 5% of their basic pay as pension contribution, while the employer contributes 10% (HEART Levy). The normal working week is 40 hours. Additional payroll data for the fortnight ended 15 April 2019 is as follows: Employee Weekly rate Total hours worked Overtime hours paid: Nicholas Grant 4600 108 hours Patrice Smith 7900 120 hours Evan Douglas 6000 86 hours 2 hours 8 hours 2 hours Double Triple 4 hours 3 hours 4 hours 5 hours 2 hours a. For Nicholas, Patrice and Evan ( fortnight ended 15 January 2021) I. Compute net pay; II. Prepare pay advise slips; III. Draw pay cheques; and IV. Draw cheques for statutory and non-statutory deductions. (30 marks) (9 marks) (3 marks) (8 marks) b. Prepare a statement detailing total payroll costs for the fortnight ending 15 January 2021. (5 marks) Using excel create a data base for the Food and Beverage department at Reggae Foods Ltd. The company has three (3) fortnightly paid workers Nicholas, Patrice and Evan. Each employee receives a non-taxable uniform allowance of 83,000 per annum. Patrice has a credit union deduction (CRM Credit Union Ltd) of 3500 per week. Patrice has a JNBS Mortgage deduction of $8000 per fortnight. . All employees pay trade union dues (STEM Trade Union) of $150 per month. Nicholas receives a non-taxable travel allowance of $4400 per fortnight. . All employees contribute 5% of their basic pay as pension contribution, while the employer contributes 10% (HEART Levy). The normal working week is 40 hours. Additional payroll data for the fortnight ended 15 April 2019 is as follows: Employee Weekly rate Total hours worked Overtime hours paid: Nicholas Grant 4600 108 hours Patrice Smith 7900 120 hours Evan Douglas 6000 86 hours 2 hours 8 hours 2 hours Double Triple 4 hours 3 hours 4 hours 5 hours 2 hours a. For Nicholas, Patrice and Evan ( fortnight ended 15 January 2021) I. Compute net pay; II. Prepare pay advise slips; III. Draw pay cheques; and IV. Draw cheques for statutory and non-statutory deductions. (30 marks) (9 marks) (3 marks) (8 marks) b. Prepare a statement detailing total payroll costs for the fortnight ending 15 January 2021

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!