80.2K

Verified Solution

Link Copied!

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:

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

Assume the company has 6,000 quarts of glue; 7,300 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 $1,250, $500, $450, and $800, respectively. Finally, for marketing purposes, the company wants to produce at least 4 pallets of each type of paneling. (Let X₁, X₂, X₃, and X₄ 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).

MAX:

Subject to:Glue (quarts)

Pressing (hours)

Pine chips (pounds)

Oak chips (pounds)

Tahoe (number pallets)

Pacific (number pallets)

Savannah (number pallets)

Aspen (number pallets)

(b)

Create a spreadsheet mode for this problem, and solve it using Solver. What is the optimal solution?

(X₁, X₂, X₃, X₄) =

Answer & Explanation Solved by verified expert

See Answer