Question: Linear Programming Applications Quitmeyer Electronics Incorporated manufactures the following six microcomputer peripheral devices: internal modems, external modems, graphics circuit boards, CD drives, hard disk
Linear Programming Applications 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. 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: Notes Comments P H 1125 EXE CK to add title DEVICE Internal modem External modem Graphics circuit board CD drive Hard disk drive Memory expansion board REVENUE PER UNIT SOLD ($) 200 120 180 130 430 260 MATERIAL COST PER UNIT ($) 35 25 40 45 170 60 Notes Comments P 113% 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?
Step by Step Solution
3.41 Rating (151 Votes )
There are 3 Steps involved in it
a b Excel Formulation Solver input Let xj units of productj to be produced and sol... View full answer
Get step-by-step solutions from verified subject matter experts
