Please answer with excel

MRA decides that all surveys should be conducted in person. It estimates that the costs of reaching people of each age are: $9.80 (under 30 years), $7.40 (between 3050) and $5.50 (over 50). Because of the travel distances involved, surveying anyone from Bavaria will add an extra $4 to the costs. MRA wishes to meet all survey requirements for the lowest possible cost. (Note: Bavaria is a state in Germany.) a. Formulate this as a Linear Program. b. Solve this program. What is the optimal solution? What is the total cost? 5. Market Research Associates (MRA) is a marketing and consumer research firm based in Hannover that handles customer surveys. One of its clients is a national press service that periodically conducts political polls on issues of widespread interest. In a survey for the press service, MRA determines that it must fulfill sev- eral requirements in order to draw statistically valid conclusions on the sensitive issue of German immigration policy. These are: Survey at least 2,300 German households in total Survey at least 900 households whose heads are under 30 years of age Survey at least 800 households whose heads are between 30 and 50 years of age Ensure that at least 20% of those surveyed live in Bavaria Ensure that no more than 15% of those surveyed who are over 50 years of age live in Bavaria . MRA decides that all surveys should be conducted in person. It estimates that the costs of reaching people of each age are: $9.80 (under 30 years), $7.40 (between 3050) and $5.50 (over 50). Because of the travel distances involved, surveying anyone from Bavaria will add an extra $4 to the costs. MRA wishes to meet all survey requirements for the lowest possible cost. (Note: Bavaria is a state in Germany.) a. Formulate this as a Linear Program. b. Solve this program. What is the optimal solution? What is the total cost? 5. Market Research Associates (MRA) is a marketing and consumer research firm based in Hannover that handles customer surveys. One of its clients is a national press service that periodically conducts political polls on issues of widespread interest. In a survey for the press service, MRA determines that it must fulfill sev- eral requirements in order to draw statistically valid conclusions on the sensitive issue of German immigration policy. These are: Survey at least 2,300 German households in total Survey at least 900 households whose heads are under 30 years of age Survey at least 800 households whose heads are between 30 and 50 years of age Ensure that at least 20% of those surveyed live in Bavaria Ensure that no more than 15% of those surveyed who are over 50 years of age live in Bavaria