7 D 0 5. Formulation (20 pts) A certain plant can manufacture five different products in any combination. Each product requires time on each of three machines in the following manner (figures in minutes/unit): Product Machine 1 Machine 2 Machine 3 A 12 8 5 B 7 9 10 8 4 10 E 11 Each machine is available 128 hours a week. Products A, B, and Care purely competitive. Any amounts made may be sold at respective prices of $5, $4, and $5. The first 20 units of Products D and E produced each week can be sold at $4 each but any quantities of these two products made in excess of 20 can only be sold at $3 each. Variable labor costs for machine 1 and 2 are $4 per hour per machine, and $3 per hour per machine 3. Material costs are $2 for products A and C, and $1 for products B, D, and E. You wish to maximize profit. a. Formulate old school: x1, x2, etc. (6 pts) 3 2 7 b. Formulate employing NPS Style (7 points). C. Find the solution and show below. You may use good screenshots. Include Excel file or Python code as separate attachment. Ensure your file is well commented and easy to navigate. (7 pts) 7 D 0 5. Formulation (20 pts) A certain plant can manufacture five different products in any combination. Each product requires time on each of three machines in the following manner (figures in minutes/unit): Product Machine 1 Machine 2 Machine 3 A 12 8 5 B 7 9 10 8 4 10 E 11 Each machine is available 128 hours a week. Products A, B, and Care purely competitive. Any amounts made may be sold at respective prices of $5, $4, and $5. The first 20 units of Products D and E produced each week can be sold at $4 each but any quantities of these two products made in excess of 20 can only be sold at $3 each. Variable labor costs for machine 1 and 2 are $4 per hour per machine, and $3 per hour per machine 3. Material costs are $2 for products A and C, and $1 for products B, D, and E. You wish to maximize profit. a. Formulate old school: x1, x2, etc. (6 pts) 3 2 7 b. Formulate employing NPS Style (7 points). C. Find the solution and show below. You may use good screenshots. Include Excel file or Python code as separate attachment. Ensure your file is well commented and easy to navigate. (7 pts)