The final assignment in this course is a 7 to 9-page paper following the guidelines below, to be double-spaced and using 12-point font (Arial or Times New Roman). Use the APA Template attached above. Be sure to cite your sources, which at a minimum should be the textbook. Other sources that we used throughout the course should be included and cited as relevant to the topics you choose. There is no need to provide additional sources beyond these. Don't forget to include your sources in the References list at the end of your paper.Part 1 of 2: We have studied a broad range of leadership topics over the past seven weeks. For the final Leadership Paper, please select five of the topics we have covered that resonate with you and your professional and personal experiences. For each of the five topics you select:Identify what you learned and apply what you understand about the topic to either yourself or an individual/leader whom you admireDescribe one or more specific examples or situations involving you or the admired individual that demonstrate or relate to the selected topicDiscuss your understanding of and ability to use this knowledge moving forwardAim for one page for each of the five topics.Part 2 of 2: In one to two pages, the conclusion of the paper should apply lessons from this course to your own professional leadership experience, including how you will use this knowledge to enhance your own effectiveness as a leader.Briefly define what you see as your own leadership style(s)Based on your identified leadership style, articulate at least one professional objective related to leadership that you will pursue as a result of your studies in this courseBe sure to include a date by which you hope to achieve the professional goal.Examples of potential topics you may use to select for your five topics include the following. This is not a complete list, as any leadership-related topic that is covered in the textbook is acceptable.Leadership vs. ManagementContingency Approaches to LeadershipAutocratic vs. Democratic BehaviorsPersonality Models (e.g., Big Five)Leader-Member ExchangeEmotional IntelligenceMoral LeadershipServant LeadershipFollowershipCognitive Differences (e.g., Hermann’s Whole Brain Model)Motivation Theories (e.g., Maslow’s Hierarchy of Needs Theory)Role of EmpowermentCommunication Models and PracticesLeading TeamsInfluential Leadership Models (e.g., Transformational Leadership)Role of PowerCultural LeadershipLevels of Personal Diversity Awareness

a. (5 points) Download the homework Excel data file and save the downloaded file as fac18002HW1.xlsx. The Excel file contains three worksheets, “Name and ID”, “Stacy’s Travel”, and “Salary”. b. (5 points) Enter your name and NetID in the “Name and ID” sheet;For sheet “Stacy’s Travel”, you are required to track all of the winter holiday specials that you sell as an agent at Stacy’s Travel Agency. Customers can purchase a package with or without airfare (flight). You are required to collect from each customer a down payment which is based on 15% of his/her total purchase amount. All customers are required to pay his/her balance after down payment on a monthly payment plan for one year, which you calculate based on a standard interest rate (shown in cell B3).c. (5 points) Assign the name “Specials” to range A16:C20;d. (5 points) Insert a function to display the current date in cell B2;e. (5 points) Use VLOOKUP function in column E for all customers to display the package cost for eachcustomer, based on their selected package (inside your VLOOKUP function, use range name“Specials” you defined in c. above);f. (10 points) In column F, use a combination of IF and VLOOKUP function to decide whether acustomer’s flight cost should be 0 (if the customer does not need a flight) or find and display the corresponding flight cost for the customer based on his/her selected package, again, use range name “Specials” you defined in c. above;g. (5 points) In column G, for each customer, calculate the total cost of the purchase;h. (5 points) In column H, for each customer, create a function to show the amount of down payment;i. (5 points) In column I, for each customer, create a function to display the balance, which is thedifference between the total purchase cost and the down payment;j. (5 points) In column J, for each customer, create a function to calculate the customer’s monthlypayment, using appropriate relative and absolute cell references. Monthly payments are based on 12 months and the standard interest rate displayed in cell B3 (use cell address, do not directly type this interest rate in your formula);k. (5 points) In cell J16, use COUNIF function to display the total number of customers who need flight;l. (5 points) In cell J17, use a combination of the functions MAX, INDEX, and MATCH to display thecustomer name with the highest total purchase cost;m. (5 points) Format all monetary values to be currency (USD) with 2 decimal digits (if you chooseaccounting format, the cells with 0 flight cost will automatically change to “$ -“, which is ok);n. (5 points) Create a 3-D Pie Chart (position it anywhere on the sheet) to display the Total Purchase Cost (in terms of %) for each customer. The chart looks similar to the following. Use Chart Style 4.The sheet “Salary” stores employee information for a company. Your job is to help the company achieve the following tasks:o. (5 points) Insert a “Pay Grade” column between Salary and Performance. Create a formula for the Pay Grade column to decide whether an employee’s salary is either “High” or “Low”. If an employee’s salary is greater than or equal to the average salary of all employees, the pay grade is “High”, otherwise it’s “Low”. Use a formula to do this, do not manually enter “High” or “Low” for each employee;p. (10 points) Design a mechanism for the user to find a particular employee by enter her ID. See the screenshot below.The user enters an employee ID into cell L2, then cells L4, L5, L6, L7, and L8 should display the employee’s first name, last name, gender, pay grade, and performance. Note: you can decide to use either Vlookup or a combination of Index and Match to design this search mechanism;q. (10 points) Continue from p above, in cell L10 create a function to decide whether the found employee deserves a raise. The criteria is, if the employee’s Pay Grade is “Low”, and the Performance is “Excellent”, then the employee deserves a raise (put a “Yes” here). Otherwise, no raise (put a “No” here).

You are the hospital administrator for a county hospital, which is funded in a large part by that county's property taxes. You discover that you have an indigent patient who has been mistakenly admitted as an inpatient to the hospital strictly for dialysis treatment. The hospital does not, as a general practice, provide only dialysis treatment for patients. This is beyond the scope of the hospital's mandate and is therefore, an inappropriate use of local property tax funding.If the indigent patient is discharged from the hospital and dialysis treatment is terminated, the patient will become toxic and experience severe physical consequences, even death. However, if the patient is kept in the hospital for purposes of dialysis treatment only, the hospital must assume the burden of the patient's debt, without revenue to cover the associated cost.Based on your understanding of the above scenario, create a report in a Microsoft Word document that includes an analysis using the classic decision model to keep the patient in the hospital or discharge them.Include: An introduction Definition of the problem. Identification of the stakeholders. Identification of alternative solutions. Evaluation of alternative solutions. Solution chosen and how to implement it with the stakeholders. Conclusion and reflection of this process.To support your work, use your course and textbook readings and also use the South University Online Library. As in all assignments, cite your sources in your work and provide references for the citations in APA format.Your assignment should be addressed in a 2- to 3-page document.