Section B - Linear Programming AMPL/Excel Solver Solution Methods For problem 3 build the LP Model from the word problem, using your desired AMPL/EXCEL SOLVER solution method. Submit all supporting work. 3. The local machining company has discounted the production of a certain unprofitable product line. This act created considerable excess production capacity. Management is considering devoting this excess capacity to one of three products. The available capacity on the machines that might limit output and marginal input are summarized in the table. Product 1 Product 2 Product 3 Available Time Machine Type (machine hours per unit) (machine hours per week) Milling 9 3 5 500 Machine Lathe 5 0 350 Grinder 3 0 2 150 4 The sales department indicates that the sales potential for products 1 and 2 exceeds production and the sales potential for product 3 is 20 units per week. The unit profit would be $50, $20, and $25 respectively on products 1, 2, and 3. a). Formulate a linear programming model for this problem statement. b). What is the optimum solution for weekly production? c). Floor space is available to procure either an additional milling machine or lathe, and both models have similar costs. An additional unit would add 37 machine hours per week? Which machine should be selected