****I ONLY NEED ONE OF THE QUESTIONS BELOW ANSWERED***** A What is the cell form
ID: 3271664 • Letter: #
Question
****I ONLY NEED ONE OF THE QUESTIONS BELOW ANSWERED*****
A What is the cell formula for B12 in the Excel model?
B What is the cell formula for C12 in the Excel model?
D What is the cell formula for D4 in the Excel model?
E What is the cell formula for D5 in the Excel model?
F What is the cell formula for D6 in the Excel model?
G What is the optimal value for x1 in the Excel model?
H What is the optimal value for x2 in the Excel model?
I What does the value of cell F4 represent in the Excel model?
J What does the value of cell B5 represent in the Excel model?
Input 2Information Variable 1 Variable 2 Used 40.0 30.0 13.1 e Available 40 30 12 2 4Constraint 1 5 Constraint 2 6 Constraint 3 8Profit per Unit Output 10 Information 11 Variables 8.5 4.6 Total Profit 12 Total Proft 42.3 18.5 60.8Explanation / Answer
A What is the cell formula for B12 in the Excel model?
= B8 * B11 (Product of optimal value of x1 and profit per unit of x1)
B What is the cell formula for C12 in the Excel model?
= C8 * C11 (Product of optimal value of x2 and profit per unit of x2)
D What is the cell formula for D4 in the Excel model?
= B4 * B11 + C4 * C11
E What is the cell formula for D5 in the Excel model?
= B5 * B11 + C5 * C11
F What is the cell formula for D6 in the Excel model?
= B6 * B11 + C6 * C11
G What is the optimal value for x1 in the Excel model?
The optimal value of x1 is Cell B11
H What is the optimal value for x2 in the Excel model?
The optimal value of x2 is Cell C11
I What does the value of cell F4 represent in the Excel model?
F4 represent the right hand constraint for 2x1 + 5x2 <= 40
J What does the value of cell B5 represent in the Excel model?
B5 represent the coefficient of x1 in the second constraint equation 3x1 + x2 <= 30
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.