Question 2

Colonial Furniture produces hand-crafted colonial style furniture. Plans are now being made for the production of rocking chairs, dining room tables, and/or armoires over the next week. These products go through two stages of production (assembly and finishing). The table in the next column gives the time required for each item to go through these two stages, the amount of wood required (fine cherry wood), and the corresponding unit profits, along with the amount of each resource available next week.

Microsoft Excel 15.0 Answer Report Worksheet: [Assignment 1 s1 2022-23 solution.xlsx]Q2 Report Created: 10/14/2022 9:25:10 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.063 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $E$4 profit 0 16200 Variable Cells Cell Name Original Value Final Value Integer $B$3 number of units Rockin chair 0 0 Contin $C$3 number of units Dining table 10 Contin OO $D$3 number of units Armoire 15 Contin Constraints Cell Name Cell Value Formula Status Slack $E$6 Assembly (minutes LHS 3600 $E$6