Salary Calculation using two different methods:

[explorel1981]

Employee 1:

Monthly Salary - $6,197.08
Date of Join - 11-Jun-2019
Month End Date - 30-Jun-2019

Salary for 20 days = $4,131.39 ($6,197.08/ 30 * 20)

Employee 2:

Monthly Salary - $2,651.08
Date of Join - 15-Sep-2019
Month End Date - 30-Sep-2019

Salary for 16 days = $1,413.91 ($2,651.08/ 30 * 16)

I need to arrive at $4,197.90 for Employee 1 & $1,453.85 for Employee 2.

The logic that will be used should work for both employees.

 

[Deleted member 4993]

Employee 1:

Monthly Salary - $6,197.08
Date of Join - 11-Jun-2019
Month End Date - 30-Jun-2019

Salary for 20 days = $4,131.39 ($6,197.08/ 30 * 20)

Employee 2:

Monthly Salary - $2,651.08
Date of Join - 15-Sep-2019
Month End Date - 30-Sep-2019

Salary for 16 days = $1,413.91 ($2,651.08/ 30 * 16)

I need to arrive at $4,197.90 for Employee 1 & $1,453.85 for Employee 2.

The logic that will be used should work for both employees.

How were the monthly salaries calculated?

 

[HallsofIvy]

You say you "need to arrive at $4,197.90 for Employee 1 & $1,453.85 for Employee 2." WHY?

If you have agreed to pay the given monthly salaries and want to pro-rate those salaries for a partial month then the calculation you did is correct. How did you get the values you say you "need to arrive at"?