M3_A5. A political polling organization has been hired to conduct a poll of likelv voters prior to an upcoming election. Each voter is to be interviewed in person. it is known that he costs of interviewing different tvpes of voters varyr due to the difference in proportion within the population. The costs to interview males, for example, are $20 per Democrat, $13 per Republican, and $2? 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: I There must be at least 1500 total interviews. I At least 2,500 independent voters must be polled I At least 3,300 males must be polled. I At least 3,250 females must be polled I No more than 35% of those polled man...r be Democrats I No more than 35% of those polled may be Republicans I No more than 15% of those polled ma'i.r be Republican males. I Each of the six tvpes of voters must be represented in the poll bv at least 13% of the total interviews Formulate and solve this problem in Excel to determine the number of each tvpe of voter that meets the requirements and minimize the cost to carrv out the interviews. a] How manv decision variables does this problem have? b} Not counting the nonnegativitv constraint how manv constraints does this problem have? c} What is the minimum cost in vour optimal solution {the value ofthe objective function}? d} Based on vour solution how manv Democrat Males should he interviewed? e] Based on 1,rour solution how manv Republican lv'lales should be interviewed? f] Based on vour solution how manv independent Males should be interviewed? g} Based on 1,rour solution how manv Democrat Females should be interviewed? h} Based on vour solution how manv Republican Females should be interviewed? i] Based on 1,rour solution how manv independent Females should be interviewed