excel hw

profilemike patel
skills_e03_grader_eoc.xlsx
Home>Information Systems homework help>excel hw

Sheet1

Aspen Falls
Courthouse
Job Title Total Gross Pay Income Tax Social Security (FICA) Tax Health Insurance Net Pay
Receptionist 31675 3825 2438 2771
Security Guard 5440 653 416 476
Maintenance 4760 577 364 416
Cleaning Crew 10880 1306 832 952
Total

City Center

Aspen Falls
City Center
Job Title Total Gross Pay Income Tax Social Security (FICA) Tax Health Insurance Net Pay
Receptionist 38472 4616 2943 2308
Security Guard 7660 919 590 459
Maintenance 6240 748 480 374
Cleaning Crew 13420 1610 1028 805
Total

Community Center

Aspen Falls
Community Center
Job Title Total Gross Pay Income Tax Social Security (FICA) Tax Health Insurance Net Pay
Receptionist 48920 5870 3742 2935
Security Guard 9301 1116 712 560
Maintenance 7920 950 608 475
Cleaning Crew 14203 1704 1086 852
Total