Question: please show the excel if used Help Save & Exit Submit A farmer in Wood County has 1,100 acres of land. She is going to
please show the excel if used
Help Save & Exit Submit A farmer in Wood County has 1,100 acres of land. She is going to plant each acre with corn, soybeans, or wheat. Each acre planted with corn yields a $2,600 profit, each with soybeans yields $2,700 profit, and each with wheat yields $3,300 profit. She has 135 workers and 135 tons of fertilizer. The table below shows the requirement per acre of each of the crops. Labor (workers) Fertilizer (tons) CORN 0.1 0.1 SOYBEANS 0.2 0.2 WHEAT 0.3 0.3 Assuming a linear relationship, use the Excel Solver to determine the optimal planting mix of corn, soybeans, and wheat to maximize her profits. In formulating your linear program, do NOT restrict the three decision variables to integer values. (However, round the final values of these decision variables to the nearest whole number when entering those answers. Use these rounded decision variable values to compute "Total Profit" and enter that answer to the nearest whole number. Lastly, also use the rounded decision variable values to compute the three "Resources Used" answers and enter them to the nearest whole number. Leave no cells blank - be certain to enter "o" wherever required.) Decision for corn Decision for soybeans Decision for wheat Total profit Resources Used Labor (workers) Fertilizer (tons) Acres Planted
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
