payroll project 2014

8/9/2019 Payroll Project 2014

1/58

Excel Instructions using Excel 2010:CAUTION: Read Appendix B for specic instructions relating to t!ese te"plates#

1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer.

2. A formula begins with an euals sign (!) and can consist of any of the following elements" #perators such as $ (for addition)% & (for subtraction)% * (for multiplication)% and / (for di'ision). ell references% including cell addresses such as 2% as well as named cells and ranges +alues and te,t -orksheet functions (such as 0)

. ou can enter a formula into a cell manually (typing it in) or by pointing to the cells. 3o enter a formula manually% follow these steps"

0o'e the cell pointer to the cell that you want to hold the formula. 3ype an euals sign (!) to signal the fact that the cell contains a formula. 3ype the formula% then press Enter.

14.5 , 1.!25.64. 3he template will display and hold 25.67% not 25.64. 3here is no need to use E,cel8s rounding function.

. 9emember to sa'e your work. -hen sa'ing your workbook% E,cel o'erwrites the pre'ious copy of your :le. ou can sa'e your work at any time. ou can sa'e the :le to the current name% or you may want to keep multiple 'ersions of your work by sa'ing each successi'e 'ersion under a di;erent name.3o sa'e to the current name% you can select 4>short>'ersion>our>?ame.,ls,3o sa'e under a di;erent name% follow these steps"

elect


2/58

JOURNAL

DATE DESCRIPTION DEBIT CREDIT

20--

Oct. 9 Payroll Cash 12 11,097.25 Cash 11 11,097.25

