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.

Linear Algebra: A Modern Introduction

4th Edition

ISBN:9781285463247

Author:David Poole

Publisher:David Poole

Chapter2: Systems Of Linear Equations

Section2.4: Applications

Problem 3EQ: A florist offers three sizes of flower arrangements containing roses, daisies, and chrysanthemums....

See similar textbooks

Similar questions

A florist offers three sizes of flower arrangements containing roses, daisies, and chrysanthemums. Each small arrangement contains one rose, three daisies, and three chrysanthemums. Each medium arrangement contains two roses, four daisies, and six chrysanthemums. Each large arrangement contains four roses, eight daisies, and six chrysanthemums. One day, the florist noted that she used a total of 24 roses, 50 daisies, and 48 chrysanthemums in filling orders for these three types of arrangements. How many arrangements of each type did she make?
If a man has 4 sweaters and 5 pairs of slacks, how many different outfit can he wear?
A commuter must travel from Ajax to Barrie and back every day. Four roads join the two cities. The commuter likes to vary the trip as much as posible, so she alwaysleaves and returns by different roads. In how many different ways can she make the round-trip?
Hector wants to place billboard advertisements throughout the county for his new business. How many ways can Hector choose 15 neighborhoods to advertise in if there are 30 neighborhoods in the county?
In a bag, a child has 325 coins worth $19.50. There were three types of coins: pennies, nickels, and dimes. If the bag contained the same number of nickels as dimes, how many of each type of coin was in the bag?
Susan bought 20 plants to arrange along the border of her garden. How many distinct arrangements can she make if the plants are comprised of 6 tulips, 6 roses, and 8 daisies?
Over the past year, John has purchased 30 books. In how many ways can he pick four of these books and arrange them, in order, on his nightstand bookshelf? In how many ways can he choose four of these books to take with him on his vacation at the shore?
A community baseball stadium has 10 seats in the first row, 13 seats in the second row, 16 seats in the third row, and so on. There are 56 rows in all. What is the seating capacity of the stadium?
Alice and Bill have four grandchildren, and they have three framed pictures of each grandchild. They wish to choose one picture of each grandchild to display on the piano in their living room, arranged from oldest to youngest. In how many ways can they do this?
Alice and Bill have four grandchild, and they have three framed pictures of each grandchild. They wish to choose one picture of each grandchild to display on the piano in their living room, arranged from oldest to youngest. In how many ways can they do this?