Market Pulse Research has conducted a study for Lucas Furniture on some designs for a new commercial office desk.Three attributes were found to be most influential in determining which desk is most desirable: number of file drawers,the presence or absence of pullout writing boards,and simulated wood or solid color finish.Listed below are the part-worths for each level of each attribute provided by a sample of seven potential Lucas customers.
Suppose the overall utility (sum of part-worths)of the current favorite commercial office desk is 50 for each customer.What product design will maximize the share of choices for the seven sample participants? Using Excel,formulate and solve this 0-1 integer programming problem.

Question

Market Pulse Research has conducted a study for Lucas Furniture on some designs for a new commercial office desk.Three attributes were found to be most influential in determining which desk is most desirable: number of file drawers,the presence or absence of pullout writing boards,and simulated wood or solid color finish.Listed below are the part-worths for each level of each attribute provided by a sample of seven potential Lucas customers.​  ​
Suppose the overall utility (sum of part-worths)of the current favorite commercial office desk is 50 for each customer.What product design will maximize the share of choices for the seven sample participants? Using Excel,formulate and solve this 0-1 integer programming problem.

Quizplus · Accepted Answer

The Answer of Market Pulse Research has conducted a study for Lucas Furniture on some designs for a new commercial office desk.Three attributes were found to be most influential in determining which desk is most desirable: number of file drawers,the presence or absence of pullout writing boards,and simulated wood or solid color finish.Listed below are the part-worths for each level of each attribute provided by a sample of seven potential Lucas customers.​  ​
Suppose the overall utility (sum of part-worths)of the current favorite commercial office desk is 50 for each customer.What product design will maximize the share of choices for the seven sample participants? Using Excel,formulate and solve this 0-1 integer programming problem.

Market Pulse Research Has Conducted a Study for Lucas Furniture