QUESTION 3 (2|) points}: Alta Electronics manufactures six peripheral devices (indicated in the table) for PCs at its Calgary plant. Each of these products requires time, in minutes to be processed in three departments (covering assembly, testing, etc.,), as shown in the table. The first two departments are available 120 hours per week, while the third is available for only 100 hours each week. Since the demand for all six peripheral devices is very large, Alta believes it can sell as many units of each product it can manufacture. R D Drive 30 60 Memo m , er unit Material Cost 45 7 45 48 (35') 1 er unit Department # I 0.167 0.200 0.067 0.167 0.200 0.083 in hours Department # 2 0.150 0.067 (in hours) Department # 3 0.083 0.033 in hours In addition, variable labor costs are $15 per hour for department 1, $12 per hour for department 2, and $18 per hour for department 3. Alto also has the following production requirements based on existing standing weekly orders: ' At least 43 hard drives (i.e., HD-30 and HD60) must be produced each week. 0 At least 20 units of each of the six products must be produced each week. 0 Develop an Excel model of the problem, ensuring that each variable and constraint is clearly indicated. (18 points) 0 What should Alta electronics manufacture if it intends to maximize profit? Write your recommendation directly in the appropriate worksheet. (2 points)