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
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
