MODULE 11

Instructions

Responses Responses
Insert a new sheet titled San Francisco Salaries
Important data into the above sheet from San Francisco Salaries.txt
Format appropriately
Insert a column in H titled Total Pay & Benefits
Populate this column with the total of base pay, OT, Other pay, and benefits
In column M create a formula to determine the Base Pay as a percent of Total Pay & Benefits
In 2011, what job title had the most employees & how many were there?
How many total employees were there in 2011?
How many total employees were there in 2014?
In 2012, what was the Average Base pay as a percent of total pay & benefits for the Accountant II position?
In 2013, which individual (name) had the highest total pay & benefits?
In 2013, which job title had the highest average total pay & benefits?
In 2012, which job title had the highest average of OT pay?
In 2012, which job title had the highest average Other pay?
In 2014, which Part Time (PT) job title had the highest total pay & benefits and how much was it?
In 2014, which Full Time (FT) job title had the highest total pay & benefits and how much was it?
In 2014, how many Full Time (FT) Pharmacist were employed?
In 2014, how many Part Time (PT) Storekeepers were employed?
In 2014, what was the average (FT) Lieutenant, Fire Suppression average base pay as a percent of total pay?
All years combined, how much was paid in all forms to custodians?
In 2013, who was the highest total paid Accountant IV and what was the total pay?
In 2014, what was Michael R Rottmayer’s % base pay as a percent of total?
In 2014, how many full time employees were there?
In 2014, how many part time employees were there?
All years combined, what percent of the total pay & benefits went to Firefighters? (one decimal place)
All years combined, how much was paid to all positions?
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *