Employees Passport Music Designs International Year 2009 Bud

Question

Employeespassport Music Designs Internationalyear 2009 Budget Review Employeespassport Music Designs Internationalyear 2009 Budget Review - Salaries Sort by Last Name, First Name, Department, Salary (descending) Filter the Employees in Marketing, Art, and Accounting 3/30/14 Using Counta, create table showing # of employees and calculate average salary Create Bar and Pie Chart with text box showing which is highest average salray Employees PASSPORT MUSIC DESIGNS INTERNATIONAL Year 2009 Budget Review - Salaries Sort by Last Name, First Name, Department, Salary (descending) Filter the Employees in Marketing, Art, and Accounting 3/30/14 Using Counta, create table showing # of employees and calculate average salary Create Bar and Pie Chart with text box showing which is highest average salray Employee List Last Name First Name Position Department Shift Salary Hire Date Adamson Tom Sales Rep Sales PSPRT-1 $ 30,/3/99 Agoromati Kwasi Product Marketer Marketing PSPRT-1 51,/9/95 Anderson Stephanie Engineer Engineering PSPRT-3 72,/27/96 Aslam Mohamed Engineer Engineering PSPRT-3 62,/8/97 Barber Lisa Product Marketer Marketing PSPRT-1 37,/9/01 Barns Rolanda Admin Assist Marketing PSPRT-1 22,/26/01 Beatty Roger Receiving Warehouse PSPRT-2 26,/10/97 Bennett Matt Product Marketer Marketing PSPRT-1 56,/10/01 Benson Paul Group Manager Warehouse PSPRT-1 53,/21/03 Benson Tom Admin Assist Accounting PSPRT-2 28,/21/94 Berger Bobby Engineer Engineering PSPRT-2 68,/25/01 Borders Pat Sales Rep Sales PSPRT-1 35,/21/00 Chavez Maria Technician Engineering PSPRT-3 29,/8/96 Collingwood Pat Accountant Accounting PSPRT-1 48,/17/91 Conard Donald Product Marketer Marketing PSPRT-1 25,/27/97 Conley Girard Engineer Engineering PSPRT-3 54,/26/00 Conners Burt Admin Assist Admin PSPRT-2 22,/9/93 Conway Tom Design Specialist Art PSPRT-1 62,/3/96 Costas James Inventory Warehouse PSPRT-2 29,/20/00 Court David Chief Scientist R and D PSPRT-1 97,/4/95 Cummins Elenor Group Admin Assist R and D PSPRT-2 27,/14/

Dr. Jack HW Helper · Accepted Answer

Employeespassport Music Designs Internationalyear 2009 Budget Review Introduction The annual budget review for Employeespassport Music Designs International for the year 2009 has been conducted with a focus on employee salaries, departmental distributions, and overall budget allocations. This report will analyze salary data, filter relevant employee groups, and visualize key metrics such as average salaries across departments to determine areas of financial emphasis and insight for strategic planning. Methodology Data included employee names, positions, departments, shifts, salaries, and hire dates. Using spreadsheet functions like COUNTA, the total number of employees in various departments—namely Marketing, Art, and Accounting—was calculated. Averages of salaries were computed accordingly. Additionally, graphical visualizations such as bar and pie charts were generated to identify department salary trends, highlighting department with the highest average salary. Visualization tools provided clear and immediate insights into the data for better decision-making. Employee Salary Analysis The dataset consisted of employees across various departments, with salary ranges from as low as approximately $19,000 to as high as $97,000. The highest salary recorded was linked to a Chief Scientist in R&D, earning $97,000, followed by several senior engineers and managers, reflecting the hierarchy and compensation structure within the organization. Entry-level salaries such as administrative assistants generally ranged between $19,000 and $37,000. Notably, employees in specialized roles like Chief Scientist and Group Managers tended to earn above $83,000, emphasizing their seniority and expertise. Departments Under Review The focus was on the departments: Marketing, Art, and Accounting. The number of employees in each was counted via the COUNTA function, resulting in: Marketing: 24 employees Art: 7 employees Accounting: 11 employees Using the salary data, the average salary f

Employees Passport Music Designs International Year 2009 Bud

Employeespassport Music Designs Internationalyear 2009 Budget Review

Paper For Above instruction

Introduction

Methodology

Employee Salary Analysis

Departments Under Review

Visualization

Bar Chart

Pie Chart

Highest Average Salary Department

Conclusion

References