DO NOT JUST COPY AND PASTE OTHER ANSWERS THAT ARE FOUND ON THIS WEBSITE PLEASE OR YOU WILL RECIEVE A THUMBS DOWN. SHOW a SCREENSHOT OF HOW IT SHOULD BE SET UP AND SOLVED IN EXCEL USING EXCEL SOLVER!!!!!!!!!!! PLEASE INCLUDE EXCEL FORMULAS AS WELL FOR THINGS LIKE LHS OF CONSTRAINTS, ETC. THANKS !
2. (6nts) Texmart is a locally owned "big-box" retail store chain in Texas with 75 stores, primarily located in the Dallas-Fort Worth area. In order to compete with national big-box store chains, Texmart is planning to undertake several "sustainability" (i.e., "green") projects at its stores. These national chains have been heavily publicizing their sustainability efforts, including the reduction of greenhouse gas (GHG) emissions, which has had a positive effect on their sales. They have also demonstrated that sustainability projects can have a positive impact on cost (especially energy) savings. The projects Texmart is considering include installing solar panels at some or all of its stores, installing small wind turbines, replacing some or all of its 165 trucks with more fuel-efficient hybrid trucks, and implementing waste reduction programs at its stores, including recycling and reducing the use of plastic bags in stores. The costs for these projects (per store or truck), the resulting reduction in GHG emissions, the energy savings, and the annual costs savings are shown in the following table: Texmart has established the following four goals: (1) It doesn't want to exceed is program budget of $30 million for sustainable projects. (2) It wants to achieve GHG emission reductions of at least 250,000 metric tons per year. (3) It wants to achieve annual cost savings of at least $4 million. (4) It wants to achieve annual energy savings of at least 5 million kilowatt hours (kWh). Moreover, Texmart board decided that goal 4 is the least important goal; Goal 3 is three times as important as goal 4. Goal 1 is two times as important as goal 3. Goal 2 is as important as goal 1 . a) Formulate a Non-Preemptive goal programming model to determine the number of each type of project to undertake to satisfy Texmart. b) Solve the model by using the computer. Write 23 sentences analyzing decision. c) The received decision actually satisfies Texmart business strategy. But during the Texmart board meeting a "green representative" argued with You that the GHG reduction must be weighted as the most important goal among others. Since this would have been a good PR for Texmart to demonstrate greenishnegs, can you propose a higher weight for the respective objective without changing actual decision? (Assuming you are a rational decision maker after successful taking of SPEA-V348 and you know how to use sensitivity analysis in Non-Preemptive GP)
