How can I enter it in spreadsheet?

1.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.

Per Unit Requirements

HyperLink FastLink SpeedLink MicroLink EtherLink

PC Board 20 15 10 8 5

(square inches)

Resistors 28 24 18 12 16

Memory Chips 8 8 4 4 6

Assembly Labor 0.75 0.6 0.5 0.65 1

(in hours)

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

Per Unit Revenues and Costs

HyperLinkFastLink SpeedLinkMicroLink EtherLink

Wholesale Price $189 $149 $129 $169 $139

Manufacturing Cost $136 $101 $ 96 $137 $101

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.