Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1) Solve the simple LP problem Wood Products company manufacturing using Excel Solver LP Simplex. Submit the Answer Report and Sensitivity Analysis Report available from

image text in transcribed
image text in transcribed
1) Solve the simple LP problem "Wood Products company manufacturing" using Excel Solver LP Simplex. Submit the Answer Report and Sensitivity Analysis Report available from Solver. Allow the answers to be non-integers. This means if Desks had a profit of $2 each, you might make 2.5 desks and have a profit of $5. 2) Answer and submit the following questions by interpreting the Answer Report. Include all work in your answers. a. In the Answer Report there are values for five (5) optimal outputs? Identify the five outputs. clearly defining what the numbers represent with their dimensions {e.g. dollars. hours, etc.). b. What is meant by Slack variables? Define them in terms of this manufacturing company (there are two slack variables). c. The constraints are labeled as "Binding or Not Binding". What do you think this means? d. Consider changes to the data in the problem. What if the number of available hours in Department 1 increased from 12 to 14 hours? How would the optimal solution change? e. The optimal solution to this problem includes the decision to make zero Tables. How would the optimal solution change if market conditions forced you to make one table

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

Managerial Economics

Authors: Luke M. Froeb, Brian T. McCann, Michael R. Ward

5th Edition

1337106666, 978-1337106665

More Books

Students also viewed these Economics questions

Question

Behaviour: What am I doing?

Answered: 1 week ago