Question: 2) Use the sensitivity report below to answer the following questions: (20 points) Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient

2) Use the sensitivity report below to answer the

2) Use the sensitivity report below to answer the following questions: (20 points) Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$4 # of Alfalfa 0 -10 30 10 1E+30 $C$4 # of Beets 200 0 40 1E+30 10 Constraints Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 200 200 1000 200 6000 0 45000 1E+30 39000 15000 0 90000 1E+30 75000 Cell Name $D$7 Land $D$8 Capital $D$9 Water 40 e. How much can the profit per unit of alfalfa can be decreased without concern for the optimal solution changing? f. If the right-hand side of land is increased by 50, what will be the effect on the optimal solution? g. After production, how much capital remains unused? h. What would be the impact on the profit, if land was increased by 10 units? Please explain. i. What would be the impact on the profit, if water was decreased by 100 units? Please explain

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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 General Management Questions!

Question LongLife, LLC manufactures rechargeable batteries for the personal and recreational drone industry. The company signed a contract with Best Buy electronics to produce three different...

Classic New Orleans desserts include pralines, pecan pie and Bananas Foster. A recipe for a dozen pralines takes a cup of pecans, two cups of brown sugar, a cup of granulated sugar, a half teaspoon...

i need help i go not understand this Variable Cells Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 Number of units Tables 320.00 0.00 7.00 3.00...

You are the purchasing manager of a sandwich food truck that operates on the local level. Given the resources, you ran the Linear Programming pool and produced wing ferro B c D E G H Variable Cells...

Given the below table generated by Excel Solver's sensitivity analysis: What will happen to the objective value if the coefficient of Variable Y is increased by 2? Variable Cells Final Reduced...

Q3. Graves Lighting is planning this weeks schedule for a metal stamping machine. It has been decided that they will make several models of exterior lanterns. All necessary accessories and glass...

We are making four products ( P 1 - P 4 ) . Objective function coefficients are profit per unit for each product. Constraints are the amount of labor available, raw materials ( 1 , 2 and 3 ) and...

Fashion Inc. produces advertisements (ads) for clients using four types of electronic media: radio, regular TV, cable TV and telephone. Partial minutes of a media type may be purchased. The LP Solver...

An airplane is flying at a constant altitude of 2 miles and a constant speed of 600 miles per hour on a straight course that will take it directly over an observer on the ground. How fast is the...

Co-insurance effect refers to: a) The possibility that mutual benefits emerge for the project and the company. b) The possibility to use the same model for dividing up risk among various project...

131. The crate has a mass of 80 kg and is being towed by a chain which is always directed at 20 from the horizontal as shown. If the magnitude of P is increased until the crate begins to slide,...

When older adults have difficulty with transportation and communication, or may be reluctant to request needed assistance to which they are entitled, they may be in need of: Group of answer choices...