A linear programming problem using the solver function in MS Excel. Complete with answer report and explanations.

KAK MarketData, Inc. is in the business of evaluating consumer response to products. A client's contract calls for door-to-door personal interviews with the following requirements:

a. Interview at least 50 households with no senior citizens

b. Interview at least 50 households with senior citizens

c. At least 50% of the households should
be contacted at night

d. At least 60% of the households with
senior citizens should be contacted at night

e. At least 250 households should be contacted

1. Formulate an LP model that will allow KAK MarketData to determine how to conduct the necessary interviews to fulfill the client's contract at minimal cost. Clearly define your decision variables, your objective function, and your constraints

2. Using Excel Solver, solve the LP. Place your solution in the space below. Clearly identify the values of your decision variables and the cost associated with your interview schedule.

See attachment below for cost table.

© SolutionLibrary Inc. solutionlibary.com 9836dcf9d7 https://solutionlibrary.com/business/operations-research/a-linear-programming-problem-using-the-solver-function-in-ms-excel-complete-with-answer-report-and-explanations-1ai

Solution Preview

Total Cost = 1750

Constraints Value
50 with no seniors 125 50
50 ...