Project 21
Joey Koons Runs a Small Custom Computer Parts Company

Essay

Project 2.1
Joey Koons runs a small custom computer parts company.As a sideline he offers customized and pre-built computer system packages.In preparation for the upcoming school year,he has decided to offer two custom computer packages tailored for what he believes are current student needs.System A provides a strong computing capability at a reasonable cost while System B provides a much more powerful computing capability,but at a higher cost.Joey has a fairly robust parts inventory but is concerned about his stock of those components that are common to each proposed system.A portion of his inventory,the item cost,and inventory level is provided in the table below.
$\begin{array}{llclclclc}\text { Part } & \begin{array}{l}\text { Type/ } \\\text { Cost }\end{array} & \begin{array}{c}\text { On } \\\text { Hand }\end{array} & \begin{array}{l}\text { Type/ } \\\text { Cost }\end{array} & \begin{array}{c}\text { On } \\\text { Hand }\end{array} & \begin{array}{l}\text { Type/ } \\\text { Cost }\end{array} & \begin{array}{c}\text { On } \\\text { Hand }\end{array} & \begin{array}{l}\text { Type/ } \\\text { Cost }\end{array} & \begin{array}{c}\text { Ond } \\\text { Hand }\end{array} \\\hline \text { Processo } & 366 & 40 & 500 & 40 & 650 & 40 & 700 & 40 \\\mathrm{r} & \mathrm{MHZ} & & \mathrm{MHZ} & & \$ \mathrm{MHZ} & & \$ 7 \% & \\& \$ 175 & & \$ 239 & & \$ 500 & & \$ 742 & \\\hline \text { Memory } & 64 \mathrm{MB} & 40 & 96 \mathrm{MB} & 40 & 128 \mathrm{MB} & 15 & 256 \mathrm{MB} & 15 \\& \$ 95 & & \$ 189 & & \$ 250 & & \$ 496 & \\\hline \text { Hard } & 4 \mathrm{~GB} & 10 & 6 \mathrm{~GB} & 25 & 13 \mathrm{~GB} & 35 & 20 \mathrm{~GB} & 50 \\\text { Drive } & \$ 89 & & \$ 133 & & \$ 196 & & \$ 350 & \\\hline \text { Monitor } & 14 " & 3 & 15 " & 65 & 17^{\prime \prime} & 25 & 19 " 10 \\& \$ 95 & & \$ 160 & & \$ 280 & & \$ 480 & 10 \\\hline \text { Graphics } & \text { Stock } & 100 & 3-\mathrm{D} & 15 & & & & \\\text { Card } & \$ 100 & & \$ 250 & & & & & \\\hline \text { CD- } & 24 \mathrm{X} & 5 & 40 \mathrm{X} & 25 & 72 \mathrm{X} & 50 & \text { DVD } & 45 \\\text { ROM } & \$ 30 & & \$ 58 & & \$ 125 & & \$ 178\\\hline \text { Sound } & \text { Stock } & 100 & \text { Sound } & 50 & \text { Plat II } & 25 \\\text { Card } & \$ 99 & & \text { II } & \$ 150 & & \$ 195 \\\hline \text { Speakers } & \text { Stock } & 75 & 60 \mathrm{~W} & 75 & 120 \mathrm{~W} & 25 \\& \$ 29 & & \$ 69 & & \$ 119 & \\\hline \text { Modem } & \begin{array}{l}\text { Stock } \\\$ 99\end{array} & 125 & & \\\hline \text { Mouse } & \begin{array}{l}\text { Stock } \\\$ 39\end{array} & 125 & \begin{array}{l}\text { Ergo } \\\$ 69\end{array} & 35 \\\hline \text { Keyboar } & \text { Stock } & 100 & \text { Ergo } & 35 \\\text { d } & \$ 59 & & \$ 129 & \\\hline \text { Game } & \text { Stock } & 25 & & \\\text { Devices } & \$ 165 & & & \\\hline\end{array}$
The requirements for each system are provided in the following table:
$$\begin{array} { r r r } & \text { System A } & \text { System B } \\\hline \text { Proces5ar } & 366 \mathrm { MHZ } & 700 \mathrm { MHZ } \\\text { Memory } & 64 \mathrm { MB } & 96 \mathrm { MB } \\\text { Hard Drive } & 6 \mathrm {~GB} & 20 \mathrm {~GB} \\\text { Monitar } & 15 " & 15 " \\\text { Graphics Card } & \text { Stack } & \text { Stack } \\\text { CD-ROM } & 40 X & 72 X \\\text { Sound Card } & \text { Stack } & \text { Stack } \\\text { Speakers } & \text { Stack } & 60 W \\\text { Modem } & \text { Stack } & \text { Stack } \\\text { Mouse } & \text { Stack } & \text { Stack } \\\text { Keyboard } & \text { Stack } & \text { Stack }\end{array}$$
Each system requires assembly,testing and packaging.The requirements per system built and resources available are summarized in the table below.
$\begin{array}{rrrr} & \text { System A } & \text { System B } & \text { Total Hours Available } \\\hline \text { Assembly hours) } & 2.25 & 2.50 & 200 \\\text { Testing hours) } & 1.25 & 2.00 & 150 \\\text { Packaging hours) } & 050 & 0.50 & 75\end{array}$
Joey is uncertain about product demand.In the past he has put together similar types of computer packages but his sales results vary.As a result is unwilling to commit all his in-house labor force to building the computer packages.He is confident he can sell all he can build and is not overly concerned with lost sales due to stock-outs.Based on his market survey,he has completed his advertising flyer and will offer System A for $ 1250 and will offer system B for
$ 2325.Joey now needs to let his workers know how many of each system to build and he wants that mix to maximize his profits.
Formulate an LP for Dave's problem.Solve the model using the graphical method.What is Dave's preferred product mix? What profit does Dave expect to make from this product mix?