Description of this paper

Loading

Survey Sciences Inc (SSI) . SSI is a marketing research firm that-(Answered)

Description

Instant Solution ? Click "Buy button" to Download the solution File


Question

Survey Sciences Inc (SSI).? SSI is a marketing research firm that does market surveys on behalf of its clients.? It has been recently contacted by a client to perform a survey for a new product line that will be targeted to the US population overall, but with a special niche market for Hispanic Americans.? The client has agreed to compensate SSI in full for the actual costs of the survey but has specified the following requirements for the survey.?

At least 2,300 U.S. households must be surveyed.

At least 1,000 households whose heads are ? 30 years old must be surveyed.

At least 600 households whose heads are between 31 and 50 must be surveyed.

Ensure that at least 15% of those surveyed live in a state that borders Mexico

Ensure that no more than 20% of those surveyed who are 51 years of age or over live in a state that borders Mexico

Because SSI conducts all its surveys in person, survey costs are high.? The cost accountants at SSI estimate of the costs of reaching people in each age and region category are as follows:

COST PER PERSON SURVEYED ($)

REGION

AGE ? 30

AGE 31-50

AGE ? 51

State bordering Mexico

$7.50

$6.80

$5.50

State not bordering Mexico

$6.90

$7.25

$6.10


Since SSI would like to get this surveying project from this client, its goal is to design a survey plan that minimizes the total cost of conducting the survey.? Formulate this decision problem for SSI as a linear program. Your answer must consist of

5 points (i) Formulate the above as a linear program.? Indicate clearly the decision variables, constraints and the objective function.

5 points (ii) Solve the linear program in (i) by using MS Excel.?? Submit a printed copy of the spreadsheet you used to model the program showing the optimal solution you obtained

5 points (iii) State your results as a table which summarizes the optimal survey plan and presents the results in the following format.

Survey Demographic Group

Number Surveyed In Optimal Survey Plan

Cost Of Surveying The Demographic Group

30 or younger and in a border state

31-50 and in a border state

51 or older and in a border state

30 or younger and in a non-border state

31-50 and in a non-border state

51 or older and in a non-border state

Totals



(15 points) Question 2: Survey Sciences Inc (SSI). SSI is a marketing research firm that does market

 

surveys on behalf of its clients. It has been recently contacted by a client to perform a survey for a new

 

product line that will be targeted to the US population overall, but with a special niche market for

 

Hispanic Americans. The client has agreed to compensate SSI in full for the actual costs of the survey but

 

has specified the following requirements for the survey.

 

1.

 

2.

 

3.

 

4.

 

5.

 


 

At least 2,300 U.S. households must be surveyed.

 

At least 1,000 households whose heads are ? 30 years old must be surveyed.

 

At least 600 households whose heads are between 31 and 50 must be surveyed.

 

Ensure that at least 15% of those surveyed live in a state that borders Mexico

 

Ensure that no more than 20% of those surveyed who are 51 years of age or over live in

 

a state that borders Mexico

 


 

Because SSI conducts all its surveys in person, survey costs are high. The cost accountants at SSI

 

estimate of the costs of reaching people in each age and region category are as follows:

 

COST PER PERSON SURVEYED ($)

 

REGION

 


 

AGE ? 30

 


 

AGE 31-50

 


 

AGE ? 51

 


 

State bordering Mexico

 


 

$7.50

 


 

$6.80

 


 

$5.50

 


 

State not bordering Mexico

 


 

$6.90

 


 

$7.25

 


 

$6.10

 


 

Since SSI would like to get this surveying project from this client, its goal is to design a survey plan that

 

minimizes the total cost of conducting the survey. Formulate this decision problem for SSI as a linear

 

program. Your answer must consist of

 

5 points (i) Formulate the above as a linear program. Indicate clearly the decision variables,

 

constraints and the objective function.

 

5 points (ii) Solve the linear program in (i) by using MS Excel. Submit a printed copy of the

 

spreadsheet you used to model the program showing the optimal solution you obtained

 

5 points (iii) State your results as a table which summarizes the optimal survey plan and presents

 

the results in the following format.

 


 

Survey Demographic

 

Group

 


 

Number Surveyed In

 

Optimal Survey Plan

 


 

Cost Of Surveying

 

The Demographic

 

Group

 


 

30 or younger and in a

 

border state

 

31-50 and in a border

 

state

 

51 or older and in a

 

border state

 

30 or younger and in a

 

non-border state

 

31-50 and in a nonborder state

 

MBA-701-Course-Proejct-4????.1

 


 

51 or older and in a

 

non-border state

 

Totals

 


 

MBA-701-Course-Proejct-4????.2

 


 

 

Paper#9210346 | Written in 27-Jul-2016

Price : $19
SiteLock