Chapter Ti Excel Exercise Instructions: The following data for Gracie West Interiors relate to the payroll for the week ended November 10th, 2018. Worked 54 Hourly Rate Weekly Salary 48 5000 Employee Ashton Becca Nathan Mia Lisa Drake Luke Marah Rex 33 47 32 50 54 42 Tax $767.94 $1,319.02 $320.40 $670.50 $243.90 $1,055.02 $732.10 $369.22 $552.34 Savings $44 $62 $75 $60 $0 $100 $120 $80 $0 4200 48 43 56 40 43 49 Employees Becca and Drake are office staff, and all of other employees are sales personnel. All sales personnel are paid 2 times the regular rate for all hours in excess of 40 hours per week. The social security tax rate is 6.0% of each employee's annual earnings, and Medicare tax is 1.5% of each employee's annual earnings. The next payroll check to be used is No. 1458. 1. Prepare a payroll register for Gracie West Interiors for the week ended November 10th, 2018. 2. Journalize the entry to record the payroll for the week. PAYROLL FOR WEEK ENDING December 9, 20Y8 EARNINGS PAID Social Security Tax Total Hours DEDUCTIONS Federal Income Tax Medicare Tax ACCOUNTS DEBITED Sales Office Salaries Salaries Expense Expense Name Overtime Retirement Savings Net Amount Regular Total Ck. No. Total 54 Ashton Becca Nathan Mia Lisa Drake Luke Marah Rex 47 32 48 43 49 2