Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help with part 2 of my class project!! (especially the excel spreadsheet) Howard's Apple Farm makes applesauce and apple juice from their apples. It
please help with part 2 of my class project!! (especially the excel spreadsheet)
Howard's Apple Farm makes applesauce and apple juice from their apples. It costs $0.80 to produce a jar of applesauce and $0.60 to produce a bottle of apple juice. The farm has a policy that at least 20% but not more than 60% of its output must be applesauce. The farm wants to meet but not exceed the demand for each product. Howard estimates that the demand for applesauce is normally 5,000 jars, plus an additional 3 jars for each $1 spent on advertising for applesauce. The normal demand for apple juice is estimated to be 4,000 bottles, plus an additional 5 bottles for every $1 spent on advertising for apple juice. The farm has $16,000 to spend on producing and advertising its two products. Applesauce sells for \$1.75 per jar; apple juice sells for $1.75 per bottle. Howard wants to know how many units of each product to produce, and how much advertising to spend on each product, in order to maximize profit. Can you help him? 2. Milestone 2 Requirements 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 flle (maximum to 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 vatue 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. Slide 1: title of the assignment, your name, and class name SHtde 2: table of contents (a short overview of your presentation) Slide 3: problem description + mathematical formulation Page 2 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 leamed in this assignment Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started