Prevosti Farms and Sugarhouse pays its employees according to their job classification. The following employees make up Sugarhouse's staff:
Complete this question by entering your answers in the table below. Payroll Payroll Register Register Thomas Kristen Joel Mary 022417 Millen Shangraw Student 021017 Avery Towle Charlie Long Lewis Schwartz Toni Prevosti Success E............................5 Update the Employee Earnings Record form for Avery Towle with the corresponding information. (Round "Hourly Rate" to 5 decimal places. Round all other intermediate computations and final answers to 2 decimal places. Hour EMPLOYEE EARNINGS RECORD Name Avery Towle Hire Date 2/1/2017 Address 4011 Route 100 Date of Birth 7/14/1991 City/State/Zip Plymouth/VT/05102 Exempt/Nonexempt Nonexempt Telephone 802-967-5873 Married/Single (M or S) S Social Security Number 089-74-0974 Number of exemptions Position Production Worker Pay Rate (Hourly, Yearly. Yearly + Commission ) $10.20/hour Flex-time Child Care FSA amount Educ. Assist. Life Ins. Long-tem care | Gym No No $1,200.00 Yes No No Total Hours Period Ended Worked (Reg Reg. Pay O.T. Pay Holiday Pay Commissions Gross Pay 401(k) Child Care FSA Educ. Assist. Life Ins. Long-term Care Taxable Pay axable Pay + O.T.) (Federal) FICA) 2/10/2017 5 0.00 2/24/2017 S 0.00 Period Ended Taxable Pay Taxable Pay Federal Social State Income Total (Federal) FICA) Income Tax Security Tax Medicare Tax Gym Deductions Net Pay YTD Net Pay YTD Gross Pay 2/10/2017 0.00 2/24/2017Complete this question by entering your answers in the table below. Payroll Payroll Register Register Thomas Avery Towle Charlie Long Mary Kristen Joel Student 021017 022417 Millen Shangraw Lewis Schwartz Toni Prevosti Success Update the Employee Earnings Record form for Charlie Long with the corresponding information. (Round "Hourly Rate" to 5 decimal places. Round all other intermediate computations and final answers to 2 decimal places. Hour EMPLOYEE EARNINGS RECORD Name Charlie Long Hire Date 2/1/2017 Address 242 Benedict Rd Date of Birth 3/16/1987 City/State/Zip S. Woodstock/VT/05002 Exempt/Nonexempt Nonexempt Telephone 802-429-3846 Married/Single (M or S) M Social Security Number 056-23-4593 Number of exemptions 2 Position Production Worker Pay Rate (Hourly, Yearly. Yearly + Commission ) $11.30/hour Flex-time Child Care FSA amount Educ. Assist. Life Ins. Long-term care Gym Yes Yes $700.00 Yes Yes No Yes Total Hours Period Ended | Worked (Reg Reg. Pay O.T. Pay Holiday Pay Commissions Gross Pay nsurance 401(k) Child Care FSA Educ. Assist. Life Ins. Long-term Care Taxable Pay Taxable Pay + O.T.) (Federal) (FICA) 2/10/2017 0.00 2/24/2017 0.00 Period Ended Taxable Pay Taxable Pay Federal Social Medicare State Income Income Tax Security Tax Tax Gym Total Deductions Net Pay YTD Net Pay YTD Gross Pay S 2/10/2017 0.00 2/24/2017Employee 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 Payroll Register Thomas Mary Kristen Joe 021017 Register 022417 Millen Avery Towle Charlie Long Shangraw Toni Prevosti Student Lewis Schwartz Success Update the Employee Earnings Record form for Joel Schwartz with the corresponding information. (Round "Hourly Rate" to 5 decimal places. Round all other intermediate computations and final answers to 2 decimal places. Hou EMPLOYEE EARNINGS RECORD Name Joel Schwartz Hire Date 2/1/2017 Address 55 Maple Farm Wy Date of Birth 6/23/1985 City/State/Zip dstock/VT/05534 Exempt/Nonexempt Exempt Telephone 802-403-9985 Married/Single (M or S) M Social Security Number 021-34-9876 Number of exemptions 2 Sales Pay Rate (Hourly, Yearly. $24,500/year base plus 3% Yearly + Commission ) Commission on Sales Flex-time Child Care FSA amount Educ. Assist Life Ins. Long-tem care Gym No No $450.00 Yes Yes No Yes Period Ended Total Hours Worked (Reg + O.T.) Reg. Pay O.T. Pay Holiday Pay Commissions Gross Pay Insurance 401(k) Child Care FSA Educ. Assist. Life Ins. Long-term Care Taxable Pay (Federal) axable Pay FICA) 2/10/2017 5 2/24/2017 Period Ended Taxable Pay Taxable Pay Federal Social State Income Total (Federal) FICA) Income Tax Security Tax Medicare Tax Gym Deductions Net Pay YTD Net Pay YTD Gross Pay 2/10/2017 0.00 2/24/2017Complete this question by entering your answers in the table below. Payroll Payroll Register Thomas 02 Register Millen Avery Towle Charlie Long Mary Kristen Joel Student Shangraw Lewis Schwartz Toni Prevosti Success EMPLOYEE EARNINGS RECORD Name Kristen Lewis Hire Date 2/1/2017 Address 840 Daily Hollow Rd Date of Birth City/State/Zip Bridgewater/VT/05523 Exempt/Nonexempt Exempt Telephone Married/Single (M or S) M Social Security Number 076-39-5673 Number of exemptions 3 Position Office Manager Pay Rate (Hourly, Yearly. Yearly + Commission ) $32,600/year Flex-time Child Care FSA amount Educ. Assist Life Ins. Long-tem care Gym No No $1,600.00 No Yes Yes No Total Hours Period Ended Worked (Reg. Reg. Pay O.T. Pay Commissions Gross Pay Insurance 401(k) Child Care FSA Educ. Assist. Life Ins. Taxable Pay Taxable Pay + O.T.) Holiday Pay Long-term Care (Federal) FICA) 2/10/2017 S 0.00 2/24/2017 Period Ended axable Pay axable Pay Federal Social Medicare State Income Gym Total Federal) FICA) Income Tax Security Tax Deductions Net Pay YTD Net Pay YTD Gross Pay 2/10/2017 0.00 2/24/2017Complete this question by entering your answers in the table below. Payroll Payroll Register Register Student Millen Avery Towle Charlie Long Kristen Joel 021017 022417 Shangraw Lewis Schwartz Toni Prevosti Success Update the Employee Earnings Record form for Mary Shangraw with the corresponding information. (Round "Hourly Rate" to 5 decimal places. Round all other intermediate computations and final answers to 2 decimal places. H EMPLOYEE EARNINGS RECORD Name Mary Shangraw Hire Date 2/1/2017 Address 1901 Main St #2 Date of Birth 8/20/1994 City/State/Zip Bridgewater/VT/05520 Exempt/Nonexempt Nonexempt Telephone 802-575-5423 Married/Single (M or S) S Social Security Number 075-28-8945 Number of exemptions 1 Position Administrative Assistant Pay Rate (Hourly, Yearly. Yearly + Commission ) $9. 10/hour Flex-time Child Care FSA amount Educ. Assist. Life Ins. Long-tem care Gym No 5200.00 No Yes No No Total Hours Period Ended Worked (Reg Reg. Pay O.T. Pay Holiday Pay Commissions Gross Pay Insurance 401(k) Child Care FSA Educ. Assist. Life Ins Long-term Care Taxable Pay (Federal) Taxable Pay + O.T.) FICA) 2/10/2017 0.00 2/24/2017 Period Ended Taxable Pay Taxable Pay Federal Social (Federal) [FICA) Medicare State Income Income Tax Security Tax Tax Gym Total Deductions Net Pay YTD Net Pay YTD Gross Pay 2/10/2017 0.00 S 2/24/2017Complete this question by entering your answers in the table below. Payroll Payroll im.... Register Register Thomas Avery Towle Charlie Long Mary Kristen Joel Toni Prevosti Student 021017 022417 Millen Shangraw Lewis Schwartz Success Update the Employee Earnings Record form for Student Success with the corresponding information. (Round "Hourly Rate" to 5 decimal places. Round all other intermediate computations and final answers to 2 decimal places EMPLOYEE EARNINGS RECORD Name Student Success Hire Date 2/1/2017 Address 1844 Smitten Rd Date of Birth 1/1/1991 City/State/Zip Woodstock/VT/05001 Exempt/Nonexempt Nonexempt Telephone Married/Single (M or S) S Social Security Number 556-55-5565 Number of exemptions Position Accounting clerk Pay Rate (Hourly, Yearly. Yearly + Commission ) $18,928/year Flex-time Child Care FSA amount Educ. Assist Life Ins. Long-tem care No No 5300.00 Yes No No Yes Total Hours Period Ended | Worked (Reg Reg. Pay O.T. Pay Holiday Pay Commissions Gross Pay Insurance 401(k) Child Care FSA Educ. Assist. Life Ins. Long-term Care Taxable Pay (Federal) Taxable Pay + O.T.) FICA) 2/10/2017 S 0.00 2/24/2017 0.00 S Period Ended Taxable Pay Taxable Pay Federal Social State Income Total Federal) FICA) Income Tax Security Tax Medicare Gym Deductions Net Pay YTD Net Pay YTD Gross Pay XB S 2/10/2017 0.00 2/24/2017Complete this question by entering your answers in the table below. Payroll Payroll Re Register Thomas Avery Towle Charlie Long Mary Student Shangraw Kristen Joel 021017 022417 Millen Lewis Schwartz Toni Prevosti Success Update the Employee Earnings Record form for Thomas Millen with the corresponding information. (Round "Hourly Rate" to 5 decimal places. Round all other intermediate computations and final answers to 2 decimal places. Hol EMPLOYEE EARNINGS RECORD Name Thomas Millen Hire Date 2/1/2017 Address 1022 Forest School Rd Date of Birth 12/16/1982 City/State/Zip Woodstock/VT/05001 Exempt/Nonexempt Exempt Telephone 802-478-5055 Married/Single (M or S) M Social Security Number 031-11-3458 Number of exemptions Position Production Manager Pay Rate (Hourly, Yearly. early + Commission) $36,000/year Flex-time Child Care FSA amount Educ. Assist. Life Ins. Long-term care Gym Yes $500.00 No Yes Yes Total Hours Period Ended Worked (Reg Reg. Pay O.T. Pay Holiday Pay Commissions Gross Pay Insurance 401(k) Child Care FSA Educ. Assist. Life Ins. Long-term Care Taxable Pay Taxable Pay + O.T.) (Federal) FICA) 2/10/2017 S 0.00 2/24/2017 S 0.00 Period Ended Taxable Pay Taxable Pay Federal Social State Income Total (Federal) FICA) Income Tax Security Tax Medicare Tax Gym Deductions Net Pay YTD Net Pay YTD Gross Pay 2/10/2017 S 0.00 2/24/2017Complete this question by entering your answers in the table below. Payroll Payroll Register Register Thomas Avery Towle Charlie Long Mary Kristen Joel Student 021017 022417 Millen Shangraw Lewis Schwartz Toni Prevosti Success Update the Employee Earnings Record form for Toni Prevosti with the corresponding information. (Round "Hourly Rate" to 5 decimal places. Round all other intermediate computations and final answers to 2 decimal places. Hour EMPLOYEE EARNINGS RECORD Name Toni Prevosti Hire Date 2/1/2017 Address 10520 Cox Hill Rd Date of Birth 9/18/1987 City/State/Zip Bridgewater/VT/05521 Exempt/Nonexempt Exempt Telephone 802-073-2036 Married/Single (M or S) M Social Security Number 055-22-0443 Number of exemptions Position Owner/President Pay Rate (Hourly, Yearly. Yearly + Commission ) $48,400/year Flex-time Child Care FSA amount Educ. Assist Life Ins. Long-tem care Gym Yes No 5900.00 No Yes No Yes Total Hours Period Ended Worked (Reg Reg. Pay O.T. Pay Holiday Pay Commissions Gross Pay Insurance 401(k) Child Care FSA + O.T. Educ. Assist. Life Ins. Long-term Care Taxable Pay (Federal) Taxable Pay (FICA) 2/10/2017 S 0.00 2/24/2017 0.00 Period Ended Taxable Pay Taxable Pay Federal Social Medicare State Income Gym Total (Federal) FICA) Income Tax Security Tax Tax Deductions Net Pay YTD Net Pay YTD Gross Pay 2/10/2017 0.00 2/24/2017
