Valu-Com Electronics manufactures five different models of telecommunications interface cards for personal and laptop computers. As summarized in the following table, each of these devices requires differing amounts of printed circuit (PC) board, resistors, memory chips, and assembly.

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

In their 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 that it 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 its assembly workers to workovertime?

Transcribed Image Text:

Per Unit Requirements HyperLink FastLink SpeedLink MicroLink EtherLink 20 28 0.75 PC Board 15 24 0.6 10 18 0.5 8 (square inches) Resistors Memory Chips Assembly Labor 12 4 0.65 16 (in hours) Per Unit Revenues and Costs HyperLink FaLink SpeedLink MicroLink EtherLinlk $129 $ 96 Wholesale Price Manufacturing Cost $189 $136 $149 $101 $169 $137 $139 $101