You work in the Human Resources Department of Devcon Finn, Ic., a computer consulting firm. An...

Transcribed Image Text:

You work in the Human Resources Department of Devcon Finn, Ic., a computer consulting firm. An employee is considering a transfer to one of the company's other locations and is qualified for several different positions. Your task is to help the employee choose the most appropriate position based on a number of criteria. For example, you need to determine the value of each position in terms of the disposable income the employee can expect. The position with the highest salary is located in the company's New York City office, but a studio apartment there costs about $2,650 per month. However, in the New York office, the employee would not need a car. You have documented each position in an Excel worksheet. On this sheet, you have recorded the positions, the annual salary, the cost of living multiplier (which you obtained from a Web site) and estimates of a monthly car payment including insurance, assuming for some of these jobs the employee will need to purchase a car. You have also recorded information regarding starting bonuses (a one-time payment when hired) offered to the employee. Now, you need to finalize the worksheet. Complete the following: 1. Open the workbook named Jobs.xlsx located in the Chapter 1 folder, and then save the file as Job Analysis.xlsx. 2. In cells F2:F4, calculate the associated annual adjusted salary. This adjusted salary is the annual salary divided by the cost of living multiplier minus the expected annual car payments. (Note that car payments are given in dollars per month ($/month). 3. In cell F6, write a formula to calculate the average adjusted salary of the three positions. 4. In cell F7, write a formula to determine the value of the lowest adjusted salary. This formula should automatically update if any of the data inputs are later changed. You work in the Human Resources Department of Devcon Finn, Ic., a computer consulting firm. An employee is considering a transfer to one of the company's other locations and is qualified for several different positions. Your task is to help the employee choose the most appropriate position based on a number of criteria. For example, you need to determine the value of each position in terms of the disposable income the employee can expect. The position with the highest salary is located in the company's New York City office, but a studio apartment there costs about $2,650 per month. However, in the New York office, the employee would not need a car. You have documented each position in an Excel worksheet. On this sheet, you have recorded the positions, the annual salary, the cost of living multiplier (which you obtained from a Web site) and estimates of a monthly car payment including insurance, assuming for some of these jobs the employee will need to purchase a car. You have also recorded information regarding starting bonuses (a one-time payment when hired) offered to the employee. Now, you need to finalize the worksheet. Complete the following: 1. Open the workbook named Jobs.xlsx located in the Chapter 1 folder, and then save the file as Job Analysis.xlsx. 2. In cells F2:F4, calculate the associated annual adjusted salary. This adjusted salary is the annual salary divided by the cost of living multiplier minus the expected annual car payments. (Note that car payments are given in dollars per month ($/month). 3. In cell F6, write a formula to calculate the average adjusted salary of the three positions. 4. In cell F7, write a formula to determine the value of the lowest adjusted salary. This formula should automatically update if any of the data inputs are later changed.

Answer rating: 100% (QA)

Formulas for calculating the adjusted salary and t... View the full answer