By using the solution and sensitivity analysis obtained with Solver, answer the questions below that correspond...
Fantastic news! We've Found the answer you've been seeking!
Question:
![](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2022/12/638d96064acc5_1670223366061.jpg)
![](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2022/12/638d96b077071_1670223536335.jpg)
Transcribed Image Text:
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₁, X₂20 (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 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₁, X₂20 (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
Expert Answer:
Answer rating: 100% (QA)
1 Number of apple trees to be planted 100 and Number of avocado trees to be planted 0 2 Optimal ... View the full answer
Related Book For
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier
Posted Date:
Students also viewed these 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
-
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...
-
What defense will Ragged Mountain probably assert? Alaina Sweeney went to Ragged Mountain Ski Resort in New Hampshire with a friend. Alaina went snow tubing down a snow-tube run designed exclusively...
-
Explain the different types of direct selling. What is the difference between a multilevel network and a pyramid scheme?
-
Koll's Company is preparing its annual financial statements at December 31, 2020. During 2020, a customer fell while riding on the escalator and has filed a lawsuit for \(\$ 150,000\) because of a...
-
The Henry Street Mission uses volunteers to assemble care packages for needy families during the holiday season. The mission would like to organize the work as efficiently as possible. A list of...
-
On August 3, Amjad Company sold to Tarek Company merchandise having a sales price of 5,000 with terms of 3/10, n/60. An invoice totalling 100, terms n/30, was received by Tarek on August 8 from Al...
-
Frankfurt Electronics produces a component internally using a state-of-the-art technology. The operations manager wants to determine the optimal lot size to ensure that the total annual inventory...
-
The following trial balance was obtained from the books of Lucas Hernandez as at December 31, 2020 : DETAILS DR CR Opening Stock 48,000 Insurance...
-
Lucia rented a car for $253 per week (with unlimited driving miles) to use during her spring break vacation. She must also pay for gasoline which costs $3.40 per gallon. The car gets 25 miles per...
-
how to find the P/E ratio , market value per share Report: Balance Sheet Type: Full Report Company: Intuitive Surgical, Inc. (Cusip: 46120E602 Sic: 3842) 2019 2020 2021 2022 2023 2024 Assets Cash...
-
Describe the duty of a stock broker ( trader ) who is acting as an agent on behalf of a principal ( client ) in terms of managing the client\'s account. Bear in mind the duty of loyalty that an agent...
-
You are running a major tech company, Technology Innovation Inc. ( TIC ) , and are thinking about investing in electric vehicles ( EV ) through a new solely owned start - up , TIC 2 . The new...
-
1. Define motivation and explain three motivational theory from the chapter. What kinds of needs motivate employees? Is a good reward good enough? How do other factors affect motivation? 2. What are...
-
what excel formula should i use to solve this problem? You currently have $84.3 in your savings account at an annual rate of 7 percent. How many years will it take for this investment to grow to a...
-
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...
-
Determine which of -38 and 27 is larger using a number line, and express that using both the greater than and the less than notations.
-
Graph the following numbers on the number line: 1. -10 2. 4 3. 0
-
Use your calculator to calculate 38 - 100. Explain how the answer agrees with what was expected.
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App