Quitmeyer Electronics (QE) Incorporated is going to manufacture the following six microcomputer peripheral devices: internal modems (IM), external modems (EM), graphical circuit boards (GCB), floppy disk drivers (FDD), hard disk drivers (HDD), and memory expansion boards (MEB). Each of these technical products requires time, in minutes, on three types of electronic testing equipment as shown in the following table: IM EM GCB FDD HDD MEB Test device 1 8 4 6 8 16 15 Test device 2 4 6 3 2 11 10 Test device 3 7 4 5 2 6 3 The first two test devices are available 200 hours per week. The third may be used only 100 hours each week. The market for all six computer components is vast, and QE 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 (in $): IM EM GCB FDD HDD MEB Revenues per unit sold 250 130 200 150 450 300 Material cost per unit 20 10 15 13 30 25 4 / 6 In addition, variable labor costs are $8 per hour for test device 1, $7 per hour for test device 2, and $9 per hour for test device 3. QE wants to maximize its profits. (1) Formulate this production problem as a mathematical programming model (2) Using Excel or QM solve the model and give the optimal solution (3) Do dual analysis (4) Do sensitivity analysis Quitmeyer Electronics (QE) Incorporated is going to manufacture the following six microcomputer peripheral devices: internal modems (IM), external modems (EM), graphical circuit boards (GCB), floppy disk drivers (FDD), hard disk drivers (HDD), and memory expansion boards (MEB). Each of these technical products requires time, in minutes, on three types of electronic testing equipment as shown in the following table: IM EM GCB FDD HDD MEB Test device 1 8 4 6 8 16 15 Test device 2 4 6 3 2 11 10 Test device 3 7 4 5 2 6 3 The first two test devices are available 200 hours per week. The third may be used only 100 hours each week. The market for all six computer components is vast, and QE 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 (in $): IM EM GCB FDD HDD MEB Revenues per unit sold 250 130 200 150 450 300 Material cost per unit 20 10 15 13 30 25 4 / 6 In addition, variable labor costs are $8 per hour for test device 1, $7 per hour for test device 2, and $9 per hour for test device 3. QE wants to maximize its profits. (1) Formulate this production problem as a mathematical programming model (2) Using Excel or QM solve the model and give the optimal solution (3) Do dual analysis (4) Do sensitivity analysis
