Quitmeyer Electronics Incorporated manufactures six microcomputer peripheral devices: internal modems, external modems, graphics circuit boards, floppy disk drives, hard disk drives, and memory expansion boards. Each of these technical products require time in minutes, on three type of electronic testing equipment, as shown in the table at the bottom of this.
The first two test devices are available 120 hours per week. Test device 3 requires more preventive maintenance and may be used only 100 hours each week. The market ofr 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 follow table summarizes the revenue and cost for each product
Device Revenue Per Unit Material Cost per Unit
Internal Modem 200 35
External Modem 120 25
Graphics circuit board 180 40
Floppy disk drive 130 45
Hard disk drive 430 170
Memory expansion board 260 60
In addition variable labor cost are $15 per hour for test device 1, $12 per hour for test device 2, and $18 per hour for test device 3. Quitmeyer wants to determine the product max that maximizes profits. Formulate the problem as an LP model and solve it by using excel
Write the equations in a WORD document. .