For a telephone survey, a marketing research group needs to contact at least 600 wives, 480 husbands, 400 single adult males, and 440 single adult females. It costs $3 to make a daytime call and (because of higher labor costs) $5 to make an evening call. The file P13_31.xlsx lists the results that can be expected. For example, 30% of all daytime calls are answered by a wife, 15% of all evening calls are answered by a single male, and 40% of all daytime calls are not answered at all. Due to limited staff, at most 40% of all phone calls can be evening calls.

a.Determine how to minimize the cost of completing the survey.

The template used is below. Please provide a step by step solution that can be followed as I want to learn the proper way to use the solver program.

Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri 11 AA ab Wrap Text v General Insert v Ex Delete Paste Merge & Center v v % 9 00 0 Conditional Format Cell Sort & Find & Analyze BIUV Sensitivity Formatting as Table Styles Format Filter Select Data S22 X V fx B C D E G H K M N O P R S U V W Telephone survey Percentages Daytime Evening Wife 309 30% 5 Husband 10% 30% 6 Single male 10% 15% Single female 10% 20% 8 None 40% 5% 9 Sum 10 11 Cost/call 12 Max % of evening calls Daytime Evening Total 15 Calls made 17 Max evening calls 19 Contacts Made Required 20 Wife 21 Husband 22 Single male 23 Single female 24 25 Total cost 28 29 43 Model STS_1 STS_2 + Ready Calculate 100%