use excel and solver to formulate and solve this problem. Will upvote.

Problem 5. The Whitt Window Company, a company with three plants, makes two different kinds of hand-crafted windows: a wood-framed window and an aluminum-framed window. Plant 1 makes wood frames. Plant 2 makes aluminum frames. Plant 3 assembles both wood-framed windows and aluminum-framed windows. Suppose Plant 1 can spend 6 hours per week in making wood-frames, Plant 2 can spend 4 hours per week in making aluminum frames, and Plant 3 can spend 48 hours per week to assemble windows. It takes one hour of Plant 1 and six hours of Plant 3 to produce one thousand wood-framed windows. It takes one hour of Plant 2 and eight hours of Plant 3 to produce one thousand aluminum-framed windows. The company earns $300 revenue for selling one thousand wood-framed window and $150 revenue for selling one thousand aluminum-framed window. The company wishes to determine how many windows of each type to produce per week to maximize the total revenue