if both employees were paid the same in month 1 as in the current month 2. for which tax has now to be calculated, which data-driven input and expected output table is correct for this situation?

A new Payroll system calculates the amount of tax that each employee must pay (TaxToPay) on their gross monthly salary (in (), and the net salary (NetSal) that they will receive after that amount of tax has been deducted It also calculates the amounts of tax (TaxPdYTD) and net salary (SalPdYTD) paid in the year to date (YTD) by adding them to the stored amounts from last month (for month 1 these will be zero), inputs Include Employee id (Empid) and Gross Salary this month (GrossSal). Tax Rate is looked up on the key of Employee Id, the amounts of tax and net salary paid in the year to date are looked up on the key of (Employee Id and [month • 1]) except that for month 1 they will be zero.

if both employees were paid the same in month 1 as in the current month 2. for which tax has now to be calculated, which data-driven input and expected output table is correct for this situation?

Table 1

SELECT ONE OPTION
A . Table 3
B . Table 1
C . Table 4
D . Table 2

View Answer

Answer: C

Explanation:

Table 4 is the correct data-driven input and expected output table for this situation. It correctly calculates the TaxToPay based on the GrossSal and TaxRate, and then determines the NetSal by subtracting TaxToPay from GrossSal. Additionally, it accurately adds the TaxToPay to the previous month’s TaxPdYTD and the NetSal to the previous month’s SalPdYTD, which are both zero for month