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
icon
Related questions
icon
Concept explainers
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.

 

  1. Calculate the total salary for given 3 names
  2. Find out who has the maximum net salary
  3. 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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Journal entries
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
Recommended textbooks for you
Century 21 Accounting Multicolumn Journal
Century 21 Accounting Multicolumn Journal
Accounting
ISBN:
9781337679503
Author:
Gilbertson
Publisher:
Cengage
Intermediate Accounting: Reporting And Analysis
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
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
College Accounting (Book Only): A Career Approach
Accounting
ISBN:
9781305084087
Author:
Cathy J. Scott
Publisher:
Cengage Learning
College Accounting, Chapters 1-27
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,
Financial And Managerial Accounting
Financial And Managerial Accounting
Accounting
ISBN:
9781337902663
Author:
WARREN, Carl S.
Publisher:
Cengage Learning,