Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

?Is this solver solution correct? Did I include everything I needed to and use the correct constraints? Wood Walker Furniture Hours Per Unit 10 11

image text in transcribed
?Is this solver solution correct? Did I include everything I needed to and use the correct constraints?
image text in transcribed

Wood Walker Furniture Hours Per Unit 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Wood Walker Furniture is a company that specializes in tables. They have four popular options. They want to know how many of each table to make to optimize their overall profits. They can't schedule their workers more than the available amount of hours. Also, for some crazy reason, they can't work partial hours; only full hours. They need to make at least the minimum demand, but don't want to make more than the maximum demand. 60 55 40 20 Set Objective: Solver Parameters $B$21 Model c Avaliable Hours Total Hours Used c Total Profit #Made All Cutting 1 2 2 3 Cost/Unit 15.00 23.00 20.00 28.00 Assemblinl Painting Total Hours 60 55 40 20 598 40 2 4 3 7 Sales Price 30.00 45.00 40.00 55.00 4 4 3 5 Min 7 10 8 15 Demand M ax 20 15 10 5 o To: Max Min By Changing Variable Cells: SBS6:$FS9 Subject to the Constraints: $B$13 $B$12 SBS6:SBS9 $GS16:SG$19 SBS6:SBS9 $F$16:$F$19 $B$6:$F$9 = integer Value Of: Profit/Unit 15.00 22.00 20.00 27.00 3,450.00 0 Add Change Delete Reset All Load / Save Make Unconstrained Variables Non-Negative e Select a Solving Method: Solving Method Select the GRG Nonlinear engine for Solver Problems that are smooth nonlinear. Select the LP Simplex engine for linear Solver Problems, and select the Evolutionary engine for Solver problems that are non- smooth.

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

Quantitative Chemical Analysis

Authors: Daniel C. Harris

8th edition

1429218150, 978-1429218153

More Books

Students also viewed these Accounting questions