A manufacturer makes two products, X and Y. Each X and Y requires a certain number of hours in each of the following dep

[answerhappygod]

A manufacturer makes two
products, X and Y.
Each X and Y requires a certain number of hours in each of the
following departments: the assembly department, the spraying
department and the finishing department.
We are also given how much profit each X and Y makes.
This information is summarised in the following table along with
the total time available in each department:
X
Y
Total time available (hrs)
Assembly (time in hrs)
3
2
500
Spraying (time in hrs)
2
5
300
Finishing (time in hrs)
7
2
400
Profit
£16
£13
A manufacturer makes two
products, X and Y.
Each X and Y requires a certain number of hours in each of the
following departments: the assembly department, the spraying
department and the finishing department.
We are also given how much profit each X and Y makes.
This information is summarised in the following table along with
the total time available in each department:
X
Y
Total time available (hrs)
Assembly (time in hrs)
3
2
500
Spraying (time in hrs)
2
5
300
Finishing (time in hrs)
7
2
400
Profit
£16
£13
Using Excel Solver and the Integer Programming inside Solver,
find the values of X and Y (to the nearest whole number) which
maximise profit and state what the maximum profit will be.