Hi, I need step by step for this problem, , specially the formulas for Excel and then how to do it in solver. Thank you

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 followingtable 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:(Select a Solving Method: GRG Nonlinear. ? Make Unconstrained Variables Non-Negative)

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