Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Accounting

Authors: Jill Collis, Andrew Holt, Roger Hussey

3rd Edition

113752149X, 9781137521491

More Books

Students also viewed these Accounting questions

Question

1. What is the meaning of the information we are collecting?

Answered: 1 week ago

Question

3. How much information do we need to collect?

Answered: 1 week ago

Question

2. What types of information are we collecting?

Answered: 1 week ago