Answer Happy

A company contributes to each eligible employee's retirement plan at the rate of 4% of the employee's annual salary. However, to be eligible for this benefit, an employee must have full-time status with two or more years of employment. A calculation for the retirement contribution requires a test of two conditions: Full- or part-time status and number of years of employment. A graphical view of the conditions to test might look like this illustration: Start No Yes Full Time? No Yes 2 yrs employmt? No retirement benefit Benefit=Salary * 4% There are three retirement contribution possibilities to account for: • An employee works full time AND has been employed two or more years. The retirement benefit applies. • An employee works full time but has NOT been employed two or more years. The retirement benefit does not apply. • An employee does NOT work full time. The retirement benefit does not apply. You can account for these three possibilities in a single formula. Write your formula using logical functions. There's more than one way to write this formula. For example, you might use both the IF and AND statements or you could express the same thing with a nested IF statement. B G # Years Employed 5 H Retirement Contribution 13 8 9 DHU Employmt. Status part time full time full time full time full time part time full time part time full time Name Gopnik 10 Mahfouz 11 Bryson 12 Peters 13 de Vries 14 Talento 15 Yang 16 Marks 17 Heller D Health Plan family family individual individual individual family other plan family family EF Hire Salary Date $45,000 Jan-98 $120,000 May-89 $145,000 Mar-01 $100,000 Nov-00 $115,000 Jul-97 $55,000 Aug-95 $95,000 Apr-99 $15,000 May-01 $124,000 Oct-00 2 2. 5 7 4 1 2