Explore BrainMass

Explore BrainMass

Not what you're looking for? Search our solutions OR ask your own Custom question.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

A) Summarize the above information in a useful table.

b) What are the decision variables? Pick a logical symbol for each one.

c) What is the objective function? Is this a maximization or a minimization problem?

d) What are ALL of the constraint equations?

e) It turns out that marketing vastly underestimated the price that they can sell Dr. Phil's Pick-Me-Up-I-Feel-DownÃ¢?Â¢ snacks. If you had solved the above problem with a LP program, such as available with Excel, and had all of the information that it would provide, what information would you use and how would you use it? Use the applicable terms that we have learned.

SOLUTION This solution is FREE courtesy of BrainMass!

2.

Dr. Phil, a well-known TV talk show host and the most caring person in the U.S., cares about making as much money as possible. Besides his Oprah-like TV show, he sells books, videos, board games and Pick-Me-Up-I-Feel-Downâ„¢ snacks. Books sell for \$22, board games for \$34, the snacks at \$2 per dozen, and videos for \$30. Each of these products is sold at twice its costs. Books require 2 pounds of material per book, 1 cubic foot of space (Dr. Phil writes a lot), and 2 hours of assembly (they are made by hand). Videos require 0.5 cubic feet of space, 1 pound of material, and 1 hour of assembly. Board games need 3 pounds of material, 4 cubic feet of space, and 4 hours of assembly. Finally, the snacks require 5 cubic feet of space per dozen, 3 hours of assembly per dozen, and 2 pounds of material. Dr. Phil has limited resources. He only has 300 pounds of materials, 1000 cubic feet of storage space, and 500 hours of assembly time. For some emotional reason having to do with his mother, Dr. Phil does not want to make more than 30 but at least 24 books. Based on a recommendation from Dr. Frank, he retains you as a consultant. Feel Dr. Phil's pain by answering the questions below showing all work.

a) Summarize the above information in a useful table.
Selling Price Cost To Produce Material Space Assembly
Books 22 11 2 pounds 1 ft 2 hrs
Board Games 34 17 3 pounds 4 ft 4 hrs
Snacks 2 1 2 pounds 5 ft 3 hrs
Videos 30 15 1 pound .5 ft 1 hr

b) What are the decision variables? Pick a logical symbol for each one.
Material = M Space = S Assembly = A Cost = C Selling = S
Books = B Board Games = BG Snacks = SN Videos = V

c) What is the objective function? Is this a maximization or a minimization problem?
The objective of this problem would be to maximize the profit that one could achieve given the restraints of this problem.

d) What are ALL of the constraint equations?
B = 24 < X >30
B = 2M + 1S + 2A
BG = 3M + 4S + 4A
SN = 2M + 5S + 3A
V = 1M + .5S + 1A
M = 300
S = 1000
A= 500

e) It turns out that marketing vastly underestimated the price that they can sell Dr. Phil's Pick-Me-Up-I-Feel-Downâ„¢ snacks. If you had solved the above problem with a LP program, such as available with Excel, and had all of the information that it would provide, what information would you use and how would you use it? Use the applicable terms that we have learned.
The information obtained from Excel would be used to maximize the profit one could achieve given the constraints of the above information. Through the use of a spreadsheet program like Excel, one can easily ascertain whether or not one is assigning a correct selling price to one's product.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!