2020 annotated EOC Chapter 4_final

xlsx

School

Estrella Mountain Community College *

*We aren’t endorsed by this school

Course

105

Subject

Electrical Engineering

Date

Apr 3, 2024

Type

xlsx

Pages

Uploaded by BrigadierMorning6292

Excel Instructions: 1. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incor 2. A formula begins with an equals sign (=) and can consist of any of the following elements: Operators such as + (for addition), - (for subtraction), * (for multiplication), and / (for division). Cell references, including cell addresses such as B52, as well as named cells and ranges Values and text Worksheet functions (such as SUM) 3. You can enter a formula into a cell manually (typing it in) or by pointing to the cells. To enter a formula manually, follow these steps: Move the cell pointer to the cell that you want to hold the formula. Type an equals sign (=) to signal the fact that the cell contains a formula. Type the formula, then press Enter. 17.65 x 1.5=26.475. The template will display and hold 26.48, not 26.475. There is no need to use Excel's rounding func EXCEPTION: Continuing Payroll Problems A & B: When calculating over-time rate for weekly salary, round regular rate to TWO decimals BEFORE calc Rounding can be accomplished by using Number function (using arrows) on Excel Home menu or by e =(Round(Weekly/40,2))*1.5 Where "Weekly" entered as either the weekly pay or cell reference. Failure to use the ROUND function will cause the OT rate to be incorrect. 5. Remember to save your work. When saving your workbook, Excel overwrites the previous copy of your file. You can You can save the file to the current name, or you may want to keep multiple versions of your work by saving each succes To save to the current name, you can select File, Save from the menu bar or click on the disk icon in the standard toolba It is recommended that you save the file to a new name that identifies the file as yours, such as Excel_End_of_Chapter_Pr To save under a different name, follow these steps: Select File, Save As to display the Save As Type drop-box, chose Excel Workbook (*.xlsx) Select the folder in which to store the workbook. Enter the new filename in the File name box. Click Save. 4. Rounding : These templates have been formatted to round numbers to either the nearest whole number or the neare

rrect answer. ction. culating overtime rate. entering the formula n save your work at any time. ssive version under a different name. ar. roblems_Your_Name.xlsx est cent. For example,

Name: Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. 4-3A Instructor Comment/Grade Area Amount to be Withheld No. of Gross Wage- Marital Withholding Wage Percentage Bracket Employee Status Allowances or Salary Method Method Corn, A. S 2 $ 675 weekly a. $ 49.11 $ 49.00 Fogge, P. S 1 1,960 weekly b. 321.47 - Felps, S. M 6 1,775 biweekly c. 35.20 35.00 Carson, W M 4 2,480 semi-monthly d. 138.40 137.00 Helm, M. M 9 5,380 monthly e. 124.70 - Student Work Area

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Name: Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. 4-3B Instructor Comment/Grade Area Amount to be Withheld No. of Gross Wage- Marital Withholding Wage Percentage Bracket Employee Status Allowances or Salary Method Method Ruiz, S. S 2 $ 1,040 weekly a. Flume, X. S 1 2,190 weekly b. - Farley, H. M 6 1,890 biweekly c. Comey, P. M 4 2,315 semi-monthly d. Hanks, R. M 4 3,200 monthly e. Student Work Area

Name: Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. 4-4A Instructor Comment/Grade Area Payroll Period W=Weekly No. of S=Semimonthly Marital Withholding M=Monthly Amount to Employee Status Allowances D=Daily Wage be Withheld Hal Bower M 1 W $ 1,350 Ruth Cramden S 1 W 590 Gil Jones S 3 W 675 Teresa Kern M 4 M 3,100 Ruby Long M 2 M 2,730 Katie Luis M 8 S 955 Susan Martin S 1 D 108 Jim Singer S 4 S 2,610 Martin Torres M 4 M 3,215 Student Work Area

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Name: Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. 4-4B Instructor Comment/Grade Area Payroll Period W=Weekly No. of S=Semimonthly Marital Withholding M=Monthly Amount to Employee Status Allowances D=Daily Wage be Withheld Ed Boone M 1 W $ 1,250 $ 106.00 Ray Ortega S 1 W 695 61.00 Carl Lopez S 3 W 915 68.00 Terri Kim M 6 M 3,070 217.00 * Kathy Horace M 2 M 2,730 216.00 * John Gleam M 8 S 1,200 - Rob Abreu S 1 D 115 10.00 Carmen Sanchez S 4 S 2,040 138.00 * Howard Nee M 4 M 3,500 225.00 * Student Work Area

