Look at the contents of each cell, including any formulas. Make sure that you understand how the John Deere model was set up. Pay close attention to the Total Contribution cell and the Used column of cells these are the most complicated.

Run Solver. All the necessary parameters should be set. Verify that you understand the Set Target cell, By Changing cell, and the Subject to Constraints in the Solver dialog. (Select Simplex LP for solving method).

The president of John Deere was concerned about the declining quality of his trucks. He decided to form a test group that would test each truck before it is shipped. It takes 30 minutes to test a Model A and 15 minutes to test a Model B. There are 1100 testing machine hours available per month to perform these tests.

Form a new constraint on John Deeres factory for the testing department. Add this constraint to the spreadsheet. Re-solve using Solver.

What is the new optimal product mix?

JOHN DEERE COMPANY \begin{tabular}{|lcccc|} \hline Variables & Model A & Model B & & Total Contribution \\ \hline Number to Make & 0 & 0 & & \\ Unit Contribution & 3000 & 5000 & & $0 \\ \hline Constraints & & & Used & Available \\ \hline Engine Assembly & 1 & 2 & 0 & 4000 \\ Metal Stamping & 2 & 2 & 0 & 6000 \\ A Assembly & 2 & 0 & 0 & 5000 \\ B Assembly & 0 & 3 & 0 & 4500 \\ A Non-Negativity & 1 & & & \\ B Non-Negativity & & 1 & 0 & 0 \\ \hline \end{tabular}