Hello, I have completed the math portion in my word doc and all of my work was checked and corrected by the teacher.

For the letter memo, there is an example on how this can be answered.

The Excel file is a little different. Only need seven constraints in Column A need to be filled out. Only need three variable types, for example if I am correct I think it would be steel, automobiles and machinery. You only need to use two on the right and one on the left for the columns. The teacher said they didn't want to create another excel file so Column C-J doesn't need anything it in. They said the numbers can still be generated correctly.

S=Steel A=Automobiles M=Machinery S 1= Number of units of steel produced A 1= Number of units of automobiles produced M 1= Number of units of machinery produced Maximize the net dollar value of exports S= Number of units of steel produced- Some are going to be exported and some are going to be used to make automobiles and machinery. Max 800 (Units of steel exported) Units of steel exported= Units of steel produced-units of steel used to make automobiles and machinery. Units of steel exported= S-0.75 A-1.1 M 800 (S - 0.75 A - 1.1 M) + 21,000 (A - 0.002 S - 0.03 M) + 39,000 (M -0.005 S - 0.02 A) - 200 S - 10,400 A - 17,000 M Units of automobiles exported = Units of automobiles produced - Units of automobiles used to make steel and machinery. For Steel: 800 - 42 - 195 - 200 = 363 For Automobiles: 21,000 - 600 - 780 - 10,400 = 9,220 For Machinery: 39,000 - 880 - 630 - 17,000 = 20,490 Max= 363 S + 9,220 A + 20,490 M S.T. (Subject Two) S 6,700,000 A 3,100,000 M 2,800,000 0.01 S + 0.4 A + 1.25 M 5,500,000 Amount of steel produced Amount of steel needed to make automobiles and machinery. S 0.75 A + 1.1 M A 0.002 S + 0.03 M M 0.05 + 0.02 A S 2= Number of units of steel exported A 2= Number of units of Automobiles exported M 2= Number of units of Machinery exported Max= 800 S 2 + 21,000 A 2 + 39,000 M 2 - 200 S 1 - 10,400 A 1 - 17,000 M 1 S.T. (Subject Two) S 2 = S 1 - 0.75 A 1 - 1.1 M 1 A 2 = A 1 - 0.002 S 1 - 0.03 M 1 M 2= M 1 - 0.005 S 1 - 0.02 A 1 Homework 2 Variable Values Profit Constraints: 0