University Path:P 19 ut of A manufacturer makes two products, X and Y. Each X requires 3 hours in the assembly department, 5 hours in the spraying department and 6 hours in the finishing department For Y, the time required in each of these departments is 8 hours, 4 hours and 7 hours respectively. We are also told that each X makes 48 profit and each Y makes 45. This information is summarised in the following table along with the total time available in each department: Total time available (hrs) 3 1500 5 4 850 Assembly (time in hrs) Spraying (time in hrs) Finishing time in hrs) Profit 6 7 1200 48 45 Store this information in the Linear Programming EXCEL worksheet. You will need to use it to produce suitable equations. Using Excel Solver or otherwise, find the values of X and Y (to the nearest whole number) which maximise profit X Y Parranh