A Payroll consists of Basic Pay, Allowances, Gross Salary, Deductions and Net Salary. The Allowances are 23% of the Basic Pay while the Deductions are 12% of the Gross Salary. Calculate the total salary for given 3 names Find out who has the maximum net salary Calculate how much money company has to spend on all the 3 employees. A B C D E F 1 Stationery Supplies Ltd 2 3 Name Basic Pay Allowances Gross Salary Deductions Net Salary 4 Lewis 80000 5 Francis 18000 6 Edwin 23000
A Payroll consists of Basic Pay, Allowances, Gross Salary, Deductions and Net Salary. The Allowances are 23% of the Basic Pay while the Deductions are 12% of the Gross Salary. Calculate the total salary for given 3 names Find out who has the maximum net salary Calculate how much money company has to spend on all the 3 employees. A B C D E F 1 Stationery Supplies Ltd 2 3 Name Basic Pay Allowances Gross Salary Deductions Net Salary 4 Lewis 80000 5 Francis 18000 6 Edwin 23000
Century 21 Accounting Multicolumn Journal
11th Edition
ISBN:9781337679503
Author:Gilbertson
Publisher:Gilbertson
Chapter13: Accounting For Payroll And Payroll Taxes
Section13.2: Recording Employer Payroll Taxes
Problem 1OYO
Related questions
Question
A Payroll consists of Basic Pay, Allowances, Gross Salary, Deductions and Net Salary. The Allowances are 23% of the Basic Pay while the Deductions are 12% of the Gross Salary.
- Calculate the total salary for given 3 names
- Find out who has the maximum net salary
- Calculate how much money company has to spend on all the 3 employees.
|
A |
B |
C |
D |
E |
F |
1 |
Stationery Supplies Ltd |
|
|
|
||
2 |
|
|
|
|
|
|
3 |
Name |
Basic Pay |
Allowances |
Gross Salary |
Deductions |
Net Salary |
4 |
Lewis |
80000 |
|
|
|
|
5 |
Francis |
18000 |
|
|
|
|
6 |
Edwin |
23000 |
|
|
|
|
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
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.Recommended textbooks for you
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:
9781337788281
Author:
James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:
Cengage Learning
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781337280570
Author:
Scott, Cathy J.
Publisher:
South-Western College Pub
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781305084087
Author:
Cathy J. Scott
Publisher:
Cengage Learning
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,