QSO 320 Problem Set (Problem Set 4-20)
Complete problem 4-20 at the end of Chapter 4 in your textbook.
You will demonstrate your work using Excel templates provided. You
do not need to include a graphical procedure.
Problem 4-20
X
Y
Profit
$4
$5
=SUMPRODUCT(B5:C5,$B$4:$C$4)
Constraints
Labor
1
2
=SUMPRODUCT(B7:C7,$B$4:$C$4)
<=
10
Material
6
6
=SUMPRODUCT(B8:C8,$B$4:$C$4)
<=
36
Storage
8
4
=SUMPRODUCT(B9:C9,$B$4:$C$4)
<=
40
LHS
Sign
RHS
Hi All,
The homework problem does not seem straight forward, so I put...