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: Paneling Type Glue (quarts) Pressing (hours) Pine chips (pounds) Oak chips (pounds) MAX: Subject to: Glue (quarts) Assume the company has 6,000 quarts of glue; 7,300 ours 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 $500, $1,250, $450, and $800, respectively. Finally, for marketing purposes, the company wants to produce at least 4 pallets of each type of paneling. (Let X, X2, X3, and X4 be the number of pallets of Tahoe, Pacific, Savannah, and Aspen paneling produced.) (a) Formulate an LP model for this problem to maximize profit (in dollars). 500X + 150X2+ 450X3 + 800X4 Pressing (hours) Pine chips (pounds) Oak chips (pounds) Tahoe (number pallets) Pacific (number pallets) Savannah (number pallets) Aspen (number pallets) Need Help? Read It Submit Answer 2. [2.08/25 Points] Resources Required per Pallet of Paneling Type Tahoe Pacific 50 50 50 150 200 400 500 750 DETAILS Watch It Savannah 50 50 500 500 X24 50X +50X2 +50X3 + 100X 6000 50X + 150X + 200X 7500 500X+400X2 +300X3+200X 30000 (b) Create a spreadsheet mode for this problem, and solve it using Solver. What is the optimal solution? (X1 X2 X3 X4)= 95, 13, 4,4 X X Aspen 100 100 300 250 X PREVIOUS ANSWERS RAGSMDA9 3.E.018. MY NOTES ASK YOUR TEACHER PRACTICE ANOTHER The Rent-A-Dent car rental company allows its customers to pick up a rental car at one location and return it to any of its locations.

Bearland Manufacturing produces 4 different types of wood paneling. Each type of paneling is made by gluing and pressing together a different mbxture 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,300 hours of pressing capacity; 30,000 pounds of pine chlps; 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 soid for profits of $500,$1,250,$450, and $800, respectively. Finally, for marketing purposes, the company wants to produce at feast 4 pallets of each type of paneling. (Let x1,X2,X3, and x4 be the number of pallets of Tahoe, Pacific, Savannah, and Aspen paneling produced.) (a) Formulate an LP model for this probiem to maximize profit (in dollars). (b) Create a spreadsheet mode for this problem, and solve it using solver. What is the optimal solution? (x1,x2,x3,x4)=(