9 Administrative Salaries 51 2,307.9O!!ice Salaries 52 3,353.0"Sales Salaries 53 3,00.00Plant #a$es 5% %,902.00 &'CA (a)es Paya*le - OAS+' 20.1 "7".09 &'CA (a)es Paya*le - ' 20.2 205.37 mloyees &'( Paya*le 2% 95.00 mloyees S'( Paya*le 25 %3%."2 mloyees S/(A Paya*le 25.1 9.9% mloyees C'( Paya*le 2 55.30 /nion +es Paya*le 2" 1.00 Payroll Cash 12 11,097.25

9 Payroll (a)es 5 1,231.1% &'CA (a)es Paya*le - OAS+' 20.1 "7".09 &'CA (a)es Paya*le - ' 20.2 205.3 &/(A (a)es Paya*le 21 19." S/(A (a)es Paya*le - mloyer 22 12".01

20 mloyees S'( Paya*le 25 %3%."2 Cash 11 %3%."2

23 Payroll Cash 12 11,173."9 Cash 11 11,173."9

Page 41

POST.

REF.


3/58

JOURNAL


20--

Oct. 23 Administrative Salaries 51 2,307.9O!!ice Salaries 52 3,353.0"Sales Salaries 53 3,00.00Plant #a$es 5% 5,223.92 &'CA (a)es Paya*le - OAS+' 20.1 "9".05 &'CA (a)es Paya*le - ' 20.2 210.0%

mloyees &'( Paya*le 2% 997.00 mloyees S'( Paya*le 25 %%%.70 mloyees S/(A Paya*le 25.1 10.1 mloyees C'( Paya*le 2 5".95 ro 'nsrance Premims Collected 27 15.90 /nion +es Paya*le 2" 1.00 Payroll Cash 12 11,173."9

23 Payroll (a)es 5 1,2%1.25

&'CA (a)es Paya*le - OAS+' 20.1 "9".05 &'CA (a)es Paya*le - ' 20.2 210.03 &/(A (a)es Paya*le 21 5.1 S/(A (a)es Paya*le - mloyer 22 12".01

ov. % mloyees S'( Paya*le 25 %%%.70 Cash 11 %%%.70

/nion +es Paya*le 2" 32.00

Cash 11 32.00

Page 42

POST.REF.


4/58

JOURNAL


20--

ov. Payroll Cash 12 10,937.71 Cash 11 10,937.71

Administrative Salaries 51 2,307.9O!!ice Salaries 52 3,320.79Sales Salaries 53 3,00.00

Plant #a$es 5% %,902.00 &'CA (a)es Paya*le - OAS+' 20.1 "7.09 &'CA (a)es Paya*le - ' 20.2 20%.90 mloyees &'( Paya*le 2% 1,097.00 mloyees S'( Paya*le 25 %33."3 mloyees S/(A Paya*le 25.1 9.92 mloyees C'( Paya*le 2 555.03 /nion +es Paya*le 2" 1.00 Payroll Cash 12 10,937.71

Payroll (a)es 5 1,157.25 &'CA (a)es Paya*le - OAS+' 20.1 "7.09 &'CA (a)es Paya*le - ' 20.2 20%."9 &/(A (a)es Paya*le 21 2.22 S/(A (a)es Paya*le - mloyer 22 7%.05

13 Payroll Cash 12 1,%1"."7 Cash 11 1,%1"."7

Page 43

POST.REF.


5/58

JOURNAL


20--

ov. 13 O!!ice Salaries 52 2,079.32 &'CA (a)es Paya*le - OAS+' 20.1 12".92 &'CA (a)es Paya*le - ' 20.2 30.15 mloyees &'( Paya*le 2% 3%0.00 mloyees S'( Paya*le 25 3."% mloyees S/(A Paya*le 25.1 1.%

mloyees C'( Paya*le 2 "1." ro 'nsrance Premims Collected 27 1%.%0 Payroll Cash 12 1,%1"."7

13 Payroll (a)es 5 159.07 &'CA (a)es Paya*le - OAS+' 20.1 12".92 &'CA (a)es Paya*le - ' 20.2 30.15

1 &'CA (a)es Paya*e-OAS+' 20.1 3,552.2"

&'CA (a)es Paya*le-' 20.2 "30."0mloyee &'( Paya*le 2% 1,92.00 Cash 11 ,3%5.0"

1 mloyee C'( Paya*le 2 1,125.25 Cash 11 1,125.25

1" mloyees S'( Paya*le 25 %97.7 Cash 11 %97.7

20 Payroll Cash 12 ",2"1.2" Cash 11 ",2"1.2"

20 Administrative Salaries 51 2,307.9O!!ice Salaries 52 2,112.9%Sales Salaries 53 3,00.00Plant #a$es 5% %,19.0 &'CA (a)es Paya*le - OAS+' 20.1 7"3.70

&'CA (a)es Paya*le - ' 20.2 1"3.30 mloyees &'( Paya*le 2% "1.00 mloyees S'( Paya*le 25 3"".0" mloyees S/(A Paya*le 25.1 "."7 mloyees C'( Paya*le 2 %9.50 ro 'nsrance Premims Collected 27 151.50 /nion +es Paya*le 2" 1.00

S'P4 Contri*tions Paya*le 29 1 50 00

Page 44

POST.REF.


6/58

JOURNAL


20--

ov. 20 Payroll (a)es 5 99%.%5 &'CA (a)es Paya*le - OAS+' 20.1 7"3.9 &'CA (a)es Paya*le - ' 20.2 1"3.2" S/(A (a)es Paya*le - mloyer 22 27.%"

Page 45

POST.REF.


7/58

JOURNAL


20--

Page 46

POST.REF.


8/58

JOURNAL


20--

Page 47

POST.REF.


9/58

JOURNAL


20--

Page 48

POST.REF.


10/58

GENERAL LEDGERCheckpoints

ACCOUNT: CASH ACCOUNT Debit Credit

Balance Balance

POST. BALANCE Oct. 31, 20-- 177,1%0.37

DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT ov. 30, 20-- 1%",057."120-- +ec. 31, 20--

Oct. 1 Balance a 199,"%.33

9 %1 11,097.25 1"",7%9.0"

20 %1 %3%."2 1"",31%.2

23 %1 11,173."9 177,1%0.37

ov. % %2 %%%.70 17,95.7

%2 32.00 17,3.7

%3 10,937.71 15,725.9

13 %3 1,%1"."7 1%,307.09

1 %% ,3%5.0" 157,92.01

1 %% 1,125.25 15,"3.7

1 %% %97.7 15,339.09

20 %% ",2"1.2" 1%",057."1

NO. 11


11/58

ACCOUNT: PAYROLL CASH ACCOUNT CheckpointsDebit Credit

POST. BALANCE Balance Balance

DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 0.00

20-- ov. 30, 20-- 0.00

Oct. 9 %1 11,097.25 11,097.25 +ec. 31, 20--

9 %1 11,097.25 0.00

23 %1 11,173."9 11,173."9

23 %2 11,173."9 0.00

ov. %3 10,937.71 10,937.71

%3 10,937.71 0.00

13 %3 1,%1"."7 1,%1"."7

13 %% 1,%1"."7 0.00

20 %% ",2"1.2" ",2"1.2"20 %% ",2"1.2" 0.00

NO. 12


12/58


13/58

ACCOUNT: FICA TAXES PAYABLE - OASDI ACCOUNT CheckpointsDebit Credit


DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 3,552.2"

20-- ov. 30, 20-- 3,577.%1

Oct. 9 %1 "7".09 "7".09 +ec. 31, 20--9 %1 "7".09 1,75.1"

23 %2 "9".05 2,5%.23

23 %2 "9".05 3,552.2"

ov. %3 "7.09 %,%2".37

%3 "7.09 5,30%.%

13 %% 12".92 5,%33.3"

13 %% 12".92 5,52.30

1 %% 3,552.2" 2,010.02

20 %% 7"3.70 2,793.72

20 %5 7"3.9 3,577.%1

NO. 201


14/58

ACCOUNT: FICA TAXES PAYABLE - HI ACCOUNT CheckpointsDebit Credit


DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- "30."0

20-- ov. 30, 20-- "3.7

Oct. 9 %1 205.37 205.37 +ec. 31, 20--9 %1 205.3 %10.73

23 %2 210.0% 20.77

23 %2 210.03 "30."0

ov. %3 20%.90 1,035.70

%3 20%."9 1,2%0.59

13 %% 30.15 1,270.7%

13 %% 30.15 1,300."9

1 %% "30."0 %70.09

20 %% 1"3.30 53.39

20 %5 1"3.2" "3.7

NO. 202


15/58


16/58


17/58

ACCOUNT: EMPLOYEES FIT PAYABLE ACCOUNT CheckpointsDebit Credit


DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 1,92.00

20-- ov. 30, 20-- 2,11".00

Oct. 9 %1 95.00 95.00 +ec. 31, 20--23 %2 997.00 1,92.00

ov. %3 1,097.00 3,059.00

13 %% 3%0.00 3,399.00

1 %% 1,92.00 1,%37.00

20 %% "1.00 2,11".00

NO. 2!


18/58

ACCOUNT: EMPLOYEES SIT PAYABLE ACCOUNT CheckpointsDebit Credit


DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- %%%.70

20-- ov. 30, 20-- 3"".0"

Oct. 9 %1 %3%."2 %3%."2 +ec. 31, 20--20 %1 %3%."2 0.00

23 %2 %%%.70 %%%.70

ov. % %2 %%%.70 0.00

%3 %33."3 %33."3

13 %% 3."% %97.7

1" %% %97.7 0.00

20 %% 3"".0" 3"".0"

NO. 2"


19/58

ACCOUNT: EMPLOYEES SUTA PAYABLE ACCOUNT CheckpointsDebit Credit



20-- ov. 30, 20-- %0.35

Oct. 9 %1 9.9% 9.9% +ec. 31, 20--23 %2 10.1 20.10

ov. %3 9.92 30.02

13 %% 1.% 31.%"

20 %% "."7 %0.35

NO. 2"1


20/58

ACCOUNT: EMPLOYEES CIT PAYABLE ACCOUNT CheckpointsDebit Credit



20-- ov. 30, 20-- 1,133.21

Oct. 9 %1 55.30 55.30 +ec. 31, 20--23 %2 5".95 1,125.25

ov. %3 555.03 1,"0.2"

13 %% "1." 1,71.9

1 %% 1,125.25 3.71

20 %% %9.50 1,133.21

NO. 2#


21/58

ACCOUNT: GROUP INSURANCE PREMIUMS COLLECTED ACCOUNT CheckpointsDebit Credit



20-- ov. 30, 20-- 331."0

Oct. 23 %2 15.90 15.90 +ec. 31, 20--ov. 13 %% 1%.%0 1"0.30

20 %% 151.50 331."0

NO. 2$


22/58

ACCOUNT: UNION DUES PAYABLE ACCOUNT CheckpointsDebit Credit



20-- ov. 30, 20-- 32.00

Oct. 9 %1 1.00 1.00 +ec. 31, 20--23 %2 1.00 32.00

ov. %2 32.00 0.00

%3 1.00 1.00

20 %% 1.00 32.00

NO. 2%


23/58

ACCOUNT: SIMPLE CONTRIBUTIONS PAYABLE ACCOUNT CheckpointsDebit Credit



20-- ov. 30, 20-- 1,50.00

ov. 20 %% 1,50.00 1,50.00 +ec. 31, 20--

NO. 2&


24/58

ACCOUNT: ADMINISTRATIVE SALARIES ACCOUNT CheckpointsDebit Credit


DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- %7,307.5

20-- ov. 30, 20-- 51,923.03

Oct. 1 Balance a %2,92.27 +ec. 31, 20--9 %1 2,307.9 %%,999.9

23 %2 2,307.9 %7,307.5

ov. %3 2,307.9 %9,15.3%

20 %% 2,307.9 51,923.03

NO. "1


25/58

ACCOUNT: OFFICE SALARIES ACCOUNT CheckpointsDebit Credit



20-- ov. 30, 20-- %2,59.21

Oct. 1 Balance a 2",350.00 +ec. 31, 20--9 %1 3,353.0" 31,703.0"

23 %2 3,353.0" 35,05.1

ov. %3 3,320.79 3",37.95

13 %% 2,079.32 %0,%5.27

20 %% 2,112.9% %2,59.21

NO. "2


26/58

ACCOUNT: SALES SALARIES ACCOUNT CheckpointsDebit Credit



20-- ov. 30, 20-- %2,925.00

Oct. 1 Balance a 2",525.00 +ec. 31, 20--9 %1 3,00.00 32,125.00

23 %2 3,00.00 35,725.00

ov. %3 3,00.00 39,325.00

20 %% 3,00.00 %2,925.00

NO. "'


27/58

ACCOUNT: PLANT AGES ACCOUNT CheckpointsDebit Credit


DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 52,7"3.22

20-- ov. 30, 20-- 2,30%."2

Oct. 1 Balance a %2,57.30 +ec. 31, 20--9 %1 %,902.00 %7,559.30

23 %2 5,223.92 52,7"3.22

ov. %3 %,902.00 57,"5.22

20 %% %,19.0 2,30%."2

NO. "!


28/58

ACCOUNT: PAYROLL TAXES ACCOUNT CheckpointsDebit Credit


DATE ITEM REF. DEBIT CREDIT DEBIT CREDIT Oct. 31, 20-- 1,%"5.2

20-- ov. 30, 20-- 1",79.39

Oct. 1 Balance a 1%,013.23 +ec. 31, 20--9 %1 1,231.1% 15,2%%.37

23 %2 1,2%1.25 1,%"5.2

ov. %3 1,157.25 17,%2."7

13 %% 159.07 17,"01.9%

20 %5 99%.%5 1",79.39

NO. "#

(A)ROLL REG*+,ER GLO-BR*


29/58

3 a r i t a l S t a t 0 s (ime 6ecord 6e$lar arnin$s Overtime arnin$s

A S ( # ( & S S ( # ( & S rs. Amont rs. Amont OAS+'

Payday, October 9, 20-- For Period Ending October 3, 20--onno, A. % " " " " " " " " " " "0 17.5 1,%12.00 1,%12.00 "7.5%&er$son, . 5 " " " " " " " " " " "0 2,250.00 2,250.00 139.50&ord, C. S 2 " " " " " " " " " " "0 900.00 900.00 55."0ann, +. % " " " " " " " " " " "0 1,350.00 1,350.00 "3.70O8eill, . 3 " " " " " " " " " " "0 2,307.9 2,307.9 1%3.0"6ssell, . S 1 " " " " " " " " " " "0 90.00 90.00 %2.7"6yan, . % " " " " " " " " " " "0 1".00 1,%%0.00 1,%%0.00 "9.2"So:o;s:i, (. 2 " " " " " " " " " " "0 2,050.00 2,050.00 127.10 , A l l o ; .

(otalarnin$s

6atePer

or

6atePer

or



30/58


A S ( # ( & S S ( # ( & S rs. Amont rs. Amont OAS+' 2 o .

# > , A l l o ; .

(otalarnin$s

6atePer

or

6atePer

or

6ssell, . S 2 " " " " " " " " " 7" 72.9% 72.9% %1.726yan, . % " " " " " " " " " " "0 1".00 1,%%0.00 1,%%0.00 "9.2"So:o;s:i, (. S 2 " " " " " " " " " " "0 2,050.00 2,050.00 127.10


31/58



32/58


A S ( # ( & S S ( # ( & S rs. Amont rs. Amont OAS+' 2 o .

# > , A l l o ; .

(otalarnin$s

6atePer

or

6atePer

or &er$son, . 5 " " " " " " " " " " "0 2".13 2,250.00 2,250.00 139.50&ord, C. S 2 " " " " " " " " " " "0 12.00 90.00 90.00 59.52ann, +. 0 " " " " " " " " " " "0 1."" 1,350.00 1,350.00 "3.70O8eill, . 3 " " " " " " " " " " "0 2"."5 2,307.9 2,307.9 3,"30.16yan, . 2 " 9 9 9 9 10 " " 9 " "0 1".00 1,%%0.00 7 27.00 1"9.00 1,29.00 101.00So:o;s:i, (. S 2 " " " " " " " " " " "0 25.3 2,050.00 2,050.00 127.10


33/58

A

Payday, October 9, 20--onno, A.&er$son, .&ord, C.ann, +.O8eill, .6ssell, .6yan, .So:o;s:i, (.


34/58

A6ssell, .6yan, .So:o;s:i, (.


35/58

A

Payday, November 20, 20--onno, A.&er$son, .&ord, C.ann, +.O8eill, .6ssell, .6yan, .So:o;s:i, (.


36/58

A&er$son, .&ord, C.ann, +.O8eill, .6yan, .So:o;s:i, (.


37/58

et Paid (a)a*le arnin$s 4a*or Cost


38/58

A6ssell, .6yan, .So:o;s:i, (.


39/58

A

Payday, November 20, 20--onno, A.&er$son, .&ord, C.ann, +.O8eill, .6ssell, .6yan, .So:o;s:i, (.


40/58

A&er$son, .

&ord, C.ann, +.O8eill, .6yan, .So:o;s:i, (.


41/58

A

Payday, October 9, 20--

onno, A.&er$son, .&ord, C.ann, +.O8eill, .6ssell, .6yan, .So:o;s:i, (.


42/58

A6ssell, .

6yan, .So:o;s:i, (.


43/58

A

Payday, November 20, 20--

onno, A.&er$son, .&ord, C.ann, +.O8eill, .6ssell, .6yan, .So:o;s:i, (.


44/58

A&er$son, .

&ord, C.ann, +.O8eill, .6yan, .So:o;s:i, (.


45/58

Plant i)er Oerator PA 000 00 3%"1 OO Anthony)O(6 ++/C('OS '&O6A('O SA4A6@ #>

6O/P 'S/6AC /'O +/S O(6 #4@ 6A( A44O#.

55,000 --.30> " each ayO/64@ 6A( 17.5

%O6(' 6 2.%"

20DDD 6/4A6 A6'S O6(' A6'S C//4A(' ++/C('OS

PA@+A@

6S. 6A( AO/( 6S. 6A( AO/(

A6'S &'CA

&'( S'( S/(A C'( S'P4

O(6

OAS+' ' ++/C('OS

@A6-(O-+A( 10,293.%0 1,02".0 11,322.00 701.9 1%.17 "10.00 3%7.59 7.93 %%%.73 21."0

1 10>9 "0 17.5 1,%12.00 0.00 12,73%.00 "7.5% 20.%7 %9.00 %3.35 0.99 55.% ".00

2 10>23 "0 17.5 1,%12.00 % 2.%" 105.92 1%,251.92 9%.11 22.01 59.00 %.0 1.0 59.2 2%.50

3 11> "0 17.5 1,%12.00 0.00 15,3.92 "7.5% 20.%7 %9.00 %3.35 0.99 55.% ".00

% 11>20 % 17.5 1,129.0 0.00 1,793.52 70.0% 1.3" 21.00 3%." 0.79 %%.37 2%.50

5 12>% 0.00

12>1" 0.00

E(6. (O(.

@6. (O(.

Checkpoint Checkpoint

+PA6(( OCC/PA('O #O6S '


46/58

O!!ice )ective Secretary PA 000-00-%57 &O6+ Catherine)O(6 ++/C('OS '&O6A('O SA4A6@ 2,0"0 >mo. #>

6O/P 'S/6AC /'O +/S O(6 #4@ 6A( %"0.00 A44O#.

37,000--.30>

O/64@ 6A( 12.00

2O6(' 6 1".0020DDD 6/4A6 A6'S O6(' A6'S C//4A(' ++/C('OS

PA@+A@

6S. 6A( AO/( 6S. 6A( AO/(

A6'S &'CA

&'( S'( S/(A C'( S'P4

O(6

OAS+' ' ++/C('OS

@A6-(O-+A( ,300.00 ,300.00 390.0 91.35 39.00 193.%1 %.%1 2%7.% 37."0

1 10>9 "0 900.00 7,200.00 55."0 13.05 2.00 27.3 0.3 35.35

2 10>23 "0 900.00 ",100.00 55."0 13.05 2.00 27.3 0.3 35.35 10.50

3 11> "0 900.00 9,000.00 55."0 13.05 2.00 27.3 0.3 35.35

% 11>20 "0 900.00 9,900.00 55."0 13.05 2.00 27.3 0.3 35.35 10.50

5 12>%

12>1"

E(6. (O(.

@6. (O(.


+PA6(( OCC/PA('O #O6S ' mo. #>6O/P 'S/6AC /'O +/S O(6 #4@ 6A( 75.00 A44O#.

53,000 -- .30>O/64@ 6A( 1.""

0O6(' 6

20DDD 6/4A6 A6'S O6(' A6'S C//4A(' ++/C('OS

PA@+A@

6S. 6A( AO/( 6S. 6A( AO/(

A6'S &'CA

&'( S'( S/(A C'( S'P4

O(6

OAS+' ' ++/C('OS

@A6-(O-+A( 5,%00.00 5,%00.00 33%."0 7".30 332.00 15.7" 3.7" 212.11 31.50

1 10>9 "0 1,350.00 ,750.00 "3.70 19.5" %3.00 %1.%5 0.95 53.03

2 10>23 "0 1,350.00 ",100.00 "3.70 19.5" %3.00 %1.%5 0.95 53.03 15.90

3 11> "0 1,350.00 9,%50.00 "3.70 19.5" 120.00 %1.%5 0.95 53.03

% 11>20 "0 1,350.00 10,"00.00 "3.70 19.5" "%.00 %1.%5 0.95 53.03 250.00 15.90

5 12>%

12>1"

. (O(.

. (O(.




47/58

President PA 000 00 153% O '44 oseh)O(6 ++/C('OS '&O6A('O SA4A6@ 0,000 >yr. #>

6O/P 'S/6AC /'O +/S O(6 #4@ 6A( 1,153."5 A44O#.

90,000 -- .30>

O/64@ 6A( 2"."5

3O6(' 6 20DDD 6/4A6 A6'S O6(' A6'S C//4A(' ++/C('OSPA@+A@

6S. 6A( AO/( 6S. 6A( AO/(

A6'S &'CA

&'( S'( S/(A C'( S'P4

O(6

OAS+' ' ++/C('OS

@A6-(O-+A( %2,92.27 %2,92.27 2,%.92 19.0% ,11.00 1,310.5 29."" 1,7.95 202.50

1 10>9 "0 2,307.9 %%,999.9 1%3.0" 33.% 197.00 70."5 1.2 90.5

2 10>23 "0 2,307.9 %7,307.5 1%3.0" 33.% 197.00 70."5 1.2 90.5 27.00

3 11> "0 2,307.9 %9,15.3% 1%3.0" 33.% 197.00 70."5 1.2 90.5

% 11>20 "0 2,307.9 51,923.03 1%3.0" 33.% 92.00 70."5 1.2 90.5 700.00 27.00

5 12>%

12>1" 3,"30.1

. (O(.

. (O(.


+PA6(( OCC/PA('O #O6S ' mo. #>

6O/P 'S/6AC /'O +/S O(6 #4@ 6A( 375.00 A44O#.

29,000 -- .30>O/64@ 6A( 9.3"

2O6(' 6 1%.07

20DDD 6/4A6 A6'S O6(' A6'S C//4A(' ++/C('OS

PA@+A@

6S. 6A( AO/( 6S. 6A( AO/(

A6'S &'CA

&'( S'( S/(A C'( S'P4

O(6

OAS+' ' ++/C('OS

@A6-(O-+A( ,2%0.00 ,2%0.00 3"."" 90.%" %2.00 191.5 %.37 2%5.11 31.50

1 10>9 "0 90.00 ,930.00 %2.7" 10.01 51.00 21.1" 0.%" 27.10

2 10>23 "0 90.00 7,20.00 %2.7" 10.01 51.00 21.1" 0.%" 27.10 ".10

3 11> 7" 72.9% ",292.9% %1.72 9.7 29.00 20. 0.%7 2.%3

% 11>20 7" 72.9% ",95."" %1.72 9.7 29.00 20. 0.%7 2.%3 ".10

5 12>%

12>1%

. (O(.

. (O(.


strative


48/58



49/58

O(6 ++/C('OS '&O6A('O SA4A6@ #>6O/P 'S/6AC /'O +/S O(6 #4@ 6A( A44O#.

21,000 -- .30>O/64@ 6A( 7.50

1O6(' 6 11.25

20DDD 6/4A6 A6'S O6(' A6'S C//4A(' ++/C('OS

PA@+A@

6S. 6A( AO/( 6S. 6A( AO/(

A6'S &'CA

&'( S'( S/(A C'( S'P4

O(6

OAS+' ' ++/C('OS

@A6-(O-+A( 5,550.00 5,550.00 3%%.10 "0.%" %09.00 170.3" 3."9 21".00 32.%0

1 10>9 72 7.50 5%0.00 ,090.00 33.%" 7."3 32.00 1.5" 0.3" 21.21

2 10>23 72 7.50 5%0.00 ,30.00 33.%" 7."3 32.00 1.5" 0.3" 21.21 .30

3 11> 72 7.50 5%0.00 7,170.00 33.%" 7."3 32.00 1.5" 0.3" 21.21

% 11>20 72 7.50 5%0.00 7,710.00 33.%" 7."3 32.00 1.5" 0.3" 21.21 .30

5 12>%

12>1"

E(6. (O(.

@6. (O(.


+PA6(( OCC/PA('O #O6S ' mo. #>

6O/P 'S/6AC /'O +/S O(6 #4@ 6A( 11.5% A44O#.

%",000 -- .30>O/64@ 6A( 15.29

0O6(' 6 22.9%

20DDD 6/4A6 A6'S O6(' A6'S C//4A(' ++/C('OS

PA@+A@

6S. 6A( AO/( 6S. 6A( AO/(

A6'S &'CA

&'( S'( S/(A C'( S'P4

O(6

OAS+' ' ++/C('OS

@A6-(O-+A( 10,20.00 10,20.00 3.12 1%".77 1,0.00 31%.9" 7.1" %03.01 59.%0

1 10>9 "0 1,223.0" 11,%"3.0" 75."3 17.73 155.00 37.55 0." %".0%

2 10>23 "0 1,223.0" 12,70.1 75."3 17.73 155.00 37.55 0." %".0% 1%.%0

3 11> 79 1,207."5 13,91%.01 7%."9 17.51 152.00 37.0" 0."5 %7.%%

% 11>13 13 2,079.32 15,993.33 12".92 30.15 3%0.00 3."% 1.% "1." 1%.%0

5

E(6. (O(. 375 5,733.33 5,733.33 355.%7 "3.12 "02.00 17.02 %.03 225.20 2"."0

@6. (O(. 15,993.33 15,993.33 991.59 231."9 2,%0".00 %91.00 11.21 2".21 "".20

Checkpoint 5,733.33 15,993.33 Checkpoint %,05".9


50/58



51/58

O(6 ++/C('OS '&O6A('O SA4A6@ #>6O/P 'S/6AC /'O +/S O(6 #4@ 6A( A44O#.

O/64@ 6A(

O6(' 6

20DDD 6/4A6 A6'S O6(' A6'S C//4A(' ++/C('OS

PA@+A@

6S. 6A( AO/( 6S. 6A( AO/(

A6'S &'CA

&'( S'( S/(A C'( S'P4

O(6

OAS+' ' ++/C('OS

@A6-(O-+A(

1

2

3

%

5

E(6. (O(.

@6. (O(.

+PA6(( OCC/PA('O #O6S ' 6O/P 'S/6AC /'O +/S O(6 #4@ 6A( A44O#.

O/64@ 6A(

O6(' 6

20DDD 6/4A6 A6'S O6(' A6'S C//4A(' ++/C('OS

PA@+A@

6S. 6A( AO/( 6S. 6A( AO/(

A6'S &'CA

&'( S'( S/(A C'( S'P4

O(6

OAS+' ' ++/C('OS

@A6-(O-+A(

1

2

3

%

5

E(6. (O(.

@6. (O(.

'++4

ictor

A6'(A4


52/58

A6'(A4

S(A(/S

( PA'+

C.

O. AO/(

",2"."2

72 1,1%7.19

"2 1,211.02

92 1,1%7.19

703 917."%

'++4

CladeA6'(A4

S(A(/S

( PA'+

C.

O. AO/(

17,29".1

73 1,775."3

"3 1,7%9.%3

93 1,775."370% 1,32%.%3

'++4

4oise

A6'(A4


53/58

A6'(A4

S(A(/S

S

( PA'+

C.

O. AO/(

%,95.97

7% 705.5%

"% 95.0%

9% 705.5%

705 95.0%

'++4

#ilson

A6'(A4

S(A(/S

( PA'+

C.

O. AO/(

%,2%1.73

75 1,10".29

"5 1,092.39

95 1,031.2970 "01.39

'++4

(yler A6'(A4


54/58

A6'(A4

S(A(/S

( PA'+

C.

O. AO/(

30,090.33

7 1,771.03

" 1,7%%.03

9 1,771.03

707 1,1%9.03

'++4

Aloise

A6'(A4

S(A(/S

S

( PA'+

C.

O. AO/(

%,%".10

77 537.%5

"7 529.35

97 5%%.9070" 53."0

'++4

Allen

A6'(A4


55/58

S(A(/S

( PA'+

C.

O. AO/(

11,21".21

7" 1,17.0

"" 1,312.%7

9" 1,17.0

709 970.2

'++4

amesA6'(A4

S(A(/S

S

( PA'+

C.

O. AO/(

12,102.9%

79 1,5".27

"9 1,5%%.27

99 1,%"".27710 1,%%.27

'++4

A6'(A4


56/58

S(A(/S

S

( PA'+

C.

O. AO/(

%,291.75

"0 %2".52

90 %22.22

700 %2".52

711 %22.22

'++4

ir$inia

A6'(A4

S(A(/S

S

( PA'+

C.

O. AO/(

7,0"%.5%

"1 """.07

91 "73.7

701 "7".0"702 1,%1"."7

%,05".9

11,1%3.23

11,1%3.23

'++4

Anne

A6'(A4


57/58

S(A(/S

S( PA'+

C.

O. AO/(

'++4

#inston

A6'(A4

S(A(/S

S

( PA'+

C.

O. AO/(

'++4

A6'(A4


58/58

A6'(A4

S(A(/S

( PA'+

C.

O. AO/(

'++4

A6'(A4

S(A(/S

( PA'+

C.

O. AO/(

payroll project 2014

Documents