help using spreadsheet

7-6 An electronics manufacturer has an option to pro- duce six styles of cell phones. Each of these devices Table for Problem 7-6 requires time, in minutes, on three types of elec tronic testing equipment, as shown in the table at the bottom of this page. The first two test devices are each available for 120 hours per week. Test device 3 requires more preventive maintenance and may be used only for 100 hours each week. The market for all six cell phones is vast, so the manufacturer believes that it can sell as many cell phones as it can manufacture. The table also summarizes the revenues and material costs for each type of phone. 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. Determine the product mix that would maximize profits. Formulate the prob- lem as an LP model and solve it by using Excel. Table for Problem 7-6 Test device 1 Test device 2 Test device 3 Revenue per unit Material cost per unit SMARTPHONE BLUEBERRY MOPHONE BOLDPHONE LUXPHONE4G TAP3G 18 17 15 17 9 $200 $120 $180 $200 $430 $260 $25 $40 $45 $170 $60 $35 Table for Problem 7-7 WRENCH FABRICATION HOURS W111 W222 W333 2.50 3.40 3.80 INSPECTION HOURS IN-HOUSE COST OUTSOURCE COST 0.25 $17.00 $20.40 0.30 $19.00 $21.85 $23.00 $25.76 0.45