Have students use the Excel Solver to find answers to the problems in the given items. and to analyze and discuss the meaning of Range of Allowable decrease and allowable increase of table variable cells. Shadow price of the Constraints table Allowable decrease and allowable increase ranges of the Constraints table.
Have students use the Exool Solver to find answors to the problems in the glven items. and to analyze and discuss the meaning of - Range of Allowable decrense and nllownble increose of table variable colin - Shadow price of the Constraints table - Alowsbie decrease and allowable increase ranges of the Constraints table 3.1-7. The Apex Television Company has to decide on the number of 27- and 20-inch sets to be produced at one of its factories. Market research indicates that at most 40 of the 27 -inch sets and 10 of the 20 -inch sets can be sold per month. The maximum number of work-hours available is 500 per month. A 27-inch set requires 20 work-hours and a 20 -inch set requires 10 work-hours. Each 27-inch set sold produces a profit of $120 and each 20 -inch set produces a profit of $80. A wholesaler has agreed to purchase all the television sets produced if the numbers do not exceed the maxima indicated by the market research. (a) Formulate a linear programming model for this problem. D (b) Use the graphical method to solve this model. 4 Safari 9:01PM *. 8 . Assignment5_B6411244_Yanawat_klamsuk 3 2 fx Microsoft Excel 16.0 Answer Report Worksheet: [Assignment5_B6411244_Yanawat_klamsuk.xisx]3.1-7 Report Created: 8/5/2566 20:55:14 Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.032 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1\%, Assume NonNegativ Ohiective Cell (Max) Microsoft Excel 16.0 Sensitivity Report Worksheet: [Assignment5_B6411244_Yanawat_klamsuk_xlsx]3.1-7 Report Created: 8/5/2566 20:55:25 Microsoft Excel 16.0 Limits Report Worksheet: [Assignment5_B6411244_Yanawat_klamsuk_xlsx]3.1-7 Report Created: 8/5/2566 20:55:35 Have students use the Exool Solver to find answors to the problems in the glven items. and to analyze and discuss the meaning of - Range of Allowable decrense and nllownble increose of table variable colin - Shadow price of the Constraints table - Alowsbie decrease and allowable increase ranges of the Constraints table 3.1-7. The Apex Television Company has to decide on the number of 27- and 20-inch sets to be produced at one of its factories. Market research indicates that at most 40 of the 27 -inch sets and 10 of the 20 -inch sets can be sold per month. The maximum number of work-hours available is 500 per month. A 27-inch set requires 20 work-hours and a 20 -inch set requires 10 work-hours. Each 27-inch set sold produces a profit of $120 and each 20 -inch set produces a profit of $80. A wholesaler has agreed to purchase all the television sets produced if the numbers do not exceed the maxima indicated by the market research. (a) Formulate a linear programming model for this problem. D (b) Use the graphical method to solve this model. 4 Safari 9:01PM *. 8 . Assignment5_B6411244_Yanawat_klamsuk 3 2 fx Microsoft Excel 16.0 Answer Report Worksheet: [Assignment5_B6411244_Yanawat_klamsuk.xisx]3.1-7 Report Created: 8/5/2566 20:55:14 Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.032 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001 Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1\%, Assume NonNegativ Ohiective Cell (Max) Microsoft Excel 16.0 Sensitivity Report Worksheet: [Assignment5_B6411244_Yanawat_klamsuk_xlsx]3.1-7 Report Created: 8/5/2566 20:55:25 Microsoft Excel 16.0 Limits Report Worksheet: [Assignment5_B6411244_Yanawat_klamsuk_xlsx]3.1-7 Report Created: 8/5/2566 20:55:35
