Question: Please answer questions below What is the cell formula for B12 in the Excel model? What is the cell formula for D6 in the Excel

Please answer questions below
What is the cell formula for B12 in the Excel model?
What is the cell formula for D6 in the Excel model?
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?
1 2 3 4 5 6 A Input Information Constraint 1 Constraint 2 Constraint 3 7 8 Profit per Unit 9 Output 10 Information 11 Variables 12 Total Profit 4 Adjustable Cells 5 6 Cell 11 12 Cell 13 $D$4 14 $D$5 15 $D$6 B 7 $B$11 8 $C$11 9 10 Constraints Variable 1 2 3 1 5 8.5 A B 1 Microsoft Excel Sensitivity Report 2 42.3 Name Variables Variable 1 Variables Variable 2 Name Constraint 1 Used Constraint 2 Used Constraint 3 Used C Variable 2 5 1 1 4 4.6 18.5 C D 0.0 0.0 D Used 40.0 30.0 13.1 40.0 0.5 30.0 1.3 13.1 0.0 Total Profit= E 5 4 E (type) = 60.8 F Final Shadow Constraint Allowable Value Price R.H. Side Increase 110 30 1.076923077 7 8.5 F Available 40 30 12 G Allowable Decrease 3.4 2.333333333 Allowable Decrease 7 4.666666667 1E+30Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
