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.
b. Create a spreadsheet mode for this problem, and solve it using Solver.
c. What is the optimal solution?

Transcribed Image Text:

Resources Required per Pallet of Paneling Type Pacific 50 150 Aspen 1i Savannah Paneling TypeTahoe Glue (quarts) Pressing (hours) Pine chips (pounds) 500 Oak chips (pounds) 500 100 100 300 250 50 50 50 750 500