Ensure to answer all questions. Don't answer only one question. I will give 6 dislikes if only 1 question is answered pr plagiarized.

29. A form is engaged in breeding pigs. The pigs are fed on various products grown on the farm. Because of the need to ensure certain nutrient constituents, it is necessary to buy additionally one or two products, which we shall call A and B. The nutrient constituents (vitamins and proteins) in each unit of the products are given below. Nutrient contents in the products Minimum Nutrient amount of B Nutrients 36 6 108 3 12 36 20 10 100 Product costs 20 per unit and product costs 40 per unit. Formulate the L.P. model for products A and B to be purchased at the lowest possible cost so as to provide the pigs, nutrients not less than that given in the table and solve in excel 30. The ABC Flectrical Appliance Company produces two products: refrigerators and ranges. Production takes place in two separate departments Refrigerators are produced in deptt. I and ranges are produced in deptt. IL The weekly production cannot exceed 25 refrigerators in deptt. I and 35 ranges in deptt. IL, because of limited available facilities in the two deputs. The company regularly employs a total of 60 workers in the two deptts. A refrigerator requires 2 man-weeks of labour while a range requires 1 man-week of labour. A refrigerator contributes a profit of 600 and a range contributes a profit of 400). Formulate the problem as the LP, problem to determine the number of units of refrigerators and ranges that the company should produce to realize maximum profit. and solve in excel 31. A plant manufactures two products A and B. The profit contribution of each product has been estimated as ? 20 for product A und 7 24 Fax product. Each product passes through three departments of the plant. The time required for cach product and total time available in cach department are as follows: Hours required Available hours Department during the Product A Product B month 1.500 2 1.500 64X The company has a contract to supply at least 250 units of product B per month. Formulate the problem as a linear programming model. and solve in excel 1 3 1