PAC 6.4 Tax Accounting: Determine Withholdings for Salaried Employees Data Tax Accounting For the two salaried employees, D*Tunes must withhold the employer portion of FICA taxes every month from their wages. FICA tax is a combination of Social Security tax and Medicare tax. The 2025 FICA tax rate is 7.65%, which includes Social Security tax of 6.2% and Medicare tax of 1.45%. The owner does not need to withhold Social Security tax for any earnings above $168,900. Therefore, the studio must only withhold Medicare tax on wages above this amount. Create an information model that will allow you to design a worksheet similar to the one shown that will help the studio determine the FICA tax payments for each month. An excel spreadsheet presents two tables. A table on the left has two columns, and the data are presented as follows: Salary, 200,000; F I C A%, 0.0765; Social Security%, 0.062; Medicare%, 0.0145; Social Security Maximum, 168,900. A table on the right has two columns, and the column headers are: Month, and Deduction. The data are presented as follows: Month, January; Deduction, 1,275.00; Month, February; Deduction, 1,275.00; Month, March; Deduction, 1,275.00; Month, April; Deduction, 1,275.00; Month, May; Deduction, 1,275.00; Month, June; Deduction, 1,275.00; Month, July; Deduction, 1,275.00; Month, August; Deduction, 1,275.00; Month, September; Deduction, 1,275.00; Month, October; Deduction, 1,275.00; Month, November; Deduction, 380.13; Month, December; Deduction, 241.67.