Question: I am having trouble trying to figure out E 15, is 16, E 17, E 18, F 15 through 18, G 15 through 18, C

I am having trouble trying to figure out E 15, is 16, E 17, E 18, F 15 through 18, G 15 through 18, C 22 through 25, and E 23.

A B C D E F G H K L M N Flexible Insurance Coverage Parameters Policy Parameters Premium Data Plan Deductible Family Co-Ins Size 1 Size 2 Size >2 1500 2500 0% 1825 3651 4929 2 500 1000 20% 2016 4032 5444 250 500 20% 2245 4491 6063 A W 100 200 10% 2577 5154 6959 10 Employee Family Enter 3 Annual Parent Parent Child Total 11 Data Size 3 for Family Expenses 600 1200 0 1800 12 13 14 Costs Outlays Pay Co-Pay Total 15 600 1200 Hint: Formulas in the costs section begin with "=Min" 16 500 500 17 500 250 =MIN(d7,N4:N5 Check: B16 = 500 E17 = 500 18 100 100 MIN (number], [number2], [number3], ...) C18 = 100 G15 = 1800 19 20 Cost 21 Premium w/ Premium 22 Best Plan Hint: Cells B22:B25 begin with "=Choose" 23 #N/A 24 Check: Cell C26 = 6604 25 26 0 min Best Plan = 2 27 28 29 30 31 32 33 34 35 Sheet1 +

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Haverhill Engineers Ltd. manufactures components for the car industry. It is considering automating its line for producing crankshaft bearings. The automated equipment will cost $700,000. It will...

In 2015, PayPal was spun off from eBay and provides electronic payment solutions for both consumers and merchants and maintains a focus on online transactions. For this assignment, you will utilize...

FROM: XXXXXXXXXX SUBJECT: Results of Requested Forecast 5 May 2018 Attached are the results of next year's sales forecast. After examining several quantitative models, I determined that the data best...

Overview The purpose of this assignment is to broaden your understanding of deterministic finite automata and their acceptance relation. Recall that a deterministic finite automaton is defined as a...

req 1: Computer payback, the ARR, the NPV, and the profitability index of these two plans. calculate the accounting rate of return for both plans. calculate the net present value of each plan. begin...

pions Index You are writing a file that is 4326 bytes long. The cluster size is 512 bytes. Assume the file starts at the first available cluster on the drive. 1 2 3 4 5 6 7 8 9 10 2 11 3 12 E 13 O 14...

please help! Steps please so I can understand! 2. After building a scientific way for demand forecasting, Mary hoped Jason can propose the optimal inventory/ordering policies for these 4 products for...

Using the data in the Excel file Home market value develop a multiple linear regression model for estimating the market value as a function of both the age and size of the house. State the model and...

Sole and show the solution 4. Consider the following data on 30 different investments and their maturity values after 15 years. Investment ($) Future value ($) 1500 3119 2000 4158 2200 4574 2480 5156...

LTV 495 Add interest and principal payment graph here. 2 3 4 Question 1 5 Mortgage Information 6 Property Price $250,000 7 Loan Amount $187,500 3 Down Payment $62,500 9 0.75 10 Interest rate 4.0%...

Question is need to put in the correct Vlookup formula in order to find the answer of the daily changes in stock prices for simulation data. My numbers aren't adding up. This is for part B below. A...

Why is the identification of favorable and unfavorable variances so important to a company? How can the identification of the variances help management control costs? Explain.

Is leasing a zero sum game in the sense that any gain to the lessee is a cost to the lessor? If not, how might both parties gain from a lease transaction? In your answer, explain how the lessee and...

2 8 9 6 3 2 2 8 9 6 3 2 At least one of the answers above is NOT correct. Under ideal conditions a certain bacteria population is known to double every 2 hours. Suppose there are initially 4 0 0...

At a local grocery store the demand for tri-tip is approximately 50 pounds per week when the price per pound is $4, but is only 40 pounds per week when the price rises to $5.50 per pound. Assuming a...

HK Shipper loaded 10 tons of construction steel bars on board of the vessel in Hong Kong. The steel bars will send to the U.S. The BL wrote in apparent good order and condition, 10 tons of...

4. (Cole-Hopf transformation). Show that if o satisfies the heat equation then the change of dependent variable u(x, t) =-2 satisfies the viscous Burgers equation U + uu, = Ur

2. Levels of Meaning For the next 48 hours, observe others communi- cating on the relationship level of meaning. Record examples of the following: . Communicating responsiveness Communicating lack of...

If you were Jennifer, what would be the first thing that you would do when joining the business? resource management activities, such as recruiting, selecting, training, and rewarding employees, are...

=+2. Using the same product (client), expand the brief into a longer one. Remember to describe your audience using the appropriate VALS, such as Belongers, Emulators, Achievers, and so on. (See...

=+6. Select the one that would work best for this client.