BUS spreadsheet

please show the formulas

. A B D E F G H 1 K Fica Rate M 8,65% 2 Sit rate 4% 3 Fit 18% 4 Payroll Register 5 (take home pay) 6 hours pay rate gross pay Fica Sit Fit Total deductions Net Pay 7 Marie Osmond 21 65 $1,365,00 $118.07 $ 54.60 $ 245.70 418.37 S 946.63 8 John Legend 38 125 $4,750.00 $410.88 $190.00 S 855.00 S 1.455.88 $ 3,294.13 9 Pink 35 90 $3,150.00 $272.48 $126.00 S 567.00 S 965.48 S 2.184.53 10 Greg Allman 10 50 S 500.00 $ 43.25 S 20.00 S 90.00 S 153.25s 346.75 11 Total $9,765.00 $844.67 $390.60 $1,757.70 S 2,992.97 $ 6.772.03 12 13 14 Directions: (check off each line as you do it so you don't forget any of the directions) 15 1. Calculate gross pay for each employee (hours times rate). Use cell references, not numbers so that I can change the hours and rate and still get correct answers 16 2. Forrow 7, enter your formulas and then copy them down to rows 8.10 17. Remember to use S signs in row 7, so the formulas can be copied down... Do not enter new formulas in rows 8-10 18 if your formulas are correct in row 7, you should be able to use the fill handle and copy the formulas down to row 8-10 19 of an individual works more than 40 hours in any week, they get paid overtime which is time and a half of the regular rate. 20 Net pay is gross pay minus deductions 21 3. Fica (social security is 8.65% of gross pay), use cell references and copy it down 22 4. Sit (state income tax) is 4% of gross pay, use cell references and copy it down 23 S. Fit (federal income tax is 18% of gross pay), use cell references and copy it down 24 6. Go to D11 and use the fill handle and pull the formula across to column F through! 25 7. For E11 though 111, have your formatting show double lines at the bottom and a single line at the top 26 B. In F7, Click on review tab, new comment and type "Fica rate is 1.658", then click outside the cell A B C D E 17 Remember to use $ signs in row 7, so the formulas can be copied down... Do not enter new formulas in rows 8-10 F G H 18 If your formulas are correct in row 7, you should be able to use the fill handle and copy the formulas down to row 8-10 19 If an individual works more than 40 hours in any week, they get paid overtime which is time and a half of the regular rate. 20 Net pay is gross pay minus deductions 21 3. Fica (social security is 8.65% of gross pay), use cell references and copy it down 22 4. Sit (state income tax) is 4% of gross pay, use cell references and copy it down 23 5. Fit (federal income tax is 18% of gross pay), use cell references and copy it down 24 6. Go to D11 and use the ill handle and pull the formula across to column F through) 25 7. For E11 though 111, have your formatting show double lines at the bottom and a single line at the top 26 8. In F7, Click on review tab, new comment and type "Fica rate is 8.65%", then dick outside the call 27 9. In G7, Click on new comment, "sit rate is 4%", then click outside the cell 28 10. in H7. Click on new comment, "fit rate is 18%", then click outside the cell 29 11. Click on the Page Layout tab, click on Page Setup, click on sheet, and change the comments to "print at end of sheet" 30 Excel will now print your comments at the end of the worksheet 31 If you print now, you will get the file and its comments printed 32 12. Autofit all columns but A 33 13. Save file as payrollregisteryourname 34 14. Submit completed project in the dropbox where the instruction file was located. 35 36 Must use cell references whenever possible, not actual's 37 This is what is referred to as what if, where we can then change a number 38 and all cells will recalculate automatically correctly. 39 40 Use your $ signs when you don't want the row or column to change 41 even if it won't change your answer to that we can start to really understand this concept and will be able to use it when needed 42 A Note: Sheet1