Question: solve it in excel and please submit solver and formulas too Name Problem 2 Frys Electronics Inc. conducts several projects for the next fiscal year.

solve it in excel and please submit solver and formulas too
solve it in excel and please submit solver and
Name Problem 2 Frys Electronics Inc. conducts several projects for the next fiscal year. The projects, the number of technicians and the number of customer relation (CR) employees required for each project, and the expected profits for each project are summarized in the following table: Required technicians Required CR employees Profit ($1,000,000s) 20 15 1.0 2 55 45 1.8 Project 3 4 47 38 50 40 2.0 1.5 5 90 70 3.6 6 63 70 2.2 Formulate an integer program that maximizes the company's profit subject to the following management constraints: 1) Use no more than 175 engineers 2) Use no more than 150 CR employees 3) If either project 6 or project 4 is done, both must be done 4) Project 2 can be done only if project 1 is done 5) If project 5 is done, project 3 must not be done and vice versa 6) No more than three projects are to be done. Set up the problem in Excel and find the optimal solution. What is the optimal selection of projects? You may include your algebraic formulation in your Excel submission for a higher chance of partial credits

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!