For the Corporation I have created I need to prepare the Corporation needs a Payroll Register and Payroll Tax Register for the three employees for the week ended August 31, 2024. August 2024 has 22 working days. As well as the total coronation payroll expense for the month ended August 31, 2024.   -I also attached an image of the outline of the payroll register and payroll tax register for my corporation.  The Corporation employs three employees, and pays time-and-a-half for overtime and monthly paychecks are distributed on the Friday following the last day of the month.    The Corporation withholds federal income tax at 18%, state income tax at 7%, FICA-OASDI at 6.2% for wages up to $118,500, and FICA-Medicare at 1.45%.    The Corporation also pays payroll taxes for FICA-OASDI at 6.2% for wages up to $118,500, FICA--Medicare at 1.45%, and state and federal unemployment at 5.4% and 0.6% respectively for wages up to $7,000. August 2024 has 22 working days.    The payroll data employees for the month ended August 31: Name Straight Time Rate Hours Worked Beginning Cumulative Earnings Tommy S $30 175 $52,000 Lee Y 34 196 $23,000 Sarah H 26 190 $3,060

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter22: Master Budget (master)
Section: Chapter Questions
Problem 2R: Open the file MASTER from the website for this book at cengagebrain.com. Enter all the formulas...
icon
Related questions
Question

For the Corporation I have created I need to prepare the Corporation needs a Payroll Register and Payroll Tax Register for the three employees for the week ended August 31, 2024. August 2024 has 22 working days. As well as the total coronation payroll expense for the month ended August 31, 2024.

 

-I also attached an image of the outline of the payroll register and payroll tax register for my corporation. 



The Corporation employs three employees, and pays time-and-a-half for overtime and monthly paychecks are distributed on the Friday following the last day of the month. 

 

The Corporation withholds federal income tax at 18%, state income tax at 7%, FICA-OASDI at 6.2% for wages up to $118,500, and FICA-Medicare at 1.45%. 

 

The Corporation also pays payroll taxes for FICA-OASDI at 6.2% for wages up to $118,500, FICA--Medicare at 1.45%, and state and federal unemployment at 5.4% and 0.6% respectively for wages up to $7,000. August 2024 has 22 working days. 

 

The payroll data employees for the month ended August 31:

Name

Straight Time Rate

Hours Worked

Beginning Cumulative Earnings

Tommy S

$30

175

$52,000

Lee Y

34

196

$23,000

Sarah H

26

190

$3,060



25
26
27
28
29
10
1
2
3
7
8
9
10
11
12
13
14
15
18
19
20
21
22
23
24
6
16
17
2
3
4
5
X
File
F33
A
Total
Total
AutoSave On
Home Insert
B
Employee Name
Employee Name
Page Layout
Review View Automate Help
UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps.
Description
Total Gross Pay
Payroll Tax Expense
Total
:
X✓ fx
с
Beginning
Cumulative
Earnings
Beginning
Cumulative
Amount
V3
2
Earnings
1>
Pay Rate
= P11+P11
Formulas Data
E
corporation ex Saved v
Hours
Worked
Current Ending
Period Cumulative
F
Earnings
Regular Pay
Payroll Tax Register
QASDI
G
Overtime
Pay
H
Medicare
Payroll Register
Current
Ending
Period Cumulative
Earnings Earnings
Employer Payroll Taxes
FUTA
Search
SUTA
J
OASDI
Total Taxes
K
Update now
Medicare
L
M
Withholdings
Federal State
Income Income
Tax
Tax
N
L
Total
Other Withholdings
P
Net Pay
Q
Check No
2203
2204
2205
R
Wages
Expense
Sa
Transcribed Image Text:25 26 27 28 29 10 1 2 3 7 8 9 10 11 12 13 14 15 18 19 20 21 22 23 24 6 16 17 2 3 4 5 X File F33 A Total Total AutoSave On Home Insert B Employee Name Employee Name Page Layout Review View Automate Help UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. Description Total Gross Pay Payroll Tax Expense Total : X✓ fx с Beginning Cumulative Earnings Beginning Cumulative Amount V3 2 Earnings 1> Pay Rate = P11+P11 Formulas Data E corporation ex Saved v Hours Worked Current Ending Period Cumulative F Earnings Regular Pay Payroll Tax Register QASDI G Overtime Pay H Medicare Payroll Register Current Ending Period Cumulative Earnings Earnings Employer Payroll Taxes FUTA Search SUTA J OASDI Total Taxes K Update now Medicare L M Withholdings Federal State Income Income Tax Tax N L Total Other Withholdings P Net Pay Q Check No 2203 2204 2205 R Wages Expense Sa
Expert Solution
steps

