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.

Rocking Dining Chair Room Table Armoire Available Assembly 100 180 120 3.600 (minutes) Finishing GO 80 80 2.000 {minutes) Wood 30 180 120 4.000 (pounds) Unit Profit $240 $720 $600Microsoft Excel 15.0 Arrowver Report Worksheet: [Assignment 1 51 2022-23 solution.xisx]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 SES4 profit 16200 Variable Cells Cell Name Original Value Final Value Integer $853 `number of units Rockin chair 0 Contin $C$3 number of units Dining table 10 Contin $D$3 number of units Armoire 0 15 Contin Constraints Cell Name Cell Value Formula Status Slack SE$6 Assembly ( minutes LHS 3600 SES60 5056 Binding $EST Finishing minutes LHS 2000 5657-5657 Binding 0 SESB Wood (pounds LHS 3600 $ESS