payroll example

Note: Some requirements do not show up properly when I paste the spreadsheet as a table in this webpage. For example, the names do not wrap around and row/col. height/width are altered.

Cis100 Fictional Payroll

Name

Pay Rate

Hours

Dependants

Gross Pay

Fed tax

State Tax

Net pay

Marge Simpson

 $                   25.00

45

2

$1,187.50

$237.36

$41.56

$908.58

Herman Hollerith

 $                   14.95

30

0

$448.50

$89.70

$15.70

$343.10

Betty Rubble

 $                   11.50

29

1

$333.50

$66.63

$11.67

$255.20

Buffy Summers

 $                   17.75

40

5

$710.00

$141.65

$24.85

$543.50

Fred Flintstone

 $                   24.00

34

1

$816.00

$163.13

$28.56

$624.31

Augusta Aida

 $                   33.50

55

3

$2,093.75

$418.54

$73.28

$1,601.93

Jane Doe

 $                   12.75

20

4

$255.00

$50.72

$8.93

$195.36

Suzy Snowflake

 $                   18.00

40

5

$720.00

$143.65

$25.20

$551.15

Mister Bogus

 $                   19.50

40

8

$780.00

$155.44

$27.30

$597.26

Roger Rabbit

 $                   25.50

29

2

$739.50

$147.76

$25.88

$565.86

Herman Munster

 $                   35.00

44

4

$1,610.00

$321.72

$56.35

$1,231.93

lmayer@elgin.edu