current liabilities and Payroll Con Format Formatting as Table G O M 1 Current hilles Payroll N 2 Uingerelter Payroll 3 And footwear employees three datiedotter overtime Whecked on the Tuesday following the last day of the work and withholds income tax ONLA-OASI2Land ICA-Medicwe(14A- CNC-Medinede unemployment (5.4%.ectively. The soll data for the three weekende March 31 foto Wine Stre 7 Bring Nana Hours Worked Canin Jimny Chew $15.00 45 1420.00 10 Man Bank $12.00 50 5540.00 11 Nesting $32.00 30 12 15 the bluethoded arran the ENTER ANSWERS taborg 14 Alwirte el references and form where we are Mere Weatherwollte der Internet 15 values. Do not a minor peterwyl 16 17 Requirements: Poube Pinte 18 1 complete the payroll Register for the three employees for the week ended March 21, 2018 Format to two decimal places 55 12 3 complete the Payroll Tax Register 12 20 a compute the total payroll expense for the week ended March 31. Format to two decimal places 21 Record the payroll entries Ankelmakes for each of the following use coll references to the tax register for the amounts 22 We expensered to the three employees on Saturday, March 31 2 Employer payroll es related to the threemployees on Saturday, March 31 24 c. Payment of all paroles employee and employer related on Tuesday, April 3 25 d. Payment of wages on Tuesday, April 26 27 2B Bacel Sails: 29 1 Ucell references, both absolute and relative 30 2 adent the credits in the journal antes using the increase indent button in the Paragraph Group on the more 11 32 33 Instructions ENTERANSWERS ENTERANSWERS Ready non formar Forning Table A N 0 22 Wiganted to the three employees on Saturdw, March 31, 23 over related to the three employees on Saturday, March 31 24 to payroll employeemployer rundt 25 Pyment of Won on Tuesday, April 26 27 2 EN 29 1 the call references, both absolute and relative 30 2. Indent the credits in the journal entre using the increase indent button the righ Grootha 31 32 31 34 35 Format dollar amounts to two decimal 35 37 38 Saving & Submitting Solution 119 1 Savetle to desktop 49 a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 41 2 Upload and submit your file to be graded 42 a. Nagate back to the activity window screen where you downloaded the initial sara dhe 43 b. Click Choose button ander step 3 locate the file you just saved and click on 44 6. Cikk upload button under step 3 45 d. Click Submit button under step 4 46 47 48 Viewing Results 49 1 Click on Results tab in My Accountinglab $0 2. Click on the Assignment you were working on 51 3 Click on Project in this will bring up your Scorecard 52 4 Within Score Card window,dick on Live Comments Report lower right to download spreadsheet with feedback 153 54 55 56 57 58 99 Instructions ENTERANSWERS ENTERANSWERS2 + Ready Codyt. 11 A A. Choy Wrap Test B I. gemar Cart xf 617:619 Use the function to calculate the overtime pay for each employee LOGICAL TEST should contain ASO BEN 1 RR Payrollata Word JO The sale 31100 317.00 vol NE S000 550 5.00 LO Cowgirl re 11 01 ran) wa 33 33 13 14 w theme Cure IN Coming Che MAS 1) 10 19 20 12 Focal 1104 13 Comhdh. roCar Informer www 10 25 Payroll Tax Register 21 w eine Cutie Burnine Period EN 1 30 Icons ENTERANSWERS ENTERANSWERS + Copy 9. Wee General Paste B Format urger 5-9 Conditional Port 550 C fx are the 0 (wherrence for reconheciment 1 24 N gorrarentheses for you 25 2 22 Payroll Tax Register Earnings 28 Emplowe Name Ever Part Beginning Current Finding GASON Medewe FUTA WUTA 39 Cumulative Period Tulades 143 10 5.N immy Choo EN Q.ON 31 32 Name 33 34 35 js Requirements Complete typer week ended March (Always w cell reference and formererate to celebration, you will be 37 voor eenthet anys 18 39 Description Amount 40 Total des Pay Pavel Tarbapene 42 Total 43 44 45 46 HINTS 47 1. Use the function NSUMOJ Date otsin three tables Call Hint 49 517.519 Consider a 40 hour regular working week. Uw the stuwanaunt of hours worked in the parent $17.619 ie the function to calculate the overtime pay for each employee LOGICAL TEST ent should comparison between the actualment of hou worked and the regular amount. In VALVEJ TRUE 1.5 30 coeficient to account for time and allow for overtimenter in VALUEFJALSE 51 ML7M18 Enter er into appropriateces there is no other withholdings. De note thals in when entering mere 52 Do not use cell references to Payroll Register table for calculations in these cells 53 55 $6 Instructions ENTERANSWERS ENTERANSWERS Bacardina pery Armor whethemployees on Saturdw, March 31, 2018 Word for the credit from the cost you will be wrong with mine reness for any values 1 2 Data A/Esplanation 5 be CE 2 des 11 11 irements Recordingly, 2018 wwwhere were marya Dan AROUP CH 14 1s 10 17 19 19 20 21 22 ta mendapat 21 R4 Record the payrollantry Atramento en Ap,2018 Dwellendam wherer ull credit. if you can thengwa minor parts for any) 25 26 27 Date Account/Explanation DR 28 29 30 31 32 53 Instruct ENTERANSWERS! ENTERANSWERS > ASS 25 x x Cardinal Format ca Formatting as Table Styles 24 Always use cererences and formulas where appropriate credit. if you coaste from the auction, you will be wrong op De nota ir parentheses for any values Account/Explanation OR CR 25 26 27 Date 28 29 30 31 32 33 34 35 36 Requirement 4d To record powment of payroll Taxi Wies Record the payroll entry Anal makes for payment of wages on Tuesday, April 3, 2018 (Always use cell references and formulas where appropriate to receive til credit. Wyou copw/paste from the instructionstab, you will be marked wrong intermounts aspective. Do not use minus signor parentheses for any values 32 38 39 30 Date Account/Explanation DR HINTS 41 42 To record payment of weget 43 44 45 46 47 1. For all dates, enter the date in mm/dd/yyy format 48 Call Hint: 49 05:09 inappropriatecells, use cell references to Payroll Register table in ENTERANSWERSI worksheet So 016-020 appropriate cell cell references to Payroll Tax Register table in INTRANSWERSI worksheet 51 C28:012 appropriate cells, use cell references to the wein INTERANSWERS worksheet 52 033:03 in propriate cell use the function SUM) to calculate the amount of the transaction 53 C40041 inappropriate celice references to Payroll Hagster table in ENTERANSWERS worksheet 54 55 57 58 59 Instructions ENTERANSWERS ENTERANSWEA52 + Ready Y G 9 2 Download and open the excel spreadsheet, Miller-Nobles_7e-13e- Using Excel_ChF11_Start.xlsx. This spreadsheet includes 3 tabs; you will enter all answers on the second and the third tabs, ENTERANSWERS1 and ENTERANSWERS2. (All answers should be entered in the blue highlighted cells.) Ankel Footwear employees three salespeople, and pays time-and-a-half for overtime. Weekly paychecks are distributed on the Tuesday following the last day of the week (Saturday). Ankel withholds income tax (20%), FICA-OASDI (6.2%), and FICA-Medicare (1.45%). Ankel also pays payroll taxes for FICA OASDI (6.2%), FICA-Medicare (1.45%), and state and federal unemployment (5.4% and 0.6% respectively). The payroll data for the three salespeople for the week ended March 31 is provided in the excel spreadsheet. Complete the Payroll Register for the three employees for the week ended March 31, 2018. Format to two decimal places. (55 pts)... (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab, you will be marked wrong. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Complete the Payroll Tax Register. (32 pts. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab, you will be marked wrong. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) 3 4 Compute the total payroll expense for the week ended March 31. Format to two decimal places (3 pts). (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab, you will be marked wrong. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Record the payroll entries Ankel makes for each of the following; use cell references to the tax registers for the amounts. (76 pts) a Wage expense related to the three employees on Saturday, March 31. b. Employer payroll taxes related to the three employees on Saturday, March 31. c. Payment of all payroll taxes (employee and employer related) on Tuesday, April 3. d. Payment of wages on Tuesday, April 3. 5 glish (United States) MacBook Pro b. Employer payroll taxes related to the three employees on Saturday, March 31. c. Payment of all payroll taxes (employee and employer related) on Tuesday, April 3. d. Payment of wages on Tuesday, April 3. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab, you will be marked wrong. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) 1 Created On: 07/31/2020 Miller-Nobles (7e/130) - Usir Grador - Instructions Accounting Step Instructions 6 Once completed, save the project to the desktop. File name can be anything, but DO NOT include spaces. Return to auto-graded excel activity window, and progress to Step 3. Follow on screen instructions. (To review score, navigate to Results in the MyLab and click on Review link.) Hint: current liabilities and Payroll Con Format Formatting as Table G O M 1 Current hilles Payroll N 2 Uingerelter Payroll 3 And footwear employees three datiedotter overtime Whecked on the Tuesday following the last day of the work and withholds income tax ONLA-OASI2Land ICA-Medicwe(14A- CNC-Medinede unemployment (5.4%.ectively. The soll data for the three weekende March 31 foto Wine Stre 7 Bring Nana Hours Worked Canin Jimny Chew $15.00 45 1420.00 10 Man Bank $12.00 50 5540.00 11 Nesting $32.00 30 12 15 the bluethoded arran the ENTER ANSWERS taborg 14 Alwirte el references and form where we are Mere Weatherwollte der Internet 15 values. Do not a minor peterwyl 16 17 Requirements: Poube Pinte 18 1 complete the payroll Register for the three employees for the week ended March 21, 2018 Format to two decimal places 55 12 3 complete the Payroll Tax Register 12 20 a compute the total payroll expense for the week ended March 31. Format to two decimal places 21 Record the payroll entries Ankelmakes for each of the following use coll references to the tax register for the amounts 22 We expensered to the three employees on Saturday, March 31 2 Employer payroll es related to the threemployees on Saturday, March 31 24 c. Payment of all paroles employee and employer related on Tuesday, April 3 25 d. Payment of wages on Tuesday, April 26 27 2B Bacel Sails: 29 1 Ucell references, both absolute and relative 30 2 adent the credits in the journal antes using the increase indent button in the Paragraph Group on the more 11 32 33 Instructions ENTERANSWERS ENTERANSWERS Ready non formar Forning Table A N 0 22 Wiganted to the three employees on Saturdw, March 31, 23 over related to the three employees on Saturday, March 31 24 to payroll employeemployer rundt 25 Pyment of Won on Tuesday, April 26 27 2 EN 29 1 the call references, both absolute and relative 30 2. Indent the credits in the journal entre using the increase indent button the righ Grootha 31 32 31 34 35 Format dollar amounts to two decimal 35 37 38 Saving & Submitting Solution 119 1 Savetle to desktop 49 a. Create folder on desktop, and label COMPLETED EXCEL PROJECTS 41 2 Upload and submit your file to be graded 42 a. Nagate back to the activity window screen where you downloaded the initial sara dhe 43 b. Click Choose button ander step 3 locate the file you just saved and click on 44 6. Cikk upload button under step 3 45 d. Click Submit button under step 4 46 47 48 Viewing Results 49 1 Click on Results tab in My Accountinglab $0 2. Click on the Assignment you were working on 51 3 Click on Project in this will bring up your Scorecard 52 4 Within Score Card window,dick on Live Comments Report lower right to download spreadsheet with feedback 153 54 55 56 57 58 99 Instructions ENTERANSWERS ENTERANSWERS2 + Ready Codyt. 11 A A. Choy Wrap Test B I. gemar Cart xf 617:619 Use the function to calculate the overtime pay for each employee LOGICAL TEST should contain ASO BEN 1 RR Payrollata Word JO The sale 31100 317.00 vol NE S000 550 5.00 LO Cowgirl re 11 01 ran) wa 33 33 13 14 w theme Cure IN Coming Che MAS 1) 10 19 20 12 Focal 1104 13 Comhdh. roCar Informer www 10 25 Payroll Tax Register 21 w eine Cutie Burnine Period EN 1 30 Icons ENTERANSWERS ENTERANSWERS + Copy 9. Wee General Paste B Format urger 5-9 Conditional Port 550 C fx are the 0 (wherrence for reconheciment 1 24 N gorrarentheses for you 25 2 22 Payroll Tax Register Earnings 28 Emplowe Name Ever Part Beginning Current Finding GASON Medewe FUTA WUTA 39 Cumulative Period Tulades 143 10 5.N immy Choo EN Q.ON 31 32 Name 33 34 35 js Requirements Complete typer week ended March (Always w cell reference and formererate to celebration, you will be 37 voor eenthet anys 18 39 Description Amount 40 Total des Pay Pavel Tarbapene 42 Total 43 44 45 46 HINTS 47 1. Use the function NSUMOJ Date otsin three tables Call Hint 49 517.519 Consider a 40 hour regular working week. Uw the stuwanaunt of hours worked in the parent $17.619 ie the function to calculate the overtime pay for each employee LOGICAL TEST ent should comparison between the actualment of hou worked and the regular amount. In VALVEJ TRUE 1.5 30 coeficient to account for time and allow for overtimenter in VALUEFJALSE 51 ML7M18 Enter er into appropriateces there is no other withholdings. De note thals in when entering mere 52 Do not use cell references to Payroll Register table for calculations in these cells 53 55 $6 Instructions ENTERANSWERS ENTERANSWERS Bacardina pery Armor whethemployees on Saturdw, March 31, 2018 Word for the credit from the cost you will be wrong with mine reness for any values 1 2 Data A/Esplanation 5 be CE 2 des 11 11 irements Recordingly, 2018 wwwhere were marya Dan AROUP CH 14 1s 10 17 19 19 20 21 22 ta mendapat 21 R4 Record the payrollantry Atramento en Ap,2018 Dwellendam wherer ull credit. if you can thengwa minor parts for any) 25 26 27 Date Account/Explanation DR 28 29 30 31 32 53 Instruct ENTERANSWERS! ENTERANSWERS > ASS 25 x x Cardinal Format ca Formatting as Table Styles 24 Always use cererences and formulas where appropriate credit. if you coaste from the auction, you will be wrong op De nota ir parentheses for any values Account/Explanation OR CR 25 26 27 Date 28 29 30 31 32 33 34 35 36 Requirement 4d To record powment of payroll Taxi Wies Record the payroll entry Anal makes for payment of wages on Tuesday, April 3, 2018 (Always use cell references and formulas where appropriate to receive til credit. Wyou copw/paste from the instructionstab, you will be marked wrong intermounts aspective. Do not use minus signor parentheses for any values 32 38 39 30 Date Account/Explanation DR HINTS 41 42 To record payment of weget 43 44 45 46 47 1. For all dates, enter the date in mm/dd/yyy format 48 Call Hint: 49 05:09 inappropriatecells, use cell references to Payroll Register table in ENTERANSWERSI worksheet So 016-020 appropriate cell cell references to Payroll Tax Register table in INTRANSWERSI worksheet 51 C28:012 appropriate cells, use cell references to the wein INTERANSWERS worksheet 52 033:03 in propriate cell use the function SUM) to calculate the amount of the transaction 53 C40041 inappropriate celice references to Payroll Hagster table in ENTERANSWERS worksheet 54 55 57 58 59 Instructions ENTERANSWERS ENTERANSWEA52 + Ready Y G 9 2 Download and open the excel spreadsheet, Miller-Nobles_7e-13e- Using Excel_ChF11_Start.xlsx. This spreadsheet includes 3 tabs; you will enter all answers on the second and the third tabs, ENTERANSWERS1 and ENTERANSWERS2. (All answers should be entered in the blue highlighted cells.) Ankel Footwear employees three salespeople, and pays time-and-a-half for overtime. Weekly paychecks are distributed on the Tuesday following the last day of the week (Saturday). Ankel withholds income tax (20%), FICA-OASDI (6.2%), and FICA-Medicare (1.45%). Ankel also pays payroll taxes for FICA OASDI (6.2%), FICA-Medicare (1.45%), and state and federal unemployment (5.4% and 0.6% respectively). The payroll data for the three salespeople for the week ended March 31 is provided in the excel spreadsheet. Complete the Payroll Register for the three employees for the week ended March 31, 2018. Format to two decimal places. (55 pts)... (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab, you will be marked wrong. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Complete the Payroll Tax Register. (32 pts. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab, you will be marked wrong. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) 3 4 Compute the total payroll expense for the week ended March 31. Format to two decimal places (3 pts). (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab, you will be marked wrong. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) Record the payroll entries Ankel makes for each of the following; use cell references to the tax registers for the amounts. (76 pts) a Wage expense related to the three employees on Saturday, March 31. b. Employer payroll taxes related to the three employees on Saturday, March 31. c. Payment of all payroll taxes (employee and employer related) on Tuesday, April 3. d. Payment of wages on Tuesday, April 3. 5 glish (United States) MacBook Pro b. Employer payroll taxes related to the three employees on Saturday, March 31. c. Payment of all payroll taxes (employee and employer related) on Tuesday, April 3. d. Payment of wages on Tuesday, April 3. (Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab, you will be marked wrong. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values.) 1 Created On: 07/31/2020 Miller-Nobles (7e/130) - Usir Grador - Instructions Accounting Step Instructions 6 Once completed, save the project to the desktop. File name can be anything, but DO NOT include spaces. Return to auto-graded excel activity window, and progress to Step 3. Follow on screen instructions. (To review score, navigate to Results in the MyLab and click on Review link.) Hint