1. calculate how much vacation time each employee will carry over to pay period 1 of the next year.
2. Prepare a pivot table report by the department that lists the names of the employees and the number of days of vacation time each will carry forward.
3. Prepare an example of an email you would write to the employee explaining how their carry-forward vacation time was calculated. 

Notes: 1 There are 26 pay periods in the year. 2 All employees have a usual work week of 5 days. 3 Vacation pay accrued to date is net of vacation time already taken this year. 4 Employees will continue to be employed for the 6 remaining pay periods in the year (there are no unpaid leaves or planned terminations) 5 The payroll system does not track vacation accruals in terms of days, only dollars, so dollar value is what the employee sees on their pay statements. 6 Employees are not permitted to carry over more than 10 days. 

Name	Department	Vacation pay accrual balance as of Pay period 20	Pay rate/hr	Usual working hours/week	Vacation entitlement/year (days)	Value of future scheduled vacation time
John	2000	$1,526	$ 20.00	35	21	$ 1,400.00
George	2000	$1,002	$ 25.00	40	22	$ 1,000.00
Sally	3000	$999	$ 32.00	20	20	$ 128.00
Andisheh	4000	$112	$ 18.45	35	30	$ 64.58
Gurpreet	4000	($506)	$ 19.33	35	20	$ -
Pat	4000	$88	$ 20.47	22	15	$ 122.82
Aviva	3000	190.73	$ 50.00	35	21	$ 700.00

Answer rating: 100% (QA)

To calculate how much vacation time each employee will carry over to pay period 1 of the next year d... View the full answer