M8_3. A political polling organization has been hired to conduct a poll of likely voters prior to an upcoming election. Each voter is to be interviewed in person. It is known that he costs of interviewing different types of voters vary due to the difference in proportion within the population. The costs to interview males, for example, are \$20 per Democrat, \$18 per Republican, and \$27 per Independent voter. The costs to interview female are $24,$22 and $28 for Democrat, Republican, and Independent voters, respectively. The polling service has been given certain criteria to which it must adhere: - There must be at least 7,500 total interviews. - At least 2,500 independent voters must be polled - At least 3,800 males must be polled. - At least 3,250 females must be polled - No more than 35% of those polled may be Democrats - No more than 35% of those polled may be Republicans - No more than 15% of those polled may be Republican males. - Each of the six types of voters must be represented in the poll by at least 13% of the total interviews SOLUTION: The optimal solution, the value of the cost, should be $172,675. You should have a total of 13 constraints (not including non-negativity). Questions: a) If the minimum number of independent voters was increased to 3,000 - what is the new minimum cost in your optimal solution? How does this compare to the original solution (what has changed apart from the number of independent voters and total cost)? b) Compared to the original solution, what if the minimum number of female voters was increased to 4,000 - what is the new minimum cost in your optimal solution? How does this compare to the original solution (what has changed apart from the number of female voters and total cost)? Use the LP Template.xlsx provided to you. Solve the problem using Excel Solver, place the answers to the questions in the appropriate text boxes. I will delete your decision variables in your Excel submission and re-solve your problem. There is no credit for the problem if your Excel submission doesn't solve. See the diagram of a correct solution provided to you on the first problem. If necessary, remove problem constraints so that your Excel file solves. It is better to get partial credit than no credit