(Solved): Bearland Manufacturing produces 4 different types of wood paneling. Each type of paneling is made b ...

Bearland Manufacturing produces 4 different types of wood paneling. Each type of paneling is made by gluing and pressing together a different mixture of pine and oak chips. The following table summarizes the required amount of gluing, pressing, and mixture of wood chips required to produce a pallet of 50 units of each type of paneling: Assume the company has 6,000 quarts of glue; 7,500 hours of pressing capacity; 30,000 pounds of pine chips; and 62,500 pounds of oak chips available in the next production cycle. Further assume that each pallet of Tahoe, Pacific, Savannah, and Aspen panels can be sold for profits of \( \$ 450, \$ 1,150, \$ 800 \), and \( \$ 400 \), respectively. Finally, for marketing purposes, the company wants to produce at least 4 pallets of each type of paneling. a) Formulate an LP model for this problem (10 points) b) Create a spreadsheet model for this problem and solve it using Solver (15 points) c) What is the optimal solution? (5 points)