engineering division has been asked to select at least 3 out of7 possible sites for 4945409
Engineering Division has been asked to select at least 3 out of7 possible sites for oil exploration at a cost of $50,000 per siteevaluation. Evaluating Sites 1 and 3 will prevent you fromexploring Site 7, and evaluating Sites 2 or 4 will prevent you fromevaluating Site 5. Site 3 cannot be evaluated unless Site 4 isevaluated. a) Formulate a mathematical linear program to minimize the totalcost. Clearly define your decision variables, objective andconstraints b) Implement the formulation in Excel and solve with Solver tofind the optimal solution. Include a snapshot of your solution inthe report Attached