The Whitt Window Company is a company with only three employees which makes two different kinds...

Transcribed Image Text:

The Whitt Window Company is a company with only three employees which makes two different kinds of hand-craft windows: a wood-framed and an aluminum-framed window. They earn $60 profit for each wood-framed window and $30 profit for each aluminum-framed window. Doug makes the wood frames and can make 6 per day. Linda makes the aluminum frames and can make 4 per day. Bob forms and cuts the glass, and can make 48 square feet of glass per day. Each wood-framed window uses 6 square feet of glass and each aluminum-framed window uses 8 square feet of glass. Demand for each kind of windows is unlimited. a) Formulate a linear programming (LP) model to maximize the Whitt Window Company's profit. Note: Clearly define your notation. b) Model the same problem in Excel and solve it using Excel Solver. The Whitt Window Company is a company with only three employees which makes two different kinds of hand-craft windows: a wood-framed and an aluminum-framed window. They earn $60 profit for each wood-framed window and $30 profit for each aluminum-framed window. Doug makes the wood frames and can make 6 per day. Linda makes the aluminum frames and can make 4 per day. Bob forms and cuts the glass, and can make 48 square feet of glass per day. Each wood-framed window uses 6 square feet of glass and each aluminum-framed window uses 8 square feet of glass. Demand for each kind of windows is unlimited. a) Formulate a linear programming (LP) model to maximize the Whitt Window Company's profit. Note: Clearly define your notation. b) Model the same problem in Excel and solve it using Excel Solver.