Lookup Functions The purpose of this project is to practice and apply what you have learned about using the VLookup and HLookup in Excel. In this project, you will use and create spreadsheets that require VLookup or HLookup to complete several tasks. Download the Project 5 Excel file to use for this project. Part 1 Requirements: Download and open the P5-Data.xlsx workbook.Open the Part1 spreadsheet. This spreadsheet includes a information about a list of employees.Use the VLookup function to populate the table in columns H-L. You need to look up the email, department, and supervisor last name and supervisor first name for the five employees identified in column H.The employee ID numbers are already provided for you in column H.You may add any additional columns or information you need to complete the task.You must use VLookup to populate all information in the new table except for the employee IDs in column H. Part 2 Requirements: Go to the Part2 spreadsheet in the same workbook. This spreadsheet shows a list of the most popular surnames in the United States in the year 2000. It also includes other columns of information with various statistics about the surnames. Columns G-L show the percentage of the racial makeup of those who have that surname.Choose five random surnames from the list of surnames and enter those five names in cells N2-N6.Use the VLookup function to show the Black, Asian, and Hispanic makeup of those who have those last names for each of the last names.You may add any additional columns or information you need to complete the task.You must use VLookup to populate all information in the new table except for the surnames in column N. Part 3 Requirements: Go to the Part3 spreadsheet in the same workbook. This spreadsheet shows only the Sales persons from the list of employees in Part 1. However, it also adds the sales amount they achieved during the month. Additionally, the spreadsheet also adds columns for Commission Rate and Pay for the sales persons.Create a horizontal (rows) commission table to use to calculate the commission rate and pay for each of the sales persons listed in the spreadsheet. You will then need to use HLookup to look up the information in this commission table to calculate the pay for the employees.The commission table must be horizontal.The commission table should include the following rates: <$50,000 = 5% commission rate, $50,000-$64,999 = 10% commission rate, $65,000-79,999 = 12% commission rate, $80,000-$99,999 = 15% commission rate, $100,000-$124,999 = 20% commission rate, >$125,000 = 25% commission rate.Using HLookup and the commission rate table you just created, calculate the commission rate in column H for each of the sales persons. (Linda should receive 12% commission, Mary should receive 20% commission, and Jennifer should receive 5% commission.) Use a formula in column I to multiply the sales amount in column G by the commission rate in column H for each of the employees. This should give you the pay amount for each.Format the Pay to be in currency with two decimal places. When you are finished with the three parts, submit your Excel workbook with all three spreadsheets to Blackboard.

Gold PlatingMany IT projects within health care industry suffer from scope creep and poor scope verification. Assess “What went wrong and suggest what could have been better” in the case of - FoxMeyer Drugs which filed for bankruptcy after scope creep on a robotic warehouse project.Write a 700-word critical assessment quoting 3 scholarly references, including at least two peer-reviewed references from university library. Format your paper consistent with APA guidelines. Exemplary 18-20 points Proficient 16-17 points Developing 14-15 points Beginning 12-13 points Inadequate 0-11 points Comprehension of Assignment (20% of grade) Addressed the question completely and thoroughly. Provided additional supporting evidence, demonstrating a full comprehension of subject matter. Addressed the question(s) completely and thoroughly. Addressed the majority of the question(s). Addressed minimal portions of the question(s). Did not address the question(s). Application of Course Knowledge and Content (20% of grade) Thorough technical application of course knowledge and content in a complete and concise manner. Technical application of course knowledge and content is mostly accurate, concise and complete. Technical application of course knowledge and content is partially accurate, concise and complete. Technical application of course knowledge and content is minimally accurate, concise and complete. Technical application of course knowledge and content is inaccurate and incomplete. Organization of Ideas (20% of grade) Original ideas are effectively developed and presented in a logical, sequential order throughout the entire assignment. Includes adequate and appropriate supporting evidence. Original ideas are effectively developed and presented in a logical, sequential order within a majority of the assignment. Includes acceptable supporting evidence Original ideas are partially developed and presented in a somewhat logical, sequential order. Inadequate supporting evidence. Original ideas are not present and/or not presented in a logical, sequential order. Organization is difficult to follow throughout the assignment. Lacks supporting evidence. Little to no original ideas or organization present throughout the entire assignment. Lacks supporting evidence. Writing Skills (20% of grade) Mechanics (spelling, grammar, and punctuation) are flawless, including proficient demonstration of citations and formatting throughout the entire assignment. Mechanics (spelling, grammar, and punctuation) are accurate including demonstration of citations and formatting within a majority of the assignment. Partial errors with mechanics (spelling, grammar, and punctuation) including demonstration of citations and formatting within minimal portions of the assignment. Multiple errors with mechanics (spelling, grammar, and punctuation), inaccurate demonstration of citations and formatting. Assignment is incomprehensible due to multiple errors with mechanics (spelling, grammar, and punctuation). No demonstration of citations or formatting present. Research Skills (20% of grade) Accurate and applicable use of resources relevant to the subject matter that enhance the overall assignment. Appropriate use of resources relevant to the subject matter. Adequate use of resources, not all resources relevant to the subject matter. Minimal use of resources relevant to the subject matter. No evidence of resources apparent.