Written Optimization Analysis (part 2)

( Due: Mon, 24 Jun | Status: Not Completed )

This assignment requires you to analyze and solve an optimization problem presented in an e-mail style format. Download the attached Optimization word problem.pdf and read through the scenario.

Note: This is the same problem started in the “Written Optimization Setup” graded discussion.

Written Assignment

After you have analyzed the scenario, solve the optimization problems set up earlier in the week and determine the optimal solution. You will solve the problems using graphical and computational methods (Excel). Directions on required resources are available at the bottom.

• Then draft a response to the questions posed in each problem, describing the results of your analysis. NOTE: Write your response in a professional manner, as if submitting your analysis to a supervisor. Submit your completed analysis in this assignment.
• Include a graph along with your solution for problem 1.
• Include the results from Excel spreadsheet with the values clearly labeled for problem 2.
  (These can be included within the written response, or as separate files)

Please zip your written report and any and all associated files into a single file and upload that to this assignment.
Naming Convention:  yourLastname-Optimization-MMYY.zip

Use your last name, not “yourLastname”.

MM is the two digit month, YY is the last two digits of the year.

————————————-
There are a few ways in which you can generate a graph.  Please see the associated videos for more information.
1)Grapher application in the Utilities folder (within the Applications folder)
2)Download the free, open source, dynamic mathematical software Geogebra available at: http://www.geogebra.org/