system analysis

1. A steel fabrication plant produces four different specialized steel assemblies. Each unit of specialized assembly is made up of the amounts of materials specified in the following table. Specialized Assembly B Angle Iron (lb/unit) 150 200 1 00 250 Steel Plate (lb/unit) 200 250 125 175 Fastening Brackets (lb/unit) (lbum 75 60 80 65 C D The plant can realize a $10 profit per unit of A, a $12 profit per unit of B, an $8 profit per unit of C, and a $6 profit per unit of D. A. Assuming that whatever can be fabricated can be sold, formulate an LP model that can be used to maximize profit subject to the following constraints: a) There are 100,000 lbs of angle iron, 200,000 lbs of steel plate, and 50,000 lbs of strap steel available to be used in this fabrication. b) Due to inventory problems, at least 100,000 lbs of steel plate should be used. c) Usage of the assemblies requires that two units of assembly A be produced for each unit of B. B. Solve by using two-phase Simplex. c. Check your result by running EXCEL/Solver. 1. A steel fabrication plant produces four different specialized steel assemblies. Each unit of specialized assembly is made up of the amounts of materials specified in the following table. Specialized Assembly B Angle Iron (lb/unit) 150 200 1 00 250 Steel Plate (lb/unit) 200 250 125 175 Fastening Brackets (lb/unit) (lbum 75 60 80 65 C D The plant can realize a $10 profit per unit of A, a $12 profit per unit of B, an $8 profit per unit of C, and a $6 profit per unit of D. A. Assuming that whatever can be fabricated can be sold, formulate an LP model that can be used to maximize profit subject to the following constraints: a) There are 100,000 lbs of angle iron, 200,000 lbs of steel plate, and 50,000 lbs of strap steel available to be used in this fabrication. b) Due to inventory problems, at least 100,000 lbs of steel plate should be used. c) Usage of the assemblies requires that two units of assembly A be produced for each unit of B. B. Solve by using two-phase Simplex. c. Check your result by running EXCEL/Solver