Please help me the formula for the deduction part (OASDI,Medicare, FWT, SWT,..) and entry payroll tax expense
- 2 X - x Insert Delete Format X 2 -3 = Bronson Co. Payroll Register PART 1(2) (1).xlsx - Microsoft Excel (Product Activation Failed) File Home Insert Page Layout Formulas Data Review View Developer QuickBooks % Cut Arial 12 - AA = = = r Wrap Text General Ea Copy Paste BIU D A E Merge & Center - $ % Format Painter & ... Conditional Format Cell Formatting as Table Styles Clipboard Font Alignment Number Styles A41 A B C D E F G H I J I L M N O 1 Accounting and Payroll Systems: Payroll Unit 2 2 Preparing a Payroll Register with Deductions AutoSum - A Fill- Sort & 2 Clear Filter Editing Find & Select Cells P Q R S T U V W 4 Bronson Company is a small manufacturing firm located in Milwaukee, WI. The company has a workforce 5 of both hourly and salaried employees. Each employee is paid for hours actually worked during 6 7 Each employee is paid for hours actually worked during each week, with the time worked being recorded 8 in quarter-hour increments. The standard workweek consists of 40 hours, with all employees being 9 paid time and one-half for any hours worked beyond the 40 regular hours. 10 11 Hours worked on Sundays are paid double-time. 12 13 Wages are paid bi-weekly one week after the payroll period ends. 14 Each individual calculation should be rounded to the nearest cent. 15 16 Employee Information: Time Card Hourly Wage or Marital Withholding No. Employee Name Salary Status Allowances 18 11 Fran M. Carson $7.50 per hour 12 William A. Wilson 7.25 per hour 13 Harry T. Utley 8.10 per hour 21 Lawrence R. Fife 7.90 per hour 22 Lucy K. Smith 9.75 per hour S2 23 31 Gretchen R. Fay 1,030 bi-weekly 24 32 Glenda B. Robey 1,700 bi-weekly M Payroll Practice Payroll Time Sheets Payroll Register | Ready | || W NANO- K 20. 85% 0 11:01 PM E or ^ Tra qox. 4) 11/15/2019 31 0 Type here to search X 2 - 2 X -3 Home = Insert Bronson Co. Payroll Register PART 1(2) (1).xlsx - Microsoft Excel (Product Activation Failed) Review View Developer QuickBooks File Page Layout Formulas Data - x * Cut 12 - AA = = = r Wrap Text General Autosum A U D - A E E Merge & Center $ % 48. Cell Styles Insert Delete Format Conditional Format Formatting as Table Styles Arial E Copy Paste Format Painter B I Clipboard A41 B C 16 Employee Information: AutoSum - A Fill Sort & 2 Clear Filter Editing Find & Select Font Alignment Number Cells D E F G H I J K L M N O P Q R S T U V W Marital Withholding Status Allowances 17 11821=$25N FS Time Card No. 11 12 13 21 22 31 32 33 51 99 Employee Name Fran M. Carson William A. Wilson Harry T. Utley Lawrence R. Fife Lucy K. Smith Gretchen R. Fay Glenda B. Robey Thomas K. Schork Barbara T. Hardy Carson C. Bronson Hourly Wage or Salary $7.50 per hour 7.25 per hour 8.10 per hour 7.90 per hour 9.75 per hour 1,030 bi-weekly 1,700 bi-weekly 1,980 bi-weekly 1,510 bi-weekly 52,000 per year 30 Requirements: 31 Part 1 32 1) Determine Hours Worked for each employee on the Time Card Register 33 2) Transfer employee information and hours worked into the Payroll Register Form 34 3) Calculate overtime and double-time rates and appropriate earnings 35 4) Determine Total Gross Earnings 36 Part 2 37 5) Calculate OASDI and Medicare Deductions (USE 2015 deduction %'s) 38 6) Use Bracket Method for Federal Withholding Tax and State Withholding Tax 39 7) Record Journal Entry from Payroll Register 40 Payroll Time Sheets Payroll Register N Ready Payroll Practice 2 20J 85% 11:02 PM E or ^ ra x 4) 11/15/2019 31 0 Type here to search - 2 X - x X 2 -3 = Bronson Co. Payroll Register PART 1(2) (1).xlsx - Microsoft Excel (Product Activation Failed) File Home Insert Page Layout Formulas Data Review View Developer QuickBooks * Cut Calibri 11 AA = = = Wrap Text General E Copy Paste Format Painter B I U B- A Merge & Center - $ -% . Formatting as Table Styles Clipboard Font Alignment Number Styles R18 A B C D E F G H I J K L M N O P Q 1 Name: AutoSum - A Fill Sort & 2 Clear Filter Editing Find & Select Cells R S T U V W X 2 Time Period Reports for Period ending January 15 (Next Pay Date is Friday, January 20) 3 4 Week of January 2 Regula Double- r Hours Overtim time Worked e Hours Hours T W S S 4 Time Card No. Employee Name 11 Fran M. Carson 12 William A. Wilson 13 Harry T. Utley 21 Lawrence R. Fife 22 Lucy K. Smith -0.0001 31 Gretchen R. Fay 32 Glenda B. Robey 33 Thomas K. Schork 51 Barbara T. Hardy 99 Carson C. Bronson - 16000 T F 8 _ S - 4 20 17 Week of January 9 Time Card No. Employee Name M 11 Fran M. Carson 12 William A. Wilson 13 Harry T. Utley 8 21 Lawrence R. Fife 8 22 Lucy K. Smith M Payroll Practice Payroll Time Sheets Ready W 8 8.5 8 8 8 10_8 8 21 8 10 3 10 8l 23 8 - K Payroll Register BOJ 85% . 0 11:02 PM 11/15/2019 0 Type here to search B 8 ^ ( Y - X a ? = 3 [z - - Ea; Bronson Co. Payroll Register PART 1(2) (1).xlsx - Microsoft Excel (Product Activation Failed) File Home Insert Page Layout Formulas Data Review View Developer QuickBooks * Cut Calibri 11 AA = = = Wrap Text General E Copy Paste Format Painter B I U B- A Merge & Center - $ -% . Formatting as Table Styles Clipboard Font Alignment Number Styles R18 | A B C D E F G H I J K L M N O P Q AutoSum - A G Filly Sort & 2 Clear Filter Editing Find & Select Cells R I S T U V W X - 16. T M W T F | S - | 4 - 8.5 17 Week of January 9 Time Card No. Employee Name 11 Fran M. Carson 12 William A. Wilson 13 Harry T. Utley 21 Lawrence R. Fife 22 Lucy K. Smith 31 Gretchen R. Fay 32 Glenda B. Robey 33 Thomas K. Schork 51 Barbara T. Hardy 2.8 99 Carson C. Bronson 4 | - 27 31 Time Period Reports for Period ending January 29 (Next Pay Date is Friday, February 3) 32 W T T 6.25 8 33 Week of January 16 Time Card | 34 No. Employee Name M 11 Fran M. Carson 8 12 William A. Wilson 7 13 Harry T. Utley 38 21 Lawrence R. Fife 10 39 22 Lucy K. Smith 8 N Payroll Practice Payroll Time Sheets Ready S - 8 8 7 8 oco S 4 L 8 10 | - | - 9 8 11 9 Payroll Register 8 8 10 6 T 3 K 0 | Ei Type here to search e = H | L] 85% = 0; 11:03 PM A G x 1) 115,2019 , = 1 X -33 | Home Insert - 2 X Bronson Co. Payroll Register PART 1(2) (1).xlsx - Microsoft Excel (Product Activation Failed) Review View Developer QuickBooks File Page Layout Formulas Data - x % Cut AutoSum - A A r = = = Es *Wrap Text Merge Merge & Center - Center Currency $ % % SF 4:0 .00 Insert Delete Format 3 703 Conditional Format Formatting as Table Styles Cell Styles u insert Delete Format conditional Formula se 2 Clear 2 Clear Calibri 11 A BIU P A Font fic 12044.76 C D sorte Fine E Copy Paste Format Painter Clipboard N19 Sort & Filter Editing Find & Select Alignment Number Cells E G H I J K L M O P Q R S 32 33 For Bi-Weekly Pay Period Ending January 29, 2015: DEDUCTIONS Total Gross Earnings Earnings OASDI Medicare FWT SWT Other Net Pay Marital With Status Allow. S S Time 36 Card No. Name 11 Fran M. Carson 12 William A. Wilson 13 Harry T. Utley 21 Lawrence R. Fife 22 Lucy K. Smith 31 Gretchen R. Fay 32 Glenda B. Robey 33 Thomas K. Schork 51 Barbara T. Hardy 99 Carson C. Bronson TOTALS Regular Earnings Hours Rate Per Worked Hour Amount 7.50 7.25 8.10 7.90 9.75 12.88 21.25 24.75 1 8.88 25.00 Overtime Earnings Hours Rate Per Worked Hour Amount 11.25 10.88 12.15 11.85 14.63 19.32 31.88 37.13 28.32 37.50 Doubletime Earnings Hours Rate Per Worked Hour Amount 15.00 14.50 16.20 15.80 19.50 25.76 42.50 49.50 37.76 50.00 M M S M M I 51 7 Cross Ref. Fixed ROUND, 2 Cross Ref. ROUND, 2 ROUND, 2 Cross Ref. ROUND, 2 ROUND, 2 =Reg+Ovt+Dbt None Gross-Ded. 2012 rate 2012 rate ROUND, 2 ROUND, 2 Bracket 2012 Bracket 2012 50 Accounting Entry from Payroll: Debit Credit Debit Credit 2/3/2012 Hourly Employee Wage Expense Salaried Employee Wage Expense OASDI Payable (EE) Medicare Payable (EE) FWT Payable SWT Payable Other Payable Cash Payroll Tax Entries: Payroll Tax Expense OASDI Payable (ER) Medicare Payable (ER) FUTA Payable SUTA Payable .6% on first $7,000 3.6% on first $13,000 ROUND, 2 ROUND, 2 What the payroll costs the company? Hourly Employee Wage Expense Salaried Employee Wage Expense Payroll Tax Expense 64 Payroll Practice Payroll Time Sheets Payroll Register KT M Ready 2073% 11:03 PM gA Ara 0x () W 11/15/2019 0 Type here to search - 2 X - x Insert Delete Format X 2 -3 = Bronson Co. Payroll Register PART 1(2) (1).xlsx - Microsoft Excel (Product Activation Failed) File Home Insert Page Layout Formulas Data Review View Developer QuickBooks % Cut Arial 12 - AA = = = r Wrap Text General Ea Copy Paste BIU D A E Merge & Center - $ % Format Painter & ... Conditional Format Cell Formatting as Table Styles Clipboard Font Alignment Number Styles A41 A B C D E F G H I J I L M N O 1 Accounting and Payroll Systems: Payroll Unit 2 2 Preparing a Payroll Register with Deductions AutoSum - A Fill- Sort & 2 Clear Filter Editing Find & Select Cells P Q R S T U V W 4 Bronson Company is a small manufacturing firm located in Milwaukee, WI. The company has a workforce 5 of both hourly and salaried employees. Each employee is paid for hours actually worked during 6 7 Each employee is paid for hours actually worked during each week, with the time worked being recorded 8 in quarter-hour increments. The standard workweek consists of 40 hours, with all employees being 9 paid time and one-half for any hours worked beyond the 40 regular hours. 10 11 Hours worked on Sundays are paid double-time. 12 13 Wages are paid bi-weekly one week after the payroll period ends. 14 Each individual calculation should be rounded to the nearest cent. 15 16 Employee Information: Time Card Hourly Wage or Marital Withholding No. Employee Name Salary Status Allowances 18 11 Fran M. Carson $7.50 per hour 12 William A. Wilson 7.25 per hour 13 Harry T. Utley 8.10 per hour 21 Lawrence R. Fife 7.90 per hour 22 Lucy K. Smith 9.75 per hour S2 23 31 Gretchen R. Fay 1,030 bi-weekly 24 32 Glenda B. Robey 1,700 bi-weekly M Payroll Practice Payroll Time Sheets Payroll Register | Ready | || W NANO- K 20. 85% 0 11:01 PM E or ^ Tra qox. 4) 11/15/2019 31 0 Type here to search X 2 - 2 X -3 Home = Insert Bronson Co. Payroll Register PART 1(2) (1).xlsx - Microsoft Excel (Product Activation Failed) Review View Developer QuickBooks File Page Layout Formulas Data - x * Cut 12 - AA = = = r Wrap Text General Autosum A U D - A E E Merge & Center $ % 48. Cell Styles Insert Delete Format Conditional Format Formatting as Table Styles Arial E Copy Paste Format Painter B I Clipboard A41 B C 16 Employee Information: AutoSum - A Fill Sort & 2 Clear Filter Editing Find & Select Font Alignment Number Cells D E F G H I J K L M N O P Q R S T U V W Marital Withholding Status Allowances 17 11821=$25N FS Time Card No. 11 12 13 21 22 31 32 33 51 99 Employee Name Fran M. Carson William A. Wilson Harry T. Utley Lawrence R. Fife Lucy K. Smith Gretchen R. Fay Glenda B. Robey Thomas K. Schork Barbara T. Hardy Carson C. Bronson Hourly Wage or Salary $7.50 per hour 7.25 per hour 8.10 per hour 7.90 per hour 9.75 per hour 1,030 bi-weekly 1,700 bi-weekly 1,980 bi-weekly 1,510 bi-weekly 52,000 per year 30 Requirements: 31 Part 1 32 1) Determine Hours Worked for each employee on the Time Card Register 33 2) Transfer employee information and hours worked into the Payroll Register Form 34 3) Calculate overtime and double-time rates and appropriate earnings 35 4) Determine Total Gross Earnings 36 Part 2 37 5) Calculate OASDI and Medicare Deductions (USE 2015 deduction %'s) 38 6) Use Bracket Method for Federal Withholding Tax and State Withholding Tax 39 7) Record Journal Entry from Payroll Register 40 Payroll Time Sheets Payroll Register N Ready Payroll Practice 2 20J 85% 11:02 PM E or ^ ra x 4) 11/15/2019 31 0 Type here to search - 2 X - x X 2 -3 = Bronson Co. Payroll Register PART 1(2) (1).xlsx - Microsoft Excel (Product Activation Failed) File Home Insert Page Layout Formulas Data Review View Developer QuickBooks * Cut Calibri 11 AA = = = Wrap Text General E Copy Paste Format Painter B I U B- A Merge & Center - $ -% . Formatting as Table Styles Clipboard Font Alignment Number Styles R18 A B C D E F G H I J K L M N O P Q 1 Name: AutoSum - A Fill Sort & 2 Clear Filter Editing Find & Select Cells R S T U V W X 2 Time Period Reports for Period ending January 15 (Next Pay Date is Friday, January 20) 3 4 Week of January 2 Regula Double- r Hours Overtim time Worked e Hours Hours T W S S 4 Time Card No. Employee Name 11 Fran M. Carson 12 William A. Wilson 13 Harry T. Utley 21 Lawrence R. Fife 22 Lucy K. Smith -0.0001 31 Gretchen R. Fay 32 Glenda B. Robey 33 Thomas K. Schork 51 Barbara T. Hardy 99 Carson C. Bronson - 16000 T F 8 _ S - 4 20 17 Week of January 9 Time Card No. Employee Name M 11 Fran M. Carson 12 William A. Wilson 13 Harry T. Utley 8 21 Lawrence R. Fife 8 22 Lucy K. Smith M Payroll Practice Payroll Time Sheets Ready W 8 8.5 8 8 8 10_8 8 21 8 10 3 10 8l 23 8 - K Payroll Register BOJ 85% . 0 11:02 PM 11/15/2019 0 Type here to search B 8 ^ ( Y - X a ? = 3 [z - - Ea; Bronson Co. Payroll Register PART 1(2) (1).xlsx - Microsoft Excel (Product Activation Failed) File Home Insert Page Layout Formulas Data Review View Developer QuickBooks * Cut Calibri 11 AA = = = Wrap Text General E Copy Paste Format Painter B I U B- A Merge & Center - $ -% . Formatting as Table Styles Clipboard Font Alignment Number Styles R18 | A B C D E F G H I J K L M N O P Q AutoSum - A G Filly Sort & 2 Clear Filter Editing Find & Select Cells R I S T U V W X - 16. T M W T F | S - | 4 - 8.5 17 Week of January 9 Time Card No. Employee Name 11 Fran M. Carson 12 William A. Wilson 13 Harry T. Utley 21 Lawrence R. Fife 22 Lucy K. Smith 31 Gretchen R. Fay 32 Glenda B. Robey 33 Thomas K. Schork 51 Barbara T. Hardy 2.8 99 Carson C. Bronson 4 | - 27 31 Time Period Reports for Period ending January 29 (Next Pay Date is Friday, February 3) 32 W T T 6.25 8 33 Week of January 16 Time Card | 34 No. Employee Name M 11 Fran M. Carson 8 12 William A. Wilson 7 13 Harry T. Utley 38 21 Lawrence R. Fife 10 39 22 Lucy K. Smith 8 N Payroll Practice Payroll Time Sheets Ready S - 8 8 7 8 oco S 4 L 8 10 | - | - 9 8 11 9 Payroll Register 8 8 10 6 T 3 K 0 | Ei Type here to search e = H | L] 85% = 0; 11:03 PM A G x 1) 115,2019 , = 1 X -33 | Home Insert - 2 X Bronson Co. Payroll Register PART 1(2) (1).xlsx - Microsoft Excel (Product Activation Failed) Review View Developer QuickBooks File Page Layout Formulas Data - x % Cut AutoSum - A A r = = = Es *Wrap Text Merge Merge & Center - Center Currency $ % % SF 4:0 .00 Insert Delete Format 3 703 Conditional Format Formatting as Table Styles Cell Styles u insert Delete Format conditional Formula se 2 Clear 2 Clear Calibri 11 A BIU P A Font fic 12044.76 C D sorte Fine E Copy Paste Format Painter Clipboard N19 Sort & Filter Editing Find & Select Alignment Number Cells E G H I J K L M O P Q R S 32 33 For Bi-Weekly Pay Period Ending January 29, 2015: DEDUCTIONS Total Gross Earnings Earnings OASDI Medicare FWT SWT Other Net Pay Marital With Status Allow. S S Time 36 Card No. Name 11 Fran M. Carson 12 William A. Wilson 13 Harry T. Utley 21 Lawrence R. Fife 22 Lucy K. Smith 31 Gretchen R. Fay 32 Glenda B. Robey 33 Thomas K. Schork 51 Barbara T. Hardy 99 Carson C. Bronson TOTALS Regular Earnings Hours Rate Per Worked Hour Amount 7.50 7.25 8.10 7.90 9.75 12.88 21.25 24.75 1 8.88 25.00 Overtime Earnings Hours Rate Per Worked Hour Amount 11.25 10.88 12.15 11.85 14.63 19.32 31.88 37.13 28.32 37.50 Doubletime Earnings Hours Rate Per Worked Hour Amount 15.00 14.50 16.20 15.80 19.50 25.76 42.50 49.50 37.76 50.00 M M S M M I 51 7 Cross Ref. Fixed ROUND, 2 Cross Ref. ROUND, 2 ROUND, 2 Cross Ref. ROUND, 2 ROUND, 2 =Reg+Ovt+Dbt None Gross-Ded. 2012 rate 2012 rate ROUND, 2 ROUND, 2 Bracket 2012 Bracket 2012 50 Accounting Entry from Payroll: Debit Credit Debit Credit 2/3/2012 Hourly Employee Wage Expense Salaried Employee Wage Expense OASDI Payable (EE) Medicare Payable (EE) FWT Payable SWT Payable Other Payable Cash Payroll Tax Entries: Payroll Tax Expense OASDI Payable (ER) Medicare Payable (ER) FUTA Payable SUTA Payable .6% on first $7,000 3.6% on first $13,000 ROUND, 2 ROUND, 2 What the payroll costs the company? Hourly Employee Wage Expense Salaried Employee Wage Expense Payroll Tax Expense 64 Payroll Practice Payroll Time Sheets Payroll Register KT M Ready 2073% 11:03 PM gA Ara 0x () W 11/15/2019 0 Type here to search
