90.2K

Verified Solution

Link Copied!

Please identify the actual equations that include the INDEX and MATCH functions to create the answers. Thank you in advance!

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: 5-single, F- family, SR- single retired and FR - family retired. The current employee and employer portions (%s) are listed below. - Beginning in cell 138, use a combination of the INDEX and MATCH functions (described in Chapter 6), as needed, to complete the yellow section below. Add totals to appropriate columns. Name: Group Employee Monthly Health Insurance Premiums BC/BS GHC DeanCare UW Health F $106.00 $78.40 $71.50 $80.00 FR 75.00 55.00 52.00 60.500 S 57.00 30.35 26.00 33.00 SR 38.00 22.00 20.00 24.00 Employee Deduction (EE%) Employer Paid Benefit (ER%) 22% 78% Employee Name Location Health Insurance Status Health Insurance Provider Employee Employee Employer Monthly Annual Annual Deduction Deduction Cost Total Premium F $106.00 $1,272.00 $4,510.00 $5,782.00 S S F F FR S F F SR SR S Drayton, Ehrke, Ferge, Fjelstad, Goff, Gonzalez, Hamway, Hendricks, Jones, Kindy, Knoble, Krueger! Kuether, Lopez Lopez Montes, Lor, Lovett, O'Brien, Pryce, Renz, Sok, Stout Tivari, Uselmann, Walsh Total Green Bay Milwaukee LaCrosse Green Bay Milwaukee LaCrosse Milwaukee LaCrosse Milwaukee Madison Green Bay Green Bay Milwaukee LaCrosse Madison Green Bay Milwaukee Madison Madison Madison Madison Green Bay Green Bay Green Bay Madison BC/BS BC/BS UW Health BC/BS GHC UW Health DeanCare BC/BS DeanCare DeanCare GHC BC/BS UW Health DeanCare DeanCare UW Health UW Health BC/BS DeanCare BC/BS GHC SR FR F SR FR SR F FR FR F SR GHC UW Health DeanCare GHC SR FR

Answer & Explanation Solved by verified expert

See Answer