Salary and Work-Related Information

You will use the Homework starter download to complete the assignment , the homework starter download needs to be a fully completed excel sheet to answer these following questions below:

-You have been asked by the Director of HR of Reginald Trucking to produce a one-page executive memo on the data included in the starter workbook that answers these questions:

Salary and work-related information as follows:

Total salary of all employees?

Average salary of all employees?

Total Scheduled Work Hours, Posted Hours, and the variance (difference) between Scheduled and Posted?

Count of employees as follows:?

Total employee count and then sub-totals by gender (male and female) for the entire organization?

Count of employees at each plant location shown on this report (hint: there are three plant locations shown on this report)?

Additionally, the benefits group of Reginald Trucking wants to begin sending birthday cards to employees, but in batches by month and needs to know how many to plan to send out for January, February and March. If it goes well, they will plan on following up with all months of the year.

-Then Once you have answered all the questions you need to develop a 1-page memo to send to Human Resources that address those questions. The memo should be nicely organized and clearly communicate the required information. This memo should be organized as a Microsoft Word document

I attached the sample of how the excel spreadsheet of the Activity homework starter is suppose to look