Scribd
Upload
2K views2 pages

MS Excel Exercise

This document provides a payroll template for ABC Company for June 2019. It includes columns for name, salary, allowance, evaluation, bonus, gross pay, tax, pension, deductions, total deductions, and net pay. Formulas are provided to calculate bonus based on evaluation, tax based on salary, pension based on salary, and to calculate gross pay, total deductions, and net pay. The worksheet is to be renamed to "Payroll".

Uploaded by

Agat
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
2K views2 pages

MS Excel Exercise

This document provides a payroll template for ABC Company for June 2019. It includes columns for name, salary, allowance, evaluation, bonus, gross pay, tax, pension, deductions, total deductions, and net pay. Formulas are provided to calculate bonus based on evaluation, tax based on salary, pension based on salary, and to calculate gross pay, total deductions, and net pay. The worksheet is to be renamed to "Payroll".

Uploaded by

Agat
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

MS-EXCEL EXERCISE

1. On new worksheet create the following Payrol


ABC Campany
Payroll June 2019

No NAME SALARY ALLOWANCE Evaluation Bonus Gross pay

1 Selamawit Zeleke 850 250 C 51 1151


2 Kebede Hailu 1100 300 A 110 1510
3 Sara Kiros 970 200 B 77.6 1247.6
4 Selam Abebe 500 100 A 50 650
5 Ibrahim Abdela 280 60 C 16.8 356.8
6 Gemechu Tolosa 100 25 D 4 129
7 Kalkidan Zenebe 2500 400 F 0 2900
8 Tekle Tafese 1500 350 F 0 1850
Total Salary 7800
Average Salary 975
Minimum Salary 100
Maximum Salary 2500

2. Use the value of Evaluation to Calculate Bonus Use the value of Salary to Calc
Evaluation Bonus Salary
A ------------------ 10% of salary <120 -----------------
B ------------------ 8% of salary <=600 ---------------
C ------------------ 6% of salary <=1200 --------------
D ------------------ 4% of salary <=2000 --------------
F ------------------ 0 <=3000 --------------
otherwise -----------
3. Calculate
Grosspay= Salary + Allowance + Bonus
Pension= 4% of salary
Total Deduction= Tax + Pension + Advance + Others
Netpay= Grosspay - Total Deduction
4. Rename the worksheet as Payroll
ERCISE

Deduction Total
Tax Net Pay
Pension Advance Others Deduction
85.5 34 119.5 1031.5
123 44 167 1343
103.5 38.8 100 85 327.3 920.3
38 20 58 592
16 11.2 27.2 329.6
0 4 4 125
448 100 100 900 1548 1352
198 60 200 100 558 1292

Use the value of Salary to Calculate Tax


Tax
<120 ----------------- 0
<=600 --------------- 10% of salary -12
<=1200 -------------- 15% of salary -42
<=2000 -------------- 20% of salary -102
<=3000 -------------- 30% of salary -302
otherwise ----------- 40% of salary -602

You might also like