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
$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
$720.00
$143.65
$25.20
$551.15
Mister Bogus
$ 19.50
8
$780.00
$155.44
$27.30
$597.26
Roger Rabbit
$ 25.50
$739.50
$147.76
$25.88
$565.86
Herman Munster
$ 35.00
44
$1,610.00
$321.72
$56.35
$1,231.93
lmayer@elgin.edu