Consider the following constraints: S2-1 We have a budget of only $20,000,000. S2-2 Project 2, Project 6 and Project 7 are to be performed at 3 different locations and require specialized equipment. We can only perform one of these projects (i.e., if we select Project 6, we cannot initiate Project2 or Project 7). S2-3 Project 1 and Project 4 are to be initiated together (i.e., either BOTH be initiated or neither are to be initiated). S2-4 We have a limit of 5,000 hours for Civil Engineering. S2-5 We have a limit of 3,500 hours for Electrical Engineering. S2-6 We have a limit of 2,000 hours for Management Engineering. Build your model in excel and solve using a solver

use the tables below to answer the questions

Consider the following information regarding each of the projects:

Table 1.

Projects - GreenCat Corporation
	Expected Profit Next Year	Anticipated Cost	Expected Civil Engineering Hours	Expected Electrical Engineering Hours	Expected Management Engineering Hours
Project 1	1.5-2.5	0.6-0.8	371	230	114
Project 2	3-5	0.8-1.2	527	389	256
Project 3	4-6	2.3-2.7	569	347	219
Project 4	7-8	2.5-2.9	782	539	356
Project 5	9-11	4-6	669	401	171
Project 6	0.5-1.5	0.25-0.5	228	182	131
Project 7	10-14	3.5-4.5	730	576	235
Project 8	13-17	6-9	981	706	539
Project 9	2-4	0.6-0.8	196	127	71
Project 10	5-7	2.5-3.5	841	546	485
Project 11	15-19	3-4	712	526	123
Project 12	3-5	1.5-2.5	572	446	325
Project 13	4-6	1.5-1.9	502	356	308
Project 14	4-6	2.2-2.8	589	353	357

Table 2.

Projects - GreenCat Corporation
	Expected Profit Next Year	Anticipated Cost	Expected Civil Engineering Hours	Expected Electrical Engineering Hours	Expected Management Engineering Hours
Project 1	1-3	0.5-0.9	371	230	114
Project 2	2-6	0.5-1.5	527	389	256
Project 3	3-5	1.5-3.5	569	347	219
Project 4	6-10	2-3.4	782	539	356
Project 5	6-14	3-7	669	401	171
Project 6	0.5-1.5	0.25-0.75	228	182	131
Project 7	7-17	3-5	730	576	235
Project 8	11-19	5-10	981	706	539
Project 9	1.5-4.5	0.4-1.0	196	127	71
Project 10	4-8	1.5-4.5	841	546	485
Project 11	12-22	2-5	712	526	123
Project 12	2-6	1-3	572	446	325
Project 13	3-7	1.2-2.2	502	356	308
Project 14	2-8	1.5-3.5	589	353