The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 407 Weeks Ago, 5 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
Valu-Com Electronics manufactures five different models of telecommunications interface cards for PCs and laptops. As summarized in the following table, each of these devices requires differing amounts of printed circuit board, resistors, memory chips, and assembly.
Â

The unit wholesale price and manufacturing cost for each model are as follows.

In its next production period, Valu-Com has 80,000 square inches of PC board, 100,000 resistors, 30,000 memory chips, and 5,000 hours of assembly time available. The company can sell all the product it can manufacture, but the marketing department wants to be sure the company produces at least 500 units of each product and at least twice as many FastLink cards as HyperLink cards while maximizing profit.
a. Formulate an LP model for this problem.
b. Create a spreadsheet model for this problem, and solve it using Solver.
c. What is the optimal solution?
d. Could Valu-Com make more money if it schedules assembly workers to work overtime?
Â
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll