Based on the spreadsheet, can you create a presentation and provide information for the following:

Think of both universal recommendations (such as laws that apply to all US companies) and specific recommendations (what are some issues that are unique to this company?)

• For the given data, are any marketplace and/or salary concerns?
• Are women or minorities paid fairly compared to men?
• Are any changes required due to compliance reasons (Civil Rights Act, Fair Labor Standards Act, Minimum Wage, Federal/State Laws)?
• Are there any pay-band structure problems identified and/or solutions proposed?
• Any there any specific demographics that need attention? (Race/minority issues, gender imbalances)? Do they need to plan for succession of potential upcoming retirements?
• Specify recommended changes, why to suggest the changes, and how HR plans to implement changes to the compensation program company-wide.

H2 The_Defunct_Company_Office_Payroll - Read-Only - Excel Search Anita Johnson X File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Share Comments Insert Calibri 8 A ab == a Wrap Text General AY O 3 AX Delete v Paste BIU A y EEE 3 Merge & Center Ideas $ % -29 y Sensitivity Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas Sensitivity A1 X Window Snip A B c D E F G H Salary M/F M M F F M Years of Service 40 1 1 25 3 15 2 2 39 M M M M F F F 2 Title 3 President 4 CFO 5 IT Director Purchasing Director 7 Director of Operations 8 Director of Technology 9 Controller 10 Director of Sales 11 Director of Sales 12 HR Director 13 Marketing Manager 14 Receptionist 15 | Accts. Receivable Mgr 16 Billing Supervisor 17 Assistant Billing 18 Accounting Supervisor 19 Accts. Payable & Payroll Clerk 20 Customer Service Manager 21 Customer Service Manager 22 Customer Service Rep 1 23 Customer Service Rep 2 24 Customer Service Rep 2 25 Customer Service Rep 2 26 l Customer Service Rep 2 27 Customer Service Rep 2 28 l Customer Service Rep 2 29 Customer Service Rep 2 F Dept Exec. Accounting IT Purch. Operations Technology Accounting MAG Division SEP Division HR Mktg. Accounting Accounting Accounting Accounting Accounting Accounting MAG Division SEP Division MAG Division MAG Division MAG Division MAG Division SEP Division SEP Division SEP Division SEP Division ----... Age 62 59 41 45 55 38 53 60 58 41 40 40 60 58 50 32 24 40 41 58 45 43 300,000 185,000 117,000 99,000 134,000 124,000 110,000 189,000 134,000 72,000 68,000 32,000 68,000 56,000 28,000 54,000 34,000 72,000 65,000 72,000 54,000 45,000 65,000 13.00/hr 41,000 45,000 72,000 Exempt/Non Exempt Exempt Exempt Exempt Exempt Exempt Exempt Exempt Exempt Exempt Exempt Exempt Exempt Exempt Non Exempt (hourly) Non Exempt (hourly) Exempt Exempt Exempt Exempt Exempt Exempt Exempt Exempt Non Exempt (PT Hourly) Exempt Exempt Exempt EEOC Classification Caucasian Hispanic Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian African American F F F F M M M M M F M F 28 1 1 15 15 38 35 12 3 2 15 7 25 12 8 18 4 5 F M F - 43 40 32 35 60 -- 6 40 261 Enne ---- INTL Sheet1 Sheet2 Sheet3 Ready Average: 30037.2437 Count: 329 Sum: 3574432 + 100% cr H2 The_Defunct_Company_Office_Payroll - Read-Only - Excel Search Anita Johnson X File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Share Comments Insert Calibri 8 A ab == a Wrap Text General AY O 3 AX Delete v Paste BIU A y EEE 3 Merge & Center Ideas $ % -29 y Sensitivity Format Conditional Format as Cell Formatting Table Styles Styles Sort & Find & Filter Select Editing Clipboard Font Alignment Number Cells Ideas Sensitivity A1 X Window Snip A B c D E F G H Salary M/F M M F F M Years of Service 40 1 1 25 3 15 2 2 39 M M M M F F F 2 Title 3 President 4 CFO 5 IT Director Purchasing Director 7 Director of Operations 8 Director of Technology 9 Controller 10 Director of Sales 11 Director of Sales 12 HR Director 13 Marketing Manager 14 Receptionist 15 | Accts. Receivable Mgr 16 Billing Supervisor 17 Assistant Billing 18 Accounting Supervisor 19 Accts. Payable & Payroll Clerk 20 Customer Service Manager 21 Customer Service Manager 22 Customer Service Rep 1 23 Customer Service Rep 2 24 Customer Service Rep 2 25 Customer Service Rep 2 26 l Customer Service Rep 2 27 Customer Service Rep 2 28 l Customer Service Rep 2 29 Customer Service Rep 2 F Dept Exec. Accounting IT Purch. Operations Technology Accounting MAG Division SEP Division HR Mktg. Accounting Accounting Accounting Accounting Accounting Accounting MAG Division SEP Division MAG Division MAG Division MAG Division MAG Division SEP Division SEP Division SEP Division SEP Division ----... Age 62 59 41 45 55 38 53 60 58 41 40 40 60 58 50 32 24 40 41 58 45 43 300,000 185,000 117,000 99,000 134,000 124,000 110,000 189,000 134,000 72,000 68,000 32,000 68,000 56,000 28,000 54,000 34,000 72,000 65,000 72,000 54,000 45,000 65,000 13.00/hr 41,000 45,000 72,000 Exempt/Non Exempt Exempt Exempt Exempt Exempt Exempt Exempt Exempt Exempt Exempt Exempt Exempt Exempt Exempt Non Exempt (hourly) Non Exempt (hourly) Exempt Exempt Exempt Exempt Exempt Exempt Exempt Exempt Non Exempt (PT Hourly) Exempt Exempt Exempt EEOC Classification Caucasian Hispanic Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian Caucasian African American F F F F M M M M M F M F 28 1 1 15 15 38 35 12 3 2 15 7 25 12 8 18 4 5 F M F - 43 40 32 35 60 -- 6 40 261 Enne ---- INTL Sheet1 Sheet2 Sheet3 Ready Average: 30037.2437 Count: 329 Sum: 3574432 + 100% cr