Paragraph Styles (High-tech production problem) Quitmeyer Electronics Incorporated manufactures the following six microcomputer peripheral devices: internal modems, external modems, graphics circuit boards, CD drives, hard disk drives, 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 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. Data for Problem 8-13 INTERNAL MODEM EXTERNAL MODEM CD CIRCUIT BOARD DRIVES HARD DRIVES MEMORY -BOARDS 7 3 12 Test device 1 Test device 2 Test device 3 2 5 6 2 2 17 17 3 18 15 9 5 1 3 2 The market for all six computer components is vast, and Quitmeyer Electronics believes that it can sell as many units of each product as it can manufacture. The table that follows summarizes the revenues and material costs for each product: REVENUE PER MATERIAL COST UNIT SOLD ($) PER UNIT ($) 200 35 120 DEVICE Internal modem External modem Graphics circuit board CD drive Hard disk drive Memory expansion board 25 40 45 180 130 430 260 170 60 In addition, variable labor costs are $15 per hour for test device 1, $12 per hour for test device 2, and $18 per hour for test device 3. Quitmeyer Electronics wants to maximize its profits. (a) Formulate this problem as an LP model. (b) Solve the problem by computer. What is the best product mix? (c) What is the value of an additional minute of time per week on test device 1? Test device 2? Test device 3? Should Quitmeyer Electronics add more test device time? If so, on which equipment? D AutoSave Assignment 2 Template - Excel Search Leah Yokley LY 7 File Home Insert Draw Page Layout Formulas Data Review View Developer Help Share Comments Insert Times New Roman 12 A == General AY O 5 ab Wrap Text 5 3 Merge & Center DX Delete v Paste BIU MA $ %, Ideas Conditional Format as Cell Formatting Table Styles Styles Sensitivity Sort & Find & Filter Select Format Clipboard Font Alignment Number Cells Editing Ideas Sensitivity B11 f A H J 1 M N P Q R B Internal Modem 1 External Modem D Circuit Board 1 E CD Drivers F Hard Driver G Memory Boards 1 I LEFT SIDE K RIGHT SIDE 200 35 7 2. 120 25 3 5 1 180 40 12 3 3 130 45 6 2 2 430 170 18 15 9 260 60 17 17 2 63K 44