You are the Payroll Accountant for Olney Company, Inc., a small manufacturing firm located in Allentown, PA. Your manager, Director of Human Resources, is in the process of determining if and when the company should transition to an electronic payroll system. She has directed you to complete the payroll for the pay period ending January 8^th.

The Olney Company, Inc. has a workforce of both hourly and salaried employees. Each employee is paid for hours worked during each week, with the time worked being recorded in quarter-hour increments. The standard workweek consists of 40 hours, with all employees being paid time and one-half for any hours worked beyond the 40 regular hours.

Wages are paid every Friday, with one weeks pay being held back by the company. Thus, the first payday for Olney is January 14^th for the workweek ending January 8^th (Saturday). The information (provided in the excel spreadsheet) will be used in preparing the payroll for the pay period ending January 8^th.

Ms. Carmen V. Ruppert prepares the time clerks report for each pay period. Her report for the first week of operations is provided in the Excel spreadsheet template. All employees, except for Marshall W. Olney, are paid for hours worked beyond 40 at one and one-half times their regular hourly rate of pay.

Also, and very important, you are working with money. Your numbers need to be exact and rounded to the nearest cent. All of your figures should have 2 decimal places.

Paste BI Formatting Table Styles Number Styles Alignment Font Clipboard fx AU42 H I J G K E D 2 Given: Simple No. of Marital allowances Deductions 4 Time Card No. Employee Name Inga C. Flores Carson S. Palmetto Wage or salary $19.25 per hour Status 50 0 S 12 5 40 17.80 per hour 800.00 per week 13 40 3 Carmen V. Ruppert Lucas T. Foley Marshal W. Olney 31 30 5 4,500.00 per month M 51 80 7 78,000.00 per year M 99 10 11 Time Clerk's Report No. 1- For Period Ending January 8th, 20xx 12 Th F Time W Employee No. Worked Time Lost 13 50 Flores, Inga C. Palmetto, Carson S8 Ruppert, Carmen V8 Foley, Lucas T. Olney, Marshall WS 8 10 14 12 1.5 Tardy 5.5 8 9 38.5 15 13 16 31 41.25 S 1.25 4 9 45 17 51 S 40 18 99 19 20 Start Here Process Diagram Worksheet Select destination and press ENTER or choose Paste Type here to search DELL . 67 89 Week 7 Assignment Template(2) Read-Only Excel sa Darlene Tucker DT oSave Off Share Search Help View Review Data Page Layout Formulas Insert Home AutoSum A General X Wrap Tert A A MBS 10 Arial Fill- Conditional Format as Cell Formatting Table Styles Insert Delete Format Sort & Find & Ide Merge & Center a- A EE Clear Filter Select B IU ce Cells Editing ide Styles Number Alignment Font board M N P K L J G D C A January 8, 20 FOR PERIOD ENDING OVERTIME EARNINGS REGULAR EARNINGS TOTAL RATE PER RATE PER HOUR OASDI EARNINGS AMOUNT HOUR AMOUNT EMPLOYEE 4 6 37 38 Totals JOURNAL 39 40 CREDIT DEBIT DE SCRIPTION DATE 41 20- 42 Process Diagram Worksheet Start Here Select destination and press ENTER or choose Paste 3:39 P 10/23/2 O Type here to search DELL Week 7 Assignment Template(2) Read-Only Excel Darlene Tucker OT O X AutoSave O p Search S Share Comments Help Page Layout Formulas Data Review View Insert File Home AutoSum X General -A A Wrap Text Arial -10 Fill Insert Delete Format Sort & Find & Conditional Format as Cell Ideas -A- Paste Merge & Center Clear BIU Filter Select Formatting Table Styles . Editing Styles Cells ideas A Clipboard Font Alignment Number F31 A U w Al AD AI AF Ai AH A AK AM P R S T V X Y Z AA AB AC 22 23 24 PAYROLL REGISTER 25 26 27 TAXAB DEDUCTIONS NET PAY 28 29 FICA HEALTH GROUP CHECK 30 OASDI HI FIT SIT SUTA CIT SIMPLE INSURANCE INSURANCE NO. AMOUNT OASDI HI 31 32 33 34 35 36 37 38 39 Taxable Net 40 Earnings Rate FUTA Tax 0 006 41 Net FUTA 42 SUTA Tax Start Here Worksheet Process Diagram Select destination and press ENTER or choose Paste 102% O Type here to search 3:40 PM 10/23/2019 DELL Week 7 Assignment Template(2) toSave Read-Only Excel Darlene Tucker DT O Search Formulas Data Review View Page Layout Help Home insert Share X AutoSum Fill A A General Arial -10 Wrap Text Conditional Format as Cell Insert Delete Format te A- Merge & Center E $ .% Sort & Find & Filter Select BIU Clear Formatting Table Styles Font Alignment Number Styles Cells board G Editing X U W X Y Z AA AB AC AD A AH AI A AK AI AM AN AO V Al AF Al AQ TAXABLE EARNINGS NET PAY DEDUCTIONS CHECK GROUP HEALTH SUTA FUTA AMOUNT OASDI HI INSURANCE NO 0 CIT SIMPLE INSURANCE SIT SUTA 1 2 33 34 35 36 37 38 39 Net 40 Rate FUTA Tax 41 0.006 SUTA Tax 42 Process Diagram Worksheet Start Here Select destination and press ENTER or choose Paste 3:41 Pm 10/23/20 A Type here to search DELL Paste BI Formatting Table Styles Number Styles Alignment Font Clipboard fx AU42 H I J G K E D 2 Given: Simple No. of Marital allowances Deductions 4 Time Card No. Employee Name Inga C. Flores Carson S. Palmetto Wage or salary $19.25 per hour Status 50 0 S 12 5 40 17.80 per hour 800.00 per week 13 40 3 Carmen V. Ruppert Lucas T. Foley Marshal W. Olney 31 30 5 4,500.00 per month M 51 80 7 78,000.00 per year M 99 10 11 Time Clerk's Report No. 1- For Period Ending January 8th, 20xx 12 Th F Time W Employee No. Worked Time Lost 13 50 Flores, Inga C. Palmetto, Carson S8 Ruppert, Carmen V8 Foley, Lucas T. Olney, Marshall WS 8 10 14 12 1.5 Tardy 5.5 8 9 38.5 15 13 16 31 41.25 S 1.25 4 9 45 17 51 S 40 18 99 19 20 Start Here Process Diagram Worksheet Select destination and press ENTER or choose Paste Type here to search DELL . 67 89 Week 7 Assignment Template(2) Read-Only Excel sa Darlene Tucker DT oSave Off Share Search Help View Review Data Page Layout Formulas Insert Home AutoSum A General X Wrap Tert A A MBS 10 Arial Fill- Conditional Format as Cell Formatting Table Styles Insert Delete Format Sort & Find & Ide Merge & Center a- A EE Clear Filter Select B IU ce Cells Editing ide Styles Number Alignment Font board M N P K L J G D C A January 8, 20 FOR PERIOD ENDING OVERTIME EARNINGS REGULAR EARNINGS TOTAL RATE PER RATE PER HOUR OASDI EARNINGS AMOUNT HOUR AMOUNT EMPLOYEE 4 6 37 38 Totals JOURNAL 39 40 CREDIT DEBIT DE SCRIPTION DATE 41 20- 42 Process Diagram Worksheet Start Here Select destination and press ENTER or choose Paste 3:39 P 10/23/2 O Type here to search DELL Week 7 Assignment Template(2) Read-Only Excel Darlene Tucker OT O X AutoSave O p Search S Share Comments Help Page Layout Formulas Data Review View Insert File Home AutoSum X General -A A Wrap Text Arial -10 Fill Insert Delete Format Sort & Find & Conditional Format as Cell Ideas -A- Paste Merge & Center Clear BIU Filter Select Formatting Table Styles . Editing Styles Cells ideas A Clipboard Font Alignment Number F31 A U w Al AD AI AF Ai AH A AK AM P R S T V X Y Z AA AB AC 22 23 24 PAYROLL REGISTER 25 26 27 TAXAB DEDUCTIONS NET PAY 28 29 FICA HEALTH GROUP CHECK 30 OASDI HI FIT SIT SUTA CIT SIMPLE INSURANCE INSURANCE NO. AMOUNT OASDI HI 31 32 33 34 35 36 37 38 39 Taxable Net 40 Earnings Rate FUTA Tax 0 006 41 Net FUTA 42 SUTA Tax Start Here Worksheet Process Diagram Select destination and press ENTER or choose Paste 102% O Type here to search 3:40 PM 10/23/2019 DELL Week 7 Assignment Template(2) toSave Read-Only Excel Darlene Tucker DT O Search Formulas Data Review View Page Layout Help Home insert Share X AutoSum Fill A A General Arial -10 Wrap Text Conditional Format as Cell Insert Delete Format te A- Merge & Center E $ .% Sort & Find & Filter Select BIU Clear Formatting Table Styles Font Alignment Number Styles Cells board G Editing X U W X Y Z AA AB AC AD A AH AI A AK AI AM AN AO V Al AF Al AQ TAXABLE EARNINGS NET PAY DEDUCTIONS CHECK GROUP HEALTH SUTA FUTA AMOUNT OASDI HI INSURANCE NO 0 CIT SIMPLE INSURANCE SIT SUTA 1 2 33 34 35 36 37 38 39 Net 40 Rate FUTA Tax 41 0.006 SUTA Tax 42 Process Diagram Worksheet Start Here Select destination and press ENTER or choose Paste 3:41 Pm 10/23/20 A Type here to search DELL