MS Excel Personal Timesheet Project (200 pts)

ALL:



JOURNAL ENTRY:  After viewing the following articles and charts, what
does the term POVERTY mean?  Find your block on the first link and find
out about how many families in your area are living below the Federal
Poverty level listed in the second chart listed.  Write 4-5 sentences
reflecting on your thoughts about this reality!

Please review this article for your Journal Entry:  Philadelphia Poverty Figures (Click Link)

Federal Averages For Annual Income (Poverty Level) (Click Here For Article)





PAYROLL TIMESHEET LINK:



Google Drive Spreadsheet:

https://docs.google.com/spreadsheet/ccc?key=0AjY9jTFcLEUWdDUyajRIY1gxLXpwSE5ZeXRLMEdmTUE&usp=sharing



Original MS Excel Document

https://docs.google.com/file/d/0BzY9jTFcLEUWYVMxdnZpLVQtbmc/edit?usp=sharing



Today you will be working on Microsoft Excel and creating a time-card
for yourself.  Please read the corresponding story to the number you are
given in class to fill out your time-card for the week ending on April 14th, 2014.  We will complete the Example together in class.



Example Employee:  Rate per hour is $10.55.  Monday was a vacation
day for eight hours. On Tuesday you worked for eight regular hours and
added two hours of overtime.  On Wednesday and Thursday you worked eight
hours, and Friday you worked for seven hours until you felt sick at
your stomach.  You logged an hour of sick time.  You went in Saturday to
make up for the time lost and added one hour of regular time and three
hours of overtime.



Here are your scenarios:





Anyone with a last name that starts with A - H will be Employee #1, I - P will be Employee #2, and Q -Z will be Employee #3.  Please use the following scenarios to fill out your timecards.



Employee #1:  You make $20.25 an hour.  You felt sick on Monday and
called out sick for eight hours.  You were feeling so much better the
next day that you worked eight hours and then an extra three hours
overtime to make up for your absence.  On Wednesday you could not be
stopped again and put in an eight hour day and one hour of overtime. 
Thursday you only were able to work seven hours, and Friday you worked
eight hours and an extra hour of "flex" time at the normal rate to make
up for Thursday.



Employee #2:  You make $14.50 an hour.  You arrived for work on Monday
ready to go.  You put in eight hours and two hours of overtime.  On
Tuesday you took a vacation day for eight hours of pay.  Wednesday and
Thursday were regular days of eight hours each, and Friday you arrived
late after two hours of sick time.  You finished the day strong and
added six hours of regular time and an additional four hours of
overtime.  Saturday you added four more overtime hours as well.



Employee #3:  You make $13.25 an hour.  On Monday you worked eight
regular hours and four hours of overtime.  You took Tuesday as a
personal day and clocked eight hours of vacation time.  On Wednesday you
worked eight hours of regular time and added an additional two hours of
overtime.  Thursday you were not feeling well and used eight hours of
sick time.  Friday and Saturday you worked full eight hour days and
logged an additional two hours of overtime.



Overtime for everyone is time and a half so multiply your hourly rate by
1.5 and you will have the overtime rate.  Sick time and Vacation Time
are the same rate as your regular rate.



Take a look at your TOTAL PAY in the bottom right hand corner.  In your
email  figure out what that number would be if you
took out the following deductions:

• Local Tax:  4.33%


• State Tax:  3.07%


• Federal Tax:  15%


• Social Security:  6.5%


• Medical Coverage:  1.4%


• Retirement / 401K:  2%

Once you complete your time-card, SHARE it with me (hscribnercaa@gmail.com).  You must also go to the back of the room and PRINT A COPY of your Timecard, Sign it and Date it, and turn it in for credit.



Good Luck!!



- Mr. S