data analysis and decision modelling


Question Description:

30

hi,i have attached the example assignment. i need the similar to this assignment which is in PHstat. have to make models and run the solver to get maximum profit. you can use different data but should have atleast 8 decision variables Document Preview: 1 110 80 150 70 3 3 4 3 5100 7 2 1 3 1 2600 9 3 2 4 2 4500 5 110 80 150 70 54 40 75 40 56 40 75 30 3 3 4 3 7 2 1 3 1 9 3 2 4 2 5 2 3 Page of 900 799.99999999999989 0 0 110 80 150 70 163000 54 40 75 40 80600 56 40 75 30 82400 3 3 4 3 5100 5100 7 2 1 3 1 2600 2600 9 3 2 4 2 4300 4500 5 Page of 0 82400 0 900 0 799.99999999999989 0 0 0 0 5100 0 2600 0 4300 200 Page of 900 0 56 24 2.9999999999999987 799.99999999999989 0 40 14.999999999999988 9.9999999999999929 0 -4.9999999999999982 75 4.9999999999999982 1E+30 0 -9.9999999999999929 30.000000000000007 9.9999999999999929 1E+30 5100 8 5100 600.00000000000011 1200 2600 16 2600 200.00000000000006 900.00000000000023 4300 0 4500 1E+30 200.00000000000006 1 2 Page of 0 980.00000000000034 539.99999999999977 0 110 80 150 70 159400 54 40 70 40 77000 56 40 80 30 82400 3 3 4 3 5100 5100 7 2 1 3 1 2599.9999999999995 2600 9 3 2 3 2 3580 4500 5 Page of 82400 82400 900 0 799.99999999999989 980.00000000000034 0 539.99999999999977 0 0 5100 0 2599.9999999999995 0 3580 920 Page of 0 0 55.999999999767169 0 1E+30 980.00000000000034 0 39.999999999740893 19.999999999972541 0 539.99999999999977 0 79.999999999455653 39.999999999912049 0 0 -9.9999999981023091 30.00000000174623 9.9999999981023091 1E+30 5100 7.999999999929603 5100 1533.333333337303 1633.3333333421415 2599.9999999999995 15.999999999914211 2600 1225.0000000048867 900.00000000176419 3580 0 4500 1E+30 919.99999999999955 1 2 Page of 700.00000018019978 799.99999999999989 199.9999998693167 0 110 80 150 70 171000.00000021947 54 40 75 40 84799.999999929525 56 40 75 30 86200.000000289947 3 3 4 3 5300.0000000178652 5300 7 2 1 3 1 2799.9999999683496 2800 9 3 2 4 2 4500.0000000178661 4500 5 Page of … Attachments: CO5124-Assign….xlsx

Answer

30