Open the LP Worksheet (Linear Programming) in the Excel file. A manufacturer makes two products, X and Y. Each X requires 6 hours in the assembly department, 3 hours in the spraying department and 1 hour in the finishing department. For Y, the time required in each of these departments is 12 hours, 4 hours and 5 hours respectively. We are also told that each X makes 40 profit and each Y makes 105. This information is summarised in the following table: X Y Total time available (hrs) 6 12 2400 Assembly (time in hrs) Spraying (time in hrs) Finishing (time in hrs) 4 1200 3 1 5 800 Profit 40 105 Using Excel Solver or otherwise, find the values of X and Y (to ths nearest whole number) which maximise profit and state what the maximum profit will be. B C E F 1 2 3 Product 4 Y 105 12