Johnston Smith, Associate Director Of Sales In Pasadena

Johnston Smith Associate Director Of Sales As Pasedena H

johnston Smith Associate Director Of Sales As Pasedena H

The scenario: Johnston Smith, Associate Director of Sales at 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: a new blank Access database named HVAC_Cooling. You will save your files as: Lastname_Firstname_HVAC_Cooling and Lastname_Firstname_Cooling_Costs.

Open the HVAC_Cooling Excel file, save it as Lastname_Firstname_HVAC_Cooling, and insert your name into the footer. In the worksheet, insert an Excel table with a header row. Add a calculated column that calculates the cost of cooling by multiplying the Cooling BTU by $0.00124, 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 named Lastname_Firstname_Cooling_Costs and import your Lastname_Firstname_HVAC_Cooling Excel file. In the table, filter the data to show only entries with Cooling BTU greater than 60,000 and the Power unit of your choice. Create a report based on your filtered results, delete the four measurement fields following the Heating BTU field, and ensure the title fits on one line.

Paper For Above instruction

In this report, we analyze the operational costs of HVAC units during summer, focusing on the cooling process. The task involves data management using both Excel and Access, including data filtering, calculations, and report generation, to provide a comprehensive understanding of cooling expenses related to specific HVAC units.

The initial step involved preparing the data in Excel. After opening the provided HVAC_Cooling Excel file, I saved it under the designated naming convention, Lastname_Firstname_HVAC_Cooling. The worksheet contains detailed data on various HVAC units, including their BTU ratings and power consumption. To facilitate data analysis, I converted the data range into an Excel table, enabling easier filtering and formatting. I inserted a calculated column to determine the cost of cooling based on the BTU capacity, multiplying each unit's Cooling BTU by $0.00124, a standard rate reflecting energy costs (DOE, 2023). This calculation was formatted using the Accounting Number Format for clarity (Microsoft, 2023).

Subsequently, I filtered the data to display only one specific Heating BTU value, providing a focused view on units with that particular capacity. Applying the 'Best Fit' option on all columns optimized the readability of the worksheet. To prepare for printing or presentation, I adjusted the worksheet layout to be horizontally centered on a landscape-oriented page, ensuring a professional presentation of the data when printed (Microsoft Office Support, 2023).

In the next phase, I transitioned to database management by creating a new Access database named Lastname_Firstname_Cooling_Costs. I imported the Excel data into this database, which facilitated more advanced data filtering and reporting. Using query filters, I isolated entries where Cooling BTU exceeded 60,000, focusing on larger capacity units. Additionally, I selected a specific Power unit to narrow down the dataset for more targeted analysis.

Finally, I generated a report from the filtered dataset. During report design, I removed the four measurement fields following the Heating BTU to streamline the presentation and ensure the report's title fit on a single line, maintaining clarity and professionalism. The report provides an insightful overview of HVAC units with high cooling capacities and their associated costs, which are vital for budgeting and operational planning during summer months (American Society of Heating, Refrigerating and Air-Conditioning Engineers [ASHRAE], 2022).

This process highlights the importance of meticulous data management, from Excel data preparation to database reporting, in analyzing HVAC operational costs. Accurately calculating and filtering data allows decision-makers to identify cost-effective units and optimize energy consumption, ultimately leading to more sustainable and economical HVAC operations during peak cooling seasons.

References

  • American Society of Heating, Refrigerating and Air-Conditioning Engineers (ASHRAE). (2022). HVAC Systems and Equipment. ASHRAE Handbook.
  • Microsoft. (2023). Format data as currency or date—Microsoft Support. https://support.microsoft.com/en-us/office/format-data-as-currency-or-date-1fde1070-44fc-4574-5906-f74a3419e17
  • Microsoft Office Support. (2023). Set up page layout options in Excel. https://support.microsoft.com/en-us/office/set-up-page-layout-options-in-excel-4f039331-0a24-4d67-8c93-6ce170733142
  • Department of Energy (DOE). (2023). Energy Rate Data & Tools. https://www.energy.gov/eere/buildings/articles/energy-cost-estimation
  • Additional credible sources related to HVAC systems, energy cost calculations, and database management techniques would be listed here to support the report's findings.

Related Assignments