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
Month Empid GrossSal TaxRate TaxToPay NetSal TaxPdYTD
2 1 2000 15 300 1700 600
2 2 2200 20 440 1760 880
Table 2
Month Empid GrossSal TaxRate TaxToPay NetSal SalPdYTD
2 1 2000 0.15 300 1700 600
2 2 2200 0.2 440 1760 880
Table 3
Month Empid GrossSal TaxToPay NetSal TaxPdYTD SalPdYTD
1 1 2000 300 1700 600 3400
1 2 2200 440 1760 880 3520
Table 4
Month Empid GrossSal TaxToPay NetSal TaxPdYTD SalPdYTD
2 1 2000 300 1700 600 3400
2 2 2200 440 1760 880 3520
SELECT ONE OPTION
All Official Question Types