What are the vlookup/if statements and formulas needed for the yellow cells?

It is the time of year to begin the annual budget process. You are responsible for generating budget numbers for the employer's cost of health insurance. Displayed below are premiums for different providers along with the four groups that employees may choose: S - single, F - family, SR single retired and FR - family retired. The current employee deductions are shown in the table. Employee and employer portions (\%s) are listed below. Use Vlookup and IF statements, as needed, to complete the yellow section below. Add totals to appropriate columns. Name: Emplovee Monthlv Health Insurance Premiums This chart represents the employee portion per month for health insurance. You will need to calculate employee and employer annual amounts along with the total premium. Employee Deduction (EE\%) Employer Paid Benefit (ER\%) \begin{tabular}{|l|} \hline 22% \\ \hline 78% \\ \hline \end{tabular} While you don't have the total premium amounts. you DD KNDW the company, on average, charges the employee percentage shown. It is the time of year to begin the annual budget process. You are responsible for generating budget numbers for the employer's cost of health insurance. Displayed below are premiums for different providers along with the four groups that employees may choose: S - single, F - family, SR single retired and FR - family retired. The current employee deductions are shown in the table. Employee and employer portions (\%s) are listed below. Use Vlookup and IF statements, as needed, to complete the yellow section below. Add totals to appropriate columns. Name: Emplovee Monthlv Health Insurance Premiums This chart represents the employee portion per month for health insurance. You will need to calculate employee and employer annual amounts along with the total premium. Employee Deduction (EE\%) Employer Paid Benefit (ER\%) \begin{tabular}{|l|} \hline 22% \\ \hline 78% \\ \hline \end{tabular} While you don't have the total premium amounts. you DD KNDW the company, on average, charges the employee percentage shown