Part 4: Describe features of payroll for KLE in WORD and Excel (15 marks 200 - 250 words for (a)) [CLR 3]

Background

Ken has been hiring part time workers and paying them as casual labour for each lawn they cut. The turnover rate is high and he is continually looking to replace workers. Finding good workers that will stay is a major headache for Ken. With KLEs steady business and a growing list of customers, Ken feels he can now hire a full-time person to help in all areas of the business. One of his current workers, Aiesha, would be the perfect person given her work ethic and friendly demeanor. He would pay Aiesha $500 a week to start. He is also on the verge of being able to offer a winter service so that he can provide Aiesha work year-round.

1. (3 marks) Complete in WORD 250 words. Given that Ken will have just the one employee now, what software would you suggest Ken use for KLEs payroll? Provide 3 reasons for your suggestion. (3 marks) Complete in WORD 250 words.

2. (12 marks) Complete in Excel Go to the Excel file, MGT2303 Final Project (you were working on in the previous parts of this project) Assume that Aieshas TD1 relates to column CC1. Use rates from the tax year 2020. Go the worksheet called For June, 2021

1. Calculate the weekly net pay for Aiesha showing all deductions (5 marks)

2. Assuming 4 weeks in a month, show KLEs detailed monthly remittance to the government (6 marks)

3. Assuming you are remitting for the June payroll, indicate the date the remittance is due (1 mark)

Calculate the weekly net pay for Alesha showing all deductions Calculate and show KLE's month remittance for lunees 2021 Payrol State the date the one payroll remittance is due Date the remittance is de Calculate the weekly net pay for Alesha showing all deductions Calculate and show KLE's month remittance for lunees 2021 Payrol State the date the one payroll remittance is due Date the remittance is de