Question: 2) Use the sensitivity report below to answer the following questions: (20 points) Variable Cells Cell Name $B$4 # of Alfalfa $C$4 # of Beets

2) Use the sensitivity report below to answer the

2) Use the sensitivity report below to answer the following questions: (20 points) Variable Cells Cell Name $B$4 # of Alfalfa $C$4 # of Beets Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 0 -10 30 10 1E+30 200 0 40 1E+30 10 Constraints Cell Name $D$7 Land $D$8 Capital $D$9 Water Final Shadow Constraint Allowable Allowable Value Price R.H. Side Increase Decrease 200 40 200 1000 200 6000 0 45000 1E+30 39000 15000 0 90000 1E+30 75000 a. What is the production plan shown by this sensitivity report? b. What is the maximum profit represented by this sensitivity report? C. Which constraints are binding? Which are non-binding? d. Suppose the unit profit of beets is decreased by $5. Is the current solution still optimal? What is the value of the objective function when this unit cost is decreased by $5? 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? j. The company is considering adding pumpkin to the farm. Pumpkin will use 2 units of land, 10 units of capital, and 20 unit of water. What will it cost to grow pumpkin? If they can sell pumpkin for a profit of $60 should they proceed

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!

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

Question 13 The LP problem whose output follows determines how many necklaces, bracelets, rings, and earrings a jewelry store should stock. The objective function measures profit: it is assumed that...

Larry, Moe and Curly work in a clock factory. Larry and Moe can each work 40 hours per week and Curly can work 20 hours per week. The company makes two types of clocks: grandfather clocks and wall...

Variable Cells Cell Name $B$3 Values X1 $C$3 Values X2 Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 4 0 9 12 3 0 7 11 4 5.5 Constraints Final Shadow Constraint...

A manager wants to decide production amounts of 4 products A, B, C, D in order to maximize profit. The profits are $29, $32. $72 and $54 per unit of A, B, C and D produced, respectively. Materials E...

Courtney's Cupcakes is a company that caters baked goods for events Courtney has been hired to bake cupcakes for an upcoming wedding. The client would like 4 different cupcake flavors: Buckeye,...

Larry, Moe and Curly work in a clock factory. Larry and Moe can each work 40 hours per week and Curly can work 20 hours per week. The company makes two types of clocks: grandfather clocks and wall...

A manufacturing facility for Company XYZ that produces doors and windows utilizes three manufacturing processes: cutting, sanding and finishing. There are limited resources for each of these...

Use the sensitivity report below to answer the following questions A B C D E F G H 1 Microsoft Excel 16.0 Sensitivity Report 2 Worksheet: [1205-2021-05 13 XL SOLN.xlsx]Sheet1 3 Report Created:...

1. Top-line Furniture designs and manufactures sofas for sale through select retailers. Production will soon begin on a new line of sofas. They have chosen to focus on at most 4 products: sectional,...

Coca-Cola and PepsiCo both produce and market beverages that are direct competitors. Key financial figures (in $ millions) for these businesses over the past year follow. Required 1. Compute return...

Lola, the CEO of JB Inc., and Frank, the accountant for JB Inc., were recently having a meeting to discuss the upcoming release of the companys financial statements. Following is an excerpt of their...

4 . In the spreadsheet shown below, we computed profit earned by selling houses by entering the formula = F 8 - E 8 in cell G 8 and copying it down to G 9 :G 1 1 . We used the word open to denote a...

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