Learning Goal: I’m working on a management question and need an explanation and

Learning Goal: I’m working on a management question and need an explanation and answer to help me learn.Stampede Associates (SA) is a marketing and research firm based in Winnipeg that runs consumer surveys.One of their clients is a national press service that periodically conducts political polls on issues of widespread interest.In a survey for the press service, SA determined that it must fulfill several requirements in order to draw statistically valid conclusions on a sensitive issue concerning U.S. border crossings: 1) Survey at least 2,300 Canadian households in total. 2) Survey at least 1,000 households whose heads are 30 years of age or younger. 3) Survey at least 600 households whose heads are between 31 and 50. 4) Ensure that at least 15%, of those surveyed, live in a town that borders on the U.S. 5) Among those surveyed who are 51 or over, no more than 20% should live in a town that borders on the U.S. SA estimates that the costs of reaching people in each age and region category are as shown in Table 1. SA’s objective is to meet the five sampling requirements at the least possible cost. Formulate and solve this as a linear programming problem in Solver.If you cannot make it linear, solve it as a nonlinear problem. Table 1 Cost per Person Surveyed ($) Region Age 50 Bordering town $ 7.50 $ 6.80 $ 5.50 Non-Bordering town $ 6.90 $ 7.25 $ 6.10 DECISION VARIABLES OBJECTIVE FUNCTION Cost CONSTRAINTS: Total Available 1 2 3 4 5
Requirements: 1 solution