Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Salary and Gratitude Benefits Calculation for Employees, Exercises of MS Microsoft Excel skills

Human Resources ManagementAccounting and FinancePayroll Administration

The methodology for calculating the salary, gratitude benefits, and taxes for employees based on their department, position, and tenure. It includes formulas for determining the number of months of service and the corresponding salary adjustments.

What you will learn

  • How is the tax on the net salary calculated?
  • How is the number of months of service for an employee determined?
  • What is the formula for calculating the gratitude benefits for an employee?

Typology: Exercises

2020/2021

Uploaded on 11/25/2021

wp-minh
wp-minh 🇳🇦

3 documents

1 / 4

Toggle sidebar

Related documents


Partial preview of the text

Download Salary and Gratitude Benefits Calculation for Employees and more Exercises MS Microsoft Excel skills in PDF only on Docsity! ISTT |M&NV ITén NV nam thang Ima pb 1/2102057 iCuc 21 02 0 2/2001120 |Tan 20 01 ja 3}1903032 Phan 19 03 0 4|1804011 Hai 18 104 0 5/1712003 Chau 17 12 0 6/2009230 INgan 20 109 2 7|2010290 Linh 20 10 2 8/2012310 [Tien 20 12 g 9/2101490 Hau 21 01 4 10|2103102 Phung 21 03 ja Phong ban Ma PB lo 1 2 3 Phong ban Quan ly INhan su Ké toan IKé hoach Chtrc vy & Luong Ma IChtrc vu Thuong tham nién |Luong ngay lQ Quan ly 5,000,000 800,000 IG IGiam d6c 3,000,000 500,000 E INhan vién 1,000,000 200,000 IN. iCéng nhan 500,000 180,000 Phong ban Chir vu Luong ngay_ |Ngay c6éng ITién luong Quan ly E 200000) 23] 4600000 2/1/2021) INhan su IG 500000) 24 12000000} 1/1/2020} Quan ly IN 180000} 26] 4680000} 3/1/2019 Quan ly Q 800000) 22| 17600000} 4/1/2018} Quan ly E 200000) 24 4800000 12/1/2017| Ké toan IN. 180000} 24 4320000} 9/1/2020) Ké toan IN. 180000} 24 4320000} 10/1/2020} Ké hoach IG 500000) 22| 11000000} 12/1/2020} Bao vé IN. 180000} 25 4500000} 1/1/2021 INhan su E 200000) 26 5200000} 3/1/2021) [4 Bao vé 121
Docsity logo



Copyright © 2024 Ladybird Srl - Via Leonardo da Vinci 16, 10126, Torino, Italy - VAT 10816460017 - All rights reserved