X AutoSave Off App A Student Excel File Emily Guthrie Search A Emily Guthrie EG X File Home Insert Page Layout Formulas Data Review View Automate Help Comments Share ~ X Cut Arial 10 ~ A" A E E ap Wrap Text AutoSum AY O LA Copy Paste BIU VFMAY Merge & Center $ % 9 Conditional Format as Cell Fill Insert Delete Format Sort & Find & Analyze Format Painter Formatting Table Styles v Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis 470 vi X fx Bonno, A. A BCDEFG HI JK LMNO P Q R S T U V W X Y Z AA AB AC AD AE AF AG A PAYROLL REGISTER GLO-BRITE PAINT COMPANY W N - Time Record Regular Earnings Overtime Earnings Deductions No. W/H Allow Filing Status Rate Rate Per Per Total Group Union 4 NAME SM T WT F SS M T W T F S Hrs. Hour Amount Hrs. Hour Amount Earnings OASDI HI FIT SIT SUTA CIT Ins. Dues S TOTALS 15, 994. 09 13,994.09 607.04 ZUZ. 95 607.UU 429.04 541.15 167.10 69 Payday, December 4, 20-- For Period Ending November 28, 20-- 70 Bonno, A. MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 17.60 1,408.00 8 35.20 281.60 1,689.60 104.76 24.50 64.00 51.87 1.01 65.41 9.00 71 Ferguson, J. MFJ N/A 8 8 8 8 8 8 8 8 8 80 2,250.00 2,250.00 139.50 32.63 140.00 69.08 1.35 87.10 72 Ford, C. S N/A 8 8 8 8 8 8 8 8 00 80 1,220.00 1,220.00 75.64 17.69 82.00 37.45 0.73 47.23 73 Mann, D. MFJ N/A 8 8 8 8 8 8 8 8 8 80 1,350.00 ,350.00 83.70 19.58 38.00 41.45 0.81 52.26 74 O'Neill, J. MFJ N/A 8 8 8 8 8 8 8 8 18 80 2,307.69 2,307.69 143.08 33.46 146.00 70.85 1.38 89.34 75 Russell, V. S N/A 8 8 8 8 8 8 8 8 8 80 1, 170.00 1, 170.00 72.54 16.97 75.00 35.92 0.70 45.29 76 Ryan, N. MFJ N/A 8 8 8 8 8 9 10 8 8 80 18.00 1,440.00 3 27.00 81.00 1,521.00 94.30 22.05 46.0 46.69 0.91 58.88 9.00 77 Sokowski, T. S IN/A 8 8 8 8 8 8 8 8 8 80 2,050.00 2,050.00 127.10 29.73 184.00 62.94 1.23 79.36 78 (Student) S N/A 8 8 8 4 8 8 8 8 4 80 15.00 1,080.00 1,080.00 66.96 15.66 65.00 33.16 0.65 41.81 79 Woods, B S N/A 8 8 8 8 8 8 8 8 72 16.25 1, 170.00 1, 170.00 72.54 16.97 75.00 35.92 0.70 45.29 80 81 82 TOTALS 15,445.69 362.60 15,808.29 980.12 229.24 915.00 485.33 9.47 611.97 0.00 18.00 83 Payday, December 14, 20-- For Period Ending December 12, 20-- 84 Russell, V S N/A 8 8 8 8 8 8 8 8 8 72 17.06 1,228.32 1,228.32 76.16 17.81 37.71 0.74 85 86 TOTALS 1,228.32 1,228.32 76.16 17.81 0.00 37.71 0.74 0.00 0.00 0.00 87 Payday, December 18, 20-- For Period Ending December 12, 20-- Journal General Ledger Payroll Register Employees' Earnings Records + Ready Ex Accessibility: Investigate Count: 10 + 107% Type here to search O W 9:24 AM 69.F Mostly cloudy ~ 9 8 0 604x 4/28/2023X AutoSave Off App A Student Excel File Emily Guthrie Search A Emily Guthrie EG X File Home Insert Page Layout Formulas Data Review View Automate Help Comments Share ~ X Cut Arial 10 ~ A" A E E ap Wrap Text AutoSum AY O LA Copy Paste BIUTMAY Merge & Center $ % 9 Conditional Format as Cell Fill 00 Insert Delete Format Sort & Find & Analyze Format Painter Formatting Table Styles v Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis 470 vi X fx Bonno, A. A AG AH Al AJ AK AL AM AN AO AP AQ AR AS A AU AV AW AX W N Net Paid Taxable Earnings Labor Cost Distribution Group Union CK. N/AME Ins Dues SIMPLE | No. Amount OASDI HI FUTA SUTA Admin Office Sales Plant 68 TOTALS 167.70 16.00 1,650.00 9,503.04 13,994.09 13,994.09 0.00 1,860.00 2,307.69 3,470.00 3,600.00 4,616.40 69 Payday, December 4, 2 Checkpoints 70 Bonno, A. 9.00 1,369.05 1,619.20 Total earnings 71 Ferguson, J. 1,780.34 2,250.00 Net paid 72 Ford, C 959.26 1,220.00 73 Mann, D. 1,114.20 1,350.00 74 O'Neill, J. ,823.58 2,307.69 75 Russell, V. 923.58 1, 170.00 76 Ryan, N. 9.00 1,243.17 1,521.00 77 Sokowski, T. 1,565.64 2,050.00 78 (Student) 856.76 1,080.00 79 Woods, B 923.58 1,170.00 80 81 82 TOTALS 0.00 18.00 0.00 12,559.16 15,737.89 0.00 0.00 0.00 0.00 0.00 0.00 0.00 83 Payday, December 14, Checkpoints 84 Russell, V 1,095.90 1,228.32 Total earnings 85 Net paid 86 TOTALS 0.00 0.00 0.00 1,095.90 1,228.32 0.00 0.00 0.00 0.00 0.00 0.00 0.00 87 Pavelav December 18 Checknoints Journal General Ledger Payroll Register Employees' Earnings Records + Ready Ex Accessibility: Investigate Count: 10 + 107% Type here to search O 69.F Mostly cloudy ~ 9 8 0 701x 9:25 AM 4/28/2023X AutoSave Off App A Student Excel File Emily Guthrie Search A Emily Guthrie EG X File Home Insert Page Layout Formulas Data Review View Automate Help Comments Share ~ X Cut Arial 10 ~ A" A E E ap Wrap Text AutoSum AY O LA Copy Paste BIU VFMAY Merge & Center $ % 9 Conditional Format as Cell Fill Insert Delete Format Sort & Find & Analyze Format Painter Formatting Table Styles v Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis 470 vi X fx Bonno, A. A B CDEFG HI JK LMNO P Q R S T U V W X Y Z AA AB AC AD AE AF AG AH PAYROLL REGISTER GLO-BRITE PAINT COMPANY W N - Time Record Regular Earnings Overtime Earnings Deductions No. W/H Allow Filing Status Rate Rate Per Per Total Group Union 4 N/AME SM T WT F SSM T W T F S Hrs. Hour Amount Hrs. Hour Amount Earnings OASDI HI FIT SIT SUTA CIT Ins. Dues S 86 TOTALS 1,228.32 1,228.32 16. 16 17.81 0.00 37.71 0. 74 U.OU 0.00 U.UU 87 Payday, December 18, 20-- For Period Ending December 12, 20-- 88 Bonno, A MFJ N/A 4 8 8 8 8 8 8 8 8 8 8 8 80 17.60 1,408.00 12 26.40 316.80 1,724.80 106.94 25.01 52.95 1.03 66.77 16.50 9.00 89 Ferguson, J. MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 2,250.00 2,250.00 139.50 32.63 140.00 69.08 1.35 87.10 90 Ford, C S N/A 8 8 8 8 8 4 8 8 8 8 76 15.25 1, 159.00 1, 159.00 71.86 16.81 35.58 0.70 44.87 91 Mann, D MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 1,350.00 ,350.00 83,70 19.58 41.45 0.81 52.26 92 O'Neill, J. MFJ N/A 8 8 8 8 8 8 8 8 8 8 80 2,307.69 2,307.69 5,634.36 33.46 146.00 70.85 1.38 89.34 93 Ryan, N. MFJ N/A 8 9 9 9 9 10 8 8 9 8 80 18.00 1,440.00 7 27.00 189.00 1,629.00 101.00 23.62 50.01 0.98 63.06 9.00 94 Sokowski, T. S N/A 8 8 8 8 8 8 8 8 8 8 80 2,050.00 2,050.00 127.10 29.73 62.94 1.23 79.36 95 (Student) S N/A 8 8 7 8 4 4 8 8 8 4 67 15.0 1,005.00 1,005.00 62.31 14.57 30.85 0.60 38.91 96 Woods, B S N/A 8 8 8 8 8 8 8 8 8 8 80 1,300.00 1,300.00 80.60 18.85 39.91 0.78 50.33 97 Young, P S N/A 8 8 8 8 8 8 8 8 8 8 80 1,365.00 1,365.00 84.63 19.79 41.91 0.82 52.84 98 99 100 101 TOTALS 15,634.69 505.80 16, 140.49 6,492.00 234.05 286.00 495.53 9.68 624.84 16.50 18.00 102 103 QTR 96, 113.19 11,450.34 1,393.73 4,612.00 2,950.81 57.60 3,673.22 380.70 100.00 1. 104 YEAR 238,337.76 20,268.26 3,456.00 20,529.00 7,317.10 142.94 9,179.02 1,311.10 244.00 1, 105 ... Journal General Ledger Payroll Register Employees' Earnings Records + Ready Ex Accessibility: Investigate Count: 10 + 107% Type here to search O w 69.F Mostly cloudy ~ 9 0 0 604x 9:25 AM 4/28/2023X AutoSave Off App A Student Excel File Emily Guthrie Search A Emily Guthrie EG X File Home Insert Page Layout Formulas Data Review View Automate Help Comments Share ~ X Cut Arial 10 ~ A" A E ap Wrap Text AutoSum E AY O LA Copy Conditional Format as Cell Fill Paste Merge & Center $ % 9 00 Insert Delete Format Sort & Find & Analyze Format Painter Formatting Table y Styles v Clear Filter ~ Select Data Clipboard Font Alignment Number Styles Cells Editing Analysis 470 vi X fx Bonno, A. A AF AG AH Al AJ AK AL AM AN AO AP AQ AR AS A AU AV W N - ns Net Paid Taxable Earnings Labor Cost Distribution Group Union CK. 4 NAME A CIT Ins Dues SIMPLE |No. Amount OASDI HI FUTA SUTA Admin. Office Sales Plant 86 TOTALS .74 0.00 0.00 0.00 0.00 1,095.90 1,228.32 0.00 0.00 0.00 0.00 0.00 0.00 0.00 87 Payday, December 18, Checkpoints 88 Bonno, A 03 66.77 16.50 9.00 1,446.60 1,724.80 Total earnings 89 Ferguson, J. .35 87.10 1,780.34 2,250.00 Net paid 90 Ford, C. .70 44.87 989.18 1, 159.00 91 Mann, D. 81 52.26 1, 152.20 1,350.00 92 O'Neill, J .38 89.34 -3,667.70 2,307.69 93 Ryan, N. 98 63.06 9.00 1,381.33 1,629.00 94 Sokowski, T. 23 79.36 1,749.64 2,050.00 95 (Student .60 38.91 857.76 1,005.00 Checkpoints-Annual 96 Woods, B. .78 50.33 1, 109.53 1,300.00 Total earnings 97 Young, P 82 52.84 1, 165.01 1,365.00 Qtr's taxable OASDI earnings 98 Total earnings for FIT 99 Total earnings for SIT/CIT 100 Total earnings for FUTA 101 TOTALS 68 624.84 16.50 18.00 0.00 7,963.89 16, 140.49 0.00 0.00 0.00 0.00 0.00 0.00 0.00 102 103 QTR 601 3,673.22 380.70 100.00 1,650.00 69,844.79 96,042.79 62,936.09 4,510.00 16,380.00 9,230.76 19,673.33 14,400.00 19,632.00 104 YEAR 94 9,179.02 1,311.10 244.00 1,650.00 174,240.34 238,267.36 205, 160.66 70,000.00 99,870.00 105 Journal General Ledger Payroll Register Employees' Earnings Records + Ready Ex Accessibility: Investigate Count: 10 + 107% Type here to search O 69 F Mostly cloudy ~ 9 8 0 /01x 9:25 AM 4/28/2023W AutoSave off H U Info - Compatibility Mode Search A Emily Guthrie EG X File Home Insert Draw Design Layout References Mailings Review View Help Comments Editing Share ~ Calibri (Body) 11 ~ A" A Aa Ap Find Normal No Spacing Heading 1 Heading 2 Title Gc Replace Past BIUvab x x ALA= = ~ ~ Dictate Editor Reuse Select Files Clipboard Font Paragraph Styles Editing Voice Editor | Reuse Files 1 2 . . 3 . . . 5 . . . I . . .6 . Group Insurance, 140,000. Department. once. WOODS, Beth Anne, 8102 Franklin Court, Philadelphia, PA 19105- 0915. Single. Telephone, 555-1128. Social Security No. 000-00- 1587. Position, programmer. Salary, $2,600 per month. Group insurance, $47,000. Department: Office A new employee by the name of Paul Winston Young was hired and began work on November 30. Young is single. He is training as a field sales representative in the city where the home office is located. His beginning salary is $2,730 per month. Address, 7936 Holmes Drive, Philadelphia, PA 19107-6107. Telephone, 555- 2096. Social Security No. 000-00-6057. Young is eligible for group insurance coverage of $49,000. Department: Sales, weekly rate: $630.00, and hourly rate: $15.75. The hours are correct on the excel form December 3 (the blank one) was a paid holiday. Page 3 of 4 809 words _ Text Predictions: On Accessibility: Unavailable " Focus + 130% Type here to search O N W X 69.F Cloudy ~ 9 7 604x 10:08 AM 4/28/2023