Objective: Upon completion of this activity, you will be able to define Linear Programming and formulate a Linear Programming model, including the objective function and restrictions, solve and interpret the results using Microsoft Excel Solver and identify under what conditions the Linear Programming tool can be applied. Student Instructions: After studying this module take the following quiz. You will have only one (1) attempt to answer this quiz by Assignment. Send the assignment as an Excel spreadsheet, pdf or picture. The activity is worth 40 points. The deadline for taking the quiz is indicated on "Tools", which is located in "Calendar in the "Blackboard" platform. Formulate and use linear programming to solve the following problem. A firm wants to determine how many units of each of two products (products D and E) they should produce to make the most money. The profit in the manufacture of a unit of product D is $100 and the profit in the manufacture of a unit of product E is $87. Although the firm can readily sell any amount of either product, it is limited by its total labor hours and total machine hours available. The total labor hours per week are 4,000. Product D takes 5 hours of labor per unit and product E takes 7 hours of labor per unit. The total machine hours are 5,000 per week. Product D takes 9 hours of machine time per unit and product E takes 3 hours of machine time per unit. Write the constraints and the objective function for this problem, solve the assignment with Excel Solver for the best mix of product D and E, and report the maximum value of the objective function