ASSESSMENT BRIEF

Homework answers / question archive / ASSESSMENT BRIEF 6N4005 Payroll Manual & Computerised Brief Guidelines: Please find attached the details for Manual Payroll assignment 2

ASSESSMENT BRIEF 6N4005 Payroll Manual & Computerised Brief Guidelines: Please find attached the details for Manual Payroll assignment 2

Accounting

Share With

ASSESSMENT BRIEF

6N4005 Payroll Manual & Computerised

Brief Guidelines:

Please find attached the details for Manual Payroll assignment 2.

ASSIGNMENT 2

Company Name: May & Co. Ltd

Address: 22 The Business Park, Dundrum, Dublin 16.

Tax registration number: 22801265c

Company Directors: Conor May and Daniel June

You work in the accounts department of the company. You have the position of payroll administrator; you position requires you to maintain the company’s payroll system for 2019.

Instructions:

1. Payroll processing, process the payroll for the five employees from the data supplied.

2. Transfer Emergency tax to the cumulative system.

3. Use Microsoft Word or Excel templates sample on Moodle

Assignment Criteria

Marks

Accurate calculation on a manual payroll of 5 employees: gross pay, bonus, commission, overtime, holidays, benefit-in-kind, travel pass, health cover, sick pay, statutory redundancy, unpaid leave, reimbursed expenses, pension, statutory and non-statutory deductions.

Accurate processing of at least one employee who starts work for the first time mid-year.

Accurate processing of at least one employee who starts work mid-year with a P45 from a previous employment.

Accurate processing of at least one employee who leaves employment mid-year.

Accurate processing of at least one employee who has changes in tax credits and various thresholds which leads to an overpayment of tax

Accurate processing of at least one employee who has changes in tax credits and various thresholds which leads to an underpayment of tax.

Total

Employee no:	1
Name	Adam Smith
Address	15 Bradford Avenue Dublin 16
PPS Number	5558688T
Start Date with company	Nov 2019
Basic Wage (Monthly)	2,500
Basic Hours	40
Tax Type	Emergency
Cut-off point	-
Tax Credit	-
PRSI Class	A
Weekly deductions Health Insurance	120 Per month

Task:

Process Adam’s payroll for each Month from November.

Notes:

He pays €185 per month BIK for the private use of his car company.

Employee no:	2
Name	Sandra Lawlor
Address	11 The Woods, Sandymount, Dublin 4
PPS Number	8014625k
Start Date with company	Nov 2019
Basic Wage (Monthly)	3,300
Basic Hours	40
Tax Type	Temporary
Cut-off point	-
Tax Credit	-
PRSI Class	A
Pension Contribution	5%

Task:

Process Sandra’s payroll for each Month from November, RPN details Monthly

Cut-off €2,700 and tax credit €350

Notes:

The above employee is on Temporary Tax the employer is still waiting for confirmation of her allowance from ROS.

She was paid 16 Hours overtime in November at time and a half.

Sandra is ill for the week beginning 9th December and receives €112.80 in sick pay from welfare as she is not entitled to illness pay from the company.

She received a year-end Bonus of €660 in December

Sandra receives expenses for travelling in November €388 and € 144 in December.

Employee no:	3
Name	John Barnes
Address	5 Middle Avenue, Bray, Co. Wicklow.
PPS Number	4358678Q
Start Date with company	1^st November 2012
Basic Wage (Monthly)	3,500
Basic Hours	40
Tax Type	Normal
Cut-off point Monthly	3060
Tax Credit Monthly	415
PRSI Class	A
DOB	03/02/1971
Notice of Termination	31/03/2019

Task: Process John’s payroll for each Month this year till he leave the company.

Notes: John is made redundant on 31^st. May this year and receives statutory redundancy from the company.

Employee no:	4
Name	Alan Hope
Address	3 Main Street, Blackrock, Co. Dublin.
PPS Number	2452621Q
Start Date with company	March 2011
Basic Wage (Monthly)	2,750
Basic Hours	40
Tax Type	Normal
Cut-off point Monthly	2600
Tax Credit Monthly	286
PRSI Class	A
Annual Travel Pass	112 Per Month
Social Club	30 Per Month

Task: Process Alan’s payroll for each Month.

Notes:

Alan takes one month’s unpaid leave in March.

Alan’s tax credits are increased annually to €6,732 in April as his claim for Incapacitated Child Credit is successful.

Employee no:	5
Name	Joan O’Shea
Address	51 Dalkey Street, Blackrock, Co. Dublin.
PPS Number	3465221J
Start Date with company	March 2013
Basic Wages(weekly)	600
Basic Hours	40
Tax Type	Normal
Cut-off point weekly	710
Tax Credit Weekly	86
PRSI Class	A
Pension PRSA	5%

Task: Process Joan’s payroll for each Month.

Notes: She earns the following commissions throughout the year, paid in the last week of each month.

Jan €150

Feb €300

March €400

April €300

May €700

June €450

July 0

Aug €200

Sept €800

Oct €400

Nov €450

Dec €250

In July Joan’s tax credits are changed to €3432 per annum and cut off € 31,200 per annum due to mistake.

She takes the last three weeks in June as her holiday and receives holiday pay.

Option 1

Low Cost Option

Download this past answer in few clicks

22.99 USD

PURCHASE SOLUTION

Already member? Sign In

Option 2

Custom new solution created by our subject matter experts

GET A QUOTE

rated 5 stars

Purchased 3 times

Completion Status 100%

ASSESSMENT BRIEF 6N4005 Payroll Manual & Computerised Brief Guidelines: Please find attached the details for Manual Payroll assignment 2

Accounting