Description
Details:
The purpose of this assignment is to introduce how to find solutions to business problems using nonlinear optimization techniques.
Complete Chapter 8 Problems 4a-c, 5a-c, 7, 8, 14, 18, and 27 from the textbook, using the student data files provided in the Course Materials, as directed.
Submit the Excel outputs required for each problem. Note that Excel files are to include all functions and formulas used to generate the problem solutions.
Submit the narrative answers to problem questions as a Word document.
APA style is not required, but solid academic writing is expected.
This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
Non-Linear Optimization Problems
Student number:
Question 4
Plotting the function 𝑌 = −0.865 + 8.454𝑋 − 1.696𝑋 2 + 0.132𝑋 3 − 0.00331𝑋 4 for the
positive values of X from 1 to 20 gives the following graph:
Y
30.00
25.00
20.00
15.00
10.00
5.00
0.00
0
5
10
15
20
25
The graph contains 2 local maximum solutions and one local minimum solution
Question 5
Plotting the function 𝑌 = 37.684 − 15.315𝑋 + 3.095𝑋 2 − 0.218𝑋 3 + 0.005𝑋 4 for the
positive values of X from 1 to 20 gives the following graph:
Y
30.00
25.00
20.00
15.00
10.00
5.00
0.00
0
5
10
15
There is one local maximum and two local minimums from the graph.
20
25
Question 7
The Model requires us to maximize the output ...