QUESTION 2 (30 marks) The Newtech Corporation produces two digital switches Type X and Type Y. The profit contributions per switch are $60 and $80 respectively. The products pass through 3 production departments: Assembly, Painting and Testing that have respectively 1,500 hours, 800 hours and 900 hours available each week. The company must also meet minimum demand by producing at least 90 Type X switches. The company is interested in maximizing its weekly profit. Each Type X switch requires 2 hour in Assembly, 1 hour in Painting and 2 hours in Testing and each Type Y switch requires 3 hours in Assembly, 1 hour in Painting and 1 hour in Testing. Switches not completed in one week are completed during the following week. (a) What are the two decisions that need to be made? (2 marks) (b) Set up the above problem in Excel using the style that we used in class/lab. Make sure that your spreadsheet model is logical, well organized and easy to understand. In building formulas, use the sumproduct function where appropriate. Use text boxes to identify the changing cells, target cell and constraints. (12 marks) (c) Solve the problem using Solver. Assuming Newtech wants to maximize profit during the next processing cycle, what would be your recommendation to management in terms of the decisions that need to be made? (2 marks) (d) How many hours in Testing would still be available if Newtech implements the solution that maximizes profit? (2 mark) (e) Which constraints are binding? non-binding? (2 marks) (f) Print out your spreadsheet model in landscape orientation and include it with your answers. You do NOT need to use a color printer. (5 marks) (g) Print out the cell formulas in landscape orientation and include it with your answers