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

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Dec 05, 2022

By using the solution and sensitivity analysis obtained with Solver, answer the 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

Step: 1

1 Number of apple trees to be planted 100 and Number of avocado trees to be planted 0 2 Optimal ... 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

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

Recommended Textbook for

Introduction To Management Science A Modeling And Cases Studies Approach With Spreadsheets

Authors: Frederick S. Hillier, Mark S. Hillier

5th Edition

978-0077825560, 78024064, 9780077498948, 007782556X, 77498941, 978-0078024061

More Books

Students also viewed these Economics questions

Question

★★★★★

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

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Question

★★★★★

Read the case study given below and answer the following questions Assignment: Ethics in Firefighting Firefighter ordered suspended without pay after trying to rescue an elderly woman from a fire By...

Answered: 1 week ago

Question

★★★★★

During your examination of the accounts receivable of Hope Ranch, a new client, you notice that one account is much larger than the rest, and you therefore decide to examine the evidence supporting...

Answered: 1 week ago

Question

★★★★★

Propane, C3H8, is a common fuel gas. Use the following to calculate the grams of propane you would need to provide 369 kJ of heat. C3H8(g) + 5O2(g) 3CO2(g) + 4H2O(g); H = 2043 kJ

Answered: 1 week ago

Question

★★★★★

Do you find it difficult to fall asleep if you go to bed before 10 PM? Yes No

Answered: 1 week ago

Question

★★★★★

Renees Rings manufactures college rings. Two models are produced: The Spirit model with a budgeted price of $500 and a standard variable cost of $200. The Chancellor model has a budgeted price of...

Answered: 1 week ago

Question

★★★★★

Mack Precision Tool and Die has two production departments, Fabricating and Finishing, and two service departments, Repair and Quality Control. Direct costs for each department and the proportion of...

Answered: 1 week ago

Question

★★★★★

The first quarter tax return needs to be filed for Prevosti Farms and Sugarhouse by April 15, 2019. For the purpose of the taxes, assume the second February payroll amounts were duplicated for the...

Answered: 1 week ago

Question

★★★★★

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.

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Question

★★★★★

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.

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Question

★★★★★

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)

Answered: 1 week ago

Question

★★★★★

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)?

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Question

★★★★★

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

Answered: 1 week ago

Previous Question Next Question