Question
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
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