Answer Happy

Please show and explain all work.
PRT 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 different amounts of printed circuit (PC) board, resistors, memory chips and assembly. HyperLink 20 Per Unit Requirements FastLink Speed Link 15 10 MicroLink 8 EtherLink 5 28 PC Board (square inches) Resistors Memory Chips Assembly Labor (in hours) 8 0.75 24 8 0.6 18 4 0.5 12 4 4 0.65 16 6 1 The unit wholesale Price and manufacturing cost for each model are as follows. Per Unit Revenues and costs FastLink Speed Link $149 $129 $101 $96 HyperLink $189 $136 Wholesale Price Manufacturing Cost MicroLink $169 $137 EtherLink $139 $101 In their next production period, PRT 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 wants to 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 PRT electronics make more money if it schedules its assembly workers to work overtime? e. Which of the constraints in the problem are binding? f. If the company was going to eliminate one of its products, which should it be? g. If the company could buy 1,000 additional memory chips at the usual cost, should they do it? If so, how much would profits increase? h. Suppose the manufacturing costs used in this analysis were estimated hastily and are known to be somewhat imprecise. For which products would you want more precise cost estimates before implementing this solution?