The SurveyMonkey firm has been contracted to conduct a survey on the party preference in the coming election. The firm must assign interviewers to conduct the survey. The interviews are to be conducted by telephone and in person. One person can conduct 80 telephone interviews or 40 personal interviews in a single day. The following criteria have been established by the firm in order to ensure a representative survey: • At least 3,000 interviews must be conducted. • At least 1,000 interviews must be by telephone. • At least 800 interviews must be personal. Due to urgency of the project, the interviews must be conducted within one day. An interviewer conducts only one type of interview on the day. The cost is $50 per day for a telephone interviewer and $70 per day for a personal interviewer. The firm wants to know the number of interviewers to hire in order to minimize the total cost of the survey.
Hi! How do you solve this qn using Excel Solver?
The SurveyMonkey firm has been contracted to conduct a survey on the party preference in the
coming election. The firm must assign interviewers to conduct the survey. The interviews are to be
conducted by telephone and in person. One person can conduct 80 telephone interviews or 40
personal interviews in a single day. The following criteria have been established by the firm in order
to ensure a representative survey:
• At least 3,000 interviews must be conducted.
• At least 1,000 interviews must be by telephone.
• At least 800 interviews must be personal.
Due to urgency of the project, the interviews must be conducted within one day. An interviewer
conducts only one type of interview on the day. The cost is $50 per day for a telephone interviewer
and $70 per day for a personal interviewer. The firm wants to know the number of interviewers to
hire in order to minimize the total cost of the survey.
a) Formulate a linear programing model for this problem.
b) Solve the problem using Excel. (Fractional solution is accepted)
c) Based on the optimal solution found, does the firm conduct any more telephone or personal
interviews than are required, and if so, how many more?
d) What would be effect on the optimal solution if the firm was required by the client to increase the
number of personal interviews conducted from 800 to a total of 1,200?
Step by step
Solved in 5 steps with 8 images