Question: Can you please see what i've done wrong here, the correct answer is supposed to be $203,040.00. Please set up in the format i used
Can you please see what i've done wrong here, the correct answer is supposed to be $203,040.00. Please set up in the format i used below. Thank you!
Problem:


An electronics manufacturer has an option to produce six styles of cell phones. Each of these devices requires time, in minutes, on three types of electronic 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 problem as an LP model and solve it by using Excel. Table for Problem 3-6 SMARTPHONE BLUEBERRY MOPHONE BOLDPHONE LU) 12 Test device 1 Test device 2 Test device 3 Revenue per unit Material cost per unit $120 $180 $200 $200 $35 $25 $40 $45 Excel Print G & Share I A Open in Desktop App B C D E F G SMARTPHONE BLUEBERRY MOPHONE BOLDPHONE LUXPHONE4G TAP3G 554 0 O D H DECISIONS 0 1292 O OBJECTIVES revenue material cost labor costs profit $ $ $ $ 200.00 35.00 3.65 161.35 $ $ $ $ 120.00 $ 180.00 $ 25.00 $ 40.00 $ 2.05 $ 4.50 $ 92.95 $ 135.50 $ 200.00 45.00 2.50 152.50 $ $ $ $ 430.00 $260.00 170.00 $ 60.00 10.20 $ 8.25 249.80 $ 191.75 $ 204,581.54 CONSTRAINTS test device 1 11 test devices 120 12 0 LO 0 test device 2 test device 3 120 100 14 15 16 17 $ 203,040.00 18 An electronics manufacturer has an option to produce six styles of cell phones. Each of these devices requires time, in minutes, on three types of electronic 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 problem as an LP model and solve it by using Excel. Table for Problem 3-6 SMARTPHONE BLUEBERRY MOPHONE BOLDPHONE LU) 12 Test device 1 Test device 2 Test device 3 Revenue per unit Material cost per unit $120 $180 $200 $200 $35 $25 $40 $45 Excel Print G & Share I A Open in Desktop App B C D E F G SMARTPHONE BLUEBERRY MOPHONE BOLDPHONE LUXPHONE4G TAP3G 554 0 O D H DECISIONS 0 1292 O OBJECTIVES revenue material cost labor costs profit $ $ $ $ 200.00 35.00 3.65 161.35 $ $ $ $ 120.00 $ 180.00 $ 25.00 $ 40.00 $ 2.05 $ 4.50 $ 92.95 $ 135.50 $ 200.00 45.00 2.50 152.50 $ $ $ $ 430.00 $260.00 170.00 $ 60.00 10.20 $ 8.25 249.80 $ 191.75 $ 204,581.54 CONSTRAINTS test device 1 11 test devices 120 12 0 LO 0 test device 2 test device 3 120 100 14 15 16 17 $ 203,040.00 18