Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help. I have no idea how to work this. Please put in excel if possible to show the formula. I have a few more

Please help. I have no idea how to work this. Please put in excel if possible to show the formula. I have a few more like it.

The Delicious Apple Company has orchards in Red City, Golden, and Macville. Estimated amounts of apples to be available from the three orchards are the following: Red City, 15,000 bushels; Golden, 12,000 bushels; and Macville, 9,000 bushels.Apple Products Company wants to buy up to 10,000 bushels, for which it will pay $2.90 a bushel. Fruit Processors, Inc., is interested in buying up to 12,000 bushels at $3.20 a bushel. Extragood Fruit Company will buy up to 18,000 bushels at $3.10 per bushel.Delicious Apple Company would like to distribute its apples to the buyers so as to maximize its profits.The costs of shipping form the orchards to the buyers' processing plants are given in the following table. It is acceptable to have fractional bushels.

From Orchard Apple Products Fruit Processors Extragood Fruit
Red City $0.55 $0.65 $0.45
Golden $0.40 $0.45 $0.55
Macville $0.45 $0.45 $0.85

a) Formulate the linear programming formulation for this problem.

b) Using any linear programming software, solve the problem for the optimal answer and provide the value of the objective function and the variables at optimality. Provide a copy of your linear programming output. In addition to providing this output, you are to specifically identify the value of the objective function and the values of the variables at optimality.

c) Using the sensitivity analysis (ranging) output provided as part of the linear programming output, provide two sensitivity analysis interpretations. Provide one based on the objective function and one based on a constraint. Provide a copy of the sensitivity analysis output supporting your interpretations.

d) show a constraint that will ensure that Fruit Processors obtains at least 20% of its total number of bushels from the Golden Orchard. You only need formulate this constraint. You do not need to solve the linear programming problem for the solution.

As required, you must submit your linear programming formulation and show the linear programming software solution to this problem

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

An Introduction To Management Science Quantitative Approaches To Decision Making

Authors: David R. Anderson, Dennis J. Sweeney, Thomas A. Williams, Jeffrey D. Camm, James J. Cochran

16th Edition

0357715462, 978-0357715468

More Books

Students also viewed these General Management questions

Question

Determine the of ????2 when (a) ???? = 0.83. (b) ???? = .77.

Answered: 1 week ago

Question

Evaluate the given exponential expression. (44)3 (44)3 =

Answered: 1 week ago

Question

What are the organizations reputation goals on this issue?

Answered: 1 week ago

Question

What change do you need to make to achieve the desired position?

Answered: 1 week ago