By using the solution and sensitivity analysis obtained with Solver, answer the questions below that correspond to the following linear programming problem The corresponding report obtained with Solver is in the last page X Number of apple trees to be planted, X Number of avocado trees to be planted (Total profit) subject to Max Z 5000X 7000X2 10X 20X 1000 2X 3X 200 X 2X 2400 25X 50X35000 10X 15X15000 X, X20 (Available fertilizer, in tons) (Available land, in hectares) (Available labor hours) (Available water, in liters) (Available budget, in dollars) 1 How many trees of each type must be planted 2 What is the corresponding optimal profit 3 Are there any resources left Which ones and how much of each 4 Somebody wants to buy fertilizer at $600 per ton Is it convenient for the company to sell fertilizer Up to how many tons should the company sell Justify your answer 5 If the profit obtained from each apple tree increases from $5000 to $15000 and there is no change in the profit for each avocado tree, how many apple trees and how many avocado trees should be planted What is the corresponding optimal profit 6 If the profit obtained from each avocado tree increases from $7000 to $15000 and there is no change in the profit for each apple tree, do the optimal values of the decision variables change Justify your answer 7 If the available fertilizer increases from 1000 tons to 1001 tons, then the optimal profit increases in $500 Mark the right answer True ( ) False () 8 If the total number of hectares decreases to 199, the optimal profit does not change because the shadow price or dual value is 0 Mark the right answer True ( ) False ( ) 9 If I avocado tree is planted, What is the corresponding profit 10 Some employees wish to work overtime What is the maximum amount, additional to the regular rate, the company would be willing to pay for each overtime hour Justify your answer This is the solution and sensitivity report for Problem 6 They were obtained with Solver 6769LOSSENH 10 11 456 9 10 A A X1 100 15 16 17 18 19 5000 22159 10 6 Variable Cells 7 8 10 $A$2 X1 $B$2 X2 11 12 Constraints 13 14 C B X2 0 7000 20 3 2 50 15 Cell Name Value Cell Name $C$7 Max Z $C$8 Max Z $C$9 Max Z $C$10 Max 2 $C$11 Max Z D 100 0 Max Z 1000 200 2500 1000 100 2500 1000 E SENSITIVITY REPORT D 0 500000 500 Final Reduced Objective Allowable

Question: By using the solution and sensitivity analysis obtained with Solver, answer the questions below that correspond to the following linear programming problem. The corresponding

questions below that correspond to the following linear programming problem. The corresponding

By using the solution and sensitivity analysis obtained with Solver, answer the questions below that correspond to the following linear programming problem. The corresponding report obtained with Solver is in the last page. X = Number of apple trees to be planted, X-Number of avocado trees to be planted (Total profit) subject to Max Z-5000X + 7000X2 10X +20X 1000 2X + 3X

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

1 Number of apple trees to be planted 100 and Number of avocado trees to be planted 0 2 Optimal ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!

Find the linear functions that correspond to the following graphs. (0, 1) (3, 3)

Find the linear functions that correspond to the following graphs. (0, 5) (5, 1)

Identify the operations on polynomials that correspond to the following operations on vectors. Give the resulting polynomial. (a) (b) (c) (d) 302 121 121 430 02020| 12-21 4371

The L. Young & Sons Manufacturing Company produces two products, which have the following profit and resource requirement characteristics: Last months production schedule used 350 hours of labor in...

Each coffee table produced by Kevin Watson Designers nets the firm a profit of $ 9. Each bookcase yields a $ 12 profit. Watsons firm is small and its resources limited. During any given production...

Find Vo in the network shown using both mesh and nodal analysis. 6V 2 2KS2 TTA

NSDC has a contract to produce eight satellites to support a worldwide telephone system (for Alaska Telecom, Inc.) that allows individuals to use a single, portable telephone in any location on earth...

A rope of total mass m and length L is suspended vertically. Show that a transverse pulse travels the length of the rope in a time interval t = 2Lig. (Suggestion: First find an expression for the...

Walt Wallace Construction Enterprises is investigating the purchase of a new dump truck. Interest is 9%. The cash flows for two Likely models are as follows Annual First Operating Annual Salvage...

Suppose that for Example 15.1, the gas-processing plant decides to produce a third grade of product with the following characteristics: In addition, suppose that a new source of raw gas has been...

Create a header with exploring series in the left section, the sheeting code in the center, and the file name code in the right section. Return to normal view if necessary.

what is the work content and components of the project. It can be described by naming all the activities performed?

Gas mixtures. A mixture composed of CO and H2 is contained at 283 kPa. Calculate the partial pressure of the H in kPa in this mixture if the mole fraction of CO is 68 %. Provide the answer to three...

the earnings after tax and dividends under each of the following two financing options based on the document: 1.bond financing: $20 million at 7 percent interest.

Pedagogically, there has been empirical evidence to support that there is lack of student's interest in enrollment in marketing analytics courses. Specifically, the biased perception of marketing as...

A typical wire coating die is shown schematically in the figure below. throughout the mold It is incompressible at steady state and is an isothermal flow. Rheological properties of the fluid, power...

Question 1 (5 points) List and explain 3 advantages of as a Service (PaaS, laaS, SaaS, etc) versus buying/owning a solution (software or hardware for example)

Suppose that the electrical potential at the point (x, y, z) is E(x, y, z) = x + y - 2z. What is the direction of the acceleration at the point (1,3,2)?

a. Given the bids, you need to assign one senior scientist to each of the five projects to maximize the preferences of the scientists. What are the assignments? b. Dr. Rollins is being courted by...

A major banking institution, Best Bank, plans to open a new branch office in Little-town. Preliminary estimates suggest that two tellers (and teller windows) should be provided, but this decision now...

The County Hospital emergency room always has one doctor on duty. In the past, having just a single doctor there has been sufficient. However, because of a growing tendency for emergency cases to use...

Black Bear Merchandising Inc. has three product lines in its retail stores: books, videos, and music. Results of the fourth quarter are presented below: The allocated fixed costs are unavoidable....

How do households dispose of their income? Identify the three major ways income is disposed of and the relative share for each category.

Explain the importance of self-interest in the operation of a market system.