Project #15421 - Excel Assignment

 

As the Director of the After-School Grant-funded program, you have been authorized to allocate a portion of the grant to give salary increases to the current staff. You may use money equal to 4.5% of the current total salaries that the staff as a whole makes.

Here is the current staff, their titles, and current salaries: (You will make up the names. Be sure to include yourself as the Executive Director!)

 

 

1

Executive Director

$ 75,418.42

2

Associate Director

$ 69,480.17

3

Associate Director

$ 62,429.54

4

Assistant to the Director

$ 51,287.87

5

Assistant to the Director

$ 43,035.34

6

Senior Learning Specialist

$ 38,480.23

7

Senior Learning Specialist

$ 37,131.01

8

Senior Learning Specialist

$ 35,900.39

9

Learning Specialist

$ 34,470.20

10

Learning Specialist

$ 34,316.91

11

Learning Specialist

$ 34,287.61

12

Administrative Assistant

$ 32,040.83

13

Administrative Assistant

$ 30,000.00

14

Administrative Assistant

$ 23,923.19

 

 

Create an Excel spreadsheet that includes the names of the staff members, their titles, and current salary. Write a formula(s) in one or more cells that calculates the "Total Available Money" [it is 4.5% of the current total staff salary] and the total remaining as you award raises. This "Total Remaining" should be dynamic; it should change as you add/subtract money from staff member’s salaries elsewhere in the spreadsheet. Create columns that calculate what a 3.58% increase and a 4.125% increase would be for each staff member. In another column list the amounts that you are awarding each employee. Grant as much money as you wish to each staff member, but you cannot overspend and you must give at least a 2.7% increase to each staff person. Finally, create columns containing formulas that show the "New Salary", the actual percentage increase given to each staff person, and an IF formula that prints appropriate text if you are trying to give an increase that is less than 2.7%. Label columns and cells as needed to show what data is contained in the sheet. Format salaries as currency with two decimal places. Format percentages as percents with 2 decimal places.

 

 

Subject Computer
Due By (Pacific Time) 10/27/2013 11:58 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy