Question: Plz solve using EXCEL and show steps clearly Alexandra Bergson has subdivided her 2,000-acre farm into three plots and has contracted with three local farm
Plz solve using EXCEL and show steps clearly
Alexandra Bergson has subdivided her 2,000-acre farm into three plots and has contracted with three local farm families to operate the plots.
She has instructed each sharecropper to plant three crops: corn, peas, and soybeans. The size of each plot has been determined by the capabilities of each local farmer. Plot sizes, crop restrictions, and profit per acre are given in the following tables:
PlotAcreage
1500
2800
3700
Maximum AcreageProfit/Acre
Corn900$600
Peas700450
Soybeans1,000300
Any of the three crops may be planted on any of the plots; however, Alexandra has placed several restrictions on the farming operation. At least 60% of each plot must be under cultivation. Further, to ensure that each sharecropper works according to his or her potential and resources (which determined the acreage allocation), she wants the same proportion of each plot to be under cultivation. Her objective is to determine how much of each crop to plant on each plot to maximize profit.
Formulate a linear programming model for this problem.
Solve the model by using the computer.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
