Complete the following worksheet columns; Total 2yr Financial Bonus Package Package $5.000 $1,500 $1.500 $5.500 $2.000...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Complete the following worksheet columns; Total 2yr Financial Bonus Package Package $5.000 $1,500 $1.500 $5.500 $2.000 Bonus above/below 5000 Cost of Total Jyr. Financial Annual Ling Salary Multiplier Payment Salary $84 250 Monthly Car Adjusted Location New York Washington DC $68 000 Houston Patsburgh $200 SO $389 $375 $275 2.10 1.40 $52,100 $48 750 $85.000 0.94 0 92 1.2 LA Average Adusted Salary Lowest Adjusted Salary Highest Adusted Salary 2nd lawest Adjusted Salary 2rd largest Adjusted Salary positions wbonus exceed 5000 1- In the range of cells F2:F6 calculate the adiusted salary: the annual salacy divided by the cost of living multiglier minus the expected annual.car payment 2- In the range of cells H2:H6 calculate the Total 2r. Financial Package: Note calculate the value of the adjusted salary package for each position over a two-year period, including Bonuses. Assume that the employee will receive a 2.5% after the first year of employment. 3- In the range of cells 12:16 Calculate the Total 3yr. Financial Package: Note: calculate the value of the adjusted salary package for each position over a three-year period, including Bonuses Assume that the employee will receive bonus in the second year and third year and the employee will receive a 2.5% after the first year and 3% after the second year of employment in the new position. 4- Calculate the Averages for columns: Adiusted Salany Bonus, Total Zyr. Financial Package & Total Byr. Financial Package. S- Write a formula to determine the value of the lowest adiusted salary. 6- Write a formula to determine the value of the highest adiusted salary. 7- Write a formula to determine the value of the Z lowest adjusted salany 8- Write a formula to determine the value of the 2 largest adiusted salany 9- Write a formula to determine the # positions w/bonus that exceeds a 5c00 10- Write a formula to determine the Total 3yr. Financial Packages that exceeds 150000. 11- Write a formula 12:1S for bonus to display "5000 & more" if bonus greater than or equal 5000 else display "below 5000". 12- create a clustered column chart to display Location, Adusted Salany Istal Rer. Einancial Package. Total 3yr. Financial Package 13- In the range of cells F2:F6: use conditional formatting to show the highest adiusted salary in red. Complete the following worksheet columns; Total 2yr Financial Bonus Package Package $5.000 $1,500 $1.500 $5.500 $2.000 Bonus above/below 5000 Cost of Total Jyr. Financial Annual Ling Salary Multiplier Payment Salary $84 250 Monthly Car Adjusted Location New York Washington DC $68 000 Houston Patsburgh $200 SO $389 $375 $275 2.10 1.40 $52,100 $48 750 $85.000 0.94 0 92 1.2 LA Average Adusted Salary Lowest Adjusted Salary Highest Adusted Salary 2nd lawest Adjusted Salary 2rd largest Adjusted Salary positions wbonus exceed 5000 1- In the range of cells F2:F6 calculate the adiusted salary: the annual salacy divided by the cost of living multiglier minus the expected annual.car payment 2- In the range of cells H2:H6 calculate the Total 2r. Financial Package: Note calculate the value of the adjusted salary package for each position over a two-year period, including Bonuses. Assume that the employee will receive a 2.5% after the first year of employment. 3- In the range of cells 12:16 Calculate the Total 3yr. Financial Package: Note: calculate the value of the adjusted salary package for each position over a three-year period, including Bonuses Assume that the employee will receive bonus in the second year and third year and the employee will receive a 2.5% after the first year and 3% after the second year of employment in the new position. 4- Calculate the Averages for columns: Adiusted Salany Bonus, Total Zyr. Financial Package & Total Byr. Financial Package. S- Write a formula to determine the value of the lowest adiusted salary. 6- Write a formula to determine the value of the highest adiusted salary. 7- Write a formula to determine the value of the Z lowest adjusted salany 8- Write a formula to determine the value of the 2 largest adiusted salany 9- Write a formula to determine the # positions w/bonus that exceeds a 5c00 10- Write a formula to determine the Total 3yr. Financial Packages that exceeds 150000. 11- Write a formula 12:1S for bonus to display "5000 & more" if bonus greater than or equal 5000 else display "below 5000". 12- create a clustered column chart to display Location, Adusted Salany Istal Rer. Einancial Package. Total 3yr. Financial Package 13- In the range of cells F2:F6: use conditional formatting to show the highest adiusted salary in red.
Expert Answer:
Answer rating: 100% (QA)
A B D E G H K 2 yr fin pack F2G2F21025G2 H2G2103F2 FG250005000 morebelow 5000 F3G3F31025G3 H3... View the full answer
Related Book For
Fundamental Accounting Principles
ISBN: 978-0078110870
20th Edition
Authors: John J. Wild, Ken W. Shaw, Barbara Chiappetta
Posted Date:
Students also viewed these human resource management questions
-
Many products that marketers sell can be thought of as a bundle of features. The challenge for the marketer is to identify which particular combination of features is the most likely to maximize...
-
Following are a number of unrelated transactions for the Village of Centerville, some of which affect governmental activities at the government-wide level. None of the transactions have been recorded...
-
1. Use the following worksheet to estimate your federal income tax liability based on the 2012 guidelines presented in the text or current tax regulations and rates. (The Excel worksheet will...
-
3) Sauseda Corporation has two operating divisions-an Inland Division and a Coast Division. The company's Customer Service Department provides services to both divisions. The variable costs of the...
-
How can finished grades be established in machine control projects?
-
Read Whats in a Link by Woods (1985). Section IV of this article lists a number of problems in knowledge representation. Suggest a solution to each of these problems using logic, conceptual graphs,...
-
In a study of 7847 children in grades 1 through 5, 15.5% have attention deficit hyperactivity disorder. Determine whether the study is an observational study or an experiment. Explain.
-
Colton Furniture Co. is a small but fast-growing manufacturer of living room furniture. Its two principal products are end tables and sofas. The flow diagram for the manufacturing at Colton follows....
-
Assume Lance Corp. has the following reported amounts: Sales revenue $796,000, Sales returns and allowances $23,000, Cost of goods sold $517,910, and Operating expenses $171,600. . When typing your...
-
The gecko is a reptile with an amazing ability to climb smooth surfaces, including glass. Recent discoveries indicate that geckos stick to smooth surfaces via van der Waals interactions between...
-
Company: Gucci Countries: China vs Italy discus the below with the given information- Hofstede dimensions relate to how it is easier for the Italian company to adapt to China operation According to...
-
How to do this lab in LTspice ? Questions: 1) In LTSpice. Replace A1 to A4 in the circuit by using transistors shown in Figure 1.1. And how to determine the base or gate driving circuits for the...
-
write narrative essay of eight hundred words please. Topic- A dream to climb mount Everest.
-
Let f(x) = A = -2 3x + 1 If h 0, then the difference quotient can be simplified as B = where A, B, C, and D are constants. (Note: It's possible for one or more of these constants to be 0.) Find the...
-
A.Dinesh starts business with cash Rs 50,000 and furniture Rs 20,000. The details of his transactions are given below: (i) Purchased goods on credit from Eknath Rs 60,000 at 10% discount. (ii) Goods...
-
A safety & health coordinator reporting to you proposes to discontinue using an outside vendor to conduct annual employee audio-grams. The coordinator argues it will be much cheaper, saying: "Why...
-
Erik is the office manager of a business with 20 employees. He assigns the employees their work, organizes them into work teams, reviews their performance every quarter, and tries to address their...
-
A consumer magazine is evaluating five brands of trash compactors for their effectiveness in reducing the volume of typical household products that are discarded. In the experiment, each block...
-
Nokia, Research In Motion, Apple, and Palm are competitors in the global marketplace. Selected data for Nokia follow. Required 1. Review the discussion of the importance of the cost of goods sold...
-
When output volume increases, do fixed costs per unit increase, decrease, or stay the same within the relevant range of activity? Explain.
-
On January 14, the end of the first bi-weekly pay period of the year, Rockin Companys payroll register showed that its employees earned $14,000 of sales salaries. Withholdings from the employees...
-
Determine whether each of the following statements is true or false: Management accountants should be technically proficient, but they dont need strong oral and written communication skills.
-
Determine whether each of the following statements is true or false: Management accountants should be proficient in Excel.
-
Determine whether each of the following statements is true or false: The Association of International Certified Professional Accountants (AICPA) issues the Certified Management Accountant (CMA)...
Study smarter with the SolutionInn App