Describe a situation that could be modeled using a Linear Programming Model. What are the advantages of analyzing and experimenting with a model as opposed to a real object or situation? a a Reference the attached file showing the sensitivity analysis of a solved mode. There is a letter on 20 of the values in the sensitivity report. Choose one of the letters and explain what that number means with respect to the solved model. When you post your solution, please title your response "Letter ?" replacing the question mark with the letter you have chosen from the file. Please ensure you do not duplicate a response from a fellow student. a B C D E F N 2 Variable 1 2 (type) 0 A 1 Input Information 3 4 Constraint 1 5 Constraint 2 6 Constraint 3 7 8 Profit per Unit 9 Output 10 Information 11 Variables Variable 2 5 1 1 IN | Used 40.0 30.0 13.1 Available 40 30 12 3 = 5 4 4. 8.5 4.6 Total Profit = 12 Total Profit 42.3 18.5 60.8 F G A B C D E 1 Microsoft Excel Sensitivity Report 2 4 Adjustable Cells 5 Final Reduced Objective 6 Cell Name Value Cost Coefficient 7 $B$11 Variables Variable 1 8.5 0.0 5 8 $C$11 Variables Variable 2 4.6 0.0 4 9 10 Constraints Final Shadow Constraint 12 Cell Name Value Price R.H. Side Constraint 1 Used 40.0 0.5 40 14 $D$5 Constraint 2 Used 30.0 1.3 30 Constraint 3 Used 13.1 0.0 12 Allowable Increase 7 8.5 Allowable Decrease 3.4 2.333333333 11 13 $D$4 Allowable Increase 110 30 1.076923077 Allowable Decrease 7 4.666666667 1E+30 15 $D$6 A B C D E F G H I J K L M N O P Q R S T What is the cell formula for B12 in the Excel model? What is the cell formula for C12 in the Excel model? What is the cell formula for E12 in the Excel model? What is the cell formula for D4 in the Excel model? What is the cell formula for D5 in the Excel model? What is the cell formula for D6 in the Excel model? What is the optimal value for x1 in the Excel model? What is the optimal value for x2 in the Excel model? What does the value of cell F4 represent in the Excel model? What does the value of cell B5 represent in the Excel model? What is the cell C7 represent on the sensitivity report? What is the cell C8 represent on the sensitivity report? What is the cell E7 represent on the sensitivity report? What is the cell E8 represent on the sensitivity report? What is the cell F8 represent on the sensitivity report? What is the cell G7 represent on the sensitivity report? What is the cell D13 represent on the sensitivity report? What is the cell D15 represent on the sensitivity report? What is the cell F14 represent on the sensitivity report? What is the cell G15 represent on the sensitivity report? O r E