An electronic manufacturer intends to maximize profit. The manufacturer produces six devices used in computers: internal modems (!), external modems ("), graphics circuit boards (#), USB memory stick ($), hard disk drives (%), and memory expansion boards (&). Demand is expected to be within 2,000, 1,500, 1,800, 1,200, 1,000 and 1,000 units of each of the electronic devices produced, respectively. The table that follows summarizes the revenues and material costs for each product: Electronic Devices Produced Price per unit ($) 200 120 180 130 430 260 Material Cost per unit ($) 35 25 40 45 170 60 Each of these devices needs to be tested before being sold. Specifically, each device needs to go through three different tests. The three tests are performed using different electronic testing equipment, ', ( and ). Equipment ' and ( are available 130 hours per week each, while ) is available only 100 hours per week. The time (in minutes) required per device for each of the three tests is reported in the following table: Electronic Devices Produced Electronic Testing Equipment Test 1 (min) 7 3 12 6 18 17 Test 2 (min) 2 5 3 2 15 17 Test 3 (min) 5 1 3 2 9 2 Finally, operating the testing equipment requires specialised personnel and it is therefore costly. The variable labour costs are $16 per hour for equipment ', $12 per hour for (, and $18 per hour for ). A) Write a linear program for this problem and find a solution Excel Solver. (Hint: pay particular attention to determine the objective function) [5 marks] B) Suppose that the manufacturer is considering to increase only the available time for testing equipment (. What would be the increase in the profit if the available time increased to 131, 132, 133, 134 and 135? Can you generalise the answer to part C for any increase 130+t where t is between 1 and 10? What would the formula r profit increase be? [5 marks] C) Should the manufacturer consider increasing the available time for testing equipment )? [5 marks]