Scribd
Upload
14 views1 page

Sassignment No 4

The document presents a payroll summary for 20 employees, detailing their basic salaries, overtime amounts, leave days, and net salaries. Each employee's earnings are calculated based on their overtime hours and leave days, resulting in varying net salaries. The data highlights the financial compensation structure within the organization.

Uploaded by

ruhabimrankhatri1608rh
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
14 views1 page

Sassignment No 4

The document presents a payroll summary for 20 employees, detailing their basic salaries, overtime amounts, leave days, and net salaries. Each employee's earnings are calculated based on their overtime hours and leave days, resulting in varying net salaries. The data highlights the financial compensation structure within the organization.

Uploaded by

ruhabimrankhatri1608rh
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

overtime leave days Net

s no employee basic overtime per hour Amount leave perday Amount Salary
1 ali 25000 25 400 10000 4 1000 4000 31000
2 salman 35000 14 210 2940 5 1500 7500 24560
3 mujhid 12000 52 325 16900 2 1253 2506 26394
4 kamran 36500 63 125 7875 6 214 1284 43091
5 ismali 45210 25 412 10300 3 210 630 45210
6 usman 24560 47 365 17155 5 201 1005 24560
7 nazeer 10000 85 123 10455 8 523 4184 10000
8 iqra 32456 96 214 20544 7 412 2884 50116
9 imran 12547 32 521 16672 9 652 5868 23351
10 asad 89652 45 123 5535 6 1250 7500 87687
11 hina 21458 87 652 56724 5 1250 6250 78182
12 sabir 78541 45 214 9630 4 1240 4960 83211
13 rohin 26985 21 254 5334 8 1269 10152 22167
14 ammar 21456 42 201 8442 9 1500 13500 16398
15 saba 32145 63 320 20160 8 1420 11360 40945
16 owais 21450 21 120 2520 7 1620 11340 12630
17 lubna 12540 42 321 13482 8 1325 10600 15422
18 aamir 25410 52 312 16224 9 1232 11088 30546
19 shoaib 78950 14 129 1806 8 1254 10032 79502
wajid 78950 23 210 4830 7 1212 8484 82568

You might also like