Chapter 11 Excel Exercise Instructions: The following data for Gracie West Interiors relate to the payroll for the week ended November 10th, 2018. Federal Income Employee Hours Worked 54 Hourly Rate Weekly Salary Tax 48 5000 50 Ashton Becca Nathan Mia Lisa Drake Luke Marah 33 47 32 54 42 $767.94 $1,319.02 $320.40 $670.50 $243.90 $1,055.02 $732.10 $369.22 $552.34 Retirement Savings $44 $62 $75 $60 SO $100 $120 $80 SO 4200 48 56 40 43 Rex 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. COV ETOCESO Name: Section mons entered in the cells with gray backgrounds PAYROLL FOR WEEK ENDING December 1, 2013 LARNINGS Name Total Hours Regular PAD Social Security Tas Overtime DEDUCTIONS Feder Income Tax Total Medicare Tas Retirement Swing 54 CH Ne A Total Ashton Becca Nathan 33 47 32 Drake Like Marian RA LLLLLL 48 43 49 EARNINGS PAID Beca TER DEDUCTIONS For In Hell ACCOUNTS DEBTED Bale Orice Sale Se E Tas Tuta Amount