Question: without excel please it is not allowed. 3.1-9. The Whitt Window Company, a company with only three employees, makes two different kinds of hand-crafted windows:

without excel please it is not allowed. 3.1-9. without excel please it is not allowed. 3.1-9.without excel please it is not allowed.

3.1-9. The Whitt Window Company, a company with only three employees, makes two different kinds of hand-crafted windows: a wood-framed and an aluminum-framed window. The company ears $300 profit for each wood-framed window and S150 profit for each aluminum-framed window. Doug makes the wood frames and can make six per day. Linda makes the aluminum frames and can make four 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. The company wishes to determine how many windows of each type to produce per day to maximize total profit. (a) Describe the analogy between this problem and the Wyndor Glass Co. problem discussed in Sec. 3.1. Then construct and fill in a table like Table 3.1 for this problem, identifying both the activities and the resources. (b) Formulate a linear programming model for this problem. DI (c) Use the graphical method to solve this model 1 (d) A new competitor in town has started making wood-framed windows as well. This may force the company to lower the price they charge and so lower the profit made for each wood-framed window. How would the optimal solution change (if at all) if the profit per wood-framed window de- creases from $300 to $200 From $300 to 100? (You may find it helpful to use the Graphical Analysis and Sensitivity Analysis procedure in TOR Tutorial.) 1 (e) Doug is considering lowering his working hours, which would decrease the number of wood frames he makes per day. How would the optimal solution change if he makes only five wood frames per day? (You may find it helpful to use the Graphical Analysis and Sensitivity Analysis procedure in IOR Tutorial.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!