AutoSave DET A9 Pro 04 Home Insert Draw Page Layout Formulas D Review Vio Tell me Share Comments the CAP X Cut Calibri (ody) - 71 - ab wrap Text General Namal 2 Normal Good , Y Paste B w Checkel T Neusal LI Merge Center $ug Calculation F Conditions Format Taranto Exploratory inser Delete Formal sorts Filar Cla Fids Sakt Sons that Analyze Dusa B16 f A B C D E F G H I K L M N N O P Q R S T U V W Y Z 2 3 4 A company manufactures 15 product models, Model A to Q. Table 1 JA D L 6 1 4 In lui B B 4 4 1 1 1 1 M 5 sl 5 1 5 The production of each model uses 15 machines, Machine to XV. 6 IN 2 5 5 3 6 6 Q 1 5 5 2 6 3 4 5 1 2 4 4 4 5 5 Table 1 shows the number of hours used for each machine in producing per unit of each model, and also shows the number of hours availible for each machine. 1 4 5 2 4 4 Machine hours per unit production (hrs/unit) Product Model E F IG | H 0 IC K 6 1 1 1 11 5 6 5 1 6 5 5 2 3 2 2 6 1 3 3 2 1 3 1 5 3 6 5 21 2 2 2 3 1 4 2 6 6 5 3 3 4 5 6 61 41 2 4 5 6 2 2 31 5 2 4 4 6 5 3 51 3 6 4 4 4 6 21 6 5 S 5 6 4 6 6 3 4 6 6 3 2 2 4 4 5 5 5 6 4 1 11 3 3 6 2 2 3 5 5 2 1 6 2 1 3 2 21 6 4 5 5 2 21 11 3 3 2 1 4 1 1 1 1 1 41 4 5 3 4 4 3 4 3 2 2 1 4 6 4 4 3 2 2 6 111 8 IV 9 V 10 VI 11 VII 12 Machine VIII 13 lix 14 X 15 XI 16 XII 17 XIII 18 XIV 19 XV 20 21 Table 2 22 23 Profit (S/unit) 2 5 4 Machine availible (hrs) 1 424 2 208 1 213 2 248 4 349 2 5 245 1 218 4 465 2 299 4 290 1 464 6 264 sh 313 5 5 286 1 3 4 3 3 6 2 2 6 4 1 1 1 21 5 5 2 4 4 5 5 31 3 sl 5 6 Table 2 shows the per unit profit of each machine and the minimum number of units that must be produced for each machine. 3 6 4 2 1 2 3 1 2 6 6 1 5 2 3 2 6 6 2 2 Solve this LP to maximize total profit. (decimal # of units are OK) A B B D 923 838 868 J E 968 Product Model G | . 7441 894 805 F F 920 K 810 L 694 M N N 0 Q 747 917 931 602 757 11 2 2 11 2 1 1 11 1 2 4 2 1 3 1 2 24 Minimum units that must produce 25 26 27 Decision variables 28 1 29 111 30 011 31 IV 32 v 33 VI V1 solution RA FF - = + 181% AutoSave DET A9 Pro 04 Home Insert Draw Page Layout Formulas D Review Vio Tell me Share Comments the CAP X Cut Calibri (ody) - 71 - ab wrap Text General Namal 2 Normal Good , Y Paste B w Checkel T Neusal LI Merge Center $ug Calculation F Conditions Format Taranto Exploratory inser Delete Formal sorts Filar Cla Fids Sakt Sons that Analyze Dusa B16 f A B C D E F G H I K L M N N O P Q R S T U V W Y Z 2 3 4 A company manufactures 15 product models, Model A to Q. Table 1 JA D L 6 1 4 In lui B B 4 4 1 1 1 1 M 5 sl 5 1 5 The production of each model uses 15 machines, Machine to XV. 6 IN 2 5 5 3 6 6 Q 1 5 5 2 6 3 4 5 1 2 4 4 4 5 5 Table 1 shows the number of hours used for each machine in producing per unit of each model, and also shows the number of hours availible for each machine. 1 4 5 2 4 4 Machine hours per unit production (hrs/unit) Product Model E F IG | H 0 IC K 6 1 1 1 11 5 6 5 1 6 5 5 2 3 2 2 6 1 3 3 2 1 3 1 5 3 6 5 21 2 2 2 3 1 4 2 6 6 5 3 3 4 5 6 61 41 2 4 5 6 2 2 31 5 2 4 4 6 5 3 51 3 6 4 4 4 6 21 6 5 S 5 6 4 6 6 3 4 6 6 3 2 2 4 4 5 5 5 6 4 1 11 3 3 6 2 2 3 5 5 2 1 6 2 1 3 2 21 6 4 5 5 2 21 11 3 3 2 1 4 1 1 1 1 1 41 4 5 3 4 4 3 4 3 2 2 1 4 6 4 4 3 2 2 6 111 8 IV 9 V 10 VI 11 VII 12 Machine VIII 13 lix 14 X 15 XI 16 XII 17 XIII 18 XIV 19 XV 20 21 Table 2 22 23 Profit (S/unit) 2 5 4 Machine availible (hrs) 1 424 2 208 1 213 2 248 4 349 2 5 245 1 218 4 465 2 299 4 290 1 464 6 264 sh 313 5 5 286 1 3 4 3 3 6 2 2 6 4 1 1 1 21 5 5 2 4 4 5 5 31 3 sl 5 6 Table 2 shows the per unit profit of each machine and the minimum number of units that must be produced for each machine. 3 6 4 2 1 2 3 1 2 6 6 1 5 2 3 2 6 6 2 2 Solve this LP to maximize total profit. (decimal # of units are OK) A B B D 923 838 868 J E 968 Product Model G | . 7441 894 805 F F 920 K 810 L 694 M N N 0 Q 747 917 931 602 757 11 2 2 11 2 1 1 11 1 2 4 2 1 3 1 2 24 Minimum units that must produce 25 26 27 Decision variables 28 1 29 111 30 011 31 IV 32 v 33 VI V1 solution RA FF - = + 181%
