Complete each problem on a separate worksheet in a single Excelfile. Rename the separate worksheets with the respective problemnumber. You may have to copy and paste the datasets into yourhomework file first. Name the file with your last name, firstinitial, and HW #2. Label each part of the question. Whencalculating statistics, label your outputs. Use the Solver add-infor these problems.
- For a telephone survey, a marketing research group needs tocontact 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.Problem #1 lists the results that can be expected. For example, 30%of all daytime calls are answered by a wife, 15% of all eveningcalls are answered by a single male, and 40% of all daytime callsare not answered at all. Due to limited staff, at most 40% of allcalls can be evening calls.
- Determine how to minimize the cost of completing thesurvey.
- Use SolverTable to investigate changes in the unit cost ofeither type of call. Specifically, investigate changes in the costof a daytime call, with the cost of an evening call fixed, to seewhen (if ever) only daytime calls or only evening calls will bemade. Then repeat the analysis by changing the cost of an eveningcall and keeping the cost of a daytime call fixed.
| Person responding | % of daytime calls | % of evening calls |
| Wife | 30 | 30 |
| Husband | 10 | 30 |
| Single male | 10 | 15 |
| Single female | 10 | 20 |
| None | 40 | 5 |
