[Tax Calculation 2401]
Sl.No. | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Name | Md.Abidur Rahman アビドゥル | RAJIB KUMAR SHAHA ラジブ | Md.Mossadequl Haque ヒム | Asaduzzaman Emon（イモン） | Riasat Azim（アジム） | Tipu Barua（ティプ） | Sihab Ahmed シハブ | Didarul Alom ディダルル | MD. MOSHIUR RAHMAN HIMEL モシウール | Al Amin Shekh アルアミン | Md. Bellal Hossain ベラール | Mukhlesur Rahaman モクレス
Total income Monthly | 247,511 | 171,699 | 65,152 | 52,927 | 75,605 | 127,316 | 59,817 | 58,607 | 58,607 | 44,747 | 47,057 | 44,417
Total Income Yearly | 2,970,132 | 2,060,388 | 781,824 | 635,124 | 907,260 | 1,527,792 | 717,804 | 703,284 | 703,284 | 536,964 | 564,684 | 533,004
Festival Bonus | 495,022 | 206,039 | 78,182 | 63,512 | 90,726 | 152,779 | 71,780 | 70,328 | 70,328 | 53,696 | 56,468 | 53,300
Company contribution to PF
Daily allowance
Total Salary Income Yearly | 3,465,154 | 2,266,427 | 860,006 | 698,636 | 997,986 | 1,680,571 | 789,584 | 773,612 | 773,612 | 590,660 | 621,152 | 586,304
Less: exempted as per 6th schedule | 450,000 | 450,000 | 286,669 | 232,879 | 332,662 | 450,000 | 263,195 | 257,871 | 257,871 | 196,887 | 207,051 | 195,435
Total Taxable income yearly | 3,015,154 | 1,816,427 | 573,338 | 465,758 | 665,324 | 1,230,571 | 526,390 | 515,742 | 515,742 | 393,774 | 414,102 | 390,870
Tax Slab
1st 350000/400000(female) =0%
Next 1,00,000 = 5% | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 2,189 | 3,205 | 2,043
Next 4,00,000 =10% | 40,000 | 40,000 | 18,501 | 2,364 | 32,299 | 40,000 | 7,639 | 6,574 | 6,574
Next 5,00,000 =15% | 75,000 | 75,000 | - | - | - | 57,086 | - | - | - | - | - | -
Next 5,00,000 =20% | 100,000 | 93,285 | - | - | - | - | - | - | - | - | - | -
Next 20,00,000 =25% | 291,289 | - | - | - | - | - | - | - | - | - | -
Rest Amount =30% | - | - | - | - | - | - | - | - | - | - | -
Total Tax liability | 511,289 | 213,285 | 23,501 | 7,364 | 37,299 | 102,086 | 12,639 | 11,574 | 11,574 | 2,189 | 3,205 | 2,043
Minimum Tax | 511,289 | 213,285 | 23,501 | 7,364 | 37,299 | 102,086 | 12,639 | 11,574 | 11,574 | 2,189 | 3,205 | 2,043
Less: Investment rebate | 90,455 | 54,493 | 17,200 | 13,973 | 19,960 | 36,917 | 15,792 | 15,472 | 15,472 | 11,813 | 12,423 | 11,726
Less: Advance tax paid
Net Tax Liability | 420,834 | 158,793 | 6,301 | 5,000 | 37,299 | 65,169 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000 | 5,000
Previously Deducted
Need to deduct in June 2024 | 35,069 | 13,233 | 525 | 417 | 3,108 | 5,431 | 417 | 417 | 417 | 417 | 417 | 417 | 60,283
Investment amount shall be to get rebate | 603,031 | 363,285 | 114,668 | 93,152 | 133,065 | 246,114 | 105,278 | 103,148 | 103,148 | 78,755 | 82,820 | 78,174
Investment in PF | - | - | - | - | - | - | - | - | - | - | - | -
Need to make new investment. | 603,031 | 363,285 | 114,668 | 93,152 | 133,065 | 246,114 | 105,278 | 103,148 | 103,148 | 78,755 | 82,820 | 78,174
[計算２]
チーム | 現給与107期 | 為替 \=BDT
スタッフ氏名 通称 入社順 | 昇給率 | 108期新給与案 New Salary タカ | 新給与 円 | 昇給額 タカ | 昇給額 円 | タカ b | 円 | 6/17/22
1 | 営業サポートチーム | Md.Abidur Rahman アビドゥル | 102% | BDT 241,378 | ¥323,253 | BDT 4,733 | ¥6,338 | BDT 236,645 | ¥316,915 | ¥1.34
2 | RAJIB KUMAR SHAHA ラジブ | 102% | BDT 170,238 | ¥227,983 | BDT 3,338 | ¥4,470 | BDT 166,900 | ¥223,512 | ¥1.34
3 | Md.Mossadequl Haque ヒム | 107% | BDT 65,181 | ¥87,291 | BDT 4,264 | ¥5,711 | BDT 60,917 | ¥81,580 | ¥1.34
4 | Asaduzzaman Emon（イモン） | 105% | BDT 52,938 | ¥70,894 | BDT 2,521 | ¥3,376 | BDT 50,417 | ¥67,518 | ¥1.34
5 | Riasat Azim（アジム） | 105% | BDT 74,156 | ¥99,310 | BDT 3,531 | ¥4,729 | BDT 70,625 | ¥94,581 | ¥1.34
6 | Tipu Barua（ティプ） | 102% | BDT 123,420 | ¥165,284 | BDT 2,420 | ¥3,241 | BDT 121,000 | ¥162,043 | ¥1.34
7 | ＱＣ チーム | Sihab Ahmed シハブ | 110% | BDT 59,859 | ¥80,163 | BDT 5,442 | ¥7,288 | BDT 54,417 | ¥72,875 | ¥1.34
8 | Didarul Alom ディダルル | 110% | BDT 58,649 | ¥78,542 | BDT 5,332 | ¥7,140 | BDT 53,317 | ¥71,402 | ¥1.34
9 | MD. MOSHIUR RAHMAN HIMEL モシウール | 110% | BDT 58,649 | ¥78,542 | BDT 5,332 | ¥7,140 | BDT 53,317 | ¥71,402 | ¥1.34
10 | Al Amin Shekh アルアミン | 110% | BDT 44,789 | ¥59,981 | BDT 4,072 | ¥5,453 | BDT 40,717 | ¥54,528 | ¥1.34
11 | Md. Bellal Hossain ベラール | 110% | BDT 47,099 | ¥63,075 | BDT 4,282 | ¥5,734 | BDT 42,817 | ¥57,341 | ¥1.34
12 | Mukhlesur Rahaman モクレス | 110% | BDT 44,459 | ¥59,539 | BDT 4,042 | ¥5,413 | BDT 40,417 | ¥54,126 | ¥1.34
[計算２ (2)]
スタッフ氏名 通称 入社順 | 昇給率 | 108期銀行振込額 タカ | 昇給額 タカ | 107期銀行振込額 タカ
営業サポートチーム | Md.Abidur Rahman アビドゥル | 102% | BDT 213,486 | BDT 4,186 | 209,300 | Md.Abidur Rahman | 247511 | BDT 34,025
RAJIB KUMAR SHAHA ラジブ | 102% | BDT 156,876 | BDT 3,076 | 153,800 | Rajib Kumar Saha | 35069.49
Md.Mossadequl Haque ヒム | 107% | BDT 64,735 | BDT 4,235 | 60,500 | Md.Mossadequl Haque
Asaduzzaman Emon（イモン） | 105% | BDT 52,510 | BDT 2,510 | 50,000 | Asaduzzaman
] | Riasat Azim（アジム） | 105% | BDT 73,500 | BDT 3,500 | 70,000 | Riasat Azim
Tipu Barua（ティプ） | 102% | BDT 122,400 | BDT 2,400 | 120,000 | Tipu Barua
ＱＣ チーム | Sihab Ahmed シハブ | 110% | BDT 59,400 | BDT 5,400 | 54,000 | Sihab Ahmed
Didarul Alom ディダルル | 110% | BDT 58,190 | BDT 5,290 | 52,900 | Didarul Alom
MD. MOSHIUR RAHMAN HIMEL モシウール | 110% | BDT 58,190 | BDT 5,290 | 52,900 | Md.Moshiur Rahman
Al Amin Shekh アルアミン | 110% | BDT 44,330 | BDT 4,030 | 40,300 | ALAMIN SHEKH
Md. Bellal Hossain ベラール | 110% | BDT 46,640 | BDT 4,240 | 42,400 | Md Bellal Hossain
Mukhlesur Rahaman モクレス | 110% | BDT 44,000 | BDT 4,000 | 40,000 | Md. Mukhlesur Rahaman
BDT 994,257 | 946,100
[Salary sheet]
Murata Machinery Bangladesh LTD.
Statement of Salary & Allowance
For the month of June 2023
Sl.No. | Name | Designation | Department | Joining Date | UCBL A/C No. | ETIN No. | Basic Salary | House Rent | Conveyance Allowance | Medical Allowance | Special Allowance | Performance Bonus | Incentive Bonus | Total Payable | PF | Tax | Adjustment | Advance | Net Payable | Increment 202304 | 3% Inflation Allowance | Incentive Bonus | Changes 202304 | New Salary 202304
1 | KHANDOKER ZAHIDUL AZAD | SENIOR OFFICER | 1 | 01.05.17 | 0833204000019977 | 111278432018 | 61,800 | 25,330 | 2,566 | 6,158 | 6,976 | 170 | 103,000 | 4,944 | 5,065 | 92,991 | 3,800 | 1,850 | 5,650 | 108,650 | 108650
2 | MUHAMMAD RAFIQUL ISLAM | MANAGER | 4 | 01.05.17 | 0833204000019955 | 177135206541 | 85,020 | 27,400 | 2,980 | 8,342 | 10,250 | 7,708 | 4,000 | 145,700 | 6,802 | 14,553 | 124,345 | 8,500 | 2,550 | 40,000 | 51,050 | 196,750 | 196750
3 | MD. SAKHAWAT HOSSAIN | MANAGER | 4 | 01.05.17 | 0833204000019944 | 191193741762 | 84,300 | 27,400 | 2,980 | 8,270 | 10,250 | 7,300 | 4,000 | 144,500 | 6,744 | 12,145 | 14,733 | 110,878 | 8,800 | 2,530 | 40,000 | 51,330 | 195,830 | 195830
4 | A.K.M ASHIKUL ISLAM | ASST. MANAGER | 3 | 01.05.17 | 0833204000019988 | 161790446266 | 71,940 | 27,100 | 2,920 | 7,054 | 8,506 | 2,380 | 119,900 | 5,755 | 10,344 | 103,801 | 7,700 | 2,160 | 10,000 | 19,860 | 139,760 | 139760
5 | MD.AHSHAN KABIR KHOKAN | ASST. MANAGER | 4 | 01.05.17 | 0833204000020138 | 260018511958 | 69,060 | 27,100 | 2,920 | 6,766 | 7,214 | 2,040 | 115,100 | 5,525 | 8,257 | 101,318 | 8,200 | 2,070 | 10,000 | 20,270 | 135,370 | 135370
6 | MD. SAHABUDDIN SHEK | STORE KEEPER | 1 | 01.05.17 | 0833204000019922 | 530225205988 | 24,420 | 12,210 | 1,692 | 2,378 | 40,700 | 1,954 | 417 | 38,329 | 3,000 | 730 | 3,730 | 44,430 | 44430
7 | MD. SHAMIMUZZAMAN SK | ENGINEER | 4 | 01.05.17 | 0833204000020229 | 389564966711 | 27,900 | 13,950 | 1,934 | 2,716 | 46,500 | 2,232 | 417 | 43,851 | 3,800 | 840 | 4,640 | 51,140 | 51140
8 | UMMA TONIMA | ADMIN ASSISTANT | 1 | 01.05.17 | 0833204000020078 | 835389171431 | 25,860 | 12,930 | 1,794 | 2,516 | 43,100 | 2,069 | 417 | 40,614 | 3,600 | 780 | 4,380 | 47,480 | 47480
9 | KHADIZATUL KOBRA | ADMIN ASSISTANT | 3 | 01.05.17 | 0833204000020025 | 386039364161 | 26,280 | 13,140 | 1,822 | 2,558 | 43,800 | 2,102 | 417 | 41,281 | 3,600 | 790 | 4,390 | 48,190 | 48190
10 | MUHAMMAD MAMUN AR RASHID | ENGINEER | 4 | 01.05.18 | 0833204000019933 | 827528296594 | 24,600 | 12,300 | 1,706 | 2,394 | 41,000 | 1,968 | 417 | 38,615 | 3,400 | 740 | 4,140 | 45,140 | 45140
11 | MD. NIHARUL ISLAM | ENGINEER | 4 | 01.01.18 | 0833204000020127 | 332018839010 | 25,080 | 12,540 | 1,740 | 2,440 | 41,800 | 2,006 | 417 | 39,377 | 3,400 | 750 | 4,150 | 45,950 | 45950
12 | MD. POLASH MIA | OFFICE ASSISTANT | 1 | 01.08.17 | 0833204000019911 | N/A | 10,800 | 5,400 | 744 | 1,056 | 18,000 | 864 | - | 17,136 | 1,400 | 320 | 1,720 | 19,720 | 19720
13 | S.M. KAFEE BIPUL | MANAGER | 2 | 01.10.17 | 0833204000020080 | 647516435282 | 73,260 | 27,280 | 2,956 | 7,174 | 9,900 | 1,530 | 122,100 | 5,861 | 10,619 | 16,575 | 89,045 | 8,000 | 2,200 | 40,000 | 50,200 | 172,300 | 172300
14 | MD. RIZWANUL KARIM | SENIOR OFFICER | 1 | 10.06.19 | 0833204000019966 | 198701943651 | 39,120 | 19,560 | 2,400 | 3,792 | 328 | 65,200 | 3,130 | 1,301 | 60,769 | 4,800 | 1,170 | 5,970 | 71,170 | 71170
15 | MD. MOKSHEDUR RAHMAN | ASST. ENGINEER | 4 | 01.07.19 | 0833204000020036 | 492513508747 | 22,692 | 11,346 | 1,577 | 2,205 | 37,820 | 1,815 | - | 36,005 | 3,200 | 680 | 3,880 | 41,700 | 41700
16 | MD. KAMRUL HASAN | ASST. ENGINEER | 4 | 01.07.19 | 0833204000020014 | 547564921497 | 22,692 | 11,346 | 1,577 | 2,205 | 37,820 | 1,815 | - | 36,005 | 3,200 | 680 | 3,880 | 41,700 | 41700
17 | MD. REZAUL KARIM | ASST. ENGINEER | 4 | 01.07.19 | 0833204000020149 | 696476380490 | 22,692 | 11,346 | 1,577 | 2,205 | 37,820 | 1,815 | - | 36,005 | 3,300 | 680 | 3,980 | 41,800 | 41800
18 | K. M. SALMAN HOSSAIN | ASST. ENGINEER | 4 | 16.07.22 | 0833201000058817 | 18,000 | 9,000 | 1,800 | 1,200 | 30,000 | 1,440 | - | 28,560 | 1,370 | 540 | 1,910 | 31,910 | 31910
19 | MST. DOLI AKTHER | REPAIRING EXECUTIVE | 4 | 01.02.23 | 0833209000009125 | 18,000 | 9,000 | 1,800 | 1,200 | 30,000 | 1,440 | - | 28,560 | - | 540 | 540 | 30,540 | 30540
20 | NADIA SULTANA SHETU | REPAIRING EXECUTIVE | 4 | 01.02.23 | 0833209000009114 | 18,000 | 9,000 | 1,800 | 1,200 | 30,000 | 1,440 | - | 28,560 | - | 540 | 540 | 30,540 | 30540
21 | RUBAIYET ZAHAN WRIDI | STORE MANAGEMENT EXECUTIVE | 3 | 01.04.23 | 0833209000009395 | 21,000 | 10,500 | 2,100 | 1,400 | 35,000 | 1,680 | 33,320 | - | 35,000 | 32000
22 | ROWSAN | 7,200 | 3,600 | 720 | 480 | 12,000 | 576 | 11,424 | - | 12,000
Total | 799,716 | 338,778 | 44,104 | 75,710 | 53,424 | 21,128 | 8,000 | 1,340,860 | 63,977 | 64,786 | - | 31,308 | 1,180,789 | 83,070 | 23,140 | 140,000 | 246,210 | 1,587,070
Row Labels | Sum of PF | Sum of Tax | Sum of Net Payable | Sum of Total Payable
1 | 12961 | 7200 | 249839 | 270000
2 | 5861 | 10619 | 89045 | 122100
3 | 9393 | 10761 | 175546 | 195700
4 | 35042 | 36206 | 652079 | 738060
Grand Total | 63257 | 64786 | 1166509 | 1325860