InstructionsThe scenario:Johnston Smith, Associate Director of Sales as Pasedena HVAC Manufacturer, has asked you to calculate the cost of running HVAC units in summer and provide a report.For this assignment, you will need the following files:New blank Access databaseHVAC_CoolingYou will save your files as:Lastname_Firstname_HVAC_CoolingLastname_Firstname_Cooling_CostsOpen the HVAC_Cooling Excel file, and save the file as Lastname_Firstname_HVAC_Cooling.Insert the your name in the footer.In the worksheet, insert an Excel table with a header row.Add a calculated column that calculates the cost of cooling using $0.00124 per Cooling BTU formatted with the Accounting Number Format.Filter the data to display only one Heating BTU number of your choice.Apply Best Fit to all columns.Center the worksheet horizontally on a landscape page.In Access, create a new database and save it as Lastname_Firstname_Cooling_CostsImport your Lastname_Firstname_HVAC_Cooling Excel file.In the table, filter the data to show only data for the Cooling BTU greater than 60,000 and the Power unit of your choice.Create a report based on your results.Delete the four measurement fields following the Heating BTU field, and be sure the title fits on one line.

Instructions: You are the HR Director for Washington Memorial Hospital, a sixty-year old, 250-bed acute care hospital located downtown in a major city. The hospital has been renovated several times over the years and is a landmark in the city. About ten years ago the mayor and the city council began a revitalization project to bring businesses and residents back downtown and establish the downtown area as a conference hub for conventions as well. Their plans have been going well. Finances at Washington Memorial have been tight for the last few years. The hospital employs emergency department physicians along with all hospital support staff. Because of its location, many doctors and patients have been reluctant to use the hospital in the past. The recently hired hospital administrator, however, has plans to change that. She has a vision of making Washington Memorial a “Center of Excellence” in cardiac care and surgery and believes that the cardiac department can be a major profit center for the facility. Monies have been made available to begin the changes and to support the hospital for a few years until the revamping has taken place and the hospital is profitable again. The hospital administrator has hired several consultants who are working on marketing and other strategies for the hospital’s new image, and now you have been asked to look strategically at HR services in light of the changes that are being made. The hospital administrator states that the three most important HR goals are the following. 1. Attracting the best cardiac surgeons and specialists to Washington Memorial, making it a “Center of Excellence” able to provide the best cardiac surgery and care available. 2. Training present staff who wish to remain at the hospital and are willing to adjust professionally. 3. Providing a workplace that is committed to effective employee/employer relations.   This Stand-Alone Project is comprised of 5 parts. Develop a plan to support this new strategy through human resources by completing Parts A, B, C, D, and E. (A 10-page response is required.) Five (5) scholarly articles are also required. (200 points) Part A HR Strategy Part B Recruiting Part C Compensation and Benefits Part D Training and Development Part E Employee