Question
The bookkeeper of Oysy Co. gathered the following data from individual employee earnings records and daily time cards. Your task is to complete a payroll
The bookkeeper of
Oysy
Co. gathered the following data from individual employee earnings records and daily time cards. Your task is to complete a payroll register on
October
13.
(Round deductions to the nearest cent as needed. If an input field is not used in the table leave the field empty; do not enter a zero. Abbreviations used: YTD = Year to date, FIT = Federal Income Tax, SIT = State Income Tax.)
View the data.
LOADING...
View the assumptions.
LOADING...
Question content area bottom
Part 1
Earnings | Taxable Earnings | |||||||
Employee Name | Marital Status | Prior Earnings (YTD) | Regular | Overtime | Gross | Current Earnings (YTD) | FUTA/ SUTA | Social Security |
Rock, P. | Married and filing jointly | 15000 | 620 | 620 | 2120 | |||
Love, D. | Single | 16500 | 476 | 476 | 16976 | |||
Chen, R. | Married and filing jointly | 141900 | 600 | 225 | 825 | 142725 | ||
Vent, J. | Single | 17500 | 1000 | 225 | 1225 | 18725 | ||
Total | 190900 | 2696 | 450 | 3146 | 180546 |
Part 2
Deductions | Distribution of Expense | |||||||
Employee Name | Social Security | Medicare | FIT | SIT | Charitable Contributions | Net Pay | Sales | Office |
Rock, P. | ||||||||
Love, D. | ||||||||
Chen, R. | ||||||||
Vent, J. | ||||||||
Total |
Assume the following:
1. | FICA Social Security is 6.2% on $142,800; FICA Medicare is 1.45% on all earnings. |
2. | Federal income tax has been calculated from a weekly table for you. There are no state income taxes. |
3. | Each employee contributes $32 weekly for charitable contributions. |
4. | Overtime is paid at a rate of 1.5 over 40 hours. |
5. | Rock and Chen work in the office; the other employees work in sales. |
pop-up content ends
PrintDone
Daily Time | |||||||||
Employee | Marital Status | Cumulative Earnings Before This Payroll | Monday | Tuesday | Wednesday | Thursday | Friday | Hourly Rate of Pay | Federal Income Tax (FIT) |
Rock, Preston | Married, filing jointly | $15,000 | 8 | 6 | 6 | 6 | 5 | $20 | $13.70 |
Love, Denise | Single | 16,500 | 6 | 7 | 7 | 4 | 4 | 17 | 23.50 |
Chen, Ron | Married, filing jointly | 141,900 | 7 | 11 | 11 | 12 | 9 | 15 | 34.20 |
Vent, Jonathan | Single | 17,500 | 9 | 10 | 7 | 11 | 9 | 25 | 134.64 |
pop-up content ends
PrintDone
Step 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