Q1 : Show in steps ( put screenshots) how to put this linear programming model in Microsoft Excel ( show how to put the model and how to solve it in the Excel Solver)
Max R = 0.14 xC + 0.16 x S + 0.15 x DO + DP/16 x 2.3
Constraints
0.72 C + 0.2 S+ 1.0 DO + 1.0DP <= 16000( 1000 pound =16000ounce)
0.28 C+ 0.40 S <= 5600
40S <=8000
C+S+DO <=20000
DP <=1000
C>=3000
S>=3000
DO>=3000
C-S <= 0.1 X (C+S)