Please help, I put the tables after the actual questions..

ADJUSTING THE DEPARTMENT'S BUDGET 1. Using Table 8-3 and the existing Health Information Department Budget attached, calculate the new budget total if the CEO announces that the Wages and Salaries of all departments will be increased by 3% from January 1 - June 30 (instead of the 5% shown in table 8-3). 2. Calculate a new total for Fringe Benefits for department employees, if fringe benefits amount to 30% of total Wages and Salaries. 3. Calculate a new Supplies total if General Stores Supplies are expected to increase 5%. Totals of: Wage \& Salary Costs Fringe Benefit Costs Equipment Supplies Services Cost Transfers Total of Adjusted Budget SAMPLE BUdget: Hzalth INFORMation SERVICE Health Information Department Budget Wage and salary calculations are displayed to show these details: Factor Example Current annual base $58,000 July-December of current calendar year-total earnings $29,000 January 1 cast of living increase (5\%) $2,900 New annual base effective January 1 $60,900 January-June of coming calendar year-total earnings $30,450 Total needed for full 12-month period of the fiseal year $29,000+$30,450=$59,450 Table 8-3 displays the wage and salary by position and title. Table 8-3 Wage and Salaries by Position Title \begin{tabular}{|c|c|c|c|c|c|c|} \hline & CurrentBase & JulyThroughDecember & January15%Increase & New Base & JanuaryThroughJune & TotalforFiscalYear \\ \hline Director & 75,000 & 37,500 & 3,750 & 73,750 & 39,375 & 76,875 \\ \hline Compliance Specialist & 42,000 & 21,000 & 2,100 & 44,100 & 22,050 & 43,050 \\ \hline Registries Coordinator & 42,000 & 21,000 & 2,100 & 44,100 & 22,050 & 43,050 \\ \hline Coder A & 94,000 & 17,000 & .1,700 & 35,700 & 17,850 & 34,850 \\ \hline Coder B & 35,000 & 17,500 & 1,750 & 36,750 & 18,375 & 35,875 \\ \hline Evening Shift Coder & 32,000 & 16,000 & 1,600 & 33,600 & 16,800 & 32,800 \\ \hline Bdiling Compliance Specialist & 36,000 & 18,000 & 1,800 & 37,800 & 18,900 & 36,900 \\ \hline Release of Information Specialist & 36,000 & 18,000 & 1,800 & 37,800 & 18,900 & 36,900 \\ \hline Secretary & 25,000 & 12,500 & 1,250 & 26,250 & 13,125 & 25,625 \\ \hline Medical Transcripcionist A & 34,000 & 17,000 & 1,700 & 35,700 & 17,850 & 34,850 \\ \hline Medical Transcriptionist B & 34,000 & 17,000 & 1,700 & 35,700 & 17,850 & 34,850 \\ \hline Evening Shift Transcriptionist & 32,000 & 16,000 & 1,600 & 33,600 & 16,300 & 32,800 \\ \hline Releast of Information Support Clerk & 22,000 & 11,000 & 1,100 & 23,100 & 11,550 & 22,550 \\ \hline Registration Specialist & 34,000 & 17,000 & 1,700 & 35,700 & 17,850 & 34,850 \\ \hline CertifiedDocumentadionimprovementSpecialist & 40,000 & 20,000 & 2,000 & 42,000 & 21,000 & 41,000 \\ \hline Health Record Specialist II & 25,000 & 12,500 & 1,250 & 26,250 & 13,125 & 25,625 \\ \hline Health Record Specialist I & 24,480 & 12,240 & 1,224 & 25,704 & 12,852 & 25,092 \\ \hline \end{tabular} Chapter 8 Budget Planninc and Implementation