a 1. Type a Word document with a title page and a report beginning on the second page. The report must include the following: (a) define the variables, the objective function, and the constraints for the full goal programming model for Question 1 & (b) define the variables, the objective function, and the constraints for the full goal programming model for Question 2 (Extra Credit). Note: You do not need to include formulations for the P1, P2, and P3 models in your Word document. The case described below analyzes the selection of new suppliers to replace a current supplier of a hazardous material used in the manufacture of a company's product. The buying company must purchase exactly 7.400 units total per year of a similar, but less hazardous, material that performs the same function as the current material this is a hard constraint and not a goal constraint. Each supplier has hard limits on its capacity: Supplier 1 can provide at most 2.299 units Supplier 2 can provide at most 1,975 units, Supplier 3 can provide at most 2.448 units: Supplier 4 can provide at most 2,015 units Supplier 5 can provide at most 925 units Supplier 6 can provide at most 810 As shown in Table 1 below, these criteria focus on the triple bottom line of economic. environmental and social performance objectives. Table 1. Estimated Supplier Performance on the Criteria Supplier Supplier Supplier Supplier Supplier Supplier Supplier Criterion 1 2 3 4 15 6 1) Hours of 5.10 3.42 3.10 1.82 0.92 3.50 138 Employment per Unit N $9.05 Generated 2.60 2) Hazardous 2.02 2.15 1.72 2127 1.58 2.40 Waste per Unit (lbs) $9.77 3) Purchase $6.10 $7.12 $8.25 $2115 SSUTO Cost Savings per Unit This table shows estimated supplier performance for all suppliers on the wee rewa considered Question 1) Priority Level 1 Goal: The hours of employment generated in economically disadvantaged areas should be at least 29 250 Priority Level 2 Goal. The total amount of hazardous waste generated annually by the suppliers should be at most 18,020 pounds. Priority Level 3 Goal. The desired annual purchase cost savings must be at least 558.000 Answer the following questions in your P3 Excel spreadsheet in Cells R1, R2 R3, R4, and R5 after solving the P3 model: a) How many units should the buyer purchase from each supplier? b) How much will total annual purchase cost savings equal? c) For each of the three goals, you must state whether you met the target for the goal exactly were over the target along with the amount over), or were under the target along with the amount under) a 1. Type a Word document with a title page and a report beginning on the second page. The report must include the following: (a) define the variables, the objective function, and the constraints for the full goal programming model for Question 1 & (b) define the variables, the objective function, and the constraints for the full goal programming model for Question 2 (Extra Credit). Note: You do not need to include formulations for the P1, P2, and P3 models in your Word document. The case described below analyzes the selection of new suppliers to replace a current supplier of a hazardous material used in the manufacture of a company's product. The buying company must purchase exactly 7.400 units total per year of a similar, but less hazardous, material that performs the same function as the current material this is a hard constraint and not a goal constraint. Each supplier has hard limits on its capacity: Supplier 1 can provide at most 2.299 units Supplier 2 can provide at most 1,975 units, Supplier 3 can provide at most 2.448 units: Supplier 4 can provide at most 2,015 units Supplier 5 can provide at most 925 units Supplier 6 can provide at most 810 As shown in Table 1 below, these criteria focus on the triple bottom line of economic. environmental and social performance objectives. Table 1. Estimated Supplier Performance on the Criteria Supplier Supplier Supplier Supplier Supplier Supplier Supplier Criterion 1 2 3 4 15 6 1) Hours of 5.10 3.42 3.10 1.82 0.92 3.50 138 Employment per Unit N $9.05 Generated 2.60 2) Hazardous 2.02 2.15 1.72 2127 1.58 2.40 Waste per Unit (lbs) $9.77 3) Purchase $6.10 $7.12 $8.25 $2115 SSUTO Cost Savings per Unit This table shows estimated supplier performance for all suppliers on the wee rewa considered Question 1) Priority Level 1 Goal: The hours of employment generated in economically disadvantaged areas should be at least 29 250 Priority Level 2 Goal. The total amount of hazardous waste generated annually by the suppliers should be at most 18,020 pounds. Priority Level 3 Goal. The desired annual purchase cost savings must be at least 558.000 Answer the following questions in your P3 Excel spreadsheet in Cells R1, R2 R3, R4, and R5 after solving the P3 model: a) How many units should the buyer purchase from each supplier? b) How much will total annual purchase cost savings equal? c) For each of the three goals, you must state whether you met the target for the goal exactly were over the target along with the amount over), or were under the target along with the amount under)