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
MonthEmpidGrossSalTaxRateTaxToPayNetSalTaxPdYTD
212000153001700600
222200204401760880
Table 2
MonthEmpidGrossSalTaxRateTaxToPayNetSalSalPdYTD
2120000.153001700600
2222000.24401760880
Table 3
MonthEmpidGrossSalTaxToPayNetSalTaxPdYTDSalPdYTD
11200030017006003400
12220044017608803520
Table 4
MonthEmpidGrossSalTaxToPayNetSalTaxPdYTDSalPdYTD
21200030017006003400
22220044017608803520
SELECT ONE OPTION