Spreadsheet software skills: Formulas; absolute and relative

addressing; worksheet formatting; SUM; AVERAGE

Business skills: Payroll accounting

In this project, you will create a payroll register for the eight

senior executives of a machine tool company with $8,500$

employees. All employees are paid through the firm's automated

payroll system except for the eight members of the company's

executive steering committee, including the CEO. The payroll

system for the steering committee is produced separately on a

spreadsheet because it contains highly confidential information

about senior executives' salaries. This group of executives is

paid monthly.

The EMIS$15$Chap$1$ Question File, which displays the names of

the executive steering committee members, their Social Security

numbers, and annual salaries. Develop a worksheet that creates a

payroll register report for these employees for the first month of

the year $($January $2023).$ The worksheet should automatically

calculate monthly gross pay, year$-$to$-$date gross pay, net pay, and

all deductions. These deductions include federal income tax

withholding $(25$ percent of gross pay$),$ state income tax

withholding $(5$ percent of gross pay$),$ FICA $($Social Security$)$

$(6\mathrm{.}2$ percent of gross pay$),$ Medicare $(1\mathrm{.}45$ percent of gross pay$),$

group health

Ashlee Burton ssn: $360-02-2757$ annual salary: $650,000$

Clay Monroe ssn: $349-97-5816$ annual salary: $495,000$

Shevonne Ramsey ssn: $600-05-6662$ annual salary: $455,000$

Tre Martinez ssn: $683-93-6944$ annual salary: $440,000$

Katherine Doherty ssn: $218-36-6712$ annual salary: $430,000$

Mike Takahashi ssn: $612-02-1078$ annual salary: $375,000$

Raymond Neville ssn: $339-78-1044$ annual salary: $350,000$

Maurice Glassman ssn: $737-82-6696$ annual salary: $295,000$