Step by step

Solved in 4 steps with 7 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

For the Corporation I have created I need to prepare the Corporation needs a Payroll Register and Payroll Tax Register for the three employees for the week ended August 31, 2024. August 2024 has 22 working days. As well as the total coronation payroll expense for the month ended August 31, 2024.

 

-I also attached an image of the outline of the payroll register and payroll tax register for my corporation.

-the income tax is seperated into the state and federal please do them separately 

and compute the total payroll expense and total gross Pay for the month ended august 31, 2024 and fill in box at bottom of image.

 

The Corporation employs three employees, and pays time-and-a-half for overtime and monthly paychecks are distributed on the Friday following the last day of the month. 

 

The Corporation withholds federal income tax at 18%, state income tax at 7%, FICA-OASDI at 6.2% for wages up to $118,500, and FICA-Medicare at 1.45%. 

 

The Corporation also pays payroll taxes for FICA-OASDI at 6.2% for wages up to $118,500, FICA--Medicare at 1.45%, and state and federal unemployment at 5.4% and 0.6% respectively for wages up to $7,000. August 2024 has 22 working days. 

 

The payroll data employees for the month ended August 31:

Name

Straight Time Rate

Hours Worked

Beginning Cumulative Earnings

Tommy S

$30

175

$52,000

Lee Y

34

196

$23,000

Sarah H

26

190

$3,060



25
26
27
28
29
10
1
2
3
7
8
9
10
11
12
13
14
15
18
19
20
21
22
23
24
6
16
17
2
3
4
5
X
File
F33
A
Total
Total
AutoSave On
Home Insert
B
Employee Name
Employee Name
Page Layout
Review View Automate Help
UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps.
Description
Total Gross Pay
Payroll Tax Expense
Total
:
X✓ fx
с
Beginning
Cumulative
Earnings
Beginning
Cumulative
Amount
V3
2
Earnings
1>
Pay Rate
= P11+P11
Formulas Data
E
corporation ex Saved v
Hours
Worked
Current Ending
Period Cumulative
F
Earnings
Regular Pay
Payroll Tax Register
QASDI
G
Overtime
Pay
H
Medicare
Payroll Register
Current
Ending
Period Cumulative
Earnings Earnings
Employer Payroll Taxes
FUTA
Search
SUTA
J
OASDI
Total Taxes
K
Update now
Medicare
L
M
Withholdings
Federal State
Income Income
Tax
Tax
N
L
Total
Other Withholdings
P
Net Pay
Q
Check No
2203
2204
2205
R
Wages
Expense
Sa
Transcribed Image Text:25 26 27 28 29 10 1 2 3 7 8 9 10 11 12 13 14 15 18 19 20 21 22 23 24 6 16 17 2 3 4 5 X File F33 A Total Total AutoSave On Home Insert B Employee Name Employee Name Page Layout Review View Automate Help UPDATES AVAILABLE Updates for Office are ready to be installed, but first we need to close some apps. Description Total Gross Pay Payroll Tax Expense Total : X✓ fx с Beginning Cumulative Earnings Beginning Cumulative Amount V3 2 Earnings 1> Pay Rate = P11+P11 Formulas Data E corporation ex Saved v Hours Worked Current Ending Period Cumulative F Earnings Regular Pay Payroll Tax Register QASDI G Overtime Pay H Medicare Payroll Register Current Ending Period Cumulative Earnings Earnings Employer Payroll Taxes FUTA Search SUTA J OASDI Total Taxes K Update now Medicare L M Withholdings Federal State Income Income Tax Tax N L Total Other Withholdings P Net Pay Q Check No 2203 2204 2205 R Wages Expense Sa
Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Federal Insurance Contributions Act (FICA)
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage