Departmental Analysis of Pay To Date Employer Name : Robert Redford Report Date & Time : 23/08/2010 14:37 Department : Admin Works No. Employee Name Total Gross Pay Taxable Gross Pay PAYE EE Net NIC EE Pension Net Payment 1 Conroy, Jane 26,670.00 26,560.00 8,613.30 951.28 110.00 16,255.42 8 Conroy, Jane 3,000.00 3,000.00 438.45 240.24 10.00 2,311.31 9 Grant, Hugh 4,000.00 4,000.00 658.45 350.24 10.00 2,981.31 10 Dean, James 3,600.00 3,600.00 570.45 306.24 10.00 2,713.31 Department Total : 37,270.00 37,160.00 10,280.65 1,848.00 140.00 24,261.35 Page 1 of 5 Department : Sales & Marketing Works No. Employee Name Total Gross Pay Taxable Gross Pay PAYE EE Net NIC EE Pension Net Payment 2 Grant, Hugh 23,560.00 23,450.00 7,369.30 920.18 110.00 14,754.52 Department Total : 23,560.00 23,450.00 7,369.30 920.18 110.00 14,754.52 Page 2 of 5 Department : Finance & Account Works No. Employee Name Total Gross Pay Taxable Gross Pay PAYE EE Net NIC EE Pension Net Payment 11 Archer, Jerrry 20,102.80 20,102.80 6,494.23 727.63 0.00 12,880.94 Department Total : 20,102.80 20,102.80 6,494.23 727.63 0.00 12,880.94 Page 3 of 5 Department : Operation / Production Works No. Employee Name Total Gross Pay Taxable Gross Pay PAYE EE Net NIC EE Pension Net Payment 5 Ford, Harrison 6,000.00 5,990.00 1,942.73 217.98 10.00 3,829.29 12 Hawn, Goldie 17,012.00 17,012.00 5,257.83 591.92 0.00 11,162.25 Department Total : 23,012.00 23,002.00 7,200.56 809.90 10.00 14,991.54 Page 4 of 5 Department : Support Works No. Employee Name Total Gross Pay Taxable Gross Pay PAYE EE Net NIC EE Pension Net Payment 3 Dean, James 19,527.28 19,417.28 5,756.10 879.85 110.00 11,933.19 4 Major, Tracy 24,700.00 24,590.00 7,825.30 931.58 110.00 15,518.12 Department Total : 44,227.28 44,007.28 13,581.40 1,811.43 220.00 27,451.31 Grand Total : 148,172.08 147,722.08 44,926.14 6,117.14 480.00 94,339.66 Page 5 of 5