TeaPod Digital Media Players
Not what you're looking for?
Instruction: This is a Linear Optimization problem in a Decision modeling course. Please use excel and Solver as it is instructed in the question.
TeaPod Digital Media Players (DMP) Corp. is a Mountain View, California based electronics manufacturer, specializing in their patented technology media players. Started in 2006, the company is still in its growth phase. The company has four different models of players it sells to consumers: The Active and iPlus models are equipped with the company's newly patented Internet browsing software and chip, and have special "touch-screen" displays specifically designed for that purpose. The Classic and Slim models have regular displays.
TeaPod out-sources its manufacturing and relies on partners located in Taiwan for the supply of the displays, assembly and test of the players. Each model's assembly time and test time requirements are shown in Table 1 below, together with the amount of time available for assembly and testing in the next month. Unfortunately, because of a supply chain disruption in Taiwan, the market is short in displays. TeaPod's supplier is working with tight resources, and indicates that not more than 12,000 displays in total could be supplied in the next month, and of these, not more than 7,000 could be the touch-screen type.
Question:
Assume that TeaPod is interested in maximizing the contribution from the players for the next month, and that it can sell all the players of any model that can be produced. How many of each model should TeaPod order to be produced? Formulate this as a linear programming model, set it up in Excel, and use Solver to find the optimal solution. Please also show your model's Excel formulas.
Please see the attached file for data.
Purchase this Solution
Solution Summary
Provides steps necessary to maximize contribution from players.
Education
- BE, Bangalore University, India
- MS, University of Wisconsin-Madison
Recent Feedback
- "Your explanation to the answers were very helpful."
- "What does 1 and 0 means in the repair column?"
- "Went through all of the formulas, excellent work! This really helped me!"
- "try others as well please"
- "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
Basic Computer Terms
We use many basic terms like bit, pixel in our usual conversations about computers. Are we aware of what these mean? This little quiz is an attempt towards discovering that.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.