Share
Explore BrainMass

Quitmeyer Electronics Incorporated

Quitmeyer Electronics Incorporated manufactures the following six microcomputer peripheral devices: internal modems, external modems, graphics circuit boards, CD drives, hard disk drivers, and memory expansion boards. Each of these technical products requires time, in minutes, on three types of electronic testing equipment, as shown in the table shown below.

The first two test devices are available 120 hours per week. The third (device 3) requires more preventive maintenance and may be used only 100 hours each week. The market for all six computer components is vast, and Quitmeyer Electronics believes that it can sell as many units of each products as it can manufacture. The table that follows summarizes the revenues and material costs for each product:

Device Revenue per unit sold($) Material Cost per unit($)
Internal Modem 200 35
External Modem 120 25
Graphics Circuit Board 180 40
CD drive 130 45
Hard disk drive 430 170
Memory expansion board 260 60

In addition, variable labor costs are $15 per hr for test device 1, $12 per hour for test device 2 and $18 per hour for test device 3.
Refer to the High Tech Excel spreadsheet attached. What is the objective function value for the external modem (EM) in the maximization formula?
A. $120
B. $200
C. $92.95
D. This information is not available

How many total minutes are used in the ultimate solution for test device three? Note: Hours available were converted to minutes to agree with the minutes necessary for each unit.
A. 22
B. 3724.138
C. 6000
D. 7200

How much would profit be reduced if High Tech produced one graphics circuit boardo?
A. 0
B. $21.41
C. $135.50
D. $138.64

Attachments

Solution Preview

Refer to the High Tech Excel spreadsheet attached. What is the objective function value for the external modem (EM) in the maximization formula?
A. $120
B. $200
C. $92.95
D. This information is not available

Answer is C. ...

$2.19