Using the data provided in the bellow example {Product-Mix Model}

a. Use Excel "Solver" tool to Maximize the "total profit" [Figure A]

b. Then change the 'Labor Limit' to "First Three digits of your Student ID" and 'Budget Limit' to "Last Four digits of your Student ID". For Example, if your Student ID is 110089929 then set Labor Limit to "110" and Budget Limit to "9929". Use Excel "Solver" tool to Maximize the total profit. [Figure B]

Provide Screen Shot for Both of the above Solver results, also explain the difference in the "total profit" for both screen shots in your own words.

Product- Mix Model x1 Total Consumed Limit x2 333.3333 200 8 Decision Vairables: Total Profit: Labor: Budget: X1 Lower: X2 Lower: 0.3 10 1 0 12 0.5 15 0 1 5066.66 200 200 6333.33 8000 333.33 100 200 200 profit and Constraints Scaled by 1000 [Figure A] Product- Mix Model Full Name : Mohammed Hadi Student ID: 110089929 x1 x2 Total Consumed Limit 333.3333 200 8 Decision Vairables: Total Profit: Labor: Budget: X1 Lower: X2 Lower: 0.3 10 12 2720.00000 0.5 110 110 First Three Digits of Your Student ID 15 3400 9929 Last Four Digits of Your Student ID 0 333.33 100 1 200 200 1 0 [Figure B] (reflect changes highlighted in blue color) ES f =C8C7+D8*D7 D E F G H 1 Product Mix Model 2 B 1 2 3 4 5 6 7 Decision Vairables: 8 Total Profit: 9 Labor: 10 Budget: 11 X1 Lower: 12 X2 Lower: 13 14 x1 100 Full Name : Mohammed Hadi Student ID: 110089929 Solver Results Total Consumed Limit Solver could not find a feasible solution 2720.00000 110 110 3400 9929 Keep Solver Solution 100 100 Bestore Original Values 160 200 8 x2 160 12 0.5 15 0 1 03 10 1 0 profit and Constraints Scaled by 1000 Return to Solver Parameters Dialog OK Cancel 16 17 18 19 20 21 22 Solver could not find a feasible: Solver can not find a point for [Sample screen shot] Product- Mix Model x1 Total Consumed Limit x2 333.3333 200 8 Decision Vairables: Total Profit: Labor: Budget: X1 Lower: X2 Lower: 0.3 10 1 0 12 0.5 15 0 1 5066.66 200 200 6333.33 8000 333.33 100 200 200 profit and Constraints Scaled by 1000 [Figure A] Product- Mix Model Full Name : Mohammed Hadi Student ID: 110089929 x1 x2 Total Consumed Limit 333.3333 200 8 Decision Vairables: Total Profit: Labor: Budget: X1 Lower: X2 Lower: 0.3 10 12 2720.00000 0.5 110 110 First Three Digits of Your Student ID 15 3400 9929 Last Four Digits of Your Student ID 0 333.33 100 1 200 200 1 0 [Figure B] (reflect changes highlighted in blue color) ES f =C8C7+D8*D7 D E F G H 1 Product Mix Model 2 B 1 2 3 4 5 6 7 Decision Vairables: 8 Total Profit: 9 Labor: 10 Budget: 11 X1 Lower: 12 X2 Lower: 13 14 x1 100 Full Name : Mohammed Hadi Student ID: 110089929 Solver Results Total Consumed Limit Solver could not find a feasible solution 2720.00000 110 110 3400 9929 Keep Solver Solution 100 100 Bestore Original Values 160 200 8 x2 160 12 0.5 15 0 1 03 10 1 0 profit and Constraints Scaled by 1000 Return to Solver Parameters Dialog OK Cancel 16 17 18 19 20 21 22 Solver could not find a feasible: Solver can not find a point for [Sample screen shot]