Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prevosti Farms and Sugarhouse pays its employees according to their job classification. The following employees make up Sugarhouse's staff: Employee Whatis late and Address Payroll

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Prevosti Farms and Sugarhouse pays its employees according to their job classification. The following employees make up Sugarhouse's staff:

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Employee Whatis late and Address Payroll information A - VILLE Thomas Hallen Fire Date : 2 - 1 - 2017 18-2 Forest School Ad DOE : 12 - 16 -1982 Goodstock VT 65091 Position : Production Manager 392 -475- 5655 AT IFT : FT , evenat SEI GEL- 1 - SHEE No of Exenations : 4 401 8 deduction : 38 1 / S H Pay Rate : 535 eze yea A Table AVERY Toile Fire Date : 2 - 1 - 201 7 Call Route lee DOE - 1 52 I mouth , VT ester Position : Preduction Porter 392-907-5973 STIFT : FT , renexempt 1 : BEE - 74- 80 74 No of Exenations : 1 491 8 deduction : 5 MIS S Ray Plate : Sie action 4 - LON Charlie Long Fire Date : 2 - 1 - 201 7 24 2 Benedict Road ARE . 4 4 497 Deadatoct . VT Gbede Position : Production Lore 392 - 420 - 3845 STIFT : FT , nonexempt SSH : GEE - 25 - 4503 no of Exemptions : 2 481 ( * deduction : 29 HIS H Pay Rate : $11 Barhour - Shang Mary Shangrat Fire Date : 2 - 1 - 2017 1961 Main Stre DUE : 5 - 28 - 19 92 Bridgewater , T 63528 Position : feministrative Arsistar 302-575-5423 AT IFT : PT , nonexempt 354 : 875 - 26- 3045 ha of Exemptions : 1 401 ( deduction : 35 15 : 5 Pay Rate : 52 19 / hour1 - Lewis ineaten Leads Fare Date : 2 - 1 - 2917 340 Daily Hollow Road DE : 5 - ICED Fringelater , VT 15523 Position : Office Manager SEE - 309 - 2512 ATIFT : FT , event IS4 : GTE - 30 - 5672 No of Exemptions ; ] 481 9 deduction HIS H Pay Rate : 532 Gea gea - Schug Joel Some Fire Date : 2 -1 - 201 7 35 Maple Farm day DOB : 5 - 23-1935 Foodstores UT 95934 Position : Sales 382-453- 9065 ATIFT : FT , PLEASE SEN : 621 - 34 - 98TE No . of Exemptions : 2 481 ( deduction : 59 IS A Pay Rate : 524 , Sea year base plus 39 Comission 27 Sales PRESS Toni Pret outs Fire Date : 2 - 1 - 201 7 19520 - Hill Road ONE : 9 - 13 - 135 Bridgelater , T 15521 Position : Cover / President 382 - 575 - 25 - F ATIFT : FT , BREAST 354 : 655 - 22 - 24 43 No . of Exemptions : 5 481 ( deduction : ES IS A Pay Rate : 549 423 / yea - Student Student Success Fire D 2 - 1 - 25 1 . 1544 Smitten Road DOE : 1 - 1 - 103 1 Goodators VT about Position : Accounting there 356 -535-3565 TIFT : FT , nonexempt SEN : 565-56- 3565 no . if Esenations : 2 401 8 deduction : 29 1 5 Pay Rate : $13 923 yearThe departments are as fo lows Department A Agricultural Workers Department . Office Workers Initial pre tax deductions for each employee are as follows : Name Seduction Than s Miller Insurance : $185 paycheck tell s : 35 of gross pay andzal Status : Married Very Towle Insurance : Bad paycheck 121 2 ) : 59 of cross pay Marital Status : Single Charlie Len Insurance : 5185 paycheck 421 1 : 24 of gross pay Marital Status Married Mary Shangrow Insurance : Set paycheck 421 18 : 35 of gross pay Marital Status : Single Kristen Loans Insurance : $185 paycheck fell 45 of cross pay Marital Status Married Joel Schwart Insurance : 538 paychecks 421 1 1 95 of cross pay Marital Status : Married Tons Are sati Insurance : 5185 paycheck 4217 : ES of gross pay Marital Status Married Student Success Insurance : Say paycheck 421 1 9 1 : 24 of aross pay Marital Status : SinghThe first day of works for Prevost Farms and Sugarhouse for all employees Is Februar y 6 207 February to is the end of the first pay period for Prevost Farms and Sugarhouse and Includes work completed during the week of February 6 - 10 Using the payal register . compute the employee gross pay and net pay using 35 hours as the standard workweek for al employees except Mary Shangraw who works 20 hours per week and receives overtime for any time worked past that point The other hourly employees receive overtime pay when they work more than 35 hours In one week Joe Schwartz has made $2 200 in case sales at a 3 percent con mission rate during this pay period . Remember that the employees are paid biweekly Note that the first pay perlod comprises only one week of work but the pay frequency for federal income tax purposes is biweekly . Federal withholding tax should be computed using the wage - bracket tables In Appendix C. State witholding tax for Vermont is computed at 3 65 percent of taxable wages ille , gross pay less pre tax deductions February 24 2017 is the end of the final pay period for the month . Schwartz has sold $3 300 of product during the pay period at a 3 percent commission Pay will be disbursed on February 27 2017 and check numbers will continue from prior payroll . The hours for the nonexempt employees are as follows Hours wo ed Hourly rate 2/ 6 -2/10 Toride s18 20Be 35 hadme Long $1 1 30980 40 haing Thangray 59 182Be 21 Hours SWEDES ( VEN ) SIE Azeez 35 hours Hours worked Hourly mat 2/13 - 2/24 CHILE s18 2038 hours Long $21 32 82 WEMAPS Shangrow $9 1Bee hours SUCCESS sie zed year You hoursRequired: Complete the payroll register for this pay perlod and update the Employee Earnings Record form for each employee with the decimal places. corresponding Information. Ensure to Input an hourly rate for each employee (Including those that are salaried) that is rounded to 5 Benefit-related payroll deductions will take effect on the first pay perlod of March, Child care Educational assistance assistance Life insurance Long-term care Gym Flex- (under $5, 800 FSA $4, 098 (at 1% of annual insurance $15 per membership Employee time annually) (annual) annually salary value) period $15 per month Millen Yes Yes 509.00 No Yes No Yes Towle No No 1 ,209.00 Yes No No Yes Long Yes Yes 709.60 Yes No Yes Shangra Yes No 209.00 No Yes No No Lewis No No 1 ,609.06 No Yes Yes No ON Schwartz No 459.90 Yes Yes No Yes ON Prevosti Yes 909.60 No No Yes Student No No 309.60 Yes No NoComplete this question by entering your answers in the table below. Payroll Register Thomas Mary Kristen Joel 021017 Millen Avery Towle Charlie Long Shangraw Lewis Schwartz Toni Prevosti Student 022417 Success numbers.) P/R End Date 2/24/2017 Company Name: | Prevosti Farms and Sugarhouse Check Date 2/27/2017 Hourly No. of NO. Of axcable WS No. of Excable Name or Period Regula Overtime Holiday Commissions Gross Earning 401(k) Insurance Child Care FSA Educ. Assist. Life Ins. Long-term Care Wages for Wages for wage Hours Hours Hours Federal WWH FICA Thomas Millen Avery Towle S Mary Shangraw Kristen Lewis Joe Schwartz Toni Prevosti Student Success Totals $ 0.00 0.00 0.00 0.00 Gross Earning Taxable laxcable s for Wages for Federal VWH Social Medicare State WH Total Federal WWH FICA Security Tax WH Tax Garnishment United Way Gym Deductions Net Pay Check No. Thomas Millen 6838 E99 Avery Towle Charlie Long 5638 Mary Shangraw 6839 Kristen Lewis 8640 Joe Schwartz 864 Toni Prevosti 8642 Student Success 684 Totals 0.00 0.00 0.00 0.00 0.00 $ 0.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

To solve this problem we need to calculate the payroll for each employee for each pay period We will follow these steps 1 Compute the gross pay for each employee 2 Deduct pretax deductions 3 Calculate ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction to Managerial Accounting

Authors: Peter C. Brewer, Ray H Garrison, Eric Noreen

8th edition

1259917061, 978-1259917066

More Books

Students also viewed these Accounting questions

Question

f. How do you apply for the position?

Answered: 1 week ago