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) 3 4 1200 1 5 800 Profit 40 105 This information is in the EXCEL worksheet. You will need to use it to produce suitable equations. State the Profit Equation. B C F m 1 2 3 Product 4 Y 105 12