Formulate the LP and create a spreadsheet model to solve for the optimal solution and optimal value. Include the LP formulation (with labels) in a textbox. Create a separate textbox and indicate what the optimal solution and optimal value are.

2. Bowen Games produces highly addictive games that people can pray on phones. They plan to do consumer research to identify future game themes in a new survey. To fully draw statistically valid results, it must fulfill the following requirements: 1) survey at least 4,000 customers in total, 2) survey at least 2,000 customers who are 25 years of age or younger, 3) survey at least 1,200 customers who are 25 and 40 years of age, 3) survey at least 800 customers who are 40 years of age or older, 4) ensure that at least 40% of those surveyed customers are male, 5) ensure that at most 100 of those surveyed male customers are older than 40 years of age. CEO Ned Bowen estimates that the costs of reaching people in each age and gender category are as follows: GENDER COST PER PERSON SURVEYED ($) AGE 40 Male $4.50 $3.50 $5.00 Female $3.80 $4.20 $5.40 Apply linear programming to model this marketing research problem to minimize the interview cost in total. (Define decision variables and write the objective function and constraints.) a. Formulate this as a Linear Program. b. Solve this program. What is the optimal solution? What is the total cost