Name: Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. 4-5A HOGAN THRIFT SHOP PAYROLL REGISTER FOR PERIOD ENDING December 20, 20-- DEDUCTIONS ( a ) ( b ) ( c ) ( d ) ( e ) TOTAL FICA NET EMPLOYEE NAME EARNINGS OASDI HI FIT SIT CIT PAY John, Matthew M 3 2,650.00 $ 38.43 $ 53.00 $ 39.75 Smith, Jennifer S 1 275.00 17.05 3.99 5.50 4.13 Bullen, Catherine M 0 250.00 15.50 3.63 5.00 3.75 Matthews, Mary S 3 320.25 19.86 4.64 6.41 4.80 Hadt, Bonnie S 1 450.00 27.90 6.53 9.00 6.75 Camp, Sean S 2 560.50 34.75 8.13 11.21 8.41 Wilson, Helen S 1 475.50 29.48 6.89 9.51 7.13 Gleason, Jose M 3 890.00 55.18 12.91 17.80 13.35 Totals 5,871.25 $ 85.15 $ 117.43 $ 88.07 Compute the employer's FICA taxes for the pay period ending December 20, 20--. OASDI Taxes HI Taxes OASDI taxable earnings HI taxable earnings OASDI taxes HI taxes Student Work Area Instructor Comment/Grade Area MARITAL STATUS NO. OF W/H ALLOW.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Name: Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. 4-5B HOGAN THRIFT SHOP PAYROLL REGISTER FOR PERIOD ENDING December 20, 20-- DEDUCTIONS ( a ) ( b ) ( c ) ( d ) ( e ) TOTAL FICA NET EMPLOYEE NAME EARNINGS OASDI HI FIT SIT CIT PAY Gold, Ken M 3 $ 2,080.00 $ 128.96 $ 30.16 Morton, Cam S 1 690.00 42.78 10.01 Wendal, Hal M 0 675.00 41.85 9.79 Cox, Debbie S 3 510.00 31.62 7.40 Hurley, Don S 1 1,010.00 62.62 14.65 Hand, Cheryl S 2 850.00 52.70 12.33 Welsh, Ronda S 1 590.90 36.64 8.57 Ruiz, Stacy M 3 611.15 37.89 8.86 Totals $ 7,017.05 $ 435.06 $ 101.77 Compute the employer's FICA taxes for the pay period ending December 20, 20--. OASDI Taxes HI Taxes OASDI taxable earnings HI taxable earnings OASDI taxes HI taxes Student Work Area Instructor Comment/Grade Area MARITAL STATUS NO. OF W/H ALLOW.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Name: Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. 4-8A COX SECURITY SYSTEMS PAYROLL REGISTER FOR PERIOD ENDING December 27, 20-- EARNINGS DEDUCTIONS ( a) ( b ) ( a ) ( b ) ( c ) ( d ) ( e ) EMPLOYEE NAME REGULAR SUPP'L. TOTAL FICA NET OASDI HI FIT SIT CIT PAY Hall, Michael M 5 (M) 3,500.00 $ 3,360.00 $ 6,860.00 $ 425.32 $ 99.47 $ 137.20 $ 68.60 Short, Joy T. M 2 (M) 2,750.00 2,640.00 5,390.00 334.18 78.16 107.80 53.90 Abbott, Linda S 1 520.00 2,163.20 2,683.20 166.36 38.91 53.66 26.83 Smith, Joseph M 4 465.00 1,934.40 2,399.40 148.76 34.79 47.99 23.99 Tols, Sean M. M 2 380.00 1,580.80 1,960.80 121.57 28.43 39.22 19.61 Gillespie, Michelle S 1 350.00 1,456.00 1,806.00 111.97 26.19 36.12 18.06 Smart, Jennifer M 2 575.00 2,392.00 2,967.00 183.95 43.02 59.34 29.67 White, Matthew J. S 0 425.00 1,768.00 2,193.00 135.97 31.80 43.86 21.93 Totals 8,965.00 $ 17,294.40 $ 26,259.40 $ 1,628.08 $ 380.77 $ 525.19 $ 262.59 Compute the employer's FICA taxes for the pay period ending December 27, 20--. OASDI Taxes HI Taxes OASDI taxable earnings $ 26,259.40 HI taxable earnings $ 26,259.40 OASDI taxes $ 1,628.08 HI taxes $ 380.76 (M) indicates monthly pay. Student Work Area Instructor Comment/Grade Area MARITAL STATUS NO. OF W/H ALLOW.

Name: Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. 4-8B Matson Office Systems PAYROLL REGISTER FOR PERIOD ENDING December 27, 20-- EARNINGS DEDUCTIONS ( a) ( b ) ( a ) ( b ) ( c ) ( d ) ( e ) EMPLOYEE NAME REGULAR SUPP'L. TOTAL FICA NET OASDI HI FIT SIT CIT PAY Wayne, Bret M 5 (M) $ 3,000.00 Young, Gina M 2 (M) 2,500.00 Course, Rudy S 1 810.00 Dickson, Emile M 4 715.00 Woodrow, Walt M 2 695.00 Noblet, Jim S 1 525.00 Ono, Joan M 2 800.00 Jones, Carrie S 0 645.00 Totals $ 9,690.00 Compute the employer's FICA taxes for the pay period ending December 27, 20--. OASDI Taxes HI Taxes OASDI taxable earnings HI taxable earnings OASDI taxes HI taxes (M) indicates monthly pay. Student Work Area Instructor Comment/Grade Area MARITAL STATUS NO. OF W/H ALLOW.