Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
PLEASE PROVIDE THE EQUATIONS USED TO GENERATE ANSWERS USING THE INDEX AND MATCH FUNCTIONS. PLEASE SEE YELLOW HIGHLIGHTED. I NEED TO KNOW THE EQUATIONS NOT
PLEASE PROVIDE THE EQUATIONS USED TO GENERATE ANSWERS USING THE INDEX AND MATCH FUNCTIONS. PLEASE SEE YELLOW HIGHLIGHTED. I NEED TO KNOW THE EQUATIONS NOT JUST THE ANSWER.
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 338, 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: Employee Monthly Health Insurance Premiums Group BC/BS GHC DeanCare UW Health F $106.00 $78.40 $71.50 $80.00 FR 75.00 55.00 52.00 60.50 S 57.00 30.35 26.00 33.00 38.00 22.00 20.00 24.001 SR 22% Employee Deduction (EE%) Employer Paid Benefit (ER%) 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 FRStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started