# Valu-Com Electronics manufactures five different models of telecommunications interface cards for personal and laptop computers. As summarized

## Question:

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?

## Step by Step Answer:

**Related Book For**

## Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science

**ISBN:** 978-0324656633

5th edition

**Authors:** Cliff T. Ragsdale