Question
Question: Employee ID Name and Address Payroll information A-Mille Thomas Millen 1022 Forest School Rd Woodstock, VT 05001 802-478-5055 SSN: 031-11-3456 401(k) deduction: 3% Hire
Question:
Employee ID | Name and Address | Payroll information |
A-Mille | Thomas Millen 1022 Forest School Rd Woodstock, VT 05001 802-478-5055 SSN: 031-11-3456 401(k) deduction: 3% | Hire Date: 2-1-2015 DOB: 12-16-1982 Position: Production Manager PT/FT: FT, exempt No. of Exemptions: 4 M/S: M Pay Rate: $35,000/year |
A-Towle | Avery Towle 4011 Route 100 Plymouth, VT 05102 802-967-5873 SSN: 089-74-0974 401(k) deduction: 5% | Hire Date: 2-4-2015 DOB: 7-14-1991 Position: Production Worker PT/FT: FT, nonexempt No. of Exemptions: 1 M/S: S Pay Rate: $12.00/hour |
A-Long | Charlie Long 242 Benedict Road S. Woodstock, VT 05002 802-429-3846 SSN: 056-23-4593 401(k) deduction: 2% | Hire Date: 2-7-2015 DOB: 3-16-1987 Position: Production Worker PT/FT: FT, nonexempt No. of Exemptions: 2 M/S: M Pay Rate: $12.50/hour |
B-Shang | Mary Shangraw 1901 Main Street #2 Bridgewater, VT 05520 802-575-5423 SSN: 075-28-8945 401(k) deduction: 3% | Hire Date: 2-5-2015 DOB: 8-20-1994 Position: Administrative Assistant PT/FT: PT, nonexempt No. of Exemptions: 1 M/S: S Pay Rate: $10.50/hour |
B-Lewis | Kristen Lewis 840 Daily Hollow Road Bridgewater, VT 05523 802-390-5572 SSN: 076-39-5673 401(k) deduction: 4% | Hire Date: 2-2-2015 DOB: 4-6-1950 Position: Office Manager PT/FT: FT, exempt No. of Exemptions: 3 M/S: M Pay Rate: $32,000/year |
B-Schwa | Joel Schwartz 55 Maple Farm Way Woodstock, VT 05534 802-463-9985 SSN: 021-34-9876 401(k) deduction: 5% | Hire Date: 2-1-2015 DOB: 5-23-1985 Position: Sales PT/FT: FT, exempt No. of Exemptions: 2 M/S: M Pay Rate: $24,000/year base plus 3% commission on case sales |
B-Prevo | Toni Prevosti 10520 Cox Hill Road Bridgewater, VT 05521 802-673-2636 SSN: 055-22-0443 401(k) deduction: 6% | Hire Date: 2-1-2015 DOB: 9-18-1967 Position: Owner/President PT/FT: FT, exempt No. of Exemptions: 5 M/S: M Pay Rate: $45,000/year |
The Departments are as follows:
Department A: Agricultural Workers
Department B: Office Workers
February 16 is the first pay date for Prevosti Farms and Sugarhouse and includes work completed during the week of February 9-13. Compute the employee gross pay, using 35 hours as the standard workweek for all 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. Joel Schwartz has made $5,000 in case sales during this pay period. Remember that the employees are paid biweekly. The first day of work for Prevosti Farms and Sugarhouse for all employees is February 9, 2015. Note that the first pay period comprises only one week of work, but the pay frequency for Federal income tax purposes is biweekly. You (Student F Success) have been hired to start on February 9, 2015, as the new accounting clerk. Your employee number is B-XXXXX, where "B" denotes that you are an office worker and "XXXXX" is the first five letters of your last name. If your last name is fewer than five letters, use the first few letters of your first name to complete the employee number. Your Social Security number is 555-55-5555, and you are full-time, nonexempt, and paid at a rate of $34,000 per year. You have elected to contribute 2% of your gross pay to your 401(k). Complete the W-4 and the I-9 to start your own employee file. You are single with only one job (claiming two exemptions). You live at 1644 Smitten Road, Woodstock, VT 05001. Your date of birth is 01/01/1991. Your phone number is (555)555-5555. You are a citizen of the United States and provide a Vermont driver's license #88110009 expiring 1/1/2017 in addition to your Social Security card for verification of your identity.
The hours for the nonexempt employees are as follows:
Name | Hourly rate | Hours worked 2/9-2/13/15 |
Towle | $12.00 | 35 hours |
Long | $12.50 | 40 hours |
Shangraw | $10.50 | 21 hours |
Student F Success | $18.68 ($34,000 annual salary/26 pay periods/70 hours per pay period) | 35 hours |
Update the Employee Earning record for the period's pay and the new YTD amount.
February 27, 2015, is the final payday for the month. Compute the employee gross pay and update the Employee Earning Record with the February 27 pay and the new YTD amount. Schwartz has sold $7,500 of product during this pay period.
The hours for the nonexempt employees are as follows:
Name | Hourly rate | Hours worked 2/14-2/27 |
Towle | $12.00 | 80 hours |
Long | $12.50 | 70 hours |
Shangraw | $10.50 | 42 hours |
Student F Success | $18.68 | 71 hours |
-(NOTE): Enter all dates in mm/dd/yyyy format. Do not round intermediate computations and round final answers to two decimal places.
SOME OF THE EMPLOYEES HAVE WRONG ANSWERS IN THE BOXES. I ATTEMPTED TO GET THE RIGHT ANSWERS BUT I FAILED :( SAD PANDA
I have attached the employees as a file. It seemed to be easier that way. If not I'msorry. Thank you very much for all the help. Second attempt to have this answered for me. Thank you in advance.
, X \"I KaplanU x U D AB122:F x ' [m Unii4c x ' :5 prevusii x \\\"u Homewc x \\\"u AB122- x \\'u ab122-5 x \\'u JDnDUWI x ([5] Uni14E> x \\g 6 C' I G eztomheducation.com/hm.tpx?i:O.6327?8053?14921171490677491600 if e E 5 555 Apps Lego Pirates althe C: II We Love Manseld, T G centurylink st paul , E a cheesy Sweet Potato 1 7' Grocery U51 and Retil 7 Meals in 'l Hour Bio >0 i . Other bookmarks A -(NOTE): Enter all dates in mma'ddlyyyy format. Do not round intermediate computations and round final answers to two decimal places. Thomas Avery Towle Charlie Long Mary Kristen Joel Toni Prevosti Student F Millen Shangraw Lewis Schwartz Success NAME Student F Success HIRE DATE 02I09I2315 ADDRESS 1544 Smitten Rd DATE OF BIRTH 0501:1991 s CITwSTATEIZIP Woodstock! VTIo5oo1 POSI110N Accounting Clerk FT TELEPHONE 555-555-5555 no. 0F EXEMPTION S 2 SOCIAL SECURITY NUMBER 555555555 PAY RATE $34,333 per year :22: Hrs. Worked Reg. Pay o.T. Pay Gross Pay smxsec- Medicare Tax Fed. Inc. Tax State Inc. Tax SDI 401(k) Other 35 13.55 13.55 11 13.55 13.55 'm ith , X \"I KaplanU x U D AB122:F x ' [m UniI4Cr x ' :5 prevosii x \\\"u Homewc x \\\"u AB122- x \\'u ab122-5 x \\'u JDnDUWI x ([5] Uni14E> x \\g 6 C' I G eztomheducation.com/hm.tpx?i:O.6327?8053?14921171490677491600 if e E 5 555 Apps Lego Pirates althe C: II We Love Manseld, T G centurylink st paul , E a cheesy Sweet Potato 1 7' Grocery U51 and Retil 7 Meals in 'l Hour Bio >0 i . Other bookmarks A -(NOTE): Enter all dates in mmr'ddr'yyyy format. Do not round intermediate computations and round final answers to two decimal places. Thomas Avery Towle Charlie Long Mary Kristen Joel Toni Prevosti Student F Millen Shangraw Lewis Schwartz Success NAME Thomas Millen HIRE DATE 02ro1I2015 ADDRESS 1022 Forest School Rd. DATE OF BIRTH 1211 5:19:32 M CITYISTATEIZIP Woodstock! VTJDSOM POSI110N Production Manager FT TELEPHONE 002470-5055 no. OF EXEMPTION S 4 SOCIAL SECURITY NUMBER 031.11.34.56 PAY RATE $35,000 per year :22: Hrs. Worked Reg. Ply o.T. Pay Gross Pay smxsec- Medicare Tax Fed. Inc. Tax State Inc. Tax SDI 401(k) Other 35 0.00 35 0.00 7 previous next , X \"I KaplanU x U D AB122:F x ' [m UniI4Cr x ' :5 prevasli x \\\"u Homewr x \\\"u AB122- x \\'u ab122-' x \\'u JDnDUWI x ([5] Uni14E> x \\g 6 C' I G eztomheducation.com/hm.tpx?i:O.6327?8053?14921171490677491600 if e E 5 555 Apps Lego Pirates althe C: II We Love Manseld, T G centurylink st paul , E a cheesy Sweet Potato I 7' Grocery U51 and Retil 7 Meals in 'l Hour Bio >0 i . Other bookmarks A -(NOTE): Enter all dates in mma'ddr'yyyy format. Do not round intermediate computations and round final answers to two decimal places. Thomas Avery Towle Charlie Long Mary Kristen Joel Toni Prevosti Student F Millen Shangraw Lewis Schwartz Success NAME Avery TowIe HIRE DATE 02I04I2015 ADDRESS 4011 Route 100 DATE OF BIRTH 07l14l'1991 CITYISTATEIZIP PIymouthNTmsmz POSI110N Production Worker TELEPHONE 002-957-5073 no. 0F EXEMPTION s 1 SOCIAL SECURITY , NUMBER ass74-0914 PAY RATE $12.00 per hour :22: Hrs. Worked Reg. Pay o.T. Pay Gross Pay smxsec- Medicare Tax Fed. Inc. Tax State Inc. Tax SDI 401(k) Olher 35 12.00 12.00 00 12.00 12.00 7 previous next , X \"I KaplanU x U D AB122:F x ' [m Unil4C1 x ' :5 prevasli x \\\"u Homewr x \\\"u AB122- x \\'u ab122-' x \\'u JDnDUWI x ([5] Uni14E> x \\g 6 C' I G eztomheducation.com/hm.tpx?i:O.6327?8053?14921171490677491600 if e E 5 555 Apps Lego Pirates althe C: II We Love Manseld, T G centurylink st paul , E a cheesy Sweet Potato 1 7' Grocery U51 and Retil 7 Meals in 'l Hour Bio >0 i . Other bookmarks A -(NOTE): Enter all dates in mmr'ddr'yyyy format. Do not round intermediate computations and round final answers to two decimal places. Thomas Avery Towle Charlie Long Mary Kristen Joel Toni Prevosti Student F Millen Shangraw Lewis Schwartz Success NAME Charlie Long HIRE DATE 02:07:2015 ADDRESS 242 Benedict Rd DATE OF BIRTH 03:15:1937 CITYISTATEIZIP s. Woodstociwmsonz POSI110N Production Worker TELEPHONE 002-429-3045 no. 0F EXEMPTION s 2 SOCIAL SECURITY NUMBER ass23.4593 PAY RATE $12.50 per hour :22: Hrs. Worked Reg. Ply o.T. Pay Gross Pay smxsec- Medicare Tax Fed. Inc. Tax State Inc. Tax SDI 401(k) Other 40 12.50 12.50 10 12.50 12.50 'w ith , X \"I KaplanU x U D AB122:F x ' [m UniI4CI x ' :5 prevasli x \\\"u Humewr x \\\"u AB122- x \\'u ab122-' x \\'u JDnDUWI x ([5] Uni14E> x \\g 6 C' I G eztomheducation.com/hm.tpx?i:O.6327?8053?14921171490677491600 if e E 5 555 Apps Lego Pirates althe C: II We Love Manseld, T G centurylink st paul , E a cheesy Sweet Potato I 7' Grocery U51 and Retil 7 Meals in 'l Hour Bio >0 i . Other bookmarks A -(NOTE): Enter all dates in mma'ddlyyyy format. Do not round intermediate computations and round final answers to two decimal places. Thomas Avery Towle Charlie Long Mary Kristen Joel Toni Prevosti Student F Millen Shangraw Lewis Schwartz Success NAME Mary Shangraw HIRE DATE 02I05I2015 ADDRESS 1901 Main St #2 DATE OF BIRTH 00I20I1994 CITYISTATEIZIP BridgewaterNTIOSSZn POSI110N Administrative Assistant TELEPHONE 002-575-5423 no. OF EXEMPTION S 1 SOCIAL SECURITY , NUMBER airs20-3945 PAY RATE $10.50 per hour :22: Hrs. Worked Reg. Pay o.T. Pay Gross Pay smxsec- Medicare Tax Fed. Inc. Tax State Inc. Tax SDI 401(k) Olher 21 10.50 10.50 42 10.50 10.50 7 previous next , X \"I Kapianu x U D AB122:F x ' [m Unil4Cr x ' :5 prevasli x \\\"u Humewr x \\\"u AB122- x \\'u ab122-' x \\'u JonDawr x ([5] Uni14E> x \\g 6 C' I G eztomheducation.com/hm.tpx?i:O.6327?8053?14921171490677491600 if e E 5 555 Apps Lego Pirates althe C: II We Love Manseld, T G centurylink st paul , E a cheesy Sweet Potato I 7' Grocery U51 and Retil 7 Meals in 'l Hour Bio >0 i . Other bookmarks A -(NOTE): Enter all dates in mmi'ddr'yyyy format. Do not round intermediate computations and round final answers to two decimal places. Thomas Avery Towle Charlie Long Mary Kristen Joel Toni Prevosti Student F Millen Shangraw Lewis Schwartz Success NAME Kristen Lewis HIRE DATE 02I02I2015 ADDRESS 840 Daily Hollow Rd DATE OF BIRTH 04:05:1950 M CITYISTATEIZIP BridgewaterNTIossza POSI110N Ofce Manager FT TELEPHONE 802-390-5572 no. 0F EXEMPTION s 3 SOCIAL SECURITY NUMBER airs39-5613 PAY RATE $32,000 per year :22: Hrs. Worked Reg. Pay o.T. Pay Gross Pay smxsec- Medicare Tax Fed. Inc. Tax State Inc. Tax SDI 401(k) Other 35 0.00 35 0.00 7 previous next 7 X \"I KaplanU x U D AB122:F x ' [m Uni14Cl x ' :5 prevasli x \\\"u Homew: x \\\"u AB122- x \\'u ab122-' x \\'u JonDUWI x ([5] Uni14E> x \\g 6 C' I G eztomheducation.com/hm.tpx?i:O.6327?8053?14921171490677491600 if e E 5 555 Apps Lego Pirates althe C: II We Love Manseld, T G centurylink st paul , E a cheesy Sweet Potato . 7' Grocery IJSI and Retil 7 Meals in 'l Hour Bio >0 i . Other bookmarks A -(NOTE): Enter all dates in mma'ddlyyyy format. Do not round intermediate computations and round final answers to two decimal places. Thomas Avery Towle Charlie Long Mary Kristen Joel Toni Prevosti Student F Millen Shangraw Lewis Schwartz Success NAME Joel Schwartz HIRE DATE 02i'01l'2015 ADDRESS 55 Maple Farm Wy DATE OF BIRTH 05i'23l'1985 CITYISTATEIZIP WoodstockNTIIISM POSI110N Sales TELEPHONE 802-463-9985 NO. OF EXEMPIION S 2 SOCIAL SECURITY . . . NUMBER 021-34-9I76 PAY RATE $24,000 per year Plus Commissmn 2:22: Hrs. Worked Reg. Pay Commission Gross Pay Socilaileec. Medicare Tax Fed. Inc. Tax State Inc. Tax SDI 401(k) OIher 0.00 0.00 7 previous next Andrea 0 X K Kaplan U X AB122: P X M Unit 4 CC X G prevosti X *Homewo X AB 122 - X *ab122 - - X JonDowr X M Unit 4 Ex X -> C @ ezto.mheducation.com/hm.tpx?_=0.6327780537149211_1490677491600 G E : Apps ce Lego Pirates of the Ca f We Love Mansfield, Te G centurylink st paul - G G cheesy Sweet Potato a Grocery List and Recipe 7 Meals in 1 Hour Slo > > Other bookmarks -(NOTE): Enter all dates in mm/dd/yyyy format. Do not round intermediate computations and round final answers to two decimal places. Thomas Avery Towle Charlie Long Mary Kristen Joel Toni Prevosti Student F Miller Shangraw Lewis Schwartz Success NAME Toni Prevosti HIRE DATE 2/01/2015 ADDRESS 10520 Cox Hill Rd DATE OF BIRTH 09/18/1967 CITY/STATE/ZIP Bridgewater/VT/05521 POSITION Owner/President TELEPHONE 802-673-2636 NO. OF EXEMPTIONS 5 SOCIAL SECURITY NUMBER 055-22-0443 PAY RATE $45,000 per year Period Hrs. Worked Reg. Pay O. T. Pay Gross Pay Social Sec. Tax Medicare Tax Fed. Inc. Tax |State Inc. Tax SDI 401(k) Other Ended 0.00 0.00 previous nextStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started