Exercise N il (Sensitivity Analvsis) (10 pts.) AlMuasasa company manufactures two type of products; Product A and Product B. Selling one unit of product A (resp. of product B) earns the company 300SR (resp. 400SR). To manufacture products A and B, the company uses resources shown in table 1. The company owns 73 of Type 2 machines. Each day, there are 260 tons of steel available and the AlMuasasa needs to rent up to 98 Type I machine at a cost of 50SR per machine. Managerial constraints require that at least 88 of product A, and at least 26 of product B, be manufactured. Let x1= number of product A produced daily: x2= number of product B produced daily; and mt= Type 1 machines rented daily. 1) Use Excel Solver to check that the optimal solution to Carco problem is to get 32540 SR when x1=88, x2=27.6, and m1=98. a. Hint: The constraint 0,8x1+x2my0 will ensure that AlMuasasa will rent only what is needed for the production. Use Excel Solver's Sensitivity Analysis report to answer the following questions (provides all the details for you answers and from where you obtained them in Analysis report): 2) If each product A contributed 310SR to profit, what would be the new optimal solution to the problem? 3) If AlMuasasa was required to produce at least 86 of product A, what would AlMuasasa's profit become? Exercise N:2 (Transportation Simplex) (15 pts.) Consider the following transportation tableau summarizing the requirement of a company's transportation problem: Apply the Transportation Simplex to find the optimal solution (show all the steps and provide the z-value of the optimal solution). Exercise N il (Sensitivity Analvsis) (10 pts.) AlMuasasa company manufactures two type of products; Product A and Product B. Selling one unit of product A (resp. of product B) earns the company 300SR (resp. 400SR). To manufacture products A and B, the company uses resources shown in table 1. The company owns 73 of Type 2 machines. Each day, there are 260 tons of steel available and the AlMuasasa needs to rent up to 98 Type I machine at a cost of 50SR per machine. Managerial constraints require that at least 88 of product A, and at least 26 of product B, be manufactured. Let x1= number of product A produced daily: x2= number of product B produced daily; and mt= Type 1 machines rented daily. 1) Use Excel Solver to check that the optimal solution to Carco problem is to get 32540 SR when x1=88, x2=27.6, and m1=98. a. Hint: The constraint 0,8x1+x2my0 will ensure that AlMuasasa will rent only what is needed for the production. Use Excel Solver's Sensitivity Analysis report to answer the following questions (provides all the details for you answers and from where you obtained them in Analysis report): 2) If each product A contributed 310SR to profit, what would be the new optimal solution to the problem? 3) If AlMuasasa was required to produce at least 86 of product A, what would AlMuasasa's profit become? Exercise N:2 (Transportation Simplex) (15 pts.) Consider the following transportation tableau summarizing the requirement of a company's transportation problem: Apply the Transportation Simplex to find the optimal solution (show all the steps and provide the z-value of the optimal solution)
