Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The State of Georgia requires all employees of the University of Georgia to contribute to a retirement fund. The university makes a deduction from every

image text in transcribed

The State of Georgia requires all employees of the University of Georgia to contribute to a retirement fund. The university makes a deduction from every employee's basic salary. If the employee is full-time staff of the university, the retirement fund deduction is 2% of the employee's salary. If the employee works part-time, the deduction is 1%. Table 2 below shows the first five employees from an Excel spreadsheet you have received from HR, as well as their status and basic salaries. Table 2: Excerpt from Excel file of employees A B D 1 Name Status Basic Salary Retirement Deduction 2 John Smith Full-time $24,812.00 3 Mike Peterson Part-time $6,500.00 4 Paul Markov Full-time $66,100.00 5 Peter Petrov Part-time $7,000.00 6 Ivan Andonov Part-time $8,600.00 Using the information above, complete Table 2 by: Writing a logical Excel statement (IF function) in the last column of the spreadsheet, which computes the retirement deduction for the first employee and can be copied all the way down the list of employees. The logical statement must take into account the employee's status and basic salary. Start by downloading the Data File which contains the information from Table 2 here After solving the question in Excel, you should copy the formula used in your spreadsheet (i.e. copy and paste the "=IF..........)" statement) and paste in into the box below along with the completed Table 2 from your Excel spreadsheet

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

Be Audit You Can Be

Authors: Awesome Auditor

1st Edition

1659095700, 978-1659095708

More Books

Students also viewed these Accounting questions

Question

Address an envelope properly.

Answered: 1 week ago

Question

Discuss guidelines for ethical business communication.

Answered: 1 week ago