Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your submission materials for this milestone are ( 1 ) a recorded video in which you present your slides, ( 2 ) an Excel spreadsheet

Your submission materials for this milestone are (1) a recorded video in which you present
your slides, (2) an Excel spreadsheet containing the solver solution to your problem, and (3)
using the presentation template provided in Canvas (or one of your choice), develop a
structured presentation file (maximum 10 slides), addressing the following:
a. What is the mathematical formulation of the problem?
b. What is the optimal solution to the problem? Describe it in words.
c. Which parameter in the problem has the greatest impact on the objective function?
d. How does your optimal profit value change with respect to changes in both
applesauce and apple juice unit costs?
e. Does your optimal solution change if the normal demand values for applesauce and
apple juice were to swap? i.e.,4000 for applesauce and 5000 for apple juice.
You may organize your slides for this milestone as follows(you may organize in other ways
if you wish but number of slides should not exceed 10):
Slide 1: title of the assignment, your name, and class name
Slide 2: table of contents (a short overview of your presentation)
Slide 3: problem description + mathematical formulation
Page 3 of 3
Slide 4: take visible screenshots of your spreadsheet and present it (including solver window)
Slide 5: give a descriptive answer to question a under Milestone 2 Requirements.
Slide 6: give a descriptive answer to question b under Milestone 2 Requirements.
Slide 7: give a descriptive answer to question c under Milestone 2 Requirements.
Slide 8: give a descriptive answer to question d under Milestone 2 Requirements.
Slide 9: give a descriptive answer to question e under Milestone 2 Requirements.
Slide 10: Conclusions, discussions, and lessons learned in this assignment

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

Mind Management Not Time Management

Authors: David Kadavy

1st Edition

0578733692, 978-0578733692

More Books

Students also viewed these General Management questions

Question

Th ey have to wait a long time for an appointment?

Answered: 1 week ago