A - MGMT 430 Week 2 - Discussion 3 Input Information 2 Variable 1 Variable 2 Used (type) CE Available 40 30 12 Constraint Constraint 2 Constraint 3 5 3 1 1 1 30.0 13.1 > What is the cell formula for 12 in the Excel model What is the cel formula for C12 in the Excel moder? What is the cell formula for E 12 in the Excel model? What is the cell formula for D4 in the Excel moder? What is the cell formula for DS in the Excel moder? What is the cell formula for D6 in the Excel model? What is the optimal value fort in the Excel model What is the optimal value for x2 in the Excel moder? What does the value of cell F4 represent in the Excel model? What does the value of cell BS represent in the Excel model? What is the cell C7 represent on the sensitivity report? What is the cell CB represent on the sensitivity report? What is the cell E7 represent on the sensitivity report? What is the cell Es 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? 8. Profit per Unit 5 4 Output Information Total Profit 12 Tots Prof 185 F G Micro C D E Microsoft Excel Sensitivity Report Adustable Cels Final Reduced Objective Cell Name Value Cost Coefficient 7 $8511 Variables Variable 1 85 00 5 8 SC 511 Variables Variable 246 00 4 Alovable increase 7 85 Allowable Decrease 34 2.333333333 10 Constraints 12 Call Name 13 SDS4 Constrant 1 Used 14 5055 Constraint 2 Used 15 509 Constrant 3 Used Final Shadow Constraint Value Price RH. Side 400 05 40 300 13 3 0 131 00 12 Alowable Allowable Increase Decrease 1 10 30 4.666666667 10769230771E30