Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribed

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.

image text in transcribedimage text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Elementary Point-Set Topology A Transition To Advanced Mathematics

Authors: Andre L Yandl, Adam Bowers

1st Edition

0486811018, 9780486811017

More Books

Students also viewed these Mathematics questions

Question

Find the opposite of each integer. 1. -18 2. 42

Answered: 1 week ago