$3878.55
Explanation:
Step 1 :
It is given that Kristy has a biweekly gross earnings of $1950.
Since it is bi-weekly payments there are 26 payments in the year.
Gross earnings per year = 1950 * 26 = $50,700
Step 2 :
It is given that the social security tax is 6.2% up to $128,400. Kristy's earnings of 50,700$ does not exceed the threshold $128,400, hence 6.2% of her entire income is subject to social security withholding.
Social security withholding = 6.2% of 50,700 = 6.2*50700/100 = $3143.40
Step 3 :
It is given that Medicare tax is 1.45% with no wage limit
Medicare withholding = 1.45% of 50,700 = 1.45*50700/100 = $735.15
Total withholding = Social Security withholding + Medicare withholding 3143.40 + 735.15 = $3878.55
Answer:
Absolute reference
Explanation:
An absolute reference in excel indicates a reference that is locked such that rows and columns do not alter when copied to another cell in the excel sheet.
It points to an actual fixed location in excel and absolute referencing is simply by adding a dollar sign before the row and column.
In other words ,Ellen will absolutely reference her income ,as the income is the same month-on-month.