Share
Explore BrainMass

KAK Market Data

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.

Attachments

Solution Preview

NSD NSN SSD SSN ...

Solution Summary

The solution discusses KAK MarketData, Inc. is in the business of evaluating consumer response to products. A client's contract calls for door-to-door personal interviews.

$2.19