Question: I have already posted the instructions. I need help with phase III. AutoSave O Off) 1) v Retirement Problem DATA Spring 2020 (1) - Excel

I have already posted the instructions. I need help with phase III.

 I have already posted the instructions. I need help with phase

AutoSave O Off) 1) v Retirement Problem DATA Spring 2020 (1) - Excel Search Sarpong, Gideon SG X File Home Insert Page Layout Formulas Data Review View Help Share Comments C4 X V Employee A B C D E F G H I K L M N O P W N P Employee Date of Birth Date of Hire Total Wages Wages as of Hours Worked June 30, 2019 401(k) Deferral. in 2019 Separation Date Rolando Blackman 5/6/1969 1/1/2012 $350,000 $100,000 $16,500 2,080 Kiera Hughes 11/15/1974 6/20/2015 $36,000 $15,000 $1,000 2,080 Larry Findley 1/11/1981 7/1/2018 $225,000 $50,000 $12,500 2,080 Jon Kopf 5/24/1976 5/12/2011 $60,000 $60,000 $9,000 2,080 6/1/2019 10 Kevin Babb 4/12/1990 6/25/2016 $20,000 $9,800 SO 2,080 11 Elaine Bland 2/20/1987 5/15/2018 $165,000 $10,000 $4,000 1,400 12 Rick VanHarn 6/28/2000 8/10/2018 $35,000 $17,000 $3,500 2,080 13 Kevin Sherfey 12/19/1977 9/5/2015 $175,000 $85,000 $16,500 1,000 14 Chelsea Webb 7/1/1998 10/10/2016 $290,000 $150,000 $22,000 2,080 15 Betty Walters 9/7/1993 11/19/2013 $155,000 $25,000 SO 2,080 16 Andrew Crowder 11/24/1990 4/25/2018 $38,000 $32,500 $6,000 1,400 7/3/2019 17 Wayne Saubert 2/1/1954 8/11/2012 $4,000 $4,000 $400 900 2/1/2019 18 Robert Bell 2/26/1971 5/3/2014 $42,000 $21,000 $4,200 980 19 Samantha Frye 8/5/1975 8/15/2018 $127,000 so $19,500 1,400 20 Thomas Snedeker 10/1/1980 4/16/2012 $84,000 $40,000 SO 2,080 21 Denise Evans 7/1/1986 10/4/2016 $47,000 $24,000 $6,000 720 22 Michael Wade 9/20/1981 1/3/2018 $90,000 $40,000 $14,000 2,080 23 Lauren Hicks 1/2/1998 6/20/2016 $255,000 $50,000 $15,000 1,800 24 Steven Childers 7/11/1967 2/13/2018 $12,500 $10,000 $7,000 240 2/14/2019 25 26 27 Sheet1 Sheet2 Sheet3 + - - + 100%

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!