solve 1 (weight method) by lingo

solve 2 (pre-emptive) by excel

Rucklehouse Public Relations has contracted to do a survey following an election primary in New Hampshire. The firm must assign interviewers to carry out the survey. The interviews are conducted by telephone and in person. One person can conduct 80 telephone interviews or 40 personal interviews in a day. It costs $50 per day for a telephone interviewer and $70 per day for a personal interviewer. The following three goals have been established by the firm to ensure a representative survey: a. At least 3,000 total interviews should be conducted. b. An interviewer should conduct only one type of interview each day. The firm wants to maintain its daily budget of $2,500. c. At least 1,000 interviews should be by telephone. 1. Formulate a goal programming model to determine the number of interviewers to hire to satisfy these goals which have the same importance, and then solve the model (Weights method) 2. Formulate a goal programming model to determine the number of interviewers to hire to satisfy these goals which are listed in order of their priority, and then solve the model. (Preemptive method)