Q2Please formulate an operational model for the following management problem. And use excel solver to solve the model, reporting the solution of all decision variables and the corresponding optimal Z value.

New product development Problem

A Leisure Food Company plans to develop some new products.

The following table shows relevant data for six potential foods which are under consideration.

The company wants to know which projects should be selected so as to maximize total profits. There are some constraints for project selection. First, the available capital is at most 170 thousand dollars, and the available researchers are no more than 35 people. Second, project 3 and project 4 are closely related, meaning that these two projects must be selected simultaneously. Third, project 5 must be selected if project 2 or project 3 is selected. Fourth, considering the potential risks, at most two projects could be selected among project 1, 4, and 6. Fifth, considering the future development, at least one project should be selected among project 3, 4, and 5.

Please help this company to determine the optimal combinations of new products.

Table 1 Data table

Project	Capital requirement	Researchers requirement	Profit
1	50	11	65
2	65	16	90
3	45	9	80
4	55	7	90
5	40	5	60
6	90	24	110