Show using graphical analysis. Use Desmos graphing calculator.

Market Analysis, Inc., is a company that evaluates consumer response to new business ventures. Jefferson Community Health Plan is a full-service health maintenance organization operating in a tri-county region of a mid-western state. Jefferson has hired Market Analysis to evaluate the market response to an innovative comprehensive health care plan. Jefferson's contract calls for a telephone survey with the following requirements: Market Analysis needs to contact at least 150 wives, 120 husbands, 100 single adult males, and 110 single adult females. It costs $2 to make a daytime call and (because of higher labor costs) $5 to make an evening call. The table below lists the results that can be expected. For example, 30% of all daytime calls are answered by a wife, and 15% of all evening calls are answered by a single male. a) Formulate a linear program in Excel to minimize the cost of completing the survey. Solve the problem using the Excel Solver. b) Verify your answers using graphical analysis. Person Responding Percentage of Daytime Calls Percentage of Evening Calls Wife 30 30 Husband 10 30 Single male 10 15 Single female 10 20 None 40 5 A B D E F 1 Daytime calls Evening calls 2 0.3 300 150 0.3 0.1 0.3 120 120 3 Wives 4 Husbands 5 Single males 6 Single females 7 0.1 0.15 105 100 0.1 0.2 110 110 0 0 8 9 Cost: 2 5 2300 10 11 Daytime Evening 12 Result: 900 100 13 Number of daytime nd evening calls to make 14 15