Maurice Tutor

(5)

$15/per page/Negotiable

About Maurice Tutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Biology,Calculus,Chemistry,Economics,English,Essay writing,Geography,Geology,Health & Medical,Physics,Science Hide all
Teaching Since: May 2017
Last Sign in: 307 Weeks Ago, 3 Days Ago
Questions Answered: 66690
Tutorials Posted: 66688

Education

  • MCS,PHD
    Argosy University/ Phoniex University/
    Nov-2005 - Oct-2011

Experience

  • Professor
    Phoniex University
    Oct-2001 - Nov-2016

Category > Computer Science Posted 15 Jul 2017 My Price 14.00

Sensitivity Report

Use Solver to create a Sensitivity Report for question 26 at the end of Chapter 3, and answer the following questions.

 

a. What is the maximum level profit that can be achieved for this problem?

b. Are there alternate optimal solutions to this problem? If so, identify the solution that allows the most grade 5 oranges to be used in fruit baskets while still achieving the maximum profit identified in part a. c. If Holiday could acquire 1,000 more pounds of grade 4 oranges at a cost of $2.65 per pound, should the company do so? Why?

d. Create a Spider Table and Plot showing the change in the total profit obtained by changing the required grade of fruit baskets and juice from 90% to 110% in 1% increments. If the department of agriculture wants to increase the required rating of one of these products, which product should the company lobby for?

Question 26

Holiday Fruit Company buys oranges and processes them into gift fruit baskets and fresh juice. The company grades the fruit it buys on a scale from 1 (lowest quality) to 5 (highest quality). The following table summarizes Holiday’s current inventory of fruit.

Each pound of oranges devoted to fruit baskets results in a marginal profit of $2.50, whereas each pound devoted to fresh juice results in a marginal profit of $1.75. Holiday wants the fruit in its baskets to have an average quality grade of at least 3.75 and its fresh juice to have an average quality grade of at least 2.50.

a. Formulate an optimization model for this problem.

b. Implement your model in a spreadsheet, and solve it.

c. What is the optimal solution?

Answers

Maurice Tutor
(5)
Status NEW Posted 15 Jul 2017 07:07 PM My Price 14.00

Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â----------- Th-----------ank----------- Yo-----------u f-----------or -----------usi-----------ng -----------our----------- we-----------bsi-----------te -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill-----------

Not Rated(0)
Relevent Questions