Question: The following linear programming model is developed to solve the crop planning problem (if you need the full description of the problem, it is attached

 The following linear programming model is developed to solve the cropplanning problem (if you need the full description of the problem, it

The following linear programming model is developed to solve the crop planning problem (if you need the full description of the problem, it is attached below), and the resulting sensitivity values are tabulated below. Find xij is the number of acres of crop i = (1-beets, 2-cotton, 3-sorghum } ) grown in kibbutz j={1,2,3}] MAX 1000(x11+x12+x13)+750(x21+x22+x23)+250(x31+x32+x33) (profit, $) Ponetrainte Using the sensitivity table above, answer the following questions. Where you are asked to estimate a value and that value cannot be estimated, then indicate the answer as unknown. a) At what value of Net Return for crop 3 (sorghum) will it become attractive to grow? b) The cost of growing crop 1 (beets) is expected to increase, thus reducing its Net Return. Up to what increase in that cost will the current crop growing plan remain optimal? Briefly explain how you obtained your answer. c) Suppose fluctuations in the selling price of the crops are expected, and therefore their Net Returns are anticipated to vary. Change in the price of which crop would have the greatest effect on the current optimal crop growing plan? Briefly explain how you obtained your answer. d) How will additional availability of water, which will be equally divided among the three kibbutzes, affect the optimal profit? Briefly explain your answer. e) Suppose the unused land in each kibbutz is being repurposed for dairy farming, and will be allocated in proportion to the current acreage of each kibbutz. At least 150 acres in each kibbutz is required to properly operate a dairy farm. Can this plan to include dairy farming be implemented without affecting the optimal crop growing plan? f) Suppose the global demand for cotton (crop 2) is increasing and the kibbutz group intends to increase the cotton quota to 600 acres. What will be the increase in profit? The following linear programming model is developed to solve the crop planning problem (if you need the full description of the problem, it is attached below), and the resulting sensitivity values are tabulated below. Find xij is the number of acres of crop i = (1-beets, 2-cotton, 3-sorghum } ) grown in kibbutz j={1,2,3}] MAX 1000(x11+x12+x13)+750(x21+x22+x23)+250(x31+x32+x33) (profit, $) Ponetrainte Using the sensitivity table above, answer the following questions. Where you are asked to estimate a value and that value cannot be estimated, then indicate the answer as unknown. a) At what value of Net Return for crop 3 (sorghum) will it become attractive to grow? b) The cost of growing crop 1 (beets) is expected to increase, thus reducing its Net Return. Up to what increase in that cost will the current crop growing plan remain optimal? Briefly explain how you obtained your answer. c) Suppose fluctuations in the selling price of the crops are expected, and therefore their Net Returns are anticipated to vary. Change in the price of which crop would have the greatest effect on the current optimal crop growing plan? Briefly explain how you obtained your answer. d) How will additional availability of water, which will be equally divided among the three kibbutzes, affect the optimal profit? Briefly explain your answer. e) Suppose the unused land in each kibbutz is being repurposed for dairy farming, and will be allocated in proportion to the current acreage of each kibbutz. At least 150 acres in each kibbutz is required to properly operate a dairy farm. Can this plan to include dairy farming be implemented without affecting the optimal crop growing plan? f) Suppose the global demand for cotton (crop 2) is increasing and the kibbutz group intends to increase the cotton quota to 600 acres. What will be the increase in profit

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!