Question Solved1 Answer 2.9. The Whitt Window Company is a company with only three employees that makes two different kinds of handcrafted win- dows: 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. 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 Section 2.1. Then construct and fill in a table like Table 2.1 for this problem, identifying both the activities and the resources. b. Identify verbally the decisions to be made, the con- straints on these decisions, and the overall measure of performance for the decisions. C. Convert these verbal descriptions of the constraints and the measure of performance into quantitative expressions in terms of the data and decisions. d. Formulate a spreadsheet model for this problem. Identify the data cells, the changing cells, and the objective cell. Also show the Excel equation for each output cell expressed as a SUMPRODUCT function. Then use Solver to solve this model. e. Indicate why this spreadsheet model is a linear pro- gramming model. f. Formulate this same model algebraically. g. Identify the decision variables, objective function, nonnegativity constraints, functional constraints, and parameters in both the algebraic version and spreadsheet version of the model. h. Use the graphical method to solve this model. i. A new competitor in town has started making wood-framed windows as well. This may force the company to lower the price it charges 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 decreases from $60 to $40? From $60 to $20? j. 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 only makes 5 wood frames per day?
54SLWB The Asker · Management
Transcribed Image Text: 2.9. The Whitt Window Company is a company with only three employees that makes two different kinds of handcrafted win- dows: 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. 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 Section 2.1. Then construct and fill in a table like Table 2.1 for this problem, identifying both the activities and the resources. b. Identify verbally the decisions to be made, the con- straints on these decisions, and the overall measure of performance for the decisions. C. Convert these verbal descriptions of the constraints and the measure of performance into quantitative expressions in terms of the data and decisions. d. Formulate a spreadsheet model for this problem. Identify the data cells, the changing cells, and the objective cell. Also show the Excel equation for each output cell expressed as a SUMPRODUCT function. Then use Solver to solve this model. e. Indicate why this spreadsheet model is a linear pro- gramming model. f. Formulate this same model algebraically. g. Identify the decision variables, objective function, nonnegativity constraints, functional constraints, and parameters in both the algebraic version and spreadsheet version of the model. h. Use the graphical method to solve this model. i. A new competitor in town has started making wood-framed windows as well. This may force the company to lower the price it charges 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 decreases from $60 to $40? From $60 to $20? j. 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 only makes 5 wood frames per day?
More Transcribed Image Text: 2.9. The Whitt Window Company is a company with only three employees that makes two different kinds of handcrafted win- dows: 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. 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 Section 2.1. Then construct and fill in a table like Table 2.1 for this problem, identifying both the activities and the resources. b. Identify verbally the decisions to be made, the con- straints on these decisions, and the overall measure of performance for the decisions. C. Convert these verbal descriptions of the constraints and the measure of performance into quantitative expressions in terms of the data and decisions. d. Formulate a spreadsheet model for this problem. Identify the data cells, the changing cells, and the objective cell. Also show the Excel equation for each output cell expressed as a SUMPRODUCT function. Then use Solver to solve this model. e. Indicate why this spreadsheet model is a linear pro- gramming model. f. Formulate this same model algebraically. g. Identify the decision variables, objective function, nonnegativity constraints, functional constraints, and parameters in both the algebraic version and spreadsheet version of the model. h. Use the graphical method to solve this model. i. A new competitor in town has started making wood-framed windows as well. This may force the company to lower the price it charges 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 decreases from $60 to $40? From $60 to $20? j. 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 only makes 5 wood frames per day?
See Answer
Add Answer +20 Points
Community Answer
ONRW6L
See all the answers with 1 Unlock
Get 4 Free Unlocks by registration
Get 4 Free Unlocks by registration
ANSWER:- Spreadsheet model is formulated as below Spreadsheet model is formulated as below:Set up Solver Parameters as follows:Solver ParametersxxClick SolveAfter that, values appear automatically in variable (yellow) cellsAlgebraic model is formulated below:Let X be the number of wood-framed windows to be made per dayY be the number of aluminum-framed windows to be made per day{:[" Max 60X+30Y "],[" s.t. "],[1X<=6],[1Y<=4],[6X+8Y<=48],[X","Y>=0]:}Solution using graphical method is following:Feasible r ... See the